Reconcile the AR Aging Schedule report to the AR GL account
You can reconcile AR aging information to the year-to-date AR GL account balance by generating the Aging Schedule report and the General Ledger report using the following settings.
Aging Schedule report
Option | Setting |
|---|---|
Date | All |
As of date | <current period end date> |
Discount treatment | Gross |
Aging basis | <your preference> |
Period definition | <your preference> |
General Ledger report
Option | Setting |
|---|---|
Date | Current period |
Regions to include | <your preference> |
Sections to include | <your preference> |
Accounting method | Accrual basis (or Client basis if the client is set up as accrual in the Setup > Clients screen) |
Journal entry format | <your preference> |
note
- To display detailed information on the Aging Schedule report, use theAging Schedule - Detailedreport.
- To display detailed information on the General Ledger report, clear theSummarize accounts receivable accountcheckbox in the Journal Entry Format section of the report options.
- To ease the process of reconciling, we recommend that you post transactions to the posting period in which the transaction date falls.
- If a client has non-AR transactions posted to the AR account, the general ledger balance will be impacted and differ from the aging schedule total.
- If a client uses multiple AR accounts, take the combined balance of those accounts into consideration on the General Ledger report.