Month-end close and bank reconciliation for a small business
Run a real month-end close on a set of synthetic books: reconcile the bank, post accruals and depreciation, check every balance sheet account and hand over a short close pack.
Industry project · for Harbourline Coffee Roasters, a small roaster with two cafés and an online shop, about C$1.8 million a year in sales
Harbourline Coffee Roasters roasts beans, runs two cafés and sells online. Sales are about C$150,000 a month. The owner, Priya Nair, used to do the books herself on weekends. Last month her accountant found that the bank balance in the books was C$14,600 higher than the real bank statement and nobody could say why. Two supplier bills had been entered twice and card fees had never been recorded.
Priya has now hired a part-time bookkeeper and wants a proper month-end routine. She wants to know her real profit by the 8th working day of the next month, not three months later at year end.
You will create one month of synthetic books (about 180 transactions), a matching bank statement with realistic differences, and a set of opening balances. Then you will run the close the way a small accounting practice would: - a close checklist and calendar with owners; - a bank reconciliation that explains every difference; - accruals, prepayments and depreciation journals; - a reconciliation of each balance sheet account; - a trial balance, a simple P&L and balance sheet, and a one-page close note.
Done looks like a close pack that a reviewer can tick through, with an unreconciled difference of zero and a P&L Priya trusts. The method must work in any small business, so keep it general, but use the sales tax that applies where you live and say which one it is.
Excel workbook with ledger, bank reconciliation, journals and trial balance + close checklist + one-page close note
Stack: Microsoft Excel or Google Sheets, QuickBooks Online, Xero or Wave (optional free trial), A PDF bank statement you create
- Bank reconciled to zero30
Every difference between the ledger and the statement is listed, explained and either corrected or carried as a timing item, leaving zero unexplained.
- Correct journals25
Accruals, prepayments, depreciation and corrections are posted with correct accounts, amounts and narrations.
- Balance sheet checked25
Every balance sheet account has a reconciliation or support, and the trial balance balances.
- Close pack20
Checklist, statements and a one-page note let a reviewer follow the close and see the month’s result.
Pass 60% · Merit 75% · Distinction 90%
Engineering Students
Diploma, B.Tech, B.E., BCA, MCA, or M.Tech students seeking practical experience.
Aspiring Developers
Developers who want to build proof-of-work capstone projects for tech resumes.
Job Seekers
Graduates looking for AI-evaluated code review & verified industry credentials.