Skip to main content

Detail Balancing [report] [A/P]

Detail Balancing [report] [A/P]​

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

The A/P Detail Balancing Report is used as a tool to find why your Accounts Payable is out of balance.

THE REPORT DOES NOT RECONCILE YOUR ACCOUNTS PAYABLE ACCOUNT.

The A/P Detail Balancing report should be run in conjunction with the A/P Journal Transaction Balancing Report to troubleshoot why you are out of balance.

  • The A/P Detail 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 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/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.