Reconciling Accounts Receivable to the General Ledger

How to troubleshoot errors when Project Financial Transaction Transfer fails to transfer data from Financials to project controller.
• Begin with identifying the period/year where the two first went out of balance. Run the reports for prior periods until you determine the last period AR and GL were in balance and the period they first went out of balance.

1. Customer Trial Balance (08.620) – Open Documents Only format or the Aged AR (08.610) – Summary Customer Balances format.

2. General Ledger Trial Balance (01.610) either format – Run this just for the account being balanced. This is done by entering a Select statement for your Accounts Receivable account as follows: Field: account.acct, Operator: Equal, Value: (the account number).

The account total on the GL Trial Balance report should balance with the total on the Accounts Receivable report. If the totals from these two reports balance, no further reconciliation is needed.

NOTE: If multiple Accounts Receivable accounts and or multiple subaccounts are used, print the AR report with a select statement to include only one of the AR accounts and then use the same select statement in the GL Trial Balance and compare each AR account one by one.

3. Customer Period Trial Balance (08.621) and Period Sensitive Aged AR (08.611) – To reconcile past periods, Dynamics SL provides these reports that show the document balances as of that period and can be used to reconcile against General Ledger for that prior period.

4. Reconciling Differences Between the AR report and the GL Trial Balance

If a difference is found by comparing the totals of either the Aged AR or the Customer Trial Balance with the GL Trial Balance, there are many detailed reports available in Dynamics SL to help find the differences.

• Detail General Ledger (01.620) – Print this report for the Accounts Receivable accounts. This will show all the entries posted to the accounts for the period.

To verify the module where an entry to AR originated, use the Jrnl Type field. It will have the module designated as AR (Accounts Receivable), GJ (General Ledger) or AP (Accounts Payable). It is possible that when entering a GL batch, the Journal Type could be changed to AR in which case using the Jrnl Type alone to find discrepancies may not be enough. If that occurs, use Tran Type in addition to Jrnl Type to identify the necessary transactions. The possible Tran Types are GL (General Ledger), CE (Consolidation), LS (Allocation Source) and LD (Allocation Destination). The Tran Type is equivalent to the document type of the original document.

If there is a Jrnl Type other than AR, this would indicate that an entry was made to the Accounts Receivable account through a module other than Accounts Receivable which would create a difference between General Ledger and Accounts Receivable. A simple way to find the original entry for the transaction is to do the following:

1. Note the batch number of the transaction in the Bat Nbr field and the entry in the Jrnl Type field on the Detail General Ledger report.

2. Open the Edit Report for the module noted in the Jrnl Type field (i.e. if the Jrnl Type field is GJ, open the GL Edit (01.810) report). Enter a select statement to have the report include only the batch number noted above. Research the transaction in question on the Edit Report and decide what adjustments are needed to balance the accounts between the General Ledger accounts and the Accounts Receivable.

Entries posted to prior periods will not print on the current Detail General Ledger report. To determine if entries have been posted to prior periods, compare the beginning balance of the current month Detail General Ledger report with the ending balance of the prior month’s report for Accounts Receivable accounts and subaccounts. If the beginning balance of the current month and the ending balance of the prior month are not the same, it is an indication that a transaction has been posted to the prior period. Print a Detail General Ledger for the prior period and research the transactions that were posted to that period. Transactions posted in a different period will be marked with an asterisk (*) and the explanation ‘Indicates that the period entered is different from the period post’ will be printed at the bottom of the page making it easy to glance at a page to see which transactions were posted in a different period.

• GL Transaction (01.680) – This report is also used when trying to reconcile differences between General Ledger and Accounts Receivable. Generate this report with an Unposted format. All transactions entered through subsidiary modules such as Accounts Receivable as well as those entered through the General Ledger are listed on this report. It will ensure there are no unposted transactions that may affect the customer or General Ledger balances.

• Account Distribution (08.630) – To ensure that the Accounts Receivable accounts were properly debited for invoices and debit memos and credited for payments and credit memos, a review of this report should be done. The balance on this report should equal the balance of the Accounts Receivable accounts in the Detail General Ledger report. A review of the Transaction Type (TnTp) field will help identify transactions. Transaction types in the Accounts Receivable module are IN (invoice), PA (payment), CM (credit memo), DM (debit memo) and FI (finance charge). The batch number of each transaction is also listed on this report. If a questionable transaction is found, note the batch number in the Batch field and review the batch by running the AR Edit (08.810) report by batch number.

• AR Transactions (08.640) – This report is very helpful if questionable transactions appear on any of the above reports. This report lists each transaction entered for the current period in Invoice and Memo (08.010), Payment Applications (08.030) and Payment Entry (08.050). It shows each Accounts Receivable account and offsetting expense account to which the transactions are posted. To sort the report by transaction type, select ARTRAN.TranType in the Sort/Select field and in the value field select the TnTp type of the transaction in question.