How to Create an Expense Report in QuickBooks Online (Step-by-Step)
How to Create an Expense Report in QuickBooks Online (Step-by-Step)
Category: Small Business Finances | Read Time: 9 min | By: Raymond Ihim | Updated: March 2025
Key Takeaways
- QuickBooks Online tracks, categorizes, and reports business expenses automatically once your accounts are connected
- The built-in reporting tools let you generate a complete expense report in under five minutes at any point during the year
- Proper category setup at the start saves significant time at tax season and reduces the risk of miscategorized deductions
- QuickBooks Online is the most efficient tool available for small business expense management \u2014 this guide shows you exactly how to use it
You have QuickBooks. Or you have been thinking about getting it. Either way, the question is the same: how do you actually turn your business spending into a clean, organized expense report you can hand to a tax preparer or use to make decisions about your business?
The answer is simpler than most people expect. QuickBooks Online was built to do exactly this, and once it is set up correctly, it essentially runs in the background \u2014 categorizing transactions, matching receipts, and generating reports on demand. The setup takes a few hours. The payoff lasts all year.
This guide walks you through the exact process, step by step. By the end, you will know how to connect your accounts, categorize expenses correctly, capture receipts, and pull a finished expense report whenever you need one.
Why QuickBooks Is the Right Tool for This Job
Before getting into the steps, it is worth being direct about why this matters. A lot of small business owners use a combination of spreadsheets, notes apps, and memory to track expenses. That system works until it does not, and it usually stops working at the worst possible time \u2014 right before a filing deadline or during an audit.
QuickBooks Online solves the core problem of manual tracking by connecting directly to your bank accounts and credit cards. Transactions flow in automatically. The software learns your spending patterns and applies categories without you having to touch every line item. When you need a report, you generate it from real data rather than assembling it from scattered sources.
For a business running more than 20 to 30 transactions per month, the time savings alone make the subscription cost irrelevant. The question is not whether to use it. The question is whether you are using it correctly.
"The difference between a business that controls its finances and one that is controlled by them often comes down to one thing: whether their recordkeeping system runs in real time or gets rebuilt from memory in April." \u2014 Raymond Ihim, Founder, Lionhood Financial Coaching
Step 1: Set Up Your Chart of Accounts
The chart of accounts is the backbone of your QuickBooks expense tracking. It is the list of categories that every transaction gets assigned to. If your categories are set up correctly from the start, your reports will be accurate and useful. If they are not, you will spend time fixing miscategorizations instead of running your business.
When you first set up QuickBooks Online, it generates a default chart of accounts based on the business type you selected. For most small businesses and sole proprietors, this default list is a reasonable starting point. But you should review it and customize it to reflect how your business actually operates.
Here is how to access and edit your chart of accounts:
- Log in to QuickBooks Online
- Select Settings (the gear icon in the top right)
- Click Chart of Accounts under the Your Company column
- Review the existing expense accounts listed
- Click New to add a category that is missing, or select an existing category and click Edit to rename or adjust it
Common expense categories worth confirming are in your chart of accounts:
- Advertising and marketing
- Bank fees and charges
- Business meals (50 percent deductible)
- Contract labor and professional services
- Insurance
- Office supplies
- Rent and lease
- Software and subscriptions
- Travel expenses
- Vehicle and mileage
If you are unsure which categories your business needs, this is a good conversation to have with your accountant or with a financial coach who understands both the operational and tax implications of how you categorize spending.
\ud83d\udca1 Pro Tip: Keep your category list focused. More categories does not mean better reporting. Too many subcategories create confusion and inconsistent coding. Aim for a clean list of 10 to 15 expense categories that mirror how the IRS classifies deductions on Schedule C.
Step 2: Connect Your Bank Accounts and Credit Cards
This is where QuickBooks starts doing the heavy lifting. Once your financial accounts are connected, transactions import automatically and you stop having to manually enter spending.
To connect an account:
- Go to Bookkeeping in the left navigation menu
- Select Transactions, then Bank Transactions
- Click Connect account or Link account
- Search for your bank or credit card provider
- Enter your online banking credentials when prompted
- Select the accounts you want to connect and the start date for imported transactions
QuickBooks supports connections with most major banks, credit unions, and credit card providers. If your financial institution is not supported for direct connection, you can manually upload a CSV or QFX export from your bank's website instead.
Once connected, QuickBooks will import your transactions and begin attempting to categorize them automatically. It will not get every category right immediately, which leads directly to the next step.
\u26a0\ufe0f Watch Out: Do not assume QuickBooks categorized everything correctly just because it categorized everything quickly. In the first 30 to 60 days, spot-check your transactions regularly. The software learns from your corrections, so the more you train it early, the more accurate it becomes over time. Uncorrected miscategorizations compound into reporting errors that cause real problems at tax time.
Step 3: Review and Categorize Transactions
Once your accounts are connected and transactions are flowing in, your job is to review the uncategorized or incorrectly categorized transactions and assign them to the right accounts.
Here is the workflow:
- Go to Bookkeeping, then Transactions, then Bank Transactions
- Look for transactions flagged as uncategorized or listed under a category that does not look right
- Click a transaction to expand it
- Use the Category dropdown to assign the correct expense account
- Add a memo in the Description field if the business purpose is not obvious from the vendor name
- Click Add to confirm
For recurring vendors \u2014 the software subscription you pay monthly, the office supply store you use regularly, the fuel station you stop at for business travel \u2014 QuickBooks lets you create rules that automatically categorize transactions from those vendors going forward. This is one of the highest-leverage settings in the entire platform.
To create a rule: Go to Settings, then Rules, then New rule. Set the conditions based on vendor name or transaction description, assign the category, and save. QuickBooks will apply that rule to all matching transactions automatically.
Step 4: Attach Receipts to Transactions
Categorizing transactions establishes what you spent. Attaching receipts establishes proof. Both are necessary if you want deductions that can withstand scrutiny.
QuickBooks gives you two ways to capture receipts:
Option 1: Upload via the QuickBooks mobile app Open the QuickBooks app on your phone, tap the receipt capture icon, photograph the receipt immediately after a purchase, and QuickBooks will extract the transaction details and match it to the corresponding bank transaction automatically. This is the most efficient method for capturing receipts in real time.
Option 2: Upload manually in the desktop interface From the Bank Transactions view, click on any transaction, select the Attachments section, and upload an image or PDF of the receipt from your computer.
The goal is a one-to-one match between transactions and receipts for every significant expense. For small incidental purchases under $75, the IRS generally does not require receipts, but documentation of the business purpose is still good practice.
Building the habit of photographing receipts immediately is one of the highest-return financial habits a small business owner can develop. It takes three seconds at the point of transaction. It can save hours of reconstruction work later.
How to Generate an Expense Report in QuickBooks Online
Once your transactions are categorized and receipts are attached, pulling an expense report is straightforward. QuickBooks has several built-in reports that serve different purposes.
For a full expense summary by category:
- Go to Reports in the left navigation menu
- Search for Transaction List by Vendor or Expenses by Vendor Summary
- Set the date range to the period you want to report on
- Click Run report
For a profit and loss view that includes expense totals:
- Go to Reports
- Search for Profit and Loss
- Set your date range
- Click Run report
The Profit and Loss report gives you a complete picture of revenue versus expenses and is the document most tax preparers will ask for first.
To export your report: Any report in QuickBooks can be exported to PDF or Excel by clicking the export icon in the top right of the report view. This is the file you send to your accountant, your tax preparer, or your financial coach.
\ud83d\udca1 Pro Tip: Run your expense reports monthly and save them to a dedicated folder. This gives you a running record of your financials throughout the year and makes your year-end tax preparation a simple assembly process rather than a scramble.
What to Do When Transactions Are Missing or Incorrect
Even with automatic bank feeds, gaps happen. Banks occasionally delay transaction imports. A business expense paid from a personal account will not show up. A transaction might import with incorrect details.
Here is how to handle the most common issues:
Missing transactions: Manually add them by clicking New transaction in the Bank Transactions view. Enter the date, payee, category, amount, and a description. Attach any supporting documentation you have.
Duplicate transactions: If a transaction imported twice, select the duplicate in the Bank Transactions list and click Exclude. Do not delete it outright until you confirm which version is accurate.
Transactions from personal accounts: For business expenses paid from personal funds, use a Journal Entry or record it as an owner contribution. Your accountant can help you handle these correctly if you are not comfortable with the mechanics.
Transactions in the wrong period: QuickBooks posts transactions on the date they clear your bank. If a December expense clears in January, it will appear in the wrong tax year. Flag these for your accountant so they can be assigned to the correct period.
Frequently Asked Questions
Does QuickBooks Online automatically generate expense reports? QuickBooks does not send you a report automatically, but it makes generating one a two-minute task at any point. The data is always current as long as your bank feeds are connected and your transactions are categorized. You generate the report when you need it rather than waiting for it to be sent.
Can I use QuickBooks to track mileage as a business expense? Yes. QuickBooks Online includes a mileage tracking feature accessible through the mobile app. You can log trips manually or enable automatic tracking using your phone's GPS. The app calculates the deduction based on the current IRS standard mileage rate and adds it to your expense records.
How do I handle receipts I already lost? For transactions where you no longer have the original receipt, check your email for order confirmations or digital receipts from the vendor. For in-person purchases, contact the vendor directly \u2014 most businesses can reprint receipts for recent transactions. If neither is possible, document the expense with a written explanation of the business purpose and the best information you have. Consult your tax preparer on