Accounting Toolkit
Sixteen free Excel workbooks for practicing accounting fundamentals — each one a worked example with its solution shown, a practice problem, and a self-checking calculator. Download the ones you need.
Debits & Credits
Building a Balance Sheet
Meridian Trading — Balance Sheet
Meridian Trading Inc.
Six transactions, one balance sheet to build by hand — then a live calculator that rebuilds it from your own numbers and checks that Assets equal Liabilities plus Equity.
View workbook →
Harborline Trading — Balance Sheet
Harborline Trading Inc.
The same balance-sheet drill with a bank loan and accrued interest thrown in, so you see a liability recognized before any cash changes hands.
View workbook →
Crestpoint Trading — Balance Sheet
Crestpoint Trading Inc.
A balance-sheet exercise built around cash collected before the goods ship — the moment Unearned Revenue earns its keep as a liability.
View workbook →
Presentation Formats
Accrual Timing
Ashcombe — Prepaid & Accrued Items
Ashcombe Inc.
Three prepaid and accrued items on one company's books, worked through the matching principle so the expense lands in the month it was actually used up.
View workbook →
Brightwell — Prepaid & Accrued Items
Brightwell Inc.
A second matching-principle workbook — prepaid insurance, an accrued utility bill, and accrued wages — same mechanic, different accounts.
View workbook →
Depreciation
Summit Equipment — Depreciation
Summit Equipment Co.
One asset, three depreciation methods, and the mid-year-purchase wrinkle that gives Year 1 only a half-year charge.
View workbook →
Vantage Fleet — Depreciation
Vantage Fleet Corp.
A second depreciation workbook with a real salvage value, so straight-line, declining-balance, and units-of-production all have to land on the exact same total.
View workbook →
Multi-Year Financial Statements
Cobalt Property — Year 1
Cobalt Property Group
Build a Year 1 Balance Sheet and Income Statement from a list of raw transactions, and watch Net Income flow straight into Retained Earnings.
View workbook →
Cobalt Property — Year 2
Cobalt Property Group
Part two of the Cobalt Property Group case — Year 2 opens exactly where Year 1 closed, and every balance has to carry forward correctly.
View workbook →
Lakeview Industries — Financials
Lakeview Industries Inc.
A second two-year financial-statement case, with a bad-debt write-off that trims both Accounts Receivable and Net Income together.
View workbook →
Cash Flow Statements
Anchor Point Retail — Cash Flow
Anchor Point Retail Inc.
Build the same operating cash flow figure two ways — direct and indirect — across four years of growing complexity, and prove they always land on the same number.
View workbook →
Cobalt Property — Cash Flow
Cobalt Property Group
The Cobalt Property Group case concludes with a Year 2 cash flow statement, built entirely from the balance-sheet deltas established in Parts 1 and 2.
View workbook →
Falcon Games — Cash Flow
Falcon Games Inc.
A standalone indirect-method cash flow statement, solving Capex from a PP&E roll-forward note along the way.
View workbook →
Antelope Outdoor — Cash Flow
Antelope Outdoor Supply Inc.
The same indirect-method cash flow build, at real-scale numbers, with two separate debt sources to track through the financing section.
View workbook →