Reconcile accounts payable to the general ledger

Reviewed by Ijaz Ali, ACCA · Updated November 2026

You are the staff accountant at Cedar Lantern Foods Ltd. The controller has asked for the June 30 AP reconciliation. All figures are in Canadian dollars (CAD). The AP control account is reserved for vendor balances.

June 30 balances
ReportCredit balance (CAD)
AP control account — general ledger$126,400
AP subledger — vendor aging as exported$124,000
Reconciling items
Reference and evidenceEffect on GL less exported aging (CAD)
JE 618: $2,400 June cleaning accrual credited directly to AP control, with no vendor item. Cleaning invoice CL-104 arrived in July and confirms the accrual.$2,400
Invoice PK-289: $900 June vendor credit balance recorded in both ledgers. The aging export excluded the warehouse branch.$900
Credit memo CM-118: $900 June vendor debit balance recorded in both ledgers. The aging export suppressed debit balances.−$900

Your tasks

  1. Calculate the difference between the June 30 GL balance and the vendor aging export.
  2. Explain which items need a journal entry and which require correcting the report filters.
  3. Prepare the correcting entry and calculate the revised control account and unfiltered aging balances.
  4. Draft a short recommendation to the controller and identify the evidence to retain.

Check your figures

  1. June 30 GL less vendor aging
  2. June 30 aging after fixing both filters
  3. June 30 AP control balance after reclassification

Make the decision

What should the reviewer approve?

Reveal worked solution

The GL exceeds the exported aging by CAD $2,400 ($126,400 − $124,000). The reconciling items are $2,400 + $900 − $900 = $2,400. Rerun the aging with the warehouse branch and vendor debit balances included: $124,000 + $900 − $900 = $124,000. Reclassify the $2,400 cleaning accrual so the GL also reaches $124,000. In July, process CL-104 against the accrued liability to avoid expensing the service twice.

June 30 correcting journal entry (CAD)
AccountDebitCredit
Accounts payable control$2,400—
Accrued liabilities—$2,400

Document your recommendation

Write a short note to the controller explaining the difference, the correcting entry and the reporting controls.

Compare with a model controller note

The June AP control balance of CAD $126,400 exceeds the exported vendor aging of $124,000 by $2,400. The $900 excluded warehouse invoice and $900 suppressed vendor credit memo offset in total, but both belong in the aging. The remaining difference is the June cleaning accrual posted directly to AP control. I recommend moving $2,400 to accrued liabilities, rerunning the unfiltered June aging and confirming both balances at $124,000. Please retain the aging parameters, source journal and July cleaning invoice with the reconciliation and review direct posting access to AP control.

In the workplace

  1. Vendor with a debit balance: The vendor credit memo has left this vendor with a debit balance. Follow up with the vendor to request a refund or apply the credit to the next invoice. If debit balances are material at year-end, consider reclassifying them to receivables for presentation.
  2. System control: In ERP systems such as SAP, the AP control account is usually set up as a reconciliation account, which blocks direct journal postings. A direct posting like the one in this case suggests the control is missing or has been bypassed. The memo should recommend restricting direct postings to the AP control account.

What’s next

Try another case:

Review the related lesson: Accounts payable

Want one-to-one help with month-end close or SAP? Book a free 30-minute intro

All companies, people and figures in this case are fictional and for study purposes only.

About the tutor

Ijaz Ali is an ACCA-qualified Senior Accountant with over 10 years of experience in financial reporting, month-end close and SAP FICO. He is a former SAP FICO instructor and runs The Accounting Nest YouTube channel.

Watch on YouTube