Record revenue in Shopify. Record revenue on Amazon. And a QuickBooks file that agrees with neither.
Marketplace fees are scattered across settlements. Refunds haven't been recorded correctly. Inventory doesn't match, and bank deposits are nowhere close to reported sales.
Now imagine handling that across ten clients.
That's the challenge accountants and bookkeepers face during Black Friday and Cyber Monday (BFCM).
The fix? Close these accounting gaps before the holiday rush begins.
A little preparation now can save you from chasing missing transactions, mismatched payouts, and unexplained discrepancies when BFCM orders start pouring in.
This BFCM accounting checklist covers nine essential steps to help you prepare your clients' books, streamline reconciliation, and avoid spending December fixing November's mistakes.
For ecommerce sellers, BFCM means more orders, customers, and revenue. For accountants, it means more transactions to record, reconcile, and explain.
A single Shopify or Amazon sale can involve discounts, payment processing fees, sales tax, shipping charges, refunds, and settlement adjustments. Multiply that by thousands of orders across different marketplaces, and month-end reconciliation becomes significantly more complicated.
The biggest BFCM accounting challenges include:
The solution isn't simply syncing more transactions. It's establishing accounting workflows that keep every order, fee, refund, and payout accounted for.
The best time to fix BFCM accounting problems is before orders start pouring in. Here's what accountants should review before November 27:
Start BFCM from a fully reconciled October, because peak volume buries whatever is already broken. Unposted orders and unmatched deposits that slide into the rush won't surface again until January, under thousands of new transactions. Therefore, you should first:
The goal: Enter the holiday season with clean accounting records rather than carrying unresolved errors into the busiest month of the year.
Your clients might be selling through Shopify, Amazon, Walmart, and other marketplaces, but are those transactions reaching the correct accounts in QuickBooks?
Review how each sales channel records revenue, payment methods, fees, taxes, refunds, and inventory adjustments.
Pay attention to product SKUs, variants, payment gateways, and clearing accounts.
For example, if the same product sells through Shopify and Amazon but maps to different inventory items in QuickBooks, it can create inconsistent stock and cost records.
Test a few representative transactions from every connected marketplace before BFCM, including discounted orders, multi-item purchases, and orders with shipping charges.
One of the biggest BFCM accounting challenges is explaining why marketplace sales don't match bank deposits.
Consider this simplified settlement example:
|
Transaction |
Amount |
|
Gross sales |
$100,000 |
|
Marketplace and processing fees |
-$8,000 |
|
Refunds |
-$6,000 |
|
Funds withheld in reserves |
-$4,000 |
|
Net settlement deposit |
$82,000 |
Your client's sales dashboard shows $100,000, but only $82,000 arrives in the bank.
That doesn't automatically mean $18,000 is missing. Each deduction needs to be traced and classified correctly. Fees, refunds, and withheld reserves have different accounting treatments.
Before BFCM, test whether your reconciliation process can connect orders, settlement reports, clearing accounts, and bank deposits without duplicating revenue.
Remember: Synced isn't the same as reconciled. A transaction appearing in QuickBooks doesn't necessarily mean the corresponding payout has been matched.
Decide how to record gift cards and promotional discounts before BFCM. Gift card purchases shouldn't be counted as revenue until redemption, and discounts should be tracked separately.
With Cyber Week discounts expected to reach 30% off listed prices, accurate records will help your clients understand how promotions affected their profit when reviewing results in January.
Agree on these with each client and write them down:
Must Read: Cashback vs Discounts: Choose the right holiday strategy
Set the rules for returns and cutoff before the orders exist, because BFCM sales keep moving long after Cyber Monday. Extended holiday return windows push refunds into January, and chargebacks can trail by weeks. Preorders and backorders may not ship until after December 31.
Webgility solution: Returns and refunds post automatically with the correct accounting treatment, so January's returns don't become a manual cleanup project.
True up inventory quantities and costs before the spike, because November errors compound through year-end. Wrong quantities lead to oversells, cancellations, and refunds. Wrong costs mean every BFCM order posts the wrong COGS, and your December margin review is built on bad numbers.
A strong BFCM can push a client past a state's economic nexus threshold in a single weekend. Crossing one creates registration, collection, and filing obligations, and any tax that goes uncollected comes out of the client's own pocket.
Must Read: Holiday Compliance Checklist: How to Stay Ahead of Nexus Rules by State
During BFCM, thousands of orders flow between Shopify, Amazon, and QuickBooks. A failed sync, manual re-entry, or repeated import can result in the same transaction being recorded twice.
And when duplicate orders go unnoticed, they can inflate revenue, distort inventory and COGS, and create discrepancies during payout reconciliation.
Before BFCM, verify that each marketplace order maps to a unique transaction in QuickBooks. Check for duplicate order IDs, repeated sales receipts or invoices, and transactions created after sync retries.
The goal: Catch duplicate postings before they affect your clients' financial reports and turn month-end closing into a cleanup exercise.
Even automated accounting workflows can encounter exceptions during peak transaction volumes.
An order might contain an unmapped product, an inactive customer, or an edited total. A marketplace connection might expire, preventing transactions from downloading.
If these issues go unnoticed until month-end, accountants have to investigate weeks of activity to determine what went wrong.
Before BFCM, test your accounting automation using different transaction scenarios.
Check how the system handles missing products, modified orders, refunds, failed postings, and connection errors.
Establish who will review flagged transactions and how quickly issues should be investigated.
The objective is to identify exceptions close to when they occur, rather than discovering them during reconciliation.
The nine steps bury your team in data work: exporting settlements, matching deposits, and mapping new SKUs, one client at a time. Webgility automates that layer across your roster, so your hours go to the judgment calls instead.
Your clients are getting ready to sell more. Make sure their accounting can keep up.
Book a 15-minute Webgility demo to explore automated ecommerce accounting and reconciliation before BFCM.
Start in October. Reconcile outstanding transactions, verify account mappings, and test automation before holiday sales increase.
Yes. Economic nexus thresholds are based on sales or transaction counts, so one strong weekend can push a client past a state's limit. Check sales by state before BFCM, and register ahead where a client is close.
Review P&L statements, SKU-level profitability, cash flow, inventory valuation, and outstanding settlements to understand actual holiday profits.