E-commerce Sellers

Sales Tax Expense Tracking: Keep Tax Out of the Wrong Numbers

Follow one inventory receipt through a resale-tax correction, a marketplace payout reconciliation, and the records needed for next year’s tax preparation.

One inventory receipt, one month of payouts, and a trail that survives year-end.

By the Scan2Sheet Team

On September 8, 2025, Maya photographed a $1,296 receipt from Mesa Wholesale for mugs she would resell online. Her sheet classified the entire payment as office supplies. The troublesome detail was the separate $96 sales tax line: the supplier had not applied her resale certificate, and the mugs were inventory, not supplies.

Correcting the category alone would leave the tax question unresolved. Deleting the tax would leave the payment unmatched. Good sales tax expense tracking preserves what happened while separating cash movement from accounting treatment.

Here is how that receipt should travel from capture to next year’s review. This is a record-keeping workflow, not tax advice.

1. Capture the tax line before assigning an expense

Start with the supplier’s itemized receipt, not just the $1,296 card transaction. Keep the subtotal, sales tax, and total in separate columns, alongside a record ID and image link.

Record IDDateMerchantPretax amountSales tax paidTotal paidReview status
INV-09082025-09-08Mesa Wholesale$1,200.00$96.00$1,296.00Resale tax review

Scan2Sheet extracts receipt data into your own Google Sheet and stores a receipt image linked from the row. Its automatic categorization is a starting point, not a decision about inventory or tax treatment. For a long wholesale receipt, use multi-page capture so the item list and tax footer stay together.

Check that subtotal plus tax equals the total, allowing for separately listed freight or discounts. If extraction misses the tax footer, inspect the image and correct the fields; do not infer a tax rate from the total. If the original lacks detail, request an itemized invoice and leave the record flagged rather than inventing a split.

2. Resolve the resale certificate without rewriting the payment

Maya finds that her certificate was missing from the supplier’s account. She sends the documentation and asks whether the supplier can refund the tax on this purchase.

Resale certificates generally support qualifying purchases for resale without sales tax, but accepted forms, registration requirements, and refund procedures vary by state. Check the relevant state department of revenue or taxation—not merely the supplier’s checkout instructions. A sales tax permit and a resale certificate are not automatically interchangeable documents.

Keep the $1,296 payment intact while the request is pending. Add the certificate reference, supplier correspondence, and expected correction to INV-0908.

On September 18, Mesa issues a $96 credit back to Maya’s card. Add a linked correction:

Record IDLinked recordEventCash movement
CR-0918INV-0908Sales tax refunded by supplier+$96.00

The original payment and refund now support a net inventory purchase cost of $1,200. The refund is not sales revenue.

If the supplier refuses, retain its response and check the state’s purchaser refund procedure. Until resolved, do not silently remove the $96 or assume it is recoverable.

3. Put purchase tax with the thing purchased

The separate tax column is useful evidence, but it is not an instruction to exclude every purchase tax from costs.

Nonrefundable sales tax generally follows the underlying purchase:

  • Resale inventory: it generally becomes part of inventory cost, with expense recognition following the applicable inventory or small-business accounting method.
  • Operating supplies: tax generally forms part of the supply cost when the purchase qualifies as a business expense.
  • Equipment: tax generally enters the asset’s cost basis rather than becoming a standalone sales tax expense.

For example, a $50 label-paper purchase with $4 tax generally carries a $54 supplies cost. Expensing $54 and then adding $4 under “sales tax expense” counts the tax twice.

If an invoice mixes resale mugs with shelving for the stockroom, split the lines and associated tax. Do not apply the resale treatment to the shelving simply because it came from the same wholesaler. For federal treatment, consult IRS Publications 334 and 551 and your preparer; small-business inventory methods can change timing.

Maya’s corrected receipt remains linked to inventory records, not buried in a general expense summary.

4. Reconcile September payouts without calling deposits revenue

At September close, Maya matches that inventory payment to her card statement and reconciles sales separately. Sales tax collected from customers on behalf of a taxing authority is a liability, not revenue. Paying it over settles that liability; it is not another business expense.

Her September product sales were $18,000 before $600 of merchandise refunds, leaving $17,400 in revenue. The following figures are after refunds, including tax reversals. Assume all September payouts arrived in September, with no reserves or other adjustments. The 8% tax amounts are illustrative, not a rate recommendation.

ChannelSales after refundsCustomer sales taxTax withheld by marketplaceSelling/payment feesBank deposits
Direct store$9,600$768$0$300$10,068
Marketplace$7,800$624$624$960$6,840
Total$17,400$1,392$624$1,260$16,908

The bridge from deposits to revenue is:

$16,908 deposits + $1,260 withheld fees − $768 seller-held sales tax = $17,400 revenue.

Those “gross deposits”—bank credits before outgoing business payments—are neither gross customer charges nor revenue. The marketplace’s $624 never reached Maya’s bank, so it is not subtracted from deposits again.

Recording the $18,792 in customer charges as revenue and the $1,392 tax as expense would inflate both sides. Recording only deposits as sales would instead understate revenue here. If the bridge fails, inspect payout dates, reserves, refunds, and chargebacks before using a balancing entry.

5. Separate marketplace tax from Maya’s filing obligation

Save the marketplace settlement report showing the $624 collected and remitted under marketplace facilitator rules. Keep it separate from Maya’s $768 direct-store liability.

Marketplace collection does not automatically eliminate seller registration or reporting obligations. Some states require marketplace sales to appear on returns with an exclusion or deduction; requirements depend on the state and the seller’s circumstances. Verify treatment with each applicable state tax authority and the platform’s transaction-level tax report.

If Maya remits the $768 in October, match the payment to the September liability and return confirmation. Do not categorize the bank withdrawal as an expense. Filing frequency and due dates vary, so use the deadline assigned to her account rather than assuming every state follows the same monthly schedule.

If a platform report does not establish who remitted tax, investigate before treating the amount as either Maya’s liability or an expense.

6. Make INV-0908 understandable a year later

When Maya’s preparer asks about inventory costs before the usual mid-April individual filing deadline, the receipt should open alongside its $96 credit, certificate reference, and final classification. A year later, the explanation should still work without Maya remembering the phone call.

Retain the original image, correction, card evidence, monthly payout reconciliation, and state filing confirmations. If an image link fails, restore the document from your retained copy; a spreadsheet total is not a substitute for purchase evidence. Set retention periods using IRS and state requirements, including longer needs for asset records.

Use Scan2Sheet to capture the receipt into your Google Sheet, then keep its tax decision and reconciliation attached to the same record.