On Sunday evening, freelance photographer Lina opens a supermarket receipt and discovers her business purchases do not add up to what she paid. Two items were for Tuesday’s shoot; the rest was household shopping. A basket-wide discount reduced the total by 4.00, but she had entered the business items at full price.
You already know a dedicated account would help. Until you open one, the way to separate business and personal expenses is to make every allocation traceable—not to guess from merchant names at month-end.
1. Give every card transaction a spending tag
Use four values in a dedicated Use column: Business, Personal, Split, and Unresolved. Keep these separate from expense categories. “Software” describes what you bought; it does not establish whose use it served.
Alongside date, merchant, and total, keep columns for:
- Business amount and personal amount
- Business purpose and allocation basis
- Receipt link and statement reference
- Review status
Tag purchases the same day where possible, then clear unresolved items weekly. Personal rows still need an amount and tag, but not an elaborate business explanation. If you cannot explain a purchase, leave its allocation unresolved rather than letting an automatic category turn it into a business expense.
Scan2Sheet can extract receipt data into your own Google Sheet, categorize expenses, and link cloud-stored receipt images from each row. Add your own use and allocation columns: automation cannot know that a notebook was bought for your child.
These tags are record-keeping classifications, not tax conclusions. If you trade through a separate legal entity, ask your accountant how personally paid business costs and business-paid personal costs should enter its books.
Decision: classify use before category, because a plausible category can hide a personal purchase.
2. Split supermarket baskets from the itemised receipt
A supermarket name tells you almost nothing. The basket might contain household food, shoot props, stationery, or supplies for a client event. Start with individual items and their purpose, not a percentage of the whole shop.
Here is Lina’s receipt from Greenway Market, dated 8 October. All figures are in her card’s currency. The receipt shows a 4.00 discount applying proportionately across the entire 100.00 basket.
| Item | Before discount | After discount | Use |
|---|---|---|---|
| Client-project notebooks | 18.00 | 17.28 | Business |
| Backdrop paper for shoot | 12.00 | 11.52 | Business |
| Household groceries | 52.00 | 49.92 | Personal |
| Household detergent | 18.00 | 17.28 | Personal |
| Total | 100.00 | 96.00 | Split |
The business share is (18.00 + 12.00) × 0.96 = 28.80. The personal share is 96.00 − 28.80 = 67.20.
Her transaction row therefore reads:
8 Oct | Greenway Market | 96.00 | Split | Business 28.80 | Personal 67.20
The allocation note identifies the two business items, the shoot, and the discount calculation. If a coupon applies only to detergent, assign it there instead; do not spread every discount automatically.
A missing middle section of a long receipt makes this split unreliable. Recapture overlapping sections or request a digital copy. Do not reconstruct prices from memory. Separating the baskets at checkout next time creates two clean transactions without requiring another account.
Decision: allocate the amount actually paid for each item, because shelf-price totals can overstate the business portion.
3. Give shared subscriptions a written allocation basis
Subscriptions look easy because the same merchant and amount recur. That is also why a bad allocation can repeat unnoticed for a year.
For cloud storage, a design tool, or a phone plan, first ask whether business and personal use can be distinguished. Separate user seats or separately priced services provide stronger evidence than “probably half.” Usage reports may help where they reasonably reflect the service being purchased.
Record the basis, supporting evidence, and review date. For example: Two equally priced seats; one business, one household; business allocation 50%; review at renewal. That basis fails if the next invoice replaces equal seats with a bundled family plan.
When there is no defensible split, mark it unresolved and seek guidance rather than choosing a convenient percentage. Your local tax authority’s guidance on mixed-use expenses—and your accountant’s interpretation for your circumstances—determines what treatment is acceptable. Keep the practical allocation distinct from any deductible amount.
Decision: carry forward an allocation only while its evidence remains valid, because recurring billing does not prove recurring business use.
4. Treat fuel receipts as purchase evidence, not trip evidence
A fuel receipt dated the day before a job started is not necessarily wrong. The tank may have supplied that job, several personal journeys, and next week’s client visit. The purchase date cannot establish the business share.
Keep a journey record with date, destination, business purpose, and distance, plus the vehicle-use records required locally. Link the fuel receipt to the vehicle records rather than labeling the entire fill-up with the nearest client’s name.
Some jurisdictions permit distance-based methods; others allow or require different actual-cost approaches. Check your tax authority’s vehicle-expense guidance before building the calculation. Do not add fuel on top of a distance-based amount where that method already covers fuel.
If the journey log is missing, reconstruct only what calendars, job records, and other reliable evidence support. Leave unsupported use unresolved.
Decision: establish the vehicle-expense method before allocating fuel, because the receipt alone cannot measure business travel.
5. Match the sheet to the complete card statement
Once a month, account for every statement transaction, including personal purchases. Otherwise, you cannot distinguish an intentionally excluded purchase from a missing business receipt.
For each resolved purchase, check:
Business amount + Personal amount = Card transaction total
Match by amount and merchant, allowing for purchase and posting dates to differ. Preserve both dates when necessary. A scanned receipt and its statement entry represent one purchase, not two expenses.
Handle refunds as linked reversals of the original allocation. If Lina returns the backdrop paper and receives 11.52, reverse that business amount—not half the refund simply because the original basket was mixed.
Treat card-balance payments as transfers, not fresh spending. Keep unresolved allocations visible, and build business summaries from the business amount column rather than raw receipt totals.
Decision: reconcile the entire card but report only verified business allocations, because selective matching conceals omissions and duplicates.
6. Price the sorting before postponing another account
Track mixed-card administration for one month: splitting baskets, checking subscriptions, chasing evidence, and correcting entries. Value that time at a realistic rate, not your highest advertised hourly fee.
Suppose sorting takes 90 minutes monthly and you value that time at 30.00 per hour. That costs 45.00. An eligible second account costing 8.00 monthly, plus 15 minutes of administration worth 7.50, costs 15.50—a potential monthly saving of 29.50.
If setup takes two hours, its 60.00 time cost is recovered in just over two months. Include actual account fees, transaction charges, and migration work in your comparison.
The saving depends on moving business payments and actually using the new account. Shared subscriptions and mixed vehicle use will still need allocation. If account eligibility blocks you, compare permitted alternatives and check the provider’s terms rather than assuming any second personal account allows business use.
Decision: open the second account when avoidable sorting costs more than operating it, because postponement has a measurable price.
Start with your next receipt: capture it in Scan2Sheet, then add the use tag and allocation evidence in your Sheet before the details disappear.