The General Ledger (GL) Report displays detailed transaction information on all sales and payments over a specified date range.
The report includes GL information for all items provided that the 'GL Code 1', 'Receivable GL Code', 'GL Description1' and 'GL Description2' fields have been populated in the following areas:
•Event Configuration - Events|Basic page for all events
•General Configuration - Payment Methods|Basic page for all payment methods (does not have a 'Receivable GL Code' field)
•Product Configuration - Charges|Details page for all charges
•Product Configuration - Miscellaneous Items|Details page for all miscellaneous items
•Product Configuration - Stored Value Items|Details page for all stored value items
•Funds Management - Funds|Details page for all funds
|
Information 'Account Receivable Payment GL' and 'Unallocated Payment GL' field labels can be configured in the Registry - Application::System node. |
This report will provide an overview of your accounts receiveables.
You can extract the report without the criteria headings so that you can import it into any accounting platform that accepts .CSV input.
Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Transaction Date Format |
Specifies the date(s) to use for the report: •Date Range •Previous 7 Days (excluding today) •Today •Yesterday |
Transaction From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is selected in the 'Transaction Date Format' field. Click |
Transaction To |
If you are entering a date range, this is the date to which data will be included in the report. This date is inclusive where the end time will be up to 23:59:59 on the selected date. Any value entered into this field will only apply if Date Range is selected in the 'Transaction Date Format' field. Click |
Items to Include |
Enables you to specify other transaction types to include: •Receiveable •Unallocated |
Report Output By |
Specifies whether to display transactions by: •Summary: Grouped by GL Code, displaying the net values for each. •Detail: Grouped by item and order, displaying all of the sales/refunds that net to zero/cancel each other out. |
Display Headers |
Enables you to specify whether the report will include headers. This field only effects the CSV version of the report. |
Advanced Section
The following criteria is available in the advanced section:
Criteria |
Description |
User Role |
Filters the report by the selected user role(s). This is the user who last updated the order. |
User Role Group |
Filters the report by the selected user group(s). |
Marketing Data [1-8] |
Enables you to include information that is populated in the available 'Marketing Data' fields. |
Output
The following image illustrates the report's output when Receivable and Unallocated have been selected from the 'Items to Include' field:
The following table describes the report’s output:
Column |
Description |
GL Code |
Displays the GL Code name. |
GL Description1 |
Displays the first GL description. |
GL Description2 |
Displays the second GL description. |
Debit |
Displays the total debits for each of the GL codes. |
Credit |
Displays the total credits for each of the GL codes. |
