Month-End Close Template

Small Business Month-End Close Excel Template with bank reconciliation, journal entries, and a P&L dashboard. Close your books in one workbook — no accounting software required.

WHAT'S INCLUDED (5 sheets):

- Close Checklist — 18 tasks in close order, status dropdowns, auto % complete

- Bank Reconciliation — deposits in transit, outstanding checks, adjustments, and a difference check that must read 0.00

- Journal Entries — 10-entry log, debits must equal credits

- P&L Dashboard — revenue and expenses by category, net income, margin, variance vs. prior month and budget

- Cover & How to Use — start here

PLEASE NOTE:

- Instant digital download. No physical item ships.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data is included so you can see how it works. Replace the yellow cells with your own numbers — yellow cells are the only ones you edit.

- This is a bookkeeping tool, not tax, legal, or CPA advice.

- Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.