Skip to main content

Journal Transaction Balancing [report] [A/R]

Journal Transaction Balancing [report] [A/R]

From the DockMaster menu, select Accounts Receivable > Reports > Journal Transaction Balancing

Report ID: DM.AR.JT.RECONCILE

The A/R Journal Transaction Balancing Report uses the Journal Transaction file to report the JT’s posted in Accounts Receivable. THE REPORT DOES NOT RECONCILE YOUR ACCOUNTS RECEIVABLE ACCOUNT. Use the A/R Journal Transaction Balancing Report in conjunction with the A/R Detail Balancing Report to trouble shoot why you are out of balance.

This 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 JT Balancing Report can be run in to locate the Journal Transaction where 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/06 on the first line and 12/31/06 on the second line. Verify that the Account Number listed in the third line is your Accounts Receivable General Ledger account 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.