Month-end close is when you finalize your books for the month, ensuring everything is recorded, reconciled, and accurate. A proper month-end close gives you reliable financial statements you can trust to make business decisions. Here's a complete, step-by-step process that works for Minnesota small businesses.
Why Month-End Close Matters
Regular month-end close: • Provides accurate financial statements • Catches errors before they compound • Enables meaningful period-to-period comparisons • Supports informed business decisions • Makes tax preparation easier • Identifies cash flow trends • Ensures you're ready for audits or loan applications
Businesses that skip month-end close end up with: • Unreliable financial data • Surprise tax bills • Poor business decisions based on bad data • Expensive cleanup projects
The Month-End Close Timeline
Realistic timeline for small businesses:
Week 1 of new month: Transaction recording and preliminary reconciliation Week 2: Complete reconciliations and adjustments By 15th of new month: Financial statements complete
With practice and good systems, you can close in 3-5 business days.
Step 1: Review Outstanding Items (Day 1)
Before diving into reconciliation, handle open items:
Review Undeposited Funds: • QuickBooks holds payments here until deposit • Should be zero or match actual undeposited checks • Create bank deposits to clear old items
Check for Uncategorized Transactions: • Bank feed transactions not assigned to accounts • Credit card charges not categorized • Categorize or match to existing entries
Review Pending Bills: • Bills entered but not paid • Verify they belong in this accounting period • Enter any missing bills
Check Open Invoices: • Review accounts receivable aging • Verify all work invoiced • Create invoices for completed work
Step 2: Record All Transactions (Day 1-2)
Ensure all financial activity is recorded:
Bank Transactions: • Download or import latest bank statements • Record all checks written • Record all deposits made • Record all ACH payments • Record all wire transfers • Record all bank fees
Credit Card Transactions: • Download credit card statements • Categorize all charges • Match to existing entries if duplicates • Add missing business purpose notes
Cash Transactions: • Record all cash receipts • Record all cash disbursements • Verify petty cash balance
Revenue: • Record all sales • Create invoices for completed work • Record cash sales • Record merchant processor deposits
Expenses: • Enter all vendor bills received • Record expenses paid with cash/check • Add recurring expenses (rent, subscriptions) • Record payroll if not already done
Step 3: Reconcile Bank Accounts (Day 2-3)
Reconcile every bank account:
Checking Accounts: 1. Open bank reconciliation in QuickBooks 2. Enter ending balance from bank statement 3. Enter statement ending date 4. Check off all cleared transactions: • Deposits that cleared • Checks that cleared • Electronic payments that cleared • Bank fees 5. Investigate any discrepancies 6. Difference should be zero before finishing
Savings Accounts: • Same process as checking • Record interest earned • Record any transfers between accounts
Common Reconciliation Issues:
Transactions Missing: • Bank shows transaction, QuickBooks doesn't • Enter the missing transaction
Duplicate Entries: • Transaction entered twice in QuickBooks • Delete duplicate
Wrong Amount: • Amount in QuickBooks doesn't match bank • Edit transaction to correct amount
Outstanding Checks: • Checks written but not yet cashed • Perfectly normal, verify they're legitimate • Follow up on old outstanding checks (90+ days)
Step 4: Reconcile Credit Cards (Day 3)
Reconcile each business credit card:
1. Match credit card statement to QuickBooks 2. Verify all charges are recorded 3. Check for personal charges (record as owner draw) 4. Confirm payment is recorded 5. Ending balance should match statement
Handling Credit Card Payments: When you pay the credit card: • Debit: Credit Card Liability (reduces balance) • Credit: Checking Account (payment)
Don't record payment as an expense - it reduces liability.
Step 5: Review Accounts Receivable (Day 3)
Verify your AR aging report:
Run AR Aging Detail: • Shows all open invoices • Grouped by age (current, 30, 60, 90+ days)
Verify each open invoice: • Was work actually completed? • Has customer paid (but payment not recorded)? • Is invoice still valid?
Handle problem invoices: • Customer paid: Record the payment • Invoice incorrect: Credit and reissue • Uncollectible: Write off as bad debt
Uncollectible Accounts: If invoice is truly uncollectible: 1. Create credit memo or journal entry 2. Debit: Bad Debt Expense 3. Credit: Accounts Receivable
Step 6: Review Accounts Payable (Day 3)
Verify your AP aging report:
Run AP Aging Detail: • Shows all unpaid bills • Verify accuracy
Check for: • Bills entered twice (duplicates) • Bills from prior periods not yet entered • Bills paid but not marked paid in system
Match Bills to Bank Transactions: • Bills marked paid should match actual payments • Bank payments should have corresponding bills
Step 7: Record Adjusting Entries (Day 4)
Make necessary month-end adjustments:
Depreciation: • Monthly depreciation for fixed assets • Debit: Depreciation Expense • Credit: Accumulated Depreciation
Prepaid Expenses: • Insurance, rent, or other prepaid items • Debit: Expense account (monthly portion) • Credit: Prepaid asset account
Accrued Expenses: • Expenses incurred but not yet billed • Debit: Expense account • Credit: Accrued expenses liability
Deferred Revenue: • If you received payment for future work • Recognize revenue as work is completed • Debit: Deferred revenue liability • Credit: Revenue
Inventory Adjustments (if applicable): • Physical count vs. system count • Adjust for shrinkage, damage, theft • Debit: Cost of goods sold (for shortage) • Credit: Inventory
Loan Interest Accrual: • Accrue interest on loans • Debit: Interest expense • Credit: Interest payable or loan balance
Step 8: Review Financial Statements (Day 4-5)
Generate and review key reports:
Profit & Loss Statement: • Revenue by category • Expenses by category • Net income
Look for: • Unusual spikes in expenses • Revenue lower/higher than expected • Accounts with unexpected activity • Very large miscellaneous expenses
Balance Sheet: • Assets • Liabilities • Equity
Verify: • Bank balances match reconciled amounts • AR balance matches aging report • AP balance matches aging report • Credit card balances match statements • Loan balances are accurate
Statement of Cash Flows: • Operating activities • Investing activities • Financing activities
Analyze: • Where cash came from • Where cash went • Whether operations are cash-positive
Step 9: Review Key Metrics (Day 5)
Calculate and track important metrics:
Profitability Metrics: • Gross profit margin: (Revenue - COGS) / Revenue • Net profit margin: Net income / Revenue • Revenue growth: Compare to prior month and year
Liquidity Metrics: • Current ratio: Current assets / Current liabilities • Quick ratio: (Current assets - Inventory) / Current liabilities • Working capital: Current assets - Current liabilities
Efficiency Metrics: • Days sales outstanding: (AR / Revenue) × 30 • Days payable outstanding: (AP / COGS) × 30 • Inventory turnover: COGS / Average inventory
Compare to: • Prior month • Same month prior year • Budget • Industry benchmarks
Step 10: Document and File (Day 5)
Create permanent record:
Financial Statement Package: • Profit & Loss (current month and YTD) • Balance Sheet • Statement of Cash Flows • AR Aging • AP Aging • Key metrics summary
Save as PDF: • Create folder: "Financial Statements/2025/January" • Save all reports • Add notes about unusual items
Bank Reconciliation Reports: • Save reconciliation summary • Note any outstanding items • Document any adjustments made
Supporting Documentation: • Save bank statements • Save credit card statements • Save payroll reports • File physical receipts
Step 11: Communication (Day 5)
Share results with stakeholders:
Owner Review: • Review financial statements • Discuss unusual items • Address any concerns • Plan for next month
Management Meeting: • Present key metrics • Explain variances • Discuss cash flow • Review budget vs. actual
External Parties: • CPA (if quarterly review) • Lenders (if required) • Investors (if applicable)
Month-End Close Checklist
Use this checklist each month:
□ Review and clear undeposited funds □ Categorize all bank transactions □ Categorize all credit card transactions □ Record all cash transactions □ Enter all bills received □ Create invoices for completed work □ Reconcile all bank accounts □ Reconcile all credit cards □ Review accounts receivable aging □ Review accounts payable aging □ Record depreciation □ Adjust prepaid expenses □ Record accrued expenses □ Adjust deferred revenue □ Review P&L for unusual items □ Review balance sheet for accuracy □ Calculate key metrics □ Compare to prior periods □ Generate financial statement package □ Save all reports to file □ Document unusual items □ Review with owner/management
Common Month-End Problems and Solutions
Problem: Reconciliation Won't Balance Solution: • Check for duplicates • Verify all transactions are in correct month • Look for transposed numbers • Check for missing transactions • Review previous month's reconciliation
Problem: Taking Too Long Solution: • Record transactions weekly, not monthly • Use bank feeds to import automatically • Create recurring entries for predictable expenses • Use receipt capture apps • Develop checklist and follow same process
Problem: Unusual Account Balances Solution: • Run transaction detail report • Review each transaction in the account • Look for miscategorized items • Check for duplicate entries • Reclassify if needed
Problem: Net Income Doesn't Match Bank Balance Solution: • Remember: Profit ≠ Cash • Check: Did you buy equipment? (cash out, not expense) • Check: Did customers pay? (AR affects cash, not income) • Check: Did you pay bills? (Expense when incurred, not when paid) • Review balance sheet for changes
Automating Month-End Close
Tools that speed up the process:
Bank Feeds: • Automatically import transactions • Reduce manual data entry • Match to existing entries • Set up rules for recurring transactions
Recurring Transactions: • Rent • Insurance • Software subscriptions • Loan payments • Set up once, auto-create monthly
Receipt Capture Apps: • Photograph receipts • Extract data automatically • Sync to QuickBooks • Searchable archive
Class/Location Tracking: • Auto-categorize by department • Track profitability by location • Simplify reporting
Custom Reports: • Save report configurations • Run same reports each month • Compare periods automatically
Best Practices for Efficient Month-End
1. Don't Wait Until Month-End Record transactions throughout month: • Weekly transaction entry • Weekly receipt organization • Ongoing bank feed review
2. Use Same Process Every Month • Follow checklist • Same order every time • Develops muscle memory • Harder to forget steps
3. Set Realistic Deadlines Don't try to close on the 1st: • Need bank statements (available 1-3 days after month-end) • Need time to investigate issues • Need credit card statements
Target: Close by the 15th of following month
4. Review Don't Just Record Month-end is chance to: • Spot trends • Identify problems early • Find cost savings • Improve operations
Don't just create reports - actually review them.
5. Document Unusual Items Leave notes for future you: • Why did marketing spike this month? • What was that large miscellaneous expense? • Why is AR so high?
Six months from now, you won't remember.
6. Get Help If Needed Strugging with month-end? • Hire bookkeeper • Fix setup issues • Clean up historical mess
Professional bookkeepers can: • Complete close in days, not weeks • Ensure accuracy • Teach you the process • Set up systems that work
A consistent month-end close process transforms your bookkeeping from a necessary evil into a valuable business tool. The time you invest in closing properly pays dividends in better decisions, less stress during tax season, and confidence in your financial position.