Last updated:
Sample Bookkeeping Reports (Fictional)
What a monthly package, a cleanup summary, a diagnostic summary and a year-end handoff look like, shown with invented businesses and invented numbers.
Everything on this page is fictional. Cedar Studio LLC and Maple Print Co. LLC do not exist, and the figures are made up. These samples show how existing reports can be laid out; they add no services, and what you receive is set by your engagement letter. None of them are audited, reviewed or compiled financial statements.
A monthly package: Cedar Studio LLC, September (fictional; accrual basis)
| Profit and loss, September | Amount |
|---|---|
| Revenue | $12,000 |
| Contractor costs | ($4,000) |
| Software and other expenses | ($2,000) |
| Net profit | $6,000 |
| Balance sheet, September 30 | Amount |
|---|---|
| Cash | $9,000 |
| Unpaid customer invoices | $3,000 |
| Total assets | $12,000 |
| Unpaid bills | $2,000 |
| Equipment loan | $4,000 |
| Total liabilities | $6,000 |
| Owner's equity: opening $1,000 + September profit $6,000 − owner withdrawals $1,000 | $6,000 |
| Total liabilities and equity | $12,000 |
Compared with August: revenue rose $2,000 with one new client; contractor costs rose $1,000 for a freelancer on that project.
Questions for the owner:
- A $750 deposit on September 18 was recorded as Client B's payment because it matches their invoice. Can you confirm?
- A $129 software charge on the business card: business or personal?
- Is the printer's $2,000 bill dated September 28 still unpaid?
Still outstanding: the September loan statement, to confirm the $4,000 balance.
A cleanup summary: Cedar Studio LLC, January to June (fictional)
Covered: one business checking account and one business credit card.
| Finding | Effect on the books | Status |
|---|---|---|
| 14 transactions imported twice when the bank feed was reconnected in March | Expenses overstated | Corrected after matching to statements |
| 3 customer payments recorded as revenue and again as invoice payments | Revenue overstated | Corrected |
| $2,400 of card charges uncategorized | Unknown | Open: owner to identify 9 charges |
| A loan payment recorded entirely as expense | Expense overstated by the principal | Open: needs the June loan statement |
| Personal purchases on the business card | Belong in owner withdrawals | Open: owner to confirm the list |
Open items stay open until the record or the answer arrives. The summary lists what was corrected and what is still open; it does not say the books are complete.
A diagnostic summary: Maple Print Co. LLC (fictional)
Covered: federal and New Jersey filings for 2023 to 2025, one checking account, one credit card and the operating agreement.
| Finding | What it means | Status |
|---|---|---|
| The LLC has two members, and no 2024 partnership return is on record | Federal and New Jersey partnership returns appear to have been required for 2024 | Likely: the IRS transcript is still to be checked |
| No 2025 business return filed yet | The 2025 returns are part of the catch-up | Confirmed |
| Online sales to customers in four states, some through a marketplace | Each state's registration rules need checking; a marketplace may already have collected tax on its own sales | Unknown: sales by state not yet supplied |
| Books reconciled through June 2025 | Six months of books to bring current before the 2025 returns | Confirmed |
| An IRS letter about the 2023 return, already answered | Answered; the IRS replies next, and nothing is needed from the owner now | Open: waiting for the IRS |
| Late-filing penalty on the 2024 partnership return | The federal penalty is charged for each person who was a partner during the year, for each month or part of a month late, up to 12 months; the amount and any relief depend on the dates once confirmed | Unknown: dates not yet confirmed; estimate to follow |
How the labels work: confirmed means a record shows it; likely means the records point that way but one is missing; unknown means the records needed have not arrived; open means the item waits on the person named.
Next phase (fictional): the 2024 partnership returns and the members' Schedule K-1s, the 2025 returns, six months of books and a New Jersey sales tax review, each quoted before it starts.
Ownership schedule: contributions and distributions by member for 2024 and 2025, for the members and their attorney. It quotes the operating agreement and does not interpret it.
How a diagnostic works is described on the Business Diagnostic page. To ask about one, use the contact form, with “Several business problems at once (diagnostic)” already chosen.
A year-end handoff: Cedar Studio LLC (fictional)
| Item | Prepared by | Status |
|---|---|---|
| Trial balance, P&L and balance sheet at December 31 | Bookkeeper | Ready |
| Bank and card reconciliations through December | Bookkeeper | Ready |
| December loan statement | Owner | Missing |
| Equipment bought this year, with invoices and in-service dates | Owner | Ready |
| Owner contributions and withdrawals | Bookkeeper | Ready |
| Proposed year-end adjustments | CPA | Two proposed, awaiting the owner's approval |
| Open questions | Owner and bookkeeper | Three open |
The same September reports, read as five numbers (fictional)
| Question | Answer |
|---|---|
| How much is in the bank? | $9,000 |
| How much do customers owe? | $3,000 |
| How much in recorded bills is due? | $2,000, plus the loan payment |
| What did the month earn? | $6,000 profit |
| How much did the owner take out? | $1,000 |
Each number answers a different question, so they shouldn't be added together.
How I work through incomplete records: three fictional examples
These three examples are fictional. They illustrate questions to work through when records are incomplete. They are not client stories.
Profit, but no cash
What the records show. Imagine a shop whose profit report shows a profit for the year while its bank balance is low. For this example, assume the accrual report records revenue when earned, unpaid invoices are still recorded as receivables, and unsold inventory remains an asset with no write-down.
Why profit and cash can differ. In this example, unpaid sales add recorded income without adding cash. Purchases still held in inventory use cash without entering cost of goods sold. Assume the loan payments repay genuine debt and the owner's withdrawals are draws, not wages: the principal and draws use cash without being expenses on this report. Other accounting methods and facts can change the treatment.
What is still uncertain. Whether the unpaid invoices will be collected, whether the stock count matches the books, whether each loan payment was split correctly between interest and principal, and how much the owner took out.
What I would check. The reports against the bank statements, the list of unpaid invoices and how old each one is, the inventory records against a count, the loan statements, and the record of owner withdrawals.
What the owner can reasonably conclude. The profit report and the bank balance answer different questions. Until each difference is traced to a record, neither number alone explains where the money went.
“QuickBooks says reconciled,” but the opening balance is wrong
What the records show. Imagine a business whose checking account shows every month of the year as reconciled in QuickBooks. Suppose the starting balance on January's reconciliation does not match the ending balance on the prior December's bank statement, and the ledger holds an adjustment entry that nobody can explain.
Why “reconciled” is not proof. A “reconciled” label is not enough to explain an unexplained opening balance. Keep the underlying statements, reconciliation reports and record of changes. Do not delete transactions or force a balance just to make a report look finished.
What is still uncertain. Whether last year's reconciliations were correct, whether entries were changed or deleted after they were reconciled, and what the adjustment covers.
What I would check. The opening balance against the prior year's final bank statement, the earlier reconciliation reports, the record of changes to past entries, and the first month where the books and the bank stop agreeing. I would trace that first difference before changing any later month.
What the owner can reasonably conclude. A “reconciled” label does not show that the opening balance is right. I would keep the difference visible, rather than cover it with another adjustment, until a record explains it.
An S election before its assumptions are checked
What the records show. Imagine an LLC owner who filed Form 2553 for the LLC after comparing two tax estimates. Suppose the comparison assumed a salary for the owner and left out recurring costs, such as running payroll and preparing a separate business return.
Why filing is not the same as acceptance. Sending Form 2553 does not by itself show that the election took effect. Check the IRS acceptance or nonacceptance determination and the effective tax year against the filed election and the entity's facts.
What is still uncertain. Whether the IRS has accepted the election and from what date, whether the assumed salary can be supported by the work the owner does, and whether the estimates used a full year of income and expenses.
What I would check. The filed Form 2553 and the IRS acceptance or nonacceptance letter, the ownership records, complete income and expense records, the salary assumption against the owner's duties and time, how payroll would be handled, and the costs the comparison left out.
What the owner can reasonably conclude. The comparison does not yet show that the election saves anything. I would say which assumptions hold up and which are still open before drawing any conclusion.
See bookkeeping, bookkeeping cleanup and pricing, or describe your books.
Tax advice disclaimer: This material is for general educational information only and is not legal, tax, or accounting advice for your specific facts. A CPA-client relationship is formed only through a signed engagement letter.