How to Create an Expense Report in QuickBooks (Step-by-Step Guide)
How to Create an Expense Report in QuickBooks — Step-by-Step Guide
Category: Small Business Finances | Read Time: 8 min | By: Raymond Ihim | Updated: April 2026
Key Takeaways
- QuickBooks generates detailed expense reports in minutes, but only if your transactions are properly categorized before you run them.
- The most useful reports for small business owners are Expenses by Vendor Summary and Transaction Detail by Account, both fully customizable by date range and category.
- An expense report is not just a tax document. It is a cash flow management tool that tells you exactly where your money is going every month.
- Connecting your bank accounts and automating transaction imports eliminates the backlog that makes expense reporting painful at year end.
If you are running a small business and dreading the expense tracking conversation, you are not alone. Most business owners do not struggle because their finances are complicated. They struggle because no one ever showed them a clean, repeatable system.
QuickBooks has the tools to fix that. The problem is that most users only scratch the surface of what the platform can actually do. They log transactions, hope the categories are right, and then scramble when tax season or a lender review arrives.
This guide walks you through exactly how to create an expense report in QuickBooks, what to look for once you have it, and how to build the habits that make this process take minutes instead of hours.
What Is an Expense Report and Why Does It Matter?
An expense report is a summarized record of everything your business spent over a given period. It captures vendor payments, operating costs, travel, meals, software subscriptions, equipment purchases, and every other outflow that runs through your business accounts.
For a small business owner, this report does four things at once:
- Shows you exactly where your cash is going
- Identifies categories that are overweight relative to your revenue
- Surfaces tax-deductible expenses before your accountant has to hunt for them
- Gives lenders, investors, or partners a clean financial picture on demand
"An expense report is not paperwork. It is a financial dashboard. If you are not reviewing it monthly, you are managing your business in the dark." — Raymond Ihim, Founder, Lionhood Financial Coaching
The distinction matters because most business owners treat expense reporting as a compliance task — something you do because the IRS expects it. The owners who grow fastest treat it as a decision-making tool. They run their reports every month, spot the trends, and adjust before problems compound.
Step 1: Log In and Navigate to Reports
Open your QuickBooks Online dashboard and sign in to your account. On the left-hand navigation menu, click Reports.
QuickBooks organizes its reports into categories. For expense tracking, you are working primarily in the Expenses and Vendors section. You can also use the search bar at the top of the Reports page to pull up specific report types by name.
The two reports you will use most often are:
- Expenses by Vendor Summary — shows total spending per vendor over your selected date range
- Transaction Detail by Account — shows every individual transaction categorized by account type
Both are customizable and exportable. Start with Expenses by Vendor Summary for a high-level read on where your money is going, then drill into Transaction Detail by Account when you need line-item clarity.
💡 Pro Tip: Bookmark both reports in your browser once you have customized them to your preferred settings. QuickBooks does not always save your filter preferences between sessions, so having direct access saves time every month.
Step 2: Set Your Date Range and Filters
Once you have opened your chosen report, the first thing to configure is the date range. QuickBooks gives you preset options — This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year — or you can enter a custom range manually.
For monthly financial reviews, run Last Month every time you close out a period. For tax preparation, run the full calendar year or your fiscal year, depending on how your business is structured. For a lender package or investor review, run the trailing twelve months.
Beyond the date range, you can filter by:
- Vendor — useful when you want to isolate spending with a specific supplier or contractor
- Expense category or account — useful when you are analyzing one cost center, such as marketing or payroll
- Class or location — useful if you have set up tracking for multiple business units or properties inside the same QuickBooks account
Apply your filters before generating the report. Changing them after the fact can reset other settings and cost you extra steps.
⚠️ Watch Out: Running an expense report without first verifying your transaction categories will give you a report that looks complete but is not. Miscategorized transactions skew every number on the page. Before you trust any report output, spend time in your transaction register confirming that each entry is tagged to the right account. A report built on bad data is worse than no report at all.
Step 3: Review and Confirm Your Expense Categories
This is the step most business owners skip, and it is the one that matters most.
Before you finalize any expense report, open your transaction list and audit the categories. In QuickBooks Online, go to Transactions, then Expenses, and scroll through your entries for the period you are reporting on.
Look for three things:
- Uncategorized transactions — these show up as "Uncategorized Expense" and will create a catch-all bucket in your report that obscures real spending patterns
- Miscategorized transactions — a software subscription logged as office supplies, or a contractor payment logged as payroll, distorts both your expense profile and your tax position
- Personal expenses mixed in with business expenses — if your business and personal accounts share any overlap, this is where it shows up
Cleaning these up before you run your report takes more time upfront. It saves significantly more time when your accountant reviews your books or when you need to defend a deduction.
Here is a clean category framework for most small businesses:
- Payroll and contractor payments
- Rent and occupancy costs
- Software and subscriptions
- Marketing and advertising
- Travel and meals
- Office supplies and equipment
- Professional services (legal, accounting, coaching)
- Utilities
- Insurance
- Loan repayments and interest
If your QuickBooks chart of accounts does not reflect these categories clearly, that is a setup issue worth correcting before your next reporting cycle. QuickBooks Online allows you to customize your chart of accounts to match your actual business structure.
Step 4: Generate, Export, and Use the Report
Once your categories are clean and your filters are set, click Run Report. QuickBooks will generate the report within seconds.
From here you have several options:
- Export to Excel or CSV for further analysis or sharing with a bookkeeper or accountant
- Export to PDF for lender packages, investor presentations, or clean record-keeping
- Print directly if you need a physical copy for a meeting or file
After you have the report in hand, do not just file it. Spend five to ten minutes reading it like a business owner, not an accountant. Ask yourself:
- Which expense categories grew compared to last month or last quarter?
- Are there any vendors you are paying consistently that no longer deliver value?
- Is your total expense load growing faster or slower than your revenue?
- Are there any charges you do not recognize?
That last question matters more than most owners realize. Unauthorized charges, duplicate payments, and forgotten subscriptions are common and they show up clearly in a well-run expense report.
💡 Pro Tip: Set a recurring calendar reminder on the first business day of each month to run your prior month expense report. Pair it with your bank reconciliation and you have a complete monthly financial close that takes under an hour once the habit is established.
What to Do When Your Books Are Behind
Not everyone is starting from a clean state. If your QuickBooks account has months of uncategorized transactions, mismatched entries, or a backlog of unreconciled bank statements, running an expense report right now will produce unreliable data.
Here is the deal: a backlog is fixable. It is not a reason to avoid the process. It is a reason to address it systematically before you rely on the output.
Work through it in this order:
- Reconcile your bank and credit card accounts first, starting with the most recent month and working backward
- Resolve uncategorized transactions in batches, oldest period first
- Flag any transactions you cannot identify for follow-up with your bank or card issuer
- Once each period is clean, run the expense report for that period and archive it
If you are several months behind, a bookkeeping cleanup session with a financial coach can compress that process significantly. At Lionhood Financial, we work with small business owners to get their QuickBooks accounts current, categorized, and reporting accurately so they can make decisions based on real numbers. Reach out here to get started.
Frequently Asked Questions
What is the best expense report to run in QuickBooks for tax preparation? Run the Transaction Detail by Account report for your full tax year, filtered to show all expense accounts. Export it to Excel and share it with your accountant alongside your bank reconciliation reports. That combination gives your tax preparer everything they need to identify deductions without having to dig through your raw transaction history.
How often should I run expense reports in QuickBooks? Monthly at minimum. Business owners who review expense reports quarterly are always reacting. Monthly reviews let you catch cost overruns, unauthorized charges, and category drift while there is still time to correct course within the same fiscal period.
Can I create a custom expense report in QuickBooks that shows only specific categories? Yes. In the Reports section, use the Customize button to filter by specific accounts, classes, vendors, or transaction types. You can save customized reports under a name of your choice for quick access in future months. This is particularly useful if you track expenses across multiple departments, projects, or properties.
What if my expense categories are a mess? Should I fix them before running reports? Yes, always. Running a report on miscategorized data produces numbers you cannot trust, and trusting bad numbers is more dangerous than having no numbers at all. Use the Expenses tab in QuickBooks to audit and correct your categories before generating any report you plan to act on or share externally.
Does QuickBooks automatically create expense reports? QuickBooks does not auto-generate a scheduled report without configuration, but you can set up automated report delivery inside the Reports section by clicking the gear icon and enabling email scheduling. Once configured, QuickBooks will deliver your chosen reports to a specified email address on a schedule you define.
The Bottom Line
Creating an expense report in QuickBooks is not technically difficult. What makes it hard for most small business owners is the setup work that should have happened earlier: clean categories, reconciled accounts, and a consistent monthly habit.
Get that foundation right and the reporting takes care of itself. You will have clean data for your accountant, a clear picture of where your money is going every month, and the financial visibility that separates businesses that scale from businesses that stall.
Start with Step 1 today. If your books need cleanup before you can trust your reports, that is the real first step.
Ready to get your QuickBooks account organized and reporting accurately? Connect with Lionhood Financial. →
Raymond Ihim is a banking leader with extensive expertise in risk management and financial services, and a proven track record of helping individuals and small business owners master their finances. As founder and head coach of Lionhood Financial Coaching, he has empowered countless clients to build generational wealth, eliminate debt, and establish financial stability through his popular "Make More of Your Money" podcast and practical financial coaching programs.