🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › Accounts Receivable and Accounts Payable › Lesson 8
BUS-BOOK55-04 · Lesson 8 · 12 clock hours · lab

Vendor Statements, Debit Memos, and AP Reconciliation

Objective. Students reconcile a vendor statement to the QuickBooks AP subsidiary ledger, identify discrepancies, and record a debit memo for a returned purchase.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why AP Reconciliation Matters

Accounts payable (AP) reconciliation is the process of confirming that the balance your company shows for each vendor matches what that vendor believes you owe them. Discrepancies cost money — you may pay a bill twice, miss a credit, or damage a vendor relationship by disputing an invoice that actually exists in your own system under a different date. The AIPB Certified Bookkeeper exam tests this skill directly, and QuickBooks is the tool most employers use to manage it day to day.

Reconciling AP is not just a clerical check. It is a control procedure that catches fraud, data-entry errors, and timing differences before they become larger problems.

The Vendor Statement

A vendor statement is a document the supplier sends — usually monthly — listing every open invoice, credit memo, and payment they have recorded for your account, along with the balance they believe you owe. Think of it as the vendor's version of your AP subsidiary ledger for that one vendor.

Key columns on a typical vendor statement:

Your job is to compare every line to QuickBooks.

The AP Subsidiary Ledger in QuickBooks

In QuickBooks, the Vendor Balance Detail report shows every open bill, bill credit, and payment for each vendor. The total of all vendor balances in the subsidiary ledger must equal the AP control account balance in the general ledger — that is the fundamental internal-control relationship in accounts payable.

To pull the Vendor Balance Detail report: go to Reports → Vendors & Payables → Vendor Balance Detail. Set the date range to match the statement period before comparing.

Three-Column Reconciliation Worksheet

A three-column reconciliation worksheet is the organized tool you use to compare the two sources side by side. The three columns are:

1. Vendor Statement — amounts as the vendor recorded them

2. QuickBooks Vendor Balance Detail — amounts as your company recorded them

3. Difference / Explanation — the dollar variance and its likely cause

For each line, mark one of three outcomes:

Timing differences are normal and expected. True discrepancies require follow-up.

Common Discrepancies and What They Mean

| Situation | Most Likely Cause | Next Step |

|---|---|---|

| Vendor shows invoice you don't have | Invoice never received or lost | Request copy; enter if valid |

| You have a bill vendor doesn't show | Vendor error or payment crossed in mail | Contact vendor |

| Payment amounts differ | Discount taken vs. not agreed upon | Review payment terms |

| Vendor balance higher than yours | Missing debit memo or credit not recorded | Review returns and credits |

Debit Memos for Returned Purchases

When your company returns merchandise to a vendor, you reduce what you owe them. The source document you create to record this reduction is called a debit memo (also called a vendor credit or bill credit in QuickBooks). The term "debit memo" comes from the fact that you are debiting accounts payable — reducing the liability — and crediting the inventory or expense account that was originally charged.

Journal entry for a return to vendor:

Recording a debit memo in QuickBooks:

1. Go to Vendors → Enter Bills.

2. At the top of the screen, select Credit (not Bill).

3. Enter the vendor name, date, amount, and the account to credit (usually Inventory or the original expense account).

4. Save the credit.

5. Go to Vendors → Pay Bills, select the open bill, and click Set Credits to apply the credit against the outstanding balance.

6. Confirm the vendor's updated balance in the Vendor Balance Detail report.

Applying the credit is a separate step from creating it. A credit that sits unapplied does not reduce the vendor's open balance.

Writing the AP Reconciliation Memo

After completing the worksheet, you prepare a brief reconciliation memo for each vendor. A professional memo includes:

This documentation trail is exactly what an auditor or AIPB examiner expects to see. Clear, factual language — no guessing.

Accuracy and Data Integrity

Always work from saved, backed-up QuickBooks files in a lab environment. Never alter a vendor's balance manually through a journal entry to accounts payable without proper authorization and documentation — doing so bypasses the subsidiary ledger and creates a control breakdown. If you discover an error, the correct path is to enter the missing bill, credit, or payment through the proper transaction screen, not a general journal entry to AP.

Data accuracy in AP directly affects cash flow, vendor relationships, and financial statement reliability — all areas tested on both the AIPB Certified Bookkeeper exam and the QuickBooks Certified User exam.

Key terms8

Vendor StatementA document issued by a supplier listing all open invoices, credits, and payments recorded on the supplier's books for your account, along with the balance they believe you owe.
AP Subsidiary LedgerThe detailed record — one page or section per vendor — that supports the Accounts Payable control account in the general ledger; in QuickBooks this is visible as the Vendor Balance Detail report.
Vendor Balance DetailA QuickBooks report that lists every open bill, bill credit, and payment for each vendor; used as the company-side source in an AP reconciliation.
Debit MemoA document (and the corresponding accounting entry) that reduces the amount owed to a vendor, typically because merchandise was returned; recorded in QuickBooks as a Bill Credit.
Timing DifferenceA discrepancy between the vendor statement and the company's records caused by transactions in transit or processing at different times, expected to clear in a subsequent period.
AP ReconciliationThe process of comparing a vendor's statement balance to the company's QuickBooks vendor balance, identifying and explaining all differences, to confirm that recorded liabilities are accurate.
Bill CreditThe QuickBooks transaction type used to record a debit memo or return to a vendor; it reduces the vendor's open balance when applied to an outstanding bill.
Unresolved DiscrepancyA difference between the vendor statement and company records that cannot be explained by timing alone and requires follow-up action such as contacting the vendor or requesting documentation.

Worked examples4

1. Vendor ABC's statement shows a balance due of $4,750.00. Your QuickBooks Vendor Balance Detail shows $4,350.00 for the same vendor. You find that ABC's statement includes Invoice #1089 for $400.00, but this invoice does not appear in QuickBooks. What is the likely cause, and what should the reconciled balance be if the invoice is valid?
  1. Step 1 — Compare totals: Vendor statement $4,750 minus QuickBooks balance $4,350 = $400 difference.
  2. Step 2 — Locate the item causing the difference: Invoice #1089 for $400 appears on the vendor statement but is missing from QuickBooks.
  3. Step 3 — Determine cause: The invoice was likely never received or was lost in transit — a missing bill, not just a timing difference.
  4. Step 4 — Determine correct balance if invoice is valid: $4,350 + $400 = $4,750. After entering the missing bill in QuickBooks, both balances should agree at $4,750.
  5. Step 5 — Document in reconciliation memo: Note Invoice #1089, $400, missing from QuickBooks; recommend requesting a copy from the vendor and entering the bill upon confirmation.
Answer: The $400 difference is caused by Invoice #1089 present on the vendor statement but absent from QuickBooks. If valid, the corrected QuickBooks balance is $4,750.00, matching the vendor statement.
2. Your company returned $650 of defective merchandise to Vendor XYZ. Before the return, the open bill balance for XYZ was $2,200.00. After recording and applying the debit memo (bill credit) in QuickBooks, what should the vendor's updated balance be?
  1. Step 1 — Identify the original open balance: $2,200.00.
  2. Step 2 — Identify the debit memo (bill credit) amount: $650.00.
  3. Step 3 — Calculate the updated balance: $2,200.00 − $650.00 = $1,550.00.
  4. Step 4 — Verify in QuickBooks: Open the Vendor Balance Detail report for XYZ and confirm the balance reads $1,550.00 after the credit is applied.
Answer: After recording and applying the $650 bill credit, Vendor XYZ's updated balance in QuickBooks should be $1,550.00.
3. You are reconciling Vendor LMN. The vendor statement shows three invoices totaling $3,100.00 and one payment of $1,200.00, giving a vendor statement balance of $1,900.00. QuickBooks shows the same three invoices but the payment is recorded as $1,000.00 (not $1,200.00). What is the difference, and on which side does the higher balance appear?
  1. Step 1 — Calculate the vendor statement balance: $3,100 − $1,200 = $1,900.00.
  2. Step 2 — Calculate the QuickBooks balance: $3,100 − $1,000 = $2,100.00.
  3. Step 3 — Calculate the difference: $2,100 − $1,900 = $200.00.
  4. Step 4 — Identify which side is higher: QuickBooks shows a higher balance ($2,100) because it recorded a smaller payment ($1,000) than the vendor recorded ($1,200).
  5. Step 5 — Determine next steps: Check the original check or ACH record to confirm the amount actually paid; contact the vendor if the payment amount is in dispute. This is an unresolved discrepancy until documentation confirms the correct figure.
Answer: There is a $200 discrepancy. QuickBooks balance ($2,100) is $200 higher than the vendor statement balance ($1,900) because the payment was recorded as $1,000 in QuickBooks versus $1,200 on the vendor's statement. Follow-up is required.
4. At the end of a reconciliation, Vendor PQR's statement balance is $5,500.00. Your QuickBooks balance is $5,300.00. Investigation shows your company mailed a check for $200.00 on the last business day of the month, which the vendor had not yet received or posted. After accounting for this timing difference, do the two balances agree?
  1. Step 1 — Identify the timing difference: A $200 payment is recorded in QuickBooks (reducing your balance) but not yet recorded by the vendor.
  2. Step 2 — Adjust the vendor statement balance for the in-transit payment: $5,500.00 − $200.00 = $5,300.00.
  3. Step 3 — Compare adjusted vendor statement balance to QuickBooks: $5,300.00 = $5,300.00.
  4. Step 4 — Conclusion: The balances agree once the in-transit payment is considered. This is a timing difference, not a discrepancy. Document it in the reconciliation memo and note it should clear in the next period.
Answer: Yes. After adjusting for the $200 in-transit payment, both balances equal $5,300.00. This is a timing difference, not a true discrepancy, and should be documented and expected to clear in the following month.
In class: Lab: students receive printed vendor statements for three vendors and compare each line to QuickBooks Vendor Balance Detail; they mark matches, missing bills, and timing differences on a three-column reconciliation worksheet · Students record a debit memo in QuickBooks for merchandise returned to a vendor, apply it to reduce the outstanding bill balance, and verify the vendor's updated balance · Students complete a formal AP reconciliation memo summarizing findings for each vendor, explaining any unresolved differences and recommending next steps, mirroring the documentation expected in an AIPB exam scenario
Materials: Printed vendor statements (three vendors), QuickBooks lab file, three-column reconciliation worksheet template, debit memo source document, AIPB reference (reconciliation module)
Check: Reconciliation memo and QuickBooks debit memo entry reviewed; pass = all matched items correctly identified, debit memo reduces vendor balance to correct amount, and memo clearly explains any timing differences

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

AIPB Certified Bookkeeper — Accounts Payable and internal controls
1. A vendor statement shows Invoice #2201 for $875, but this invoice does not appear in the QuickBooks Vendor Balance Detail. What is the FIRST action the bookkeeper should take?
QuickBooks Certified User — Vendor and AP reporting
2. Which QuickBooks report is used as the company-side source document when reconciling to a vendor statement?
QuickBooks Certified User — Enter and manage vendor transactions
3. In QuickBooks, what transaction type is used to record a debit memo when merchandise is returned to a vendor?
QuickBooks Certified User — Vendor credits and bill management
4. When a Bill Credit is created in QuickBooks but NOT applied to an outstanding bill, what effect does it have on the vendor's open balance?
AIPB Certified Bookkeeper — AP reconciliation
5. Your company's QuickBooks balance for Vendor DEF is $3,600. Vendor DEF's statement balance is $3,800. The only difference is a $200 check your company mailed on the last day of the month that the vendor has not yet posted. How should this be classified on the reconciliation worksheet?
AIPB Certified Bookkeeper — Adjusting entries and AP
6. The journal entry to record a return of merchandise to a vendor includes which of the following?
QuickBooks Certified User — Report customization and AP management
7. Before beginning an AP reconciliation, a bookkeeper should set the date range on the Vendor Balance Detail report to match the vendor statement period. What is the PRIMARY reason for this?
AIPB Certified Bookkeeper — Internal controls and AP procedures
8. An AP reconciliation memo documents an unresolved $450 discrepancy where the vendor's statement includes a charge not in QuickBooks and the vendor has not yet provided backup documentation. What is the MOST appropriate recommended next step to include in the memo?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →