Detail Balancing [report] [A/R]
Detail Balancing [report] [A/R]
From the DockMaster menu, select Accounts Receivable > Reports > Detail Balancing
Report ID: DM.AR.DETAIL.RECONCILE
The A/R Detail Balancing Report is used as a tool to find why your Accounts Receivable is out of balance. Use the A/R Detail Balancing Report in conjunction with the A/R Journal Transaction Balancing Report to trouble shoot why you are out of balance.
The A/R Detail Balancing Report should be run AFTER you have run the A/R Aging Report and A/R General Ledger balance. If the two reports do not balance, the Detail Balancing Report can be run in Summary to locate the day the error occurred. In the 3rd tab Specific Values enter the date range for the month you are trying to balance, i.e.. 12/1/24 on the first line and 12/31/24 on the second line. Verify that the schedule account listed in the third line is your accounts receivable general ledger account number you are trying to balance. Make sure that the "DETAIL SUPPRESS" box is checked in the 4th tab Advanced Options. Compare this report to the results of the A/R Journal Transaction Balancing Report processed in the same format. Once the day is known, re-run the Detail Balancing Report for that specific date, making sure to UNCHECK the DETAIL SUPPRESS box in the 4th tab to print a list of transactions that were posted to the accounts receivable module for that day. Compare this detail report to the A/R Journal Transaction Balance Report (also run in detail for that same day). You should then be able to identify the transaction(s) that is causing the out of balance.