Skip to main content

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)

Fictional profit and loss, September
Profit and loss, SeptemberAmount
Revenue$12,000
Contractor costs($4,000)
Software and other expenses($2,000)
Net profit$6,000
Fictional balance sheet, September 30
Balance sheet, September 30Amount
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:

  1. A $750 deposit on September 18 was recorded as Client B's payment because it matches their invoice. Can you confirm?
  2. A $129 software charge on the business card: business or personal?
  3. 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.

Fictional cleanup findings, January to June
FindingEffect on the booksStatus
14 transactions imported twice when the bank feed was reconnected in MarchExpenses overstatedCorrected after matching to statements
3 customer payments recorded as revenue and again as invoice paymentsRevenue overstatedCorrected
$2,400 of card charges uncategorizedUnknownOpen: owner to identify 9 charges
A loan payment recorded entirely as expenseExpense overstated by the principalOpen: needs the June loan statement
Personal purchases on the business cardBelong in owner withdrawalsOpen: 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.

Fictional diagnostic findings
FindingWhat it meansStatus
The LLC has two members, and no 2024 partnership return is on recordFederal and New Jersey partnership returns appear to have been required for 2024Likely: the IRS transcript is still to be checked
No 2025 business return filed yetThe 2025 returns are part of the catch-upConfirmed
Online sales to customers in four states, some through a marketplaceEach state's registration rules need checking; a marketplace may already have collected tax on its own salesUnknown: sales by state not yet supplied
Books reconciled through June 2025Six months of books to bring current before the 2025 returnsConfirmed
An IRS letter about the 2023 return, already answeredAnswered; the IRS replies next, and nothing is needed from the owner nowOpen: waiting for the IRS
Late-filing penalty on the 2024 partnership returnThe 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 confirmedUnknown: 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)

Fictional year-end handoff
ItemPrepared byStatus
Trial balance, P&L and balance sheet at December 31BookkeeperReady
Bank and card reconciliations through DecemberBookkeeperReady
December loan statementOwnerMissing
Equipment bought this year, with invoices and in-service datesOwnerReady
Owner contributions and withdrawalsBookkeeperReady
Proposed year-end adjustmentsCPATwo proposed, awaiting the owner's approval
Open questionsOwner and bookkeeperThree open

The same September reports, read as five numbers (fictional)

Fictional five-number reading of the September reports
QuestionAnswer
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.

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.