If Purchase Invoices and Accounting reports do not match, check the following:
- All invoices and payments from the separating month have been transferred to accounting. You can read about transferring invoices to accounting here and transferring payments here.
- The previous month's Open Purchase Invoices report matches the accounts payable balance in the ledger.
- Check for duplicate payments.
- Check if any invoice has been overpaid.
- Check if any invoices have been deleted with associated payments that have not been removed yet.
- Check if any invoice has an invoice date/receipt date in a later month than the payment. Follow the instructions below:
1. Go to Purchase Invoices --> All view
2. Filter invoices for the reconciling month (Receipt date filter)
3. Filter the last payment date to the last day of the month preceding the reconciling month