See an anonymized month.
This is an educational case study.
We changed the name, figures, and identifying details.
This protects the business.
The name and figures shown here are not real.
Anonymized case study
- Details
- Changed
- Month
- April 2026
- Use
- Teach the report shape
What went in the folder.
The case study starts with a small set of changed records.
| File group | What is there | Open note |
|---|---|---|
| Bank | 1 month-end file | No open note |
| Card | 1 month-end file | 1 receipt needs the owner |
| Sales | 7 bills sent to buyers | No open note |
| Costs | 42 receipts and bills | All are sorted |
Try the month in Excel.
Pick each sheet. The totals and cash checks use the same changed figures.
Hearth & Field Supply Co.April 2026 case study
Pick a sheet. Arrow keys move between the tabs.
Check state
Three checks are done| Check | What we found | State |
|---|---|---|
| Bank tie-out | The bank and book cash match after open bank items. | Done |
| Card receipt | One $286 repairs receipt still needs the owner. | Needs owner |
| Loan payment | $800 is interest. $2,000 pays down the loan. | Done |
| Report links | Profit and cash link into the other sheets. | Done |
Bank cash after open items$31,200Book cash$31,200Gap$0
Month result
Profit and loss
| Line | April 2026 |
|---|---|
| Sales | $82,400 |
| Cost of goods sold | $43,600 |
| Gross profit | $38,800 |
| Payroll | $18,500 |
| Rent | $5,200 |
| Utilities | $1,350 |
| Insurance | $850 |
| Software | $420 |
| Repairs | $680 |
| Total operating costs | $27,000 |
| Operating profit | $11,800 |
| Interest cost | $800 |
| Net income | $11,000 |
The profit and loss adds. The check gap is $0.
Month-end view
Balance sheet
| Line | April 2026 |
|---|---|
| Cash | $31,200 |
| Money due from buyers | $18,400 |
| Stock on hand | $24,700 |
| Costs paid ahead | $2,100 |
| Total current assets | $76,400 |
| Equipment at cost | $58,000 |
| Wear on equipment | ($15,000) |
| Net equipment | $43,000 |
| Total assets | $119,400 |
| Line | April 2026 |
|---|---|
| Bills to pay | $16,800 |
| Card balance | $3,600 |
| Loan due this year | $4,000 |
| Total due soon | $24,400 |
| Long-term loan | $35,000 |
| Total owed | $59,400 |
| Owner money put in | $44,000 |
| Past profit kept in the business | $5,000 |
| April net income | $11,000 |
| Total owner value | $60,000 |
| Total owed and owner value | $119,400 |
The balance sheet balances. The check gap is $0.
Cash movement
Cash flow
| Line | April 2026 |
|---|---|
| Cash at the start | $22,000 |
| Net income | $11,000 |
| Wear on equipment | $1,200 |
| More money due from buyers | ($3,400) |
| More stock on hand | ($2,700) |
| Less cost paid ahead | $400 |
| More bills to pay | $2,800 |
| Less card balance | ($600) |
| Cash from daily work | $8,700 |
| Equipment bought | ($6,500) |
| Cash used for equipment | ($6,500) |
| New loan money | $10,000 |
| Loan paid down | ($2,000) |
| Owner draws | ($1,000) |
| Cash from financing | $7,000 |
| Change in cash | $9,200 |
| Cash at the end | $31,200 |
Closing cash matches the balance sheet. The check gap is $0.
The file has four sheets. It opens in Excel and other workbook apps.
What this case study does not say.
- It does not set your price.
- It does not set your work pace.
- It does not show tax or audit work.
- Your own report pack may be different.
Want a clear month like this?
Tell us what is hard right now.