How the AP and General Ledger Balances Connect
In Sage 100, vendor transactions are maintained through accounts payable workflows and contribute to the accounting balances according to the system configuration and posting process. When invoices, credit memos, and payments are posted, their accounting entries affect the relevant liability and offsetting accounts. The AP subsidiary balance should reconcile to the AP control account for the same entity, currency basis, and accounting period.
Consistent invoice processing helps ensure that invoice amounts, supplier details, accounting dates, and posting status are captured correctly. The gl coding assigned to each transaction determines which general ledger accounts are affected. Because procurement activity often initiates the purchase behind a vendor invoice, purchase orders and receipt records can also provide useful evidence when investigating an unmatched transaction.
Steps to Reconcile AP to GL in Sage 100
Begin by selecting the same company, accounting period, and reporting cutoff for the AP and general ledger reports. Use the appropriate Sage 100 reports for vendor balances, AP activity, and general ledger account activity, based on the version and configuration in use. Confirm that the reports include the intended posted transactions and that the AP control account has been identified correctly.
- Establish the AP total: Run the relevant AP aging or vendor balance report for the selected cutoff date.
- Establish the GL total: Review the general ledger balance and account activity for the AP control account.
- Compare the balances: Calculate the difference between the AP subsidiary total and the GL control account balance.
- Trace the variance: Review posting dates, journal entries, invoice batches, credit memos, payment records, and any direct entries to the control account.
- Resolve and document: Correct verified posting or classification issues through authorized procedures, then rerun the reports to confirm the result.
Keep the report dates, filters, account numbers, and supporting transaction references with the reconciliation. These details allow another reviewer to reproduce the comparison and understand how the final balance was established.
Calculating and Interpreting the Difference
A straightforward reconciliation uses this calculation: Reconciliation Difference = AP Subsidiary Balance − GL Control Account Balance. When both balances are prepared on the same basis, a result of zero indicates that the totals agree. A nonzero result identifies an amount that requires investigation; it does not, by itself, establish which record is incorrect.
For example, assume Sage 100 shows an AP subsidiary balance of $126,400 and the general ledger AP control account shows $123,900 for the same cutoff date. The calculation is $126,400 − $123,900 = $2,500. The AP detail therefore exceeds the GL control account by $2,500. The accountant should inspect posting status, journal entries, period cutoff, and transaction history to identify the source before recording any adjustment.
Differences may arise when AP transactions have not been posted to the ledger, a direct journal entry affects the control account, a payment or credit memo is included in one report but not the other, or reports use different cutoff dates. Accruals for goods or services received but not yet invoiced should also be reviewed separately according to the organization's accounting policy, since their treatment may involve accounts outside the AP subsidiary balance.
Controls, Approvals, and Supporting Evidence
Good reconciliation controls establish who prepares the comparison, who reviews variances, and who can approve adjustments. AP Automation Software can support accurate invoice validation and posting workflows, while a documented review process ensures that accounting differences are examined before close. The invoice matching process helps verify that invoice details align with relevant purchase orders and receipts before transactions proceed through approval and posting.
AP Invoice Matching Approval addresses authorization associated with invoice matching, whereas Payment Approval governs authorization to release a payment. These controls support different decisions and should not replace review of the AP-to-GL balances. Payment records and remittance details should be traceable to posted transactions, and the handling of payments should follow the organization's established approval and accounting procedures.
For broader process context, the guide How Vendor Portals Improve Invoice Transparency discusses how invoice status visibility can support communication and clarification. Strong transaction evidence, clear ownership, and consistent posting practices help maintain dependable accounts payable records.
Best Practices for Period-End Reconciliation
Reconcile AP to GL at a consistent frequency, ideally before financial reports are finalized for each period. Investigate material variances first, but document smaller differences as well when they indicate a recurring posting or cutoff issue. Review manual journals affecting the AP control account, verify that relevant batches are posted, and confirm that adjustments have appropriate support and authorization.
Maintain a reconciliation file containing the AP report, GL report, difference calculation, variance explanations, supporting documents, adjustment references, and reviewer sign-off. A clear Accounts Payable Reconciliation procedure defines how subsidiary balances are checked against accounting records. This repeatable approach improves audit readiness, supports accurate liability reporting, and gives finance leaders greater confidence in period-end figures.
Summary
Sage 100 AP to GL Reconciliation confirms that detailed vendor balances agree with the general ledger accounts representing accounts payable. By comparing reports for the same period, tracing differences to transaction evidence, and documenting approved corrections, finance teams strengthen financial reporting and period-end controls. Consistent reconciliation helps ensure that supplier liabilities are accurately represented and that decisions based on accounting balances use dependable information.