AP to GL Reconciliation

SOLVED

When reconciling AP to the GL and using the AP Trial balance, does the invoice date have an impact on differences? As I understand it using the AP Trial balance goes by transaction date which is the GL posting date. I'm reconciling day by day and sometimes the AP invoice date does not equal the transaction date. Would this scenario be a valid difference in balancing the AP Trial Balance to GL or no because the the trial balance does not use invoice date?

Parents
  • +1
    verified answer

    AP Aging uses Invoice Date and is intended for managing payables (not for balancing with the GL). 

    AP Trial Balance uses Transaction date and is designed to balance with the GL. The invoice date doesn't matter.  (However, there may be rare data patterns where Trial Balance report filters are imperfect... like if you backdate the payment posting date to before the invoice's posting date... but that should never happen.  Prepayments should be posted separately, and applied later).

  • 0 in reply to Kevin M

    Kevin, So are you saying that the A/P Aging will never balance to any other report other than the current day with A/P trial balance (if all transactions have stopped for a closing) ? It will never match the same period Balance sheet, GL A/P ending balance history, or GL A/P  detailed report. All of which match each other but none of which match the aging report.  It's merely a means to keep track of invoices and age them for managing them?

  • 0 in reply to Futureguard

    AP Trial Balance is for balancing with the GL.

    AP Aging is for managing your payables.  It "might" balance with the GL, if you always set Invoice Date = Posting Date, but that doesn't happen in the real world.

    The two reports have different purposes.

Reply Children