Fictional portfolio case / September 2026 / USD

Bookkeeping case:
a month-end close.

Follow Harbor Desk Studio from transaction posting to a reconciled bank balance, adjusted trial balance, and financial reports. Inspect the figures and the decisions behind them.

01 / Scope and accounting decisions

A small service business. A traceable close.

This exercise demonstrates accounting mechanics using constructed inputs. It is not a QuickBooks or Xero export and does not contain real client information.

Assumptions you can review

  • First month of a fictional sole-proprietor service business; all opening balances are zero.
  • Accrual basis, USD, and a single bank account. Taxes, VAT, payroll, inventory, and loans are outside this exercise.
  • Insurance covers 12 months from September 1. Equipment is in use from September 1, with a 60-month life and no residual value.
  • A full month of straight-line depreciation is used. Closing supplies count is $420.
  • Document references and the bank statement are constructed inputs, not copies of real documents.

What the close checks

  1. Post correctly. Separate revenue from collections, supplier expenses from payments, and business costs from owner movements.
  2. Adjust the period. Record the bank fee, insurance used, supplies consumed, equipment depreciation, and unpaid utilities.
  3. Reconcile. Explain the difference between the statement and books with a deposit in transit and an outstanding cheque.
  4. Report and hand off. Tie the trial balance to the financial reports and list next-month follow-ups.
Inspect all 18 journal entries and source references
Balanced debit/credit pairs · all references are synthetic
Entry / dateSource / descriptionDebitCreditUSD
J01 · 09-01CAP-01 · Owner fundingCashOwner capital$12,000
J02 · 09-02EQ-01 · Equipment purchased for cashEquipmentCash$2,400
J03 · 09-03RENT-09 · September rent paidRent expenseCash$900
J04 · 09-04INS-01 · Annual insurance paid; coverage starts SeptemberPrepaid insuranceCash$1,200
J05 · 09-05BILL-01 · Supplies purchased on accountSuppliesAccounts payable$600
J06 · 09-10INV-101 · Services invoiced to Customer AAccounts receivableService revenue$4,800
J07 · 09-15REC-101 · Part-payment received from Customer ACashAccounts receivable$3,000
J08 · 09-22CASH-01 · Cash services; deposit clearedCashService revenue$1,500
J09 · 09-23UTIL-01 · September utilities paidUtilities expenseCash$250
J10 · 09-25CHQ-1001 · Supplier payment; cheque not yet clearedAccounts payableCash$400
J11 · 09-26DRAW-01 · Owner withdrawalOwner drawsCash$500
J12 · 09-28INV-102 · Services invoiced to Customer BAccounts receivableService revenue$1,600
J13 · 09-30DEP-0930 · Cash services; deposit in transitCashService revenue$700
A01 · 09-30BANK-09 · Bank fee identified on statementBank fee expenseCash$35
A02 · 09-30ADJ-INS · One month of insurance used: 1200 / 12Insurance expensePrepaid insurance$100
A03 · 09-30COUNT-09 · Supplies used: 600 less closing count of 420Supplies expenseSupplies$180
A04 · 09-30ADJ-DEP · Monthly depreciation: 2400 / 60 monthsDepreciation expenseAccumulated depreciation$40
A05 · 09-30UTIL-02 · Unpaid September utilities accruedUtilities expenseAccrued utilities$150

02 / Bank reconciliation

Explain every reconciling item.

The $700 deposit and $400 cheque are already recorded in the books. They are timing differences, so neither is posted again. The $35 statement fee needs a book adjustment.

From the bank statement

Statement closing balance
$11,215
Add: deposit in transit
+$700
Less: outstanding cheque
−$400
Adjusted bank balance
$11,515

From the books

Cash before bank fee
$11,550
Less: bank fee posted as A01
−$35
Adjusted book cash
$11,515

Unexplained difference $0

Inspect the constructed bank statement
Fictional September bank statement · opening balance $0
Date / referenceDescriptionMovement USDBalance USD
09-01 · CAP-01Owner funding+$12,000$12,000
09-02 · EQ-01Equipment purchased for cash−$2,400$9,600
09-03 · RENT-09September rent paid−$900$8,700
09-04 · INS-01Annual insurance paid; coverage starts September−$1,200$7,500
09-15 · REC-101Part-payment received from Customer A+$3,000$10,500
09-22 · CASH-01Cash services; deposit cleared+$1,500$12,000
09-23 · UTIL-01September utilities paid−$250$11,750
09-26 · DRAW-01Owner withdrawal−$500$11,250
09-30 · BANK-09Bank fee identified on statement−$35$11,215

Receivables: $3,400

Customer A: $1,800 after a $3,000 receipt. Customer B: $1,600. Both are current at September 30.

Payables: $200

Supplier bill: $600 less $400 payment. The $150 utilities accrual is a separate liability.

October follow-up

Confirm the deposit and cheque clear. Follow up open balances and settle or reverse the utilities accrual when the bill is recorded.

03 / Linked financial reports

Trace the trial balance to the reports.

Profit and loss

September 2026 · accrual basis · USD

Service revenue
$8,600
Rent expense
$900
Utilities expense
$400
Insurance expense
$100
Supplies expense
$180
Depreciation expense
$40
Bank fee expense
$35
Total expenses
$1,655
Net profit
$6,945

Balance sheet

September 30, 2026 · USD

Cash
$11,515
Accounts receivable
$3,400
Supplies
$420
Prepaid insurance
$1,100
Equipment less depreciation
$2,360
Total assets
$18,795
Liabilities: AP $200 + accrual $150
$350
Owner equity: $12,000 − $500 + profit
$18,445
Liabilities + equity
$18,795
Inspect the adjusted trial balance · debits and credits $20,990
Adjusted trial balance before closing entries · USD
AccountDebit USDCredit USD
Cash$11,515—
Accounts receivable$3,400—
Supplies$420—
Prepaid insurance$1,100—
Equipment$2,400—
Accumulated depreciation—$40
Accounts payable—$200
Accrued utilities—$150
Owner capital—$12,000
Owner draws$500—
Service revenue—$8,600
Rent expense$900—
Utilities expense$400—
Insurance expense$100—
Supplies expense$180—
Depreciation expense$40—
Bank fee expense$35—
Total$20,990$20,990
Inspect the cash movement schedule
September cash movement · opening balance $0 · USD
MovementUSD
Customer receipts$5,200
Operating payments−$2,785
Net operating cash flow$2,415
Equipment purchase−$2,400
Owner contribution less draws$11,500
Net change / closing cash$11,515

Balanced figures show arithmetic consistency. They do not replace review of source validity, completeness, business purpose, or accounting treatment. Tax and statutory compliance are outside this exercise.

Professional experience, separately documented

Remote bookkeeping support.

My professional work includes UK bookkeeping and tax-preparation support with JRA & Co. since February 2023, using QuickBooks Online, QuickBooks Desktop, Xero, and Excel. This fictional case is separate from that client work.