Engineers Clinic
BeginnerBusiness trackFP-CF-04

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.

Business & ManagementAccounting
6 Guided Steps28h Internship TierSubmit: Excel workbook with ledger, bank reconciliation, journals and trial balance + close checklist + one-page close noteVerified CertificateAI Rubric Graded
Program Overview

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.

Double-entry bookkeepingBank reconciliationAccruals and prepaymentsDepreciationBalance sheet reconciliationClose checklists
What you submit

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

How it is graded
  • 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%

Learning Outcomes
Run a month-end close from a checklist
prepare a bank reconciliation that explains every difference
post standard month-end journals
reconcile balance sheet accounts and present a close pack
Target Audience

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.