Module 8: Real Client Scenarios

Where we are in the workflow: Everything combined. Every other module taught you one skill at a time. A real client message never announces which module it belongs to — it just lands in your inbox, and you have to recognize what's actually being asked before you can fix it.

Module goal: You will be able to take a client's plain-language message, work out which skill (or skills) from Modules 1 through 7 it calls for, investigate methodically, resolve it correctly, and reply the way a confident, professional bookkeeper would.

How this module works: Each lesson is one scenario. You'll see the client's message exactly as it might arrive, a set of investigation questions to work through yourself, and then a full solution. Try to answer the investigation questions in your own head (or write them down) before reading the solution — that's where the real learning happens.

Scenario 1: The Overpayment

What This Is Really Asking

This is an applying payments question (Lesson 2.4) dressed up as a simple "what do I do" message. The real question underneath is: what happens to the $200 that doesn't match any invoice?

Investigation Questions

• Is $4,800 really the full amount owed, or are there other open invoices this $200 might be intended for?
• Has the client said anything about why the customer paid $200 extra? A tip, a future job, a mistake?
• What are this client's options for handling an overpayment, and whose decision is it?

Solution

Record the $5,000 payment and apply $4,800 to the invoice (Lesson 2.4). The remaining $200 becomes an unapplied credit on the customer's account — not a problem, just a decision point. Ask the client: apply it to the customer's next invoice, refund it (Lesson 2.6), or leave it as a credit the customer can use later. Don't decide this yourself, and don't leave it sitting unresolved indefinitely once you have an answer.

A good reply: "Got it — I've recorded the $5,000 and applied $4,800 to the invoice. The extra $200 is sitting as a credit on their account. Would you like me to apply it to their next invoice, refund it, or just leave it as a credit for now?"

What This Teaches

A client's question is often simpler than the bookkeeping behind it. Your job is to translate "what do I do" into the correct QBO action, then hand the genuine decision — not the mechanics — back to the client.

Scenario 2: "My Customer Says They Paid"

What This Is Really Asking

This draws on three places at once: applying payments (Lesson 2.4), match vs. categorize (Lesson 3.2), and Undeposited Funds (Lesson 5.4). Somewhere, the money either hasn't arrived, or it arrived but isn't linked to this invoice.

Investigation Questions

• Does the customer have a payment recorded anywhere in QBO, even if it's not applied to this invoice?
• Does the bank feed show a deposit around the date the customer says they paid?
• Is there a payment sitting in Undeposited Funds that was never grouped into a bank deposit?
• Could the payment have been categorized directly as income in the bank feed instead of matched to this invoice (the Module 3 double-count pattern, just missing the match this time instead of adding a duplicate)?

Solution

Check the customer's transaction list first for any payment, applied or not. If a payment exists but wasn't applied to this invoice, apply it now. If no payment exists in QBO at all, check the bank feed around the date in question — the money may have arrived and been categorized as a generic deposit rather than linked to this customer and invoice. If so, undo that categorization, record a proper Receive Payment against the invoice, and match the feed line correctly. If nothing shows up anywhere, the payment genuinely hasn't arrived yet, and that's useful information for the client to have before they call the customer back.

A good reply: "I checked and don't see a payment recorded against this invoice or sitting anywhere unapplied. Could you ask them for the payment date and method? If it was a bank transfer, I can also check the feed directly once I know roughly when it should have landed."

What This Teaches

"The invoice is wrong" is almost never the real problem — invoices don't change themselves. The payment is either missing, unmatched, or misfiled, and your job is to find out which, calmly and in order.

Scenario 3: The $2,000 Reconciliation Gap

What This Is Really Asking

This is finding discrepancies (Lesson 4.4) and troubleshooting (Lesson 4.5) in action — plus a dose of reassurance, since "is my money missing" is really "should I be panicking right now."

Investigation Questions

• What does the size of the difference suggest? $2,000 is large and round — more likely a whole missing or duplicated transaction than a typo.
• Is there a transaction close to $2,000 (an owner contribution, a big invoice payment, a loan) that might be missing, duplicated, or dated wrong?
• Is it exactly twice a transaction amount, suggesting a sign error (a deposit entered as a payment, or the reverse)?
• Is there anything sitting in the Excluded tab that should have been included?

Solution

Before answering the "is it missing" question, investigate using the systematic search from Lesson 4.4: re-check your inputs (statement ending balance and date), compare counts of deposits and payments, and look for a transaction near $2,000 that's missing, duplicated, or in the Excluded tab. In practice, a $2,000 gap is very often an owner contribution (Lesson 3.6) that was either never entered or entered as income instead of equity, or a deposit that was excluded by mistake. Reassure the client only once you've actually found the cause — not before.

A good reply: "Nothing's missing — the gap traced back to a $2,000 deposit that had been excluded from the bank feed by mistake, so it never made it into your books. I've restored and categorized it, and the reconciliation now matches your statement exactly."

What This Teaches

A big, round discrepancy is rarely "money gone." It's almost always a bookkeeping gap you can trace and fix — but you earn the right to say that reassuring sentence only after you've actually done the work in Lesson 4.4, not before.

Scenario 4: 47 Transactions in the Feed

What This Is Really Asking

This is straightforwardly the bank feed (Lesson 3.1) at scale — the five-question decision process and a sensible processing order, applied to a real backlog instead of a tidy 20-line exercise.

Investigation Questions

• How far back does this backlog go? Is any of it close to, or past, a closing date from a prior locked period?
• Roughly how many of the 47 are likely matches (existing invoices, bills, or transfers already recorded) versus genuinely new?
• Are there any large or unusual amounts worth triaging first, before working through everything in date order?

Solution

Don't attack it as 47 random items — apply the recommended order from Lesson 3.1: matches first, then transfers, then rule-friendly recurring items, then everything else, then a short list of genuine questions for the client. A 47-item backlog usually breaks down quickly once sorted this way: a handful of matches, a couple of transfers, several repeat vendors a bank rule could handle going forward (Lesson 3.9), and only a few true unknowns left to ask about.

A good reply: "Done — all 47 are processed. Most were routine (matches, transfers, and recurring vendors, and I've set up a few rules so those categorize automatically going forward). I do have two I need your input on: a $150 Venmo payment on the 15th and a $100 ATM withdrawal on the 26th — could you let me know what those were for?"

What This Teaches

Volume isn't a new problem, it's the same five-question process (Lesson 3.1) applied more times. A sensible order turns an intimidating number into a short, specific list of real questions.

Scenario 5: "Who Still Owes Me Money?"

What This Is Really Asking

This is the most direct possible call for the A/R Aging report (Lesson 2.7) — but a good answer does more than paste a report link.

Investigation Questions

• Before running the report, is there anything unresolved in A/R right now — an unapplied payment, an uncredited overpayment — that would make the numbers misleading?
• Does the aging total actually tie to the Balance Sheet A/R line as of today (Lesson 2.7's integrity check)?
• Which customers are the ones the client would actually want flagged first?

Solution

Run the A/R Aging Summary, but check it against the Balance Sheet first before sending anything — Lesson 2.7's tie-out isn't optional just because the client is waiting. Then don't just forward the raw report: summarize it. Lead with the total, call out anything significantly overdue by name, and offer to follow up on collections if that's useful (Lesson 2.8).

A good reply: "As of today, $1,885 is outstanding. The two to watch are Bayview Cafe ($525, over 60 days) and Alicia Chen ($340, over 30 days) — everyone else is current or only slightly overdue. Want me to send them a reminder?"

What This Teaches

A report is data. A good reply turns that data into an answer — the number the client actually wants, plus the two or three names that matter, instead of a spreadsheet they have to interpret themselves.

Scenario 6: The Month-End Reports Request

What This Is Really Asking

This single sentence is really asking you to run the entire workflow: the close (Module 5), tying out A/R and A/P (Modules 2 and 6), and assembling and delivering the package (Module 7) — all before you can actually say yes.

Investigation Questions

• Is this period's close actually finished — bank feeds processed, A/R and A/P reviewed, Undeposited Funds and uncategorized items cleared, every account reconciled?
• Has the period been reviewed for reasonableness and locked with a closing date?
• Are there any open items (a missing statement, an unanswered question) that need to be disclosed rather than hidden?

Solution

If the close genuinely isn't done yet, say so and give a realistic timeline rather than sending an incomplete or unreviewed package just because it was asked for quickly. If it is done, this is where every earlier module comes together in order: confirm the close checklist is complete (Module 5), confirm A/R and A/P both tie to the Balance Sheet (Modules 2 and 6), assemble the standard package and export it (Module 7), fill in the cover note with this period's real numbers and any open items, and send it on the agreed channel.

A good reply, if the close isn't finished yet: "I'm still finishing up a couple of reconciliations — I'll have your full package to you by Thursday."

A good reply, once it's ready: the cover note itself (Lesson 7.7), with the reports attached.

What This Teaches

This is the whole course in one sentence. A simple-sounding request is really the output of everything from Module 1 through Module 7 working correctly together — and your value as a bookkeeper is making that look simple to the client, without actually skipping any of it.

Module 8 Knowledge Check

Answer each question. Your answers are checked only when you click Check answers — nothing is revealed until then.

Module 8 Capstone Exercise: A Full Client Request, Start to Finish

Scenario: It's the start of November. Dana sends you this message, all in one go:

This single message touches five of the six scenarios above. Work through all of it, in a sensible order, using the practice file you've built throughout the course.

The Data

• Northside Dental overpayment: their $900.00 invoice (open since Module 5) is paid with a $950.00 check on November 2.
• November bank feed (Business Checking …4417) — 10 new items:
  1. Nov 2, DEPOSIT, +$950.00 (the Northside payment above)
  2. Nov 3, ADOBE ACROBAT, −$14.99
  3. Nov 4, ONLINE PMT TO VISA …8821, −$300.00
  4. Nov 5, SUNSET CLEANING SUPPLY, −$198.75
  5. Nov 6, DEPOSIT, +$300.00 (GreenGuard's vendor credit refunded in cash rather than applied — see note below)
  6. Nov 9, VERIZON WIRELESS, −$82.15
  7. Nov 12, ZELLE TO J ORTIZ, −$200.00 (Jamie's November contractor payment)
  8. Nov 15, STATE FARM INS, −$96.00
  9. Nov 18, MONTHLY SERVICE FEE, −$15.00
  10. Nov 20, ONLINE TRANSFER TO SAV …9902, −$250.00
• Reconciliation note: The November checking statement shows an ending balance that, when you first tick off every obvious match, leaves QBO $300.00 higher than the statement. (Hint: look closely at item 5 above and what it actually represents versus how it might have been recorded.)
• A/R Aging as of November 20: after Northside's payment, outstanding balances are Bayview Cafe $525.00 (now over 90 days) and Alicia Chen $340.00 (now over 60 days). Nothing else is open.

Tasks

1. Resolve the Northside overpayment (Scenario 1 skills): record the $950.00 payment, apply $900.00 to the invoice, and handle the $50.00 credit appropriately — note what you'd ask Dana before deciding what to do with it.
2. Process all 10 November feed items (Scenario 4 skills), sorted into matches, transfers, and categorized items, using the decision process from Lesson 3.1.
3. Investigate and fix the $300.00 reconciliation gap (Scenario 3 skills). Work out what item 5 (the Nov 6 deposit) really is, given that GreenGuard's $40.00 vendor credit was supposed to be applied against a future bill, not refunded in cash — and that $300.00 happens to match GreenGuard's full remaining balance from Module 6. Determine the likely explanation and the correct fix.
4. Reconcile November checking once the gap is resolved, and confirm the Difference is $0.00 with no forced adjustment.
5. Run the A/R Aging Summary as of November 20 and prepare a direct, summarized answer to "who still owes me money" (Scenario 5 skills) — don't just forward the raw report.
6. Assess whether November's reports are ready to send (Scenario 6 skills): is the close actually finished at this point, or is something still open? Decide what you'd tell Dana right now, and what (if anything) still needs to happen before the full package goes out.
7. Write one consolidated reply to Dana addressing all four parts of her original message, in plain language, following the tone and structure modeled in the scenarios above.

Deliverables

Your handling notes for the Northside overpayment; screenshots of the processed bank feed and the resolved reconciliation (Difference $0.00); the A/R Aging Summary as of November 20; your assessment of whether the full package is ready; and your single consolidated reply to Dana.

Self-Assessment Rubric

• Overpayment handling: Excellent means $900 applied, $50 left as a credit, and a specific question back to Dana about what to do with it. Needs work means the extra amount was guessed at or ignored.
• Feed processing: Excellent means all 10 items correctly sorted (matches, transfers, categorized) with no new income or expense double-counted. Needs work means the Northside deposit or the GreenGuard-related deposit was categorized as new income.
• Reconciliation investigation: Excellent means the $300 gap is correctly traced to the GreenGuard deposit being misrecorded as new income (or a vendor credit refund) rather than recognized as related to the existing A/P credit, with a clear, correct fix applied. Needs work means the gap was forced to zero without understanding the cause.
• A/R communication: Excellent means a summarized, direct answer naming the two overdue customers. Needs work means the raw report was forwarded with no commentary.
• Overall judgment and reply: Excellent means a single, clear, well-organized reply that addresses all four of Dana's points honestly, including whether the full package is genuinely ready. Needs work means any part of her message went unanswered, or the reports were declared "ready" before the reconciliation was actually resolved.

Stretch Challenge

Looking back across all eight modules, write a short paragraph (what you'd actually say to a client) explaining, in plain language, why a bookkeeper investigates before answering — using one of this exercise's own findings as your example.

Check Your Work

Finished the exercise? Compare your work against the answers below.