JT Balancing [report] [A/P]

JT Balancing [report] [A/P]

From the DockMaster menu, select Accounts Payable > Reports > JT Balancing

The A/P Journal Transaction Reconciliation Report (Balancing Report) uses the Journal Transaction file to report the JT’s posted in Accounts Payable. THE REPORT DOES NOT RECONCILE YOUR ACCOUNTS PAYABLE ACCOUNT. The A/P Journal Transaction Balancing Report should be run in conjunction with the A/P Detail Balancing report to trouble shoot why you might be out of balance.

The A/P Journal Transaction Balancing Report should be run AFTER you have run the A/P Aging Report and A/P General Ledger balance. If the two reports do not balance, the JT Balancing Report can be run 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 schedule account listed in the third line is your accounts payable 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/P 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 payable module for that day.  Compare this detail report to the A/P 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.