What reports should I run in QuickBooks each month?
Start with the Profit and Loss statement. This shows revenue minus expenses for the month and tells you whether you actually made money. Run it for the current month and compare to the same month last year. Look for expense categories that jumped unexpectedly and revenue lines that fell short. A 25% increase in vehicle expenses or a drop in service revenue is worth understanding before it becomes a pattern.
The Balance Sheet gets skipped by most small business owners because it seems abstract, but it catches problems the P&L misses. Check accounts receivable. If AR is growing faster than revenue, customers are paying slower and cash is getting stuck. Look at accounts payable to see if you’re falling behind with vendors. The balance sheet is a snapshot of your financial health, and comparing month over month reveals trends you’d otherwise miss.
Run your Accounts Receivable Aging report to see exactly who owes you money and how long they’ve owed it. Anything over 30 days needs follow-up. Anything over 60 days is at serious risk of going uncollected. The Accounts Payable Aging report does the same for what you owe. Knowing you have $12,000 due to vendors next week beats being surprised when cash runs short.
The P&L shows you revenue when earned and expenses when incurred, but that’s not the same as cash in and out. Run a Statement of Cash Flows or switch your P&L to cash basis to see where money actually went. Profitable businesses still run out of cash when receivables pile up and payables come due.
Context makes reports useful. A $50,000 revenue month means nothing until you know last year was $65,000 or your budget was $40,000. Run comparison reports that show current month versus prior month and versus the same month last year. If you maintain a budget, compare to that too. Without context, you’re just looking at numbers.
For contractors and job-based businesses, add a Job Profitability report showing revenue and costs by project. This tells you which jobs made money and which lost it. If your job costing is set up properly, this report reveals whether your estimates match reality and which job types are worth pursuing.
The reports only matter if you review them. Set a monthly close date and block time to look through everything. Many local bookkeepers prepare monthly reports with plain-English summaries of what changed and why. Even if someone else runs the numbers, you should understand what you’re looking at and know what questions to ask when something doesn’t match expectations.
Greater Boston's Trusted Bookkeeping Partner
The Next Step:
A Short Conversation
We'll ask a few questions, figure out what you need, and give you a straightforward quote.
More Questions
What financial reports help track cash flow?
The most useful reports are accounts receivable aging, accounts payable aging, bank reconciliation, and a rolling cash forecast. The profit and loss statement shows profitability but not cash position, so you need reports that track actual money movement.
Read answerHow do I set up payroll for my small business?
Setting up payroll requires a federal EIN, Massachusetts state registrations for withholding and unemployment, and a system for calculating and depositing taxes on time. Massachusetts also requires Paid Family and Medical Leave contributions that many new employers miss.
Read answerHow do I prepare my books for tax season?
Reconcile all bank and credit card accounts, categorize every transaction, and gather documentation before handing anything to your CPA. Prepare 1099s and W-2s, review accounts receivable, and run year-end reports to catch errors.
Read answerWhat bookkeeping challenges do retail stores face?
Retail stores face unique challenges including high transaction volumes, inventory tracking, cash handling, multiple payment methods, and seasonal cash flow swings. Each creates opportunities for errors that compound quickly without proper systems in place.
Read answerCan my bookkeeper handle payroll too?
Many full-service bookkeepers handle payroll alongside regular bookkeeping. Bundling these services keeps your books and payroll in sync, simplifies compliance, and gives you one point of contact for financial operations.
Read answerHow do I track job costs in QuickBooks Online?
QuickBooks Online has built-in project tracking that works for basic job costing. Enable it in settings, create a project for each job, then assign every expense, bill, and time entry to the right project. The key is consistent categorization and tagging at the time of entry.
Read answer