You can reconcile your subsidiary balance directly to the Aged Accounts Payable Report instead of the Open Invoice report, but it is not recommended for the following reasons:
    • The Open Invoice Report, by design, reflects those invoices that are still open, and therefore, part of your balance.
    • Differences between your subledger and the Open Invoice report, when defined with the correct parameters [Accounts Payable 7], are more limited and generally consist of data entry issues such as defining the invoice and post dates (or reversal dates for voided and deleted items) in different periods, making journal entries directly to the subsidiary Ledger control account.
    • The Aged Accounts Payable report does not include deleted invoices, but the Open Invoice report will include deleted invoices if their reversal post date falls after the "Show Invoices open as of" date.
    • The Aged Accounts Payable report introduces another level of complexity as it can include current invoices that are not yet due and credits that are not yet available as of your cut off date.

    For best results, reconcile your Accounts Payable subledger to the Open Invoice report, and then reconcile your Open Invoice Report and Aged Accounts Payable report