Module 7: Client Reporting

Where we are in the workflow: By Module 5 you learned to read the P&L and Balance Sheet as a bookkeeper, checking that the numbers are right before locking the period. This module teaches you to use those same reports, plus a few new ones, as a communicator — pulling the right report for the right question, customizing it, and handing it to a client in a form they'll actually understand. Report it, properly.

Module goal: You will be able to read and explain the core financial reports in plain language, pull supporting detail with the General Ledger and Transaction Detail reports, customize and save reports, export them cleanly, assemble a professional month-end package, and deliver it to a client with a summary that earns trust instead of inviting confusion.

Running case continues: Bright Path Cleaning Co.'s October books are closed (Module 5's process, run again for October). Dana Reyes says, "Can you just send me what I need each month? I don't want to have to ask." This module builds the package that answers her before she has to ask.

Key Terms for This Module

• Report basis: cash or accrual. Changes which transactions a report counts and when.
• General Ledger: every transaction posted to every account, in one report. The most detailed view of the books.
• Transaction Detail report: every transaction behind one account or one date range, used to investigate a single number.
• Custom report: a standard report with filters, columns, or date ranges changed to answer a specific question.
• Memorized (saved) report: a custom report saved so it can be re-run without rebuilding it each month.
• Reporting package: the bundle of reports delivered to a client for a given period.

Lesson 7.1: The Profit and Loss, Explained to a Client

Learning Objectives

• Explain what the P&L tells a business owner, in plain language.
• Choose the right date range and comparison for a client's question.
• Translate a P&L line into something the client can act on.

Content and Theory

You've run the Profit and Loss since Module 5 to check the books. Here the job changes: instead of asking "is this right," you're asking "what does this tell Dana about her business?"

A P&L answers one question: did the business make money during this period, and from what? Most client confusion comes from one of three things:

• Date range: "this month" and "year to date" tell very different stories. Always state the range in plain language, not just "P&L."
• Cash vs. accrual: a client who thinks in terms of "money in the bank" will read an accrual P&L and be confused why profit doesn't match their bank balance. Say which basis you're using, every time.
• Jargon: "COGS," "net other income," and account names mean nothing to most small-business owners. Translate them.

Useful comparisons for a client-facing P&L: this month vs. last month, this month vs. the same month last year (if history exists), and year-to-date vs. the prior year-to-date. Pick the one that answers what the client actually asked.

Step-by-Step Walkthrough

1. Go to Reports and open Profit and Loss.
2. Set the date range to match the client's question (the month just closed, year to date, and so on).
3. Add a comparison column (Customize, then Comparison Periods) if useful.
4. Confirm the accounting method matches what the client expects, and note it on the report or in your summary.
5. Read it top to bottom once before sending it, and write one or two plain-language sentences per unusual line.

Real-World Example

Dana asks, "Am I making more money than I was this time last year?"

Solution breakdown: This calls for a year-to-date comparison, not a single month. Run the P&L for January 1 through October 31 of this year, with a comparison column for the same period last year. If last year's file doesn't go back that far, say so plainly rather than presenting an incomplete comparison as a full one.

Best Practices and Common Pitfalls

• ✅ State the date range and basis in plain words every time you share a P&L.
• ✅ Translate at least the biggest swings into one plain sentence each.
• ⚠️ Don't hand over a report with no framing. A number with no context invites a worried phone call.
• ⚠️ Don't assume the client remembers what basis their books are on from a conversation months ago.

Tool Translation: Xero's Profit and Loss report offers the same comparison-period and basis controls under its report settings.

Sheets companion: Keep a one-line "plain English" glossary of the client's own account names, so your summaries stay consistent month to month.

Lesson 7.2: The Balance Sheet, Explained to a Client

Learning Objectives

• Explain what the Balance Sheet tells a business owner.
• Walk a client through the three sections in plain language.
• Spot the lines a client is most likely to ask about.

Content and Theory

Where the P&L covers a period, the Balance Sheet is a snapshot as of one date. It answers: what does the business own, what does it owe, and what's left over for the owner?

Three sections, explained the way a client actually thinks about them:

• Assets — "what the business has": bank balances, money customers owe it (A/R), and equipment.
• Liabilities — "what the business owes": credit cards, loans, and money owed to vendors (A/P, Module 6).
• Equity — "what's left for the owner": built from profit kept in the business, plus what the owner has put in or taken out.

The lines clients ask about most: the bank balance (does it match what they see in online banking — remind them it reflects the reconciled balance, not necessarily today's live balance), Accounts Receivable ("who owes me, and is that the same as my aging report?"), and Accounts Payable ("what do I still owe?"). Each of these should already tie to its supporting report from Modules 2, 4, and 6 — that tie-out is exactly what makes you able to answer confidently.

Step-by-Step Walkthrough

1. Run the Balance Sheet as of the date the client cares about (usually month-end).
2. Walk it top to bottom: Assets, then Liabilities, then Equity.
3. For each balance the client is likely to ask about, have its supporting report ready (A/R Aging for the A/R line, A/P Aging for the A/P line, the reconciliation report for each bank line).
4. Note anything unusual in plain language before sending.

Real-World Example

Dana asks, "Why does it say I have $1,885 in Accounts Receivable? I don't feel like anyone owes me that much."

Solution breakdown: Pull up the A/R Aging Summary for the same date (Lesson 2.7) and walk through it with her: which customers, how much, how overdue. The Balance Sheet gives the total; the aging report gives the story behind it. This is exactly why tying the two together every month (Module 5) matters — you can answer this in thirty seconds instead of having to go investigate on the spot.

Best Practices and Common Pitfalls

• ✅ Always have the supporting detail ready before you send the summary balance.
• ✅ Use the client's own words for each section where you can ("what you own," "what you owe").
• ⚠️ Don't present the Balance Sheet without the context of what's behind its biggest lines.

Tool Translation: Xero's Balance Sheet report follows the same three-section structure, with drill-down into any line's transaction detail.

Sheets companion: A "Balance Sheet Talking Points" tab, refreshed each month, so you're never caught without an answer.

Lesson 7.3: A/R Aging, General Ledger, and Transaction Detail

Learning Objectives

• Know when to reach for A/R Aging versus the General Ledger versus Transaction Detail.
• Use the General Ledger to answer "show me everything."
• Use Transaction Detail to answer "show me what's behind this one number."

Content and Theory

You already know A/R Aging well (Lesson 2.7) — it answers "who owes me money, and how overdue." Two more reports round out your toolkit for client questions that go deeper than the P&L or Balance Sheet:

• General Ledger: every transaction, in every account, for a period — the most complete and most overwhelming report in QBO. Rarely sent to a client whole; mostly used by you, or handed over if an outside accountant specifically asks for it.
• Transaction Detail (by account, or by date): a focused slice — every transaction behind one account or within one date range. This is your go-to when a client asks "what makes up this number?"

Choosing the right report is really about matching the client's question to its scope: a whole-books question goes to the General Ledger (rare), a whole-category question goes to Transaction Detail by Account, a single-transaction question goes to that transaction directly, and a "who owes me" question goes to A/R Aging (or A/P Aging for the reverse).

Step-by-Step Walkthrough

1. Identify the scope of the client's question: one transaction, one account, or everything.
2. For "what makes up this expense category," run Transaction Detail by Account, filtered to that account and the period in question.
3. For "what happened in my accounts this month, everything," run the General Ledger, filtered to the period — but consider whether a narrower report would actually answer the real question better.
4. For "who owes me" or "what do I owe," use A/R Aging or A/P Aging instead of either of the above.

Real-World Example

Dana asks, "Cleaning Supplies feels high this month. What's in there?"

Solution breakdown: Run Transaction Detail by Account, filtered to Cleaning Supplies for the month. This lists every transaction that rolled up into that P&L line — exactly what she needs, without the noise of the General Ledger's every other account.

Best Practices and Common Pitfalls

• ✅ Match the report's scope to the question's scope. Don't send the General Ledger for a one-account question.
• ✅ Filter by date range every time; an unfiltered Transaction Detail or General Ledger can run for years of history.
• ⚠️ Don't default to the General Ledger because it "has everything." More data isn't more helpful if it isn't what was asked.

Tool Translation: Xero's equivalents are the Account Transactions report (Transaction Detail) and the General Ledger report under Accounting reports.

Sheets companion: No template needed here — the skill is choosing the right built-in report, not building a new tracker.

Lesson 7.4: Custom and Saved Reports

Learning Objectives

• Customize a standard report's columns, filters, and date range.
• Save (memorize) a custom report for reuse.
• Build a small library of reports tailored to a specific client.

Content and Theory

Every standard report in QBO can be reshaped with the Customize button: different date ranges, added or removed columns (like a comparison period, or a breakdown by customer), filters (by customer, vendor, or class if the client uses them), and header or footer text.

Once a custom report is built the way a client likes it, you shouldn't have to rebuild it every month. Saving (memorizing) a report keeps its settings so you can re-run it with one click, just refreshing the date range.

A small, well-chosen set of saved reports, built around what one specific client actually asks for, is far more useful than QBO's full default report list.

Step-by-Step Walkthrough

1. Open the report you want to customize and click Customize.
2. Adjust the date range, columns, and any filters the client's question calls for.
3. Click Run report to preview it.
4. If you'll want this exact shape again, click Save customization (or Memorize), name it clearly (for example, "Bright Path – Monthly P&L with Prior Year"), and choose a group if you're organizing several.
5. Next month, open it from Reports, then Custom reports (or Memorized reports) and just update the date range.

Real-World Example

Dana always wants to see her P&L split by Residential vs. Commercial income, every single month.

Solution breakdown: Customize the P&L with columns split by Customer, or set up Classes for Residential and Commercial if the client wants that level of structure, then save the customization as "Bright Path – P&L by Service Line." Every month becomes a one-click refresh instead of rebuilding the view from scratch.

Best Practices and Common Pitfalls

• ✅ Name saved reports clearly, including the client name if you manage several clients in one QBOA account.
• ✅ Build your saved-report library around what this specific client actually asks, not a generic list.
• ⚠️ Don't over-customize. A report so specific it needs its own explanation defeats the purpose.

Tool Translation: Xero supports custom report layouts and saved reports under its Reports section in a very similar way.

Sheets companion: A "Saved Reports Index" listing each client's saved reports and what each one is for, so nothing gets rebuilt by accident.

Lesson 7.5: Exporting Reports

Learning Objectives

• Export reports cleanly to PDF and Excel.
• Choose the right format for the destination.
• Keep exported reports organized and named consistently.

Content and Theory

A report a client can open easily, on any device, without needing a QBO login, is far more useful than a link they have to click through to. Exporting turns a live report into a file.

Choosing a format:

• PDF: best for anything meant to be read, not edited — a client's monthly package, a report attached to an email. Looks the same everywhere.
• Excel: best for anything the client (or their tax preparer) might want to filter, sort, or build on — a detailed Transaction Detail export, or data headed into another spreadsheet.

Naming matters as much as the export itself. A consistent pattern (client name, report type, period) means nobody is ever digging through a folder of files named "Report (3) final FINAL.pdf."

Step-by-Step Walkthrough

1. With the report open and customized as needed, click Export (often an icon near the top of the report).
2. Choose Export to PDF or Export to Excel based on the destination.
3. Save it using a consistent name, for example BrightPath_ProfitLoss_2026-10.pdf.
4. File it in the same client folder you've been using for statements and reconciliation reports since Module 4.

Real-World Example

Dana wants her October P&L and Balance Sheet to read on her phone, and separately her tax preparer wants the full Transaction Detail for Cleaning Supplies to double-check a deduction.

Solution breakdown: Export the P&L and Balance Sheet as PDFs — easy to read on a phone, nothing to accidentally edit. Export the Transaction Detail as Excel, since the tax preparer will likely want to sort or filter it.

Best Practices and Common Pitfalls

• ✅ Use a consistent file-naming pattern across every client and every month.
• ✅ Default to PDF for anything client-facing; reserve Excel for working data.
• ⚠️ Don't send a live QBO link when a client just needs to glance at a number. A file is friction-free.

Tool Translation: Xero reports export to PDF or Excel from the same report screen, with similar format tradeoffs.

Sheets companion: No new template — just a consistent folder and file-naming convention, ideally the same one from your Reconciliation Report filing in Module 4.

Lesson 7.6: Creating the Month-End Package

Learning Objectives

• Decide what belongs in a month-end reporting package.
• Assemble it consistently every month.
• Tailor the package to what a specific client actually needs.

Content and Theory

The reporting package is the deliverable that Module 5's close (and, if the client has one, Module 6's A/P work) has been building toward. A good package is complete but not overwhelming — everything the client needs to trust the numbers and act on them, nothing that exists just because QBO can generate it.

A solid default package for a small service business like Bright Path:

• Profit and Loss (current month, with a comparison column)
• Balance Sheet (as of month-end)
• A/R Aging Summary
• A/P Aging Summary, if the client has vendor bills on terms (Module 6)
• A cover note summarizing the above in plain language (Lesson 7.7)

Add to this only when a specific, recurring need calls for it — a Transaction Detail export the tax preparer wants every quarter, for example. Don't pad the package by default.

Step-by-Step Walkthrough

1. Confirm the period is closed and locked (Module 5) before assembling anything.
2. Run and export each report in the client's standard package, using your saved customizations from Lesson 7.4.
3. Name each file consistently (Lesson 7.5).
4. Gather them into one dated folder, for example BrightPath_2026-10.
5. Draft the cover note (Lesson 7.7) referencing the actual numbers in this month's package.

Real-World Example

Bright Path now has both A/R (Module 2) and A/P (Module 6) activity. October's package needs to reflect both sides.

Solution breakdown: The package includes the P&L, Balance Sheet, A/R Aging Summary, and A/P Aging Summary this month, since Module 6 introduced real vendor bills on terms. A client with no bills on terms wouldn't need that last report at all — the package should fit the client, not a generic template.

Best Practices and Common Pitfalls

• ✅ Only assemble the package once the period is locked. A package built on an unlocked, still-changeable period can go stale within hours.
• ✅ Revisit what's "standard" for each client every few months. Needs change as a business grows.
• ⚠️ Don't send every report QBO offers. More isn't better; it's just more to read.

Tool Translation: The same package logic applies in Xero, pulling from its equivalent P&L, Balance Sheet, and Aged Receivables/Payables reports.

Sheets companion: A "Package Contents" tab per client, listing exactly which reports go in their package by default, reviewed quarterly.

Lesson 7.7: Delivering Reports to the Client

Learning Objectives

• Write a cover note that earns trust instead of inviting confusion.
• Choose a delivery method and a consistent monthly rhythm.
• Know what to do when the numbers raise a question you can't yet answer.

Content and Theory

The reports themselves are only half the delivery. The other half is the cover note — a short, plain-language summary that tells the client what they're looking at before they look at it. This is where your Client Report Cover Note template (from the Templates & Resources page) comes in.

A good cover note:

• States the period and net income up front.
• Compares to the prior period in one sentence, with a reason if there's a notable change (Lesson 5.7's variance work feeds directly into this).
• Flags A/R and A/P totals, especially anything overdue.
• Discloses any open items honestly (Lesson 5.5), rather than quietly hoping they don't come up.
• Invites questions, rather than presenting the numbers as a one-way announcement.

Delivery method and rhythm: agree on one channel (usually email, with the files attached or linked from shared cloud storage) and one day of the month, and keep to it. A predictable rhythm is itself a sign of a well-run bookkeeping relationship.

Step-by-Step Walkthrough

1. Gather the finished package (Lesson 7.6).
2. Fill in the Client Report Cover Note template with this month's actual figures and any open items.
3. Attach the exported reports, or link to the shared folder they're saved in.
4. Send on the agreed day, and note the delivery date on your Month-End Close Checklist.
5. Be available for a short follow-up conversation if the client has questions — don't just send and disappear.

Real-World Example

October's numbers: net income $1,742.10 (up from September's $1,533.39), A/R of $1,885.00 with $865.00 over 30 days past due, and A/P of $512.40 with the Sunset Cleaning Supply bill overdue (Module 6's exercise).

Solution breakdown: The cover note states October's net income and the increase from September in one sentence, flags the overdue A/R total and the overdue Sunset bill honestly, and closes by inviting Dana to ask anything. Nothing is hidden, and nothing requires her to go digging through the reports herself to find the headline numbers.

Best Practices and Common Pitfalls

• ✅ Keep the rhythm predictable: same day, same format, every month.
• ✅ Lead with the numbers that matter most to the client, not the order QBO happens to list them in.
• ✅ Disclose open items in the cover note itself, not buried in an attachment.
• ⚠️ Don't let "I'll explain it if they ask" replace a note that explains it up front.
• ⚠️ If a client's question reveals something you need to investigate further, say so plainly and follow up, rather than guessing in the moment.

Tool Translation: This lesson is about communication, not software — the same discipline applies whether the reports came from QBO or Xero.

Sheets companion: Track delivery dates on your Month-End Close Checklist, so a late package is visible to you before it's visible to the client.

Module 7 Knowledge Check

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

Module 7 Practical Exercise: Build Bright Path's October Reporting Package

Scenario: Dana writes: "Please send me my October reports, and set it up so this is easy every month going forward." Work in the same practice file you've used throughout the course. Assume October's close (following Module 5's process) is already finished and locked.

October's Numbers

• Net income: $1,742.10 (compared to September's $1,533.39)
• A/R Aging Summary total as of October 31: $1,885.00, of which $865.00 is more than 30 days past due (Bayview Cafe $525.00 and Alicia Chen's remaining balance, per Module 5's figures, carried forward)
• A/P Aging Summary total as of October 31: $512.40 (GreenGuard Pest Control $300.00, Current; Sunset Cleaning Supply $212.40, overdue — from Module 6's exercise)
• Bank and credit card accounts: reconciled with no open discrepancies

Tasks

1. Run and customize the P&L (with a comparison column to September) and the Balance Sheet as of October 31.
2. Save the P&L customization as a named, reusable report (for example, "Bright Path – Monthly P&L with Prior Month").
3. Run the A/R Aging Summary and A/P Aging Summary as of October 31, and confirm each ties to its corresponding Balance Sheet line.
4. Export all four reports: the P&L and Balance Sheet as PDF, and both aging reports as PDF as well (this client's package is light and client-facing, not working data for a tax preparer).
5. Name each file following a consistent pattern, and gather them into one October folder.
6. Fill in the Client Report Cover Note template with October's actual numbers: net income and its change from September, both aging totals, and the two specific open items (Bayview/Chen overdue, and the overdue Sunset bill).
7. Decide what belongs in Bright Path's standard monthly package going forward, and write one sentence justifying each report's inclusion.

Deliverables

Screenshots of the customized and saved P&L report, the four exported files (named consistently), and your completed cover note.

Self-Assessment Rubric

• Report accuracy: Excellent means all four reports reflect October 31 correctly and both aging totals tie to the Balance Sheet. Needs work means a mismatched date or an aging total that doesn't tie.
• Customization and reuse: Excellent means the P&L customization is saved and reusable next month with just a date change. Needs work means no customization was saved at all.
• Export and organization: Excellent means consistent file names and an organized package. Needs work means inconsistent naming or files scattered with no clear destination.
• Cover note: Excellent means it leads with the real numbers, compares to September, and discloses both overdue items honestly. Needs work means it's vague or omits an open item.

Stretch Challenge

Dana mentions she's thinking about asking her tax preparer for a quarterly check-in. What additional report, beyond Bright Path's standard monthly package, might the tax preparer want, and in which export format? Explain your reasoning in two or three sentences.

---

Check Your Work

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