General Ledger Report
The General Ledger report is a listing of transaction detail and account balances for a selected date, date range, and a specific account number (optional). Use it primarily to audit posting activity for a particular account or to provide detail in support of your agency's financial statements. The benefit of using My Agency Reports to run your General Ledger is you can create it once and then sort, filter, and create different Summary Views from the same data.
Choose a date range and select a specific account number (optional). If you do not select a specific account number, the report will default to all account numbers. Once you make your selections, the GL Report runs. Open the report and you'll find all Account Numbers/Subledgers. The sort order is:
- GL Number (smallest to largest)
- Subledger Name (A-Z)
- Division (A-Z)
- Department (A-Z)
The Classic Reports feature to "Include Unreplaced Binder Information" is not available in this report. To track unreplaced binder billings, use the Unreplaced Binders Report in AMS360 Classic Reports.
The following report columns have been added:
-
Customer Acquisition
-
Customer Business Origin
-
Customer Referral Name
-
Customer Referral Location
The following pre-filters have been added:
-
BU fields
-
Type of GL accounts:
-
Balance sheet accounts
-
Income and expense accounts
-
Range of Account - show beginning and ending account numbers boxes
-
Specific Account Number
-
Default Views
- Detail View: List of each transaction posted to the GL for the selected date or date range requested.
- Summarize by Subledger: Totals by subledger (bank, customer, company, employee, etc.). From this level you can click the + (plus) icon at the beginning of the sub-ledger row to see the detail for that subledger.
When viewing the subledger detail you'll see beginning and ending balances as well as total debits and credits at the top of the page. In the detail grid are Beginning and Ending Running Balance columns. Use the Running Balance to understand how each transaction affects the GL.
|
The running balances in the detail grid are fixed. If you sort or filter the data the balances might not be accurate as they aren't recalculated. A field called GL Subledger Order (hidden in the default view) manages the transaction order and the totals are only valid when the items appear in sequential GL Subledger Order. |
Special Feature
The report includes a column named Vendor Payment Details. It contains a comma-separated list of details related to a specific vendor invoice/payment. For example, if you created a vendor invoice, paid it, voided the payment, and then created a new payment; the Vendor Payment Details column would contain all the transactions providing an audit trail.
|
Data Level Security for this report: Business Unit |