Monthly Bookkeeping and Accounting Close

Month-end close workflow for a bookkeeper or fractional controller running an SMB engagement in QuickBooks Online or Xero. Covers pre-close setup, reconciliations, sub-ledger tie-outs, adjusting entries, reporting, and client delivery.

6 sections 24 steps Collects data
1

Pre-Close Setup

  1. Confirm bank and credit-card statements received
    • Check the client portal (SmartVault, ShareFile, Liscio, or TaxDome) for every operating account, savings account, and credit card. Missing a single statement at this stage cascades into a stalled reconciliation later in the week. Chase any missing statement before bank-rec day rather than during it.

    Collects file
  2. Confirm payroll is posted through period-end
    • Verify the last pay date in Gusto, ADP, or QuickBooks Payroll has synced to the GL with both gross wages and the corresponding tax-deposit liability. If the pay period straddles month-end, note the unpaid days for the payroll accrual in the AJE phase.

  3. Confirm vendor bills entered through period-end
    • Pull the Bill.com or Ramp queue and verify every dated bill in the period is entered to A/P. Receipt-capture tools (Hubdoc, Dext) often have unprocessed items that need to be matched or coded before close.

  4. Confirm customer invoices entered for the period
    • Tie billable revenue from the client's project tool, time tracker, or sales system to invoices in QBO/Xero. Uninvoiced revenue that should be recognized in the period gets handled as an accrual later, but missing invoices for completed work need to be created now.

2

Bank and Credit-Card Reconciliation

  1. Reconcile each operating bank account
    • Tie ending bank balance to book balance for each account, accounting for outstanding checks and deposits in transit. Save the QBO/Xero reconciliation report PDF to the workpaper folder — that is the audit trail.

  2. Reconcile each credit-card account
    • Match every charge to a coded transaction or receipt. Bank-feed rules tend to drift as new vendors appear; auto-categorized lines that landed in Ask My Accountant get cleared here, not at year-end.

  3. Clear stale uncleared transactions
    • Pull the uncleared transactions report. Anything older than 90 days is suspicious — often a duplicated entry, a voided check that was never voided in the system, or a deposit booked twice. Resolve before signing the rec.

  4. Document unreconciled items in the workpaper
    • List each unreconciled item with date, amount, and suspected cause. Per firm policy, any unreconciled item over $1,000 gets routed to the client for review before the period is locked.

    Collects list
  5. Email client about material reconciling items
    • Send the controller or owner the workpaper extract listing each item over $1,000, along with the suspected cause and the question being asked. Block the close from progressing until you have written confirmation back.

3

Sub-Ledger Tie-Out

  1. Tie A/R aging to GL receivables
    • The customer balance summary should equal the A/R control account on the trial balance. A variance usually means a journal entry hit A/R without a customer assigned, which breaks the sub-ledger. Investigate any 90+ buckets with the client for collectability.

  2. Tie A/P aging to GL payables
    • Vendor balance summary should equal the A/P control account. Common breaks: a bill-payment recorded as a check directly to expense, bypassing the bill; or a credit memo applied incorrectly.

  3. Roll forward fixed assets and post depreciation
    • Update the depreciation schedule for any new acquisitions or disposals. Post the monthly depreciation entry per the schedule. Ending accumulated depreciation should tie to the balance sheet.

  4. Tie loan balances to lender statements
    • For each note payable, confirm principal balance equals the lender's month-end statement. Split each loan payment between principal and interest using the amortization schedule — auto-categorization rules typically post the whole payment to interest.

4

Adjusting Journal Entries

  1. Accrue payroll for unpaid days
    • If period-end falls mid-pay-period, accrue gross wages for the unpaid days plus the employer FICA portion. Reverse on the first of the following month so the next payroll posting doesn't double-book.

  2. Record prepaid expense amortization
    • Annual insurance premiums, software subscriptions, and prepaid rent get spread across the periods they cover. Pull the prepaid schedule and post the monthly portion.

  3. Recognize deferred revenue earned in period
    • For SaaS or retainer clients, customer deposits sit on the balance sheet as deferred revenue and release as service is delivered. Tie to the deferred-revenue waterfall before posting.

  4. Reclass misposted transactions
    • Anything sitting in Ask My Accountant or a generic suspense account gets reclassed to the correct GL account with a memo. Every AJE needs a memo and supporting workpaper — partners block close until populated.

5

Review and Reporting

  1. Review the trial balance for variances
    • Compare the trial balance against the prior month and the same month last year. Flag any account with a movement greater than 20% or $5,000 for explanation. Capture the explanations in the variance notes — these become the basis of the management commentary.

    Collects paragraph
  2. Generate P&L with prior-period comparison
    • Run the income statement with current month, YTD, and prior-year comparison columns. If the client uses class or location tracking, also produce the segmented P&L by class.

  3. Generate balance sheet and cash flow
    • Produce the balance sheet and indirect-method cash flow statement. Confirm cash on the cash flow ties to the bank-rec ending balance — a mismatch usually means a balance-sheet account moved without a P&L counterpart.

  4. Write management commentary
    • Three to five short paragraphs covering: top P&L variances with cause, A/R concerns and aging trend, current cash position and runway, and any KPI movement the client tracks (gross margin, DSO, headcount cost ratio).

6

Client Delivery

  1. Lock the period in QBO or Xero
    • Set the close date in QBO (Account and Settings → Advanced → Accounting) or Xero (Advanced → Financial settings) with a password. This prevents the client or staff from posting back-dated transactions that would invalidate the locked figures.

  2. Send the report package to the client
    • Upload the package (P&L, balance sheet, cash flow, commentary) to the client portal and notify the client. Capture the sent date for SLA tracking — most engagement letters specify delivery by the 10th business day after period-end.

    Collects file Collects list Collects date
  3. Schedule the monthly review call
    • Get a 30-minute review call on the calendar within a week of delivery. Walking the client through the variance notes and A/R aging in person catches questions that would otherwise become a long email thread.

Use this template

Copy it to your account, customize the steps, and run it with your team in minutes.


Sections 6
Steps 24
Category Accounting
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Monthly Bookkeeping and Accounting Close with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.