DYNAMIC3i Balancing Steps:

Note. Example and document below use the A/R Balancing Inquiry – AR0300 and Report – AR0310. The same process and discussion explains also the Inventory Balancing Inquiry – IN1700 and Report – IN1810.

1) G/L Ledger – Sub ledger

a) Run the Summary Accounts Receivable Trial Balance AR4500 for the month

b) Run the G/L Summary Trial Balance – GL2300 for the main A/R control Account for the Month

2) If the above do not match then proceed to the Balancing Inquiry – AR0300

Run for the month date range in question. This will show any differences and pinpoint as to where the difference is:

3) Using the above information (ie. There is a difference in the ‘Payment / Credits’) Proceed to the A/R Balancing Report – AR0310

Run the report for the area identified in 2) above for unbalanced entries only and for the date range of the month required to be analyzed.

This will pinpoint the Invoice, customer, journal where there is an issue. Run this report for each area identified in 2) above if required.

4) Using the above report the entries on the left (A/R) will show corresponding transactions on the G/L on the right.

If there is no matching transactions on either side then asterisks (‘*’) will be printed.

Note. Small rounding issues may occur and the dollar value should also be looked at eg. 32056.51 may show on the right but on the left a summarized entry may show 32056.52 These would show like an imbalance but can be ignored.

Also, The entries on the left (A/R) may also total to a value on the right. Each would print but no asterisks would show. Below the bolded STA304 transaction matches /cancels out the right hand side Wherein the total of the left for BAS0000 totals to the single BAS000 417.50 on the right

Essentially you are only concerned with transactions identified with an asterisks AND a dollar value opposed to each other on the left or right..

5) Once you have these transactions then you can use the information (eg. Journal number, document, invoice, customer and go to the G/L Transactions – GL1800 or actual invoice, payment inquires in A/R to analyse further to see what occurred.