Expenses are where bookkeeping either stays tidy all year or slowly turns into a messy cleanup job. In QuickBooks Online, two routines make the biggest difference: entering expenses the right way (so reporting and reconciliation stay accurate), and exporting expenses when you need to share, review, or audit what happened.
This article covers a simple, repeatable workflow you can use whether you’re a business owner doing your own books or an accountant supporting multiple clients.
Part 1: Creating expenses correctly in QuickBooks Online
At a basic level, an “expense” in QuickBooks Online is how you record money going out that isn’t a bill you plan to pay later (or sometimes even if you pay immediately). Done right, expenses become easy to search, track, and report on. Done poorly, you end up with uncategorized transactions, duplicate entries, and numbers that don’t line up during reconciliation.
When you should use “Expense” vs other transaction types
Use an expense when:
- you paid immediately by bank transfer, debit card, credit card, cash, or online payment
- you want the cost to hit your reports now
- it’s not a vendor bill that will be paid later
- Use a bill when:
- you received an invoice from a vendor and will pay later
- you want proper A/P tracking (what you owe)
Use a check when:
- you pay by check and want the check number trail
Use a credit card charge when:
- you want card activity tracked directly against a credit card account (especially useful for reconciliation)
A good rule: choose the transaction type that matches how money actually moved, so your bank and credit card reconciliations stay smooth.
The fields that matter most when creating an expense
When recording spending, these fields drive accuracy:
- Payee: Helps vendor reporting and search. Keep names consistent to avoid duplicates.
- Payment account: Bank or credit card account used. This affects reconciliation.
- Category or Item details: Where the cost lands (rent, software, advertising, COGS, etc.). This is what makes your Profit & Loss meaningful.
- Customer/Project (if you use it): For job costing, client profitability, and reimbursements.
- Billable (if applicable): If you’ll charge it back to a client.
- Tax settings (if applicable): Especially important in GST/VAT setups.
- Receipt attachment: Makes audits, reimbursements, and year-end reviews much easier.
If you’re aiming to keep your books consistent month after month, focus on one habit: record day-to-day spending properly inside QuickBooks – https://www.saasant.com/blog/how-to-create-expenses-in-quickbooks/ by always choosing the correct account and category first, then adding notes/attachments after.
Use case: Employee reimbursements without confusion
If employees spend personally and you reimburse them, you can keep it clean by:
- entering an expense to the correct category (travel, meals, supplies)
- setting the payee as the employee (or a dedicated “Employee Reimbursements” vendor approach)
- attaching the receipt
- using notes for the business purpose
This creates a clear trail and makes it easier to answer questions later like “which trips cost the most?” or “why did meals spike last quarter?”
Use case: Client-billable expenses for service businesses
For agencies, consultants, or contractors, the difference between profitable and painful often comes down to capturing billable costs.
A solid flow:
- enter the expense
- assign it to the customer/project
- mark as billable when relevant
- add a short memo that will make sense to the client
Later, you can pull those billable expenses into invoices without hunting through bank feeds.
Common mistakes when creating expenses (and how to avoid them)
Using the wrong payment account: This causes reconciliation mismatches. Always confirm whether it was paid from bank or credit card.
- Dumping everything into one category: “Miscellaneous” makes reports useless. Create a basic, sensible set of expense categories.
- Not reviewing duplicates: If you create an expense manually and also accept the same transaction from a bank feed, you can double-count spending.
- Skipping attachments on important spend: You don’t need receipts for every small item, but for larger purchases or compliance-heavy categories, attachments save time later.
Part 2: Exporting expenses from QuickBooks Online without missing what you need
Exporting expenses is useful for reporting, approvals, audits, budgeting, or sharing with someone who doesn’t have QuickBooks access. The key is knowing what you’re exporting and why, because QuickBooks data can be pulled in a few different ways depending on your goal.
When exporting expenses is most helpful
- Monthly close: Share a spreadsheet of spend by category with leadership.
- CPA review: Send a clean list of expenses with vendor, category, and notes.
- Budget tracking: Compare actual spend to budget in Excel or Google Sheets.
- Audit support: Provide expense details and keep backup docs organized.
Department reporting: Filter spending by class/location/customer if you track those.
If your goal is analysis or sharing, it helps to pull expense data out of QuickBooks Online for reporting – https://www.saasant.com/blog/how-to-export-expenses-from-quickbooks-online/ in a consistent format each month (same date range, same columns, same filters). That way comparisons are meaningful.
What to decide before you export
Date range Pick the exact period (month, quarter, year, custom project window). Consistency matters.
Level of detail Do you need line-level details (splits across categories), or a summary view?
Filters If you use tracking features, decide whether you need:
- specific vendors
- specific categories
- a customer/project
- class/location (if enabled)
Output format Most teams export to Excel/CSV for sorting, pivot tables, and sharing.
A clean monthly export routine (works for most teams)
Run the expense-related view or report that best matches your goal Examples: a vendor spend report, category spend view, or transaction list filtered to expenses.
Apply your date range and filters
Export to Excel/CSV
Save with a consistent naming convention (example: “Expenses_2026-01”)
Spot-check totals against your QuickBooks report totals so you’re sure nothing dropped off
Use case: Preparing expense data for a tax preparer or audit
If you’re sending data to a CPA, the most helpful export usually includes:
- transaction date
- vendor/payee
- category/account
- amount
- memo/description
- whether it’s billable (if relevant)
If you have attachments inside QuickBooks, keep in mind: exporting a spreadsheet won’t include the actual receipt images. For audits, you may also need a separate process for providing supporting documents (often only for selected samples, not everything).
Mistakes to avoid when exporting
Exporting the wrong transaction types: Make sure you’re pulling expenses (and not bills, checks, or journal entries) unless you intentionally want them.
Ignoring split transactions: Some expenses are split across multiple categories. Decide whether you need the split detail.
Comparing mismatched periods: A “last 30 days” export will shift every time you run it. Use fixed dates for month-to-month comparisons.
Not reconciling first: If your books aren’t reconciled, your export may include duplicates or uncategorized items you’ll later change.
The simple combined system that keeps things stable
If you want fewer surprises at month-end:
- During the month: enter expenses consistently (right account, right category, basic notes).
- Weekly: review bank feed matches and duplicates.
- Month-end: reconcile bank and credit card accounts.
- Then export: same date range, same view/report, same file naming.
That’s it. When this becomes routine, reporting becomes quicker, tax time becomes calmer, and you spend less time fixing mistakes after the fact.
