GL Reconciliation Report
Use the GL Reconciliation Report to view transactions by GL account and help balance entries that are being made in General Ledger.
Printing a GL Reconciliation Report
1. Open Connect Accounts Receivable > Reports > GL Reconciliation Report.
2. Select a report title.
3. Enter the Report Dates.
Report Dates is the report date range. The report will use the report date range to select transactions to print on the report.
4. Select the Summarization Level.
The Summarization Level refers to the amount of information to include on the report. Use detail to show data at the transaction level. Or, if less information at a higher level is easier to digest, switch to summary by date. Summary by date to show the transaction total for the each date in the selected date range.
Do you want to summarize transactions by date?
-
Show me the detail; list transactions by GL account. Use the Summarization Level field to select Detail.
-
Give me an overview; print daily debit and credit totals by GL account. Use the Summarization Level field to select Summary by Date.
5. Select the Transaction Types.
A transaction type records the exchange or transfer of goods, services, or funds for a given category. The transaction types that are available for selection depends on the selected GL Update Method.
|
Transaction Types |
Accrual Method |
Cash Method |
|
Credit memo |
X |
|
|
Credit memos applied |
X |
|
|
Deposits applied |
X |
X |
|
Deposit interest |
X |
X |
|
Invoices |
X |
|
|
Payments |
X |
X |
|
Payments applied |
X |
X |
|
Payment adjustments |
X |
X |
|
Write-offs |
X |
|
Which transaction types do you want to report?
The Transaction Types area lists all of the transactions types for the application. Click to select a transaction type, or click to clear the checkbox to remove the transaction type from the report.
6. Click the Categories tab.
Categories are used to categorize invoice charges, control penalty, and tax calculations, and determine the GL accounts to be used when updating General Ledger.
Which categories do you want to include?
-
Use all categories. On the Categories tab, click to select the Include All Categories checkbox.
-
Let me choose which categories to include. On the Categories tab, click to clear the Include All Categories checkbox. Then, click Select. Use the Selection form to add categories to the Selected Categories list. Click OK.
7. Set the Summarize Categories by Master Categories checkbox.
If you are using a master category to track information, you can set up the GL Reconciliation Report to report transactions by master category. For example, Jane has a master category called Rental Fee, which includes all of the categories that collect rental fees: City Park Pavilion Rental Fee, Library Basement Rental Fee, and Pool Rental Fee.
Do you want to summarize categories by master categories?
-
Show allocated amounts based on the master category instead of using regular categories. Select the option to Summarize Categories by Master Category.
-
Show allocated amounts using regular categories. Clear the option to Summarize Categories by Master Category.
8. Click Print (CTRL+P).
The report prints.
Categories
Categories are used to categorize invoice charges, control penalty, and tax calculations, and determine the GL accounts to be used when updating General Ledger.
Which categories do you want to include?
-
Use all categories. On the Categories tab, click to select the Include All Categories checkbox.
-
Let me choose which categories to include. On the Categories tab, click to clear the Include All Categories checkbox. Then, click Select. Use the Selection form to add categories to the Selected Categories list. Click OK.
GL update method
The GL update method is the process the system uses to post transactions that are created in Accounts Receivable to the General Ledger. The accrual method records gross income when earned. While the cash method records gross income when the cash is received. The GL Update Method field displays the method used to post transactions to the General Ledger.
Summarize categories by master categories
If you are using a master category to track information, you can set up the GL Reconciliation Report to report transactions by master category. For example, Jane has a master category called Rental Fee, which includes all of the categories that collect rental fees: City Park Pavilion Rental Fee, Library Basement Rental Fee, and Pool Rental Fee.
Do you want to summarize categories by master categories?
-
Show allocated amounts based on the master category instead of using regular categories. Select the option to Summarize Categories by Master Category.
-
Show allocated amounts using regular categories. Clear the option to Summarize Categories by Master Category.
Summarization level
The Summarization Level refers to the amount of information to include on the report. Use detail to show data at the transaction level. Or, if less information at a higher level is easier to digest, switch to summary by date. Summary by date to show the transaction total for the each date in the selected date range.
Do you want to summarize transactions by date?
-
Show me the detail; list transactions by GL account. Use the Summarization Level field to select Detail.
-
Give me an overview; print daily debit and credit totals by GL account. Use the Summarization Level field to select Summary by Date.
Transaction types
A transaction type records the exchange or transfer of goods, services, or funds for a given category. The transaction types that are available for selection depends on the selected GL Update Method.
|
Transaction Types |
Accrual Method |
Cash Method |
|
Credit memo |
X |
|
|
Credit memos applied |
X |
|
|
Deposits applied |
X |
X |
|
Deposit interest |
X |
X |
|
Invoices |
X |
|
|
Payments |
X |
X |
|
Payments applied |
X |
X |
|
Payment adjustments |
X |
X |
|
Write-offs |
X |
Which transaction types do you want to report?
The Transaction Types area lists all of the transactions types for the application. Click to select a transaction type, or click to clear the checkbox to remove the transaction type from the report.
Copyright © 2025 Caselle, Incorporated. All rights reserved.