How AP Reconciliation Works in Sage 100
The process begins with the AP records maintained in Sage 100, including vendor invoices, credit memos, payment entries, and open invoice balances. The finance team compares these records with supporting documents and the corresponding general ledger accounts. The aim is to establish whether each transaction is complete, correctly applied, and reflected in the appropriate reporting period.
For example, a supplier statement may show an invoice for $8,400, while Sage 100 shows $6,900 outstanding. The team checks whether a $1,500 payment was applied to that invoice, whether a credit memo was entered, or whether the supplier statement includes a transaction that has not yet been posted. The difference should be explained by transaction-level evidence before the reconciliation is considered complete.
Consistent invoice processing supports this review by capturing invoice details, validating supplier information, assigning general ledger codes, and routing transactions for approval before posting. Supporting records make it easier to trace a balance back to its source.
Key Records and Reconciliation Checks
A reliable reconciliation brings together the documents and reports needed to verify supplier balances. The exact reports available depend on the Sage 100 version, configuration, and modules in use. Common checks include:
- Vendor balances: Compare the amount owed to each supplier against supplier statements and open invoices.
- Invoice and credit memo entries: Confirm amounts, dates, reference numbers, and posting status.
- Payment applications: Verify that issued payments are recorded and applied to the intended invoices.
- General ledger balances: Compare the AP control account with the total of the corresponding subsidiary records.
- Cutoff and period dates: Check that transactions are recorded in the correct accounting period.
Tools such as AP Automation Software can support invoice validation and payment planning, while procurement records help establish whether an invoice relates to an authorized purchase. For suppliers, accurate vendor management records also help teams confirm the correct vendor account and payment details.
Investigating Differences and Adjustments
Differences should be classified before an adjustment is made. Common explanations include invoices not yet entered in Sage 100, payments still in transit, unapplied credits, duplicate entries, amount discrepancies, and timing differences between supplier records and the accounting system. Each item should have a documented explanation and a clear next step.
Suppose a supplier statement totals $24,600, while Sage 100 lists $22,100 in open invoices. The initial difference is $2,500. If supporting records confirm an unrecorded credit memo of $1,700 and a $800 invoice received after the statement date, the team can investigate the period and posting treatment of both items. The difference is fully explained only when the transactions and their accounting treatment are verified, not simply because the amounts add up.
When invoice capture, validation, invoice matching, GL coding, and posting follow a consistent workflow, reconciliation evidence is easier to trace. The guide Vendor Invoice Processing 2025: AI Supplier Workflow Guide discusses these steps, while How Vendor Portals Improve Invoice Transparency explores how supplier visibility into invoice status can support follow-up and clarification.
Approvals, Payments, and Close Controls
Reconciliation findings may require a corrected invoice entry, a credit memo, a payment application, or a general ledger adjustment. Each change should follow the organization's authorization rules and retain supporting evidence. AP Invoice Matching Approval concerns authorization around invoice matching outcomes, while Payment Approval governs authorization to release payments. Keeping these decisions distinct helps ensure that confirming an invoice balance does not automatically authorize a payment.
Before close, finance teams should confirm that identified adjustments have been reviewed and posted, outstanding items have owners, and the AP control account agrees with the supporting vendor balances. Payment records should also be checked against bank or remittance evidence where relevant. These checks help keep supplier obligations visible and support dependable cash planning.
Best Practices for Accurate Reconciliation
Set a consistent reconciliation schedule based on transaction volume and reporting deadlines. Reconcile high-value or frequently used supplier accounts regularly, retain supplier statements and transaction references, and assign each unresolved difference to a named owner with a due date. Review recurring discrepancies to identify whether they originate in invoice entry, credit memo handling, payment application, or period cutoff.
Use the same supplier identifiers and date ranges when comparing reports, and preserve an audit trail for every adjustment. A documented Accounts Payable Reconciliation procedure defines how balances are compared and how differences are resolved. Related AP Invoice Matching Approval and Payment Approval controls should be applied according to company policy. Together, these practices strengthen the quality of AP records and make period-end review more consistent.
Summary
Sage 100 AP Reconciliation helps finance teams verify supplier balances, compare AP subsidiary records with the general ledger, and resolve differences using supporting documents. By reviewing invoices, credits, payments, and cutoff dates systematically, businesses can improve liability accuracy, maintain dependable financial reports, and make better-informed cash flow decisions. A repeatable process with clear ownership, appropriate approvals, and documented adjustments supports a more controlled AP close.