At month end, your Accounts Payable general ledger balance and your A/P reports should tell the same story. When they do not reconcile, it creates extra close work and makes it harder to trust aging, vendor balances, and cash planning.

A common root cause in Cetec ERP is an A/P payment that was edited or canceled partway through, then left open or incomplete. The ledger can still reflect the intended balance while the A/P reporting views show a different result until those payment records are fully closed out.

Start With the A/P Payment List

If your G/L Accounts Payable balance does not match A/P Summary or A/P by Vendor, review the A/P Payment List (Accounting >> A/P >> A/P Payment List (Pay Vouchers)). Look for payment records that were initiated for a vendor, then edited, canceled, or partially reversed.

In the support case that prompted this write-up, the difference between the general ledger balance and the A/P reports tied directly to two vendors. The general ledger balance was treated as correct, and the reporting discrepancy was traced to payment records that needed attention.

Close Out Edited or Canceled Payments

When your team needs to edit or cancel an A/P payment, make the needed changes to the applicable fields, then complete the process by clicking the “Mark as Paid” button. That closeout step matters because it prevents an A/P payment from remaining open or incomplete and continuing to affect A/P reporting totals.

As a practical check, if you see multiple payment records for the same vendor that net to a single amount, confirm each record is fully closed and not left in a partially updated state.

Special Case: Canceled Payments Must Be Zeroed Out

Canceled payments can fail to show correctly in A/P reports if values remain on the payment record. In that situation, zero out all values (A/P value, Cash value, and Debit Memo value if applicable), ensure that all “Include?” boxes are unchecked, then complete the closeout using “Mark as Paid.”

How to Decide What to Fix First

If the A/P reports show an unexpected negative vendor balance, start by looking for an edited or partially reversed payment that is still open. If the A/P reports are missing an expected vendor amount after a cancellation, focus on the canceled payment record and confirm all values were zeroed and excluded before closing it.

Key Takeaways

• When A/P reports do not match the Accounts Payable general ledger balance, review the A/P Payment List for open or incomplete payments.
• After editing or canceling an A/P payment, use “Mark as Paid” to fully close the payment record.
• For canceled payments, zero out all values and uncheck all “Include?” boxes before closing the payment.
• Cleaning up incomplete payment records is often enough to bring A/P by Vendor, A/P Summary, and the ledger back into alignment for close.

Conclusion

A/P to G/L reconciliation problems are often caused by workflow interruptions, not accounting theory. When your team consistently closes out edited or canceled A/P payments in Cetec ERP, A/P reporting stays aligned with the Accounts Payable ledger balance and month-end close becomes more predictable.