How to Track Expenses in QuickBooks Online

Tracking business expenses in QuickBooks Online is the single most important thing you can do to reduce your tax bill and keep your business financially healthy. Every dollar of business expense you miss is a dollar of taxable income you pay taxes on unnecessarily. Yet after 30 years of preparing tax returns for Dallas-Fort Worth business owners, Al Freideman still sees the same problem every tax season: shoeboxes full of receipts, bank statements with hundreds of uncategorized transactions, and thousands of dollars in legitimate deductions that never get claimed.

This guide walks you through everything you need to know about tracking expenses in QuickBooks Online in 2026, from initial setup and bank account linking to expense categorization, receipt capture, reporting, and the specific expense categories that matter most for tax deductions. Whether you just started using QuickBooks or you have been using it for years but know your books are messy, this guide will help you get organized. And if you decide you would rather have a professional handle it, our bookkeeping services start at $300 per month and include everything covered in this guide.

Why Expense Tracking Matters for Your Tax Bill

Every legitimate business expense reduces your taxable income dollar for dollar. If your business earns $200,000 in revenue and you have $80,000 in properly documented expenses, you pay taxes on $120,000. But if you only track $60,000 of those expenses because $20,000 went unrecorded or uncategorized, you pay taxes on $140,000 instead. For a business owner in the 24% federal tax bracket, that $20,000 in missed deductions costs you $4,800 in unnecessary federal tax alone, plus self-employment tax on top of that.

The IRS requires documentation for every business deduction you claim. If you get audited and cannot produce receipts or records showing what an expense was for, the deduction gets disallowed and you owe the tax plus interest and penalties. QuickBooks Online gives you the tools to track, categorize, and document every expense so you are always audit-ready.

Setting Up QuickBooks Online for Expense Tracking

Before you start recording expenses, you need to make sure QuickBooks is set up correctly. A clean setup now prevents hours of cleanup later. Here is what to do first.

Choose the Right QuickBooks Plan

QuickBooks Online comes in four tiers: Simple Start, Essentials, Plus, and Advanced. For most small businesses in Dallas, the Essentials plan ($60 per month in 2026) covers what you need for expense tracking. It includes bank feed connections, bill management, and basic reporting. If you need to track expenses by project or location, you will want Plus ($90 per month). Simple Start works for solo freelancers with very few transactions, but it lacks multi-user access and detailed reporting.

Link Your Bank Accounts and Credit Cards

The most important step in QuickBooks setup is connecting your business bank accounts and credit cards. This is what makes QuickBooks actually useful rather than just another piece of software you never open.

To connect your accounts: go to Transactions in the left menu, then click Bank Transactions, then click Link Account. Search for your bank (Chase, Bank of America, Capital One, or whichever institution you use), enter your online banking credentials, and select which accounts to connect. QuickBooks will import your recent transactions automatically, usually going back 90 days.

Once connected, QuickBooks downloads new transactions every day. You review them, categorize them, and they flow into your books automatically. This eliminates manual data entry for 90% of your transactions.

One critical rule: always use a separate bank account and credit card for your business. Mixing personal and business transactions makes expense tracking significantly harder and creates problems at tax time. If you are still using one account for everything, open a dedicated business checking account before doing anything else. Your CPA will thank you.

Customize Your Chart of Accounts

Your Chart of Accounts is the list of categories that QuickBooks uses to classify every transaction. QuickBooks comes with default categories, but you should customize them to match your specific business. Go to Settings (the gear icon), then Chart of Accounts, and review what is there.

For most Dallas small businesses, you want these expense categories at minimum: Advertising and Marketing, Auto and Vehicle Expenses, Bank Fees and Service Charges, Contractor and Subcontractor Payments, Insurance (broken into subcategories for health, liability, and workers comp), Meals and Entertainment, Office Supplies, Professional Fees (accounting, legal, consulting), Rent or Lease, Repairs and Maintenance, Software and Subscriptions, Telephone and Internet, Travel, and Utilities. If you have employees, add Payroll Expenses, Employee Benefits, and Payroll Taxes as separate categories.

Do not create too many categories. More is not better. If you have 150 expense categories, you will spend more time deciding where to put things than actually running your business. Aim for 15 to 25 categories that cover your major spending areas, with subcategories only where the distinction matters for tax reporting.

How to Record Expenses in QuickBooks Online

There are three main ways to get expenses into QuickBooks: bank feeds (automatic), manual entry, and receipt capture. Most businesses should use all three depending on the situation.

Method 1: Bank Feed Categorization (Best for Most Transactions)

Once your bank accounts are linked, transactions appear in the For Review tab under Bank Transactions. For each transaction, QuickBooks suggests a category based on the vendor name and past categorization patterns. You review the suggestion, adjust it if needed, and click Add to confirm. The transaction is now recorded in your books.

To speed this up, set up Bank Rules. Go to Transactions, then Bank Transactions, then click the Rules tab. Create rules like: “If vendor name contains ‘AT&T,’ categorize as Telephone and Internet.” QuickBooks will auto-categorize matching transactions going forward, saving you from reviewing them manually every time.

Review your bank feed at least once a week. Letting transactions pile up for months defeats the purpose. When you review weekly, you remember what each charge was for and can categorize accurately. When you wait until December, you are guessing and your books suffer.

Method 2: Manual Expense Entry (For Cash and Non-Bank Transactions)

Some expenses do not flow through your bank account: cash purchases, petty cash, barter transactions, or reimbursements. For these, you need to enter them manually.

Click the plus (+) button in the top right corner, then select Expense under Vendors. Choose the vendor (or add a new one), select the payment account (Cash on Hand, Petty Cash, or whichever account applies), enter the date and amount, choose the appropriate category, and add a memo describing what the expense was for. Attach a photo of the receipt if you have one.

Method 3: Receipt Capture (For Documentation and Cash Expenses)

QuickBooks Online has a built-in receipt capture feature through the QuickBooks mobile app. Open the app, tap the camera icon, and photograph your receipt. QuickBooks uses OCR (optical character recognition) to extract the vendor name, date, amount, and payment method from the receipt image. It then matches the receipt to an existing bank transaction or creates a new expense entry if no match is found.

This is especially useful for cash purchases, meals, parking, mileage reimbursement receipts, and any expense where you want to keep the receipt image attached to the transaction for audit purposes. Get in the habit of photographing every receipt the moment you get it. Paper receipts fade, get lost, and end up in that infamous shoebox. Digital copies attached to the transaction in QuickBooks are permanent, searchable, and available instantly if the IRS asks for documentation.

The 20 Most Important Expense Categories for Tax Deductions

Not all expense categories are created equal when it comes to tax deductions. These are the categories that save Dallas business owners the most money on their returns, based on 30 years of tax preparation experience.

Cost of Goods Sold (COGS): Direct costs of producing what you sell. Materials, inventory, direct labor. This is the single largest deduction for most product-based businesses. Track it separately from operating expenses because it reduces gross profit, not just net income.

Contractor Payments (1099 Labor): Payments to independent contractors, freelancers, and subcontractors. You must issue a 1099-NEC to anyone you pay $600 or more in a calendar year. QuickBooks tracks these automatically if you set up vendors correctly.

Vehicle Expenses: You can deduct actual expenses (gas, maintenance, insurance, depreciation) or use the IRS standard mileage rate (70 cents per mile for 2025, check IRS.gov for the 2026 rate). QuickBooks has a mileage tracker in the mobile app. For most Dallas business owners who drive 10,000 to 20,000 business miles per year, this deduction is worth $7,000 to $14,000.

Home Office Deduction: If you use a dedicated space in your home exclusively for business, you can deduct either the simplified method ($5 per square foot, up to 300 sq ft = $1,500) or actual expenses (percentage of rent/mortgage, utilities, insurance, repairs based on the square footage ratio). Track the underlying expenses in QuickBooks so your CPA can calculate the deduction properly.

Health Insurance Premiums: Self-employed business owners can deduct 100% of health insurance premiums for themselves, their spouse, and dependents. This includes medical, dental, and vision insurance. This deduction alone can be worth $5,000 to $20,000 per year depending on your plan.

Retirement Contributions: SEP IRA contributions (up to 25% of net self-employment income, max $69,000 for 2024), Solo 401(k) contributions, or SIMPLE IRA contributions are all deductible. If you are not contributing to a retirement plan, you are leaving one of the largest legal tax deductions on the table.

Rent and Lease Payments: Office rent, equipment leases, vehicle leases. Fully deductible as a business expense. Track each lease as a recurring transaction in QuickBooks so it never gets missed.

Professional Services: Accounting fees, legal fees, business consulting, tax preparation. Yes, the fee you pay your CPA is itself a tax-deductible business expense. Our pricing for tax preparation and bookkeeping is fully deductible.

Software and Subscriptions: QuickBooks itself, project management tools, CRM software, cloud storage, website hosting, design tools. These recurring charges add up to significant deductions. Create a subcategory for software so you can see the total at a glance.

Advertising and Marketing: Google Ads, Facebook Ads, print advertising, business cards, website design, SEO services, promotional materials. Every dollar spent marketing your business is deductible.

Insurance: General liability, professional liability (E&O), workers compensation, commercial auto insurance, cyber liability insurance. All deductible as business expenses. Health insurance is tracked separately (see above) because the deduction rules are different.

Meals (50% Deductible): Business meals with clients, prospects, or employees are 50% deductible in 2026. The 100% deduction for restaurant meals that existed during COVID has expired. Always document who you ate with and the business purpose on the receipt or in the QuickBooks memo field.

Travel: Flights, hotels, rental cars, rideshares, parking, and tolls for business travel. Fully deductible if the primary purpose of the trip is business. Keep detailed records of the business purpose for each trip.

Office Supplies: Paper, ink, pens, desk accessories, shipping supplies, cleaning supplies for your office. Small individually but they add up over a year.

Telephone and Internet: Your business phone line, cell phone (percentage used for business), and internet service. If you use your personal phone for business, track the business use percentage and deduct that portion.

Education and Training: Courses, certifications, conferences, books, and training materials related to your business. The expense must maintain or improve skills required in your current business.

Bank Fees and Merchant Processing: Monthly bank fees, credit card processing fees (Square, Stripe, PayPal), wire transfer fees, and ATM fees for your business account. These are often overlooked but they are 100% deductible.

Depreciation: Large asset purchases (equipment, furniture, computers, vehicles) over $2,500 can be expensed immediately under Section 179 or depreciated over their useful life. QuickBooks tracks fixed assets, but your CPA should handle the depreciation calculations on your tax return.

Repairs and Maintenance: Repairs to business equipment, office maintenance, janitorial services, HVAC service for your office. Fully deductible in the year incurred (unlike improvements, which must be depreciated).

Utilities: Electric, gas, water, and trash for your business location. If you work from home, these are part of your home office deduction calculation.

Setting Up Bank Rules to Automate Categorization

Bank rules are the biggest time saver in QuickBooks Online. Instead of manually categorizing the same AT&T charge every month, you create a rule once and QuickBooks handles it forever.

To create a bank rule: go to Transactions, then Bank Transactions, then click the Rules tab at the top. Click New Rule. Set the conditions (for example, “If bank text contains ‘COMCAST'” then “Categorize as Telephone and Internet”). You can also set the vendor name, class, and memo automatically. Choose whether the rule should auto-add the transaction or just suggest the category for your review.

Start with your recurring monthly charges: rent, utilities, phone, internet, insurance, software subscriptions, loan payments. These are the same every month and there is no reason to manually categorize them each time. Then add rules for your most frequent vendors: the gas station you always use, the office supply store, your regular lunch spot for client meetings.

A well-configured QuickBooks account with 30 to 50 bank rules can auto-categorize 70% to 80% of your transactions, leaving you to review only the unusual or one-time charges manually.

How to Split Transactions Across Multiple Categories

Sometimes a single transaction covers multiple expense categories. For example, you make a $500 purchase at Costco that includes $300 of inventory (COGS), $100 of office supplies, and $100 of break room snacks (meals). QuickBooks lets you split these.

When categorizing a bank transaction, click Split instead of selecting a single category. This opens multiple line items where you can assign different amounts to different categories. Enter $300 to Cost of Goods Sold, $100 to Office Supplies, and $100 to Meals, and the total still matches your bank transaction. This level of detail matters at tax time because each category may have different deductibility rules (meals are 50% deductible, supplies are 100%).

Running Expense Reports in QuickBooks Online

Tracking expenses is only useful if you review the data. QuickBooks has several reports that help you understand where your money is going.

Profit and Loss Report (P&L): This is your most important report. It shows revenue minus expenses equals net income. Run it monthly to see if your spending is on track. Go to Reports, search for Profit and Loss, set the date range, and run it. You can compare month-over-month or year-over-year to spot trends.

Transaction Detail by Account: This shows every individual transaction within each expense category. Useful when you need to see exactly what made up your $3,200 in “Contractor Payments” last month. Go to Reports, search for Transaction Detail by Account, then filter by Distribution Account to show only expense accounts.

Expenses by Vendor: Shows how much you have paid to each vendor over a time period. Helpful for identifying your largest spending relationships and negotiating better terms. Run the Expenses by Vendor Summary report from the Reports menu.

Budget vs. Actual: If you set up a budget in QuickBooks (Plus plan and above), this report compares your actual spending to your budgeted amounts by category. It highlights where you are overspending before it becomes a cash flow problem.

Monthly Expense Tracking Checklist

Follow this checklist every month to keep your books clean and your tax deductions maximized.

Week 1: Review and categorize all bank feed transactions from the past week. Capture and attach any paper receipts using the QuickBooks mobile app. Check for any transactions QuickBooks could not auto-categorize.

Week 2: Review and categorize the second week of transactions. Enter any cash expenses that did not come through the bank feed. Check for duplicate transactions (common when a charge appears as both a bank debit and a credit card charge).

Week 3: Review and categorize. Look for any recurring charges that are missing (if your rent did not post yet, follow up). Reconcile credit card statements against QuickBooks.

Week 4 (Month End): Categorize remaining transactions. Run the Profit and Loss report for the month. Reconcile your bank account (compare QuickBooks balance to your bank statement balance). Review uncategorized transactions and resolve them. File or back up receipts.

Quarterly: Review your Chart of Accounts for any needed updates. Check for miscategorized transactions by reviewing the Transaction Detail by Account report. Make estimated tax payments based on your year-to-date income (the IRS expects quarterly payments if you will owe $1,000 or more).

Common QuickBooks Expense Tracking Mistakes

After cleaning up books for hundreds of Dallas business owners, these are the mistakes we see most often.

Mixing personal and business expenses in the same account. This is the number one bookkeeping problem for small businesses. Get a separate business bank account and credit card. Period.

Categorizing everything as “Miscellaneous” or “Other Expenses.” If 40% of your expenses are in a catch-all category, your P&L is useless and your CPA has to spend hours sorting through it at tax time, which costs you more in preparation fees.

Not recording cash transactions. That $50 you paid the window cleaner in cash is still a deductible business expense, but only if you record it. Enter cash transactions manually the same day.

Duplicating transactions by entering them manually AND importing them through the bank feed. This inflates your expenses and throws off your P&L. Always check the bank feed first before entering anything manually.

Ignoring the bank feed for months and then trying to categorize 500 transactions at once. You will not remember what half of them were for, and you will categorize incorrectly. Weekly review takes 10 minutes. Annual cleanup takes 10 hours.

Not reconciling monthly. Reconciliation catches errors, duplicate transactions, and unauthorized charges. If your QuickBooks balance does not match your bank statement, something is wrong and it needs to be found before it snowballs.

When to Hire a Bookkeeper Instead of Doing It Yourself

QuickBooks is a powerful tool, but it is still a tool. It does not make accounting decisions for you. It does not know whether a charge should be categorized as a repair (deductible this year) or an improvement (must be depreciated over several years). It does not catch the nuances that save real money on your taxes.

Consider hiring a professional bookkeeper if any of these apply to you: you have more than 100 transactions per month, you have employees and need payroll processing, you have inventory to track, your books are more than 3 months behind, you are spending more than 5 hours per month on bookkeeping when you could be serving clients, or you have been categorizing expenses incorrectly and need cleanup before tax time.

At AG Freideman, our monthly bookkeeping packages run $300 to $600 per month depending on transaction volume. This includes bank reconciliation, expense categorization, payroll processing, monthly financial statements, and direct access to your CPA. Every transaction is reviewed and categorized by a professional, not auto-categorized by software and forgotten about.

The cost of professional bookkeeping is itself a tax-deductible business expense. And the deductions a professional finds that you would have missed almost always exceed the monthly fee. Think of it as an investment that pays for itself.

Frequently Asked Questions

What is the best way to track business expenses for tax purposes?

Connect your business bank accounts and credit cards to QuickBooks Online, categorize transactions weekly using the bank feed, capture receipts with the mobile app, and reconcile monthly. This gives your CPA clean, organized records at tax time and ensures you claim every legitimate deduction. The key is consistency: 10 minutes per week beats 10 hours in March.

How do I categorize expenses in QuickBooks Online?

Go to Transactions, then Bank Transactions. Each imported transaction appears in the For Review tab with a suggested category. Review the suggestion, adjust if needed, and click Add. For recurring charges, create Bank Rules (under the Rules tab) to auto-categorize them. For transactions that span multiple categories, use the Split feature to allocate amounts to different expense accounts.

How many expense categories should I have in QuickBooks?

Aim for 15 to 25 expense categories for most small businesses. Too few and your reports lack useful detail. Too many and you spend more time deciding where to put things than running your business. Start with the IRS Schedule C categories (advertising, auto, insurance, office expenses, etc.) and add subcategories only where the tax treatment differs.

Can I track mileage in QuickBooks Online?

Yes. The QuickBooks mobile app has a built-in mileage tracker that uses GPS to record business trips automatically. You swipe left or right to classify each trip as business or personal. At tax time, QuickBooks calculates your total business miles and the deduction amount using the IRS standard mileage rate. For Dallas business owners who drive frequently for client meetings, this can be worth $5,000 to $15,000 per year in deductions.

How often should I reconcile my accounts in QuickBooks?

Monthly, without exception. Reconciliation compares your QuickBooks balance to your bank statement balance and identifies discrepancies: missing transactions, duplicates, unauthorized charges, or data entry errors. Go to Settings, then Reconcile, select the account, enter the ending balance and date from your bank statement, and work through the comparison. If the difference is not zero, something needs to be found and fixed.

Let AG Freideman Handle Your Bookkeeping

If you have read this entire guide and thought “I should really be doing this but I know I won’t,” you are not alone. Most small business owners are great at running their business but struggle to keep up with the bookkeeping that makes tax time smooth and deductions maximized. That is exactly what we do.

Al Freideman is a licensed CPA with over 30 years of experience helping Dallas-Fort Worth business owners keep their books clean and their tax bills low. We are QuickBooks certified, we handle everything from monthly categorization and reconciliation to payroll and financial reporting, and we review every transaction personally. No junior staff, no assembly line, no surprises.

With 52+ five-star Google reviews and transparent pricing ($300 to $600 per month for bookkeeping, tax preparation starting at $450), we make it easy to hand off the work you should not be doing yourself and focus on the work only you can do.

Book your free consultation or call (972) 893-3481 today. We will review your current QuickBooks setup, identify what needs to be fixed, and give you a clear quote for ongoing bookkeeping support. No obligation, no pressure, just honest advice from a CPA who has been doing this for three decades.

AG Freideman Tax and Accounting
17304 Preston Road Suite 861, Dallas, TX 75252