1. In Accounts Payable, select Reports > Invoice Reports
  2. Highlight Open Invoice Report and click New
  3. On the General tab, select Detail for the Report format
  4. For "Show invoices open as of", select <Specific Date> and enter the last day of the reconciliation period
  5. For "Base invoice open date on", select Post Date
  6. For "Transaction date", select Include All Dates
  7. For "Post date", select <Specific Range>, leave the Start Date field blank and enter the End Date as the last day of the reconciliation period
  8. For "Due date", select Include All Dates

    Note: To ensure all posted transactions are included, select Include All Dates for the Transaction Date range and the Due Date range
 
  • Go to the Filters tab
  • Change the Post Statuses filter from All to Selected
  • In the Select Post Statuses screen, select Posted

    Note: In many situations, credit memo applications will have a Do Not Post status and will need to be included in the filter to show the invoice as paid.
 
  • Click OK
  • Go to the Format tab and highlight Detail
  • Mark the checkbox for "show unapplied credit memo schedule"
  • Click Preview
Subtract the Grand Total of the Unapplied Credit Memo Schedule from the Net Amount Due of the Invoices. Compare this number to the number on the General Ledger report.


For more information, refer to: