Splitting a Transaction Across Categories
Overview
Splitting a transaction lets you divide a single expense or income entry across multiple categories, so each part is assigned accurately based on what it was really for.
This is especially useful when:
A single purchase includes both business and personal items
You're categorizing a bulk charge like a grocery or supply run
You need to break down a large transaction for budgeting or tax reporting
🚨 Why It Matters for Business Owners
Properly splitting transactions isn’t just about tidiness — it’s essential for:
Tax compliance: Avoid overstating deductions or missing eligible write-offs
Accurate financial reports: Know what your business actually spends
Budget visibility: Prevent distorted monthly or project-level budgets
Client and project tracking: See where your money is really going
🔍 Common Scenarios
Scenario | Why It Matters |
---|---|
Buying multiple types of items | You spend $2000 at a big-box store—$1500 is for new computer and $500 is for event supplies. You want to track these separately. |
Shared business & personal expense | You attend a business conference in Chicago and decide to stay the weekend for personal sightseeing. You use your personal credit card to pay a $1,000 hotel bill covering 5 nights — 3 for the conference ($600 business) and 2 for leisure ($400 personal). Splitting the transaction helps you deduct only the business portion and accurately record the personal part. |
Single transaction across multiple projects or clients | You buy software for $150 and want to allocate $75 each to two different clients for billing or cost tracking. |
Annual payments with partial business use | You pay $120 for a streaming service and use it 75% for business and 25% for personal relaxation. Split the transaction to reflect that. |
🛠 How to Split a Transaction Across Multiple Categories
Split transactions in QBP when you need to assign different portions of a single charge to separate categories, tags, or budgets. This is useful for organizing complex purchases (e.g., groceries and office supplies on one receipt) or separating personal and business expenses.
✨ Step-by-Step Instructions
Open Your Transactions List
Hover over the left-hand navigation panel and select Transactions.Find the Transaction to Split
Locate the transaction you want to edit. Hover over it and click the three-dot menu (⋯) at the end of the row.Edit the Transaction
Select Edit transaction from the dropdown.Open the Split Window
Click Split. This opens the Split Transaction window.Add Split Lines
Click + Add Split to create as many lines as needed. Each line represents a different portion of the overall transaction.(Optional) Divide Evenly
If you want to divide the transaction amount evenly, click the three-dot menu in the top-right of the Split window, then select Divide among Splits.Enter Categories and Amounts
For each line:Select a Category (e.g., Office Supplies, Groceries)
Optionally add a Tag
Enter the Amount for that portion
➕ QBP will automatically track how much of the transaction is Left to Split, shown in the top-right corner.
Save and Apply Changes
Click Save Splits when you’re done dividing the transaction.
Then click Update to save the full transaction edit.
✅ Tip: For best results, use clear memo notes and tags if the splits relate to reimbursements, business use, or budget planning. This will make reporting and audits easier.
Example: Office Supply & Snacks
Transaction total: $85
$60 → Office Supplies (Category: Office Expenses)
$25 → Snacks for Team Meeting (Category: Meals & Entertainment)
Result: Your reports will now reflect the true nature of each part of the expense, making it easier to budget and prepare taxes later.
✅ Best Practices for Transaction Splits
Do This | Why |
---|---|
✔ Break out large or mixed expenses | Avoid misclassifying parts of a bulk transaction |
✔ Use descriptive memos | Clarifies what each line is for (e.g., "Team Lunch", "Client X Software") |
✔ Match categories to tax lines | Easier tax filing at year-end |
✔ Split income when needed | If a single deposit includes payments from multiple sources or projects |
✔ Use tags for additional context | If your software supports tags, use them to filter/report across multiple clients or events |
🚫 Limitations
You cannot split one transaction between income and expense categories. If a transaction includes both, enter them as two separate transactions.
Most systems don't allow splitting across different accounts — splits must stay within the original account the transaction was recorded in.
📈 Why It Matters
Without Splits | With Splits |
---|---|
❌ Inaccurate categorization | ✅ True-to-life financial picture |
❌ Misleading reports | ✅ Better budgeting and tax deductions |
❌ Missed client billing opportunities | ✅ Transparent expense tracking |
❌ Auditing headaches | ✅ Clear documentation |