The Webgility Blog | Ecommerce Content To Help Grow Your Business

Accountant’s BFCM Checklist: Get Every Ecommerce Client Ready for Black Friday 2026

Written by John May | Oct 16, 2026, 9:45:11 AM

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.

Why BFCM 2026 is a bigger accounting challenge for accountants

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:

  • Unreconciled payouts: Gross marketplace sales rarely match the deposits appearing in QuickBooks
  • Missing fees and adjustments: Payment processing charges, Amazon FBA fees, and reserves can distort financial reporting
  • Inventory and COGS discrepancies: Inaccurate inventory records and product costs can distort COGS, leading to incorrect profit margins and unreliable financial reports
  • Refunds and order changes: Delayed refunds, exchanges, and chargebacks can create discrepancies between recorded sales, marketplace payouts, and QuickBooks
  • Delayed month-end closing: Accountants spend additional time tracking down mismatches instead of delivering accurate financial reports

The solution isn't simply syncing more transactions. It's establishing accounting workflows that keep every order, fee, refund, and payout accounted for.

BFCM 2026 accounting readiness checklist: 9 steps to prepare your clients' books

The best time to fix BFCM accounting problems is before orders start pouring in. Here's what accountants should review before November 27:

1. Get every client to a clean baseline

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:

  • Close October, including bank and credit card reconciliations
  • Clear the backlog of unposted orders, failed syncs, unmapped items, and orders stuck in pending
  • Reconcile every payout clearing account (Shopify Payments, PayPal, Stripe, Amazon) to zero or to known in-transit payouts
  • Tie out marketplace settlements through the last completed settlement period
  • Clean out stale undeposited funds and suspense entries

The goal: Enter the holiday season with clean accounting records rather than carrying unresolved errors into the busiest month of the year.

2. Verify Shopify, Amazon, and other sales channels are mapped correctly to QuickBooks

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.

3. Test order-to-payout reconciliation before transaction volumes spike

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.

4. Decide how gift cards and promotions hit the books

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:

  • Gift card sales post to a liability and become revenue only when redeemed
  • Bonus cards from "buy a $100 card, get $20" offers weren't paid for, so their treatment is settled before the first one is issued
  • The breakage policy for unredeemed balances is checked against unclaimed property rules in the states that apply
  • Discounts post as contra-revenue rather than netted into sales, so you can report gross sales, discount cost, and margin by promo code
  • BOGO offers, free gifts with purchase, and free-shipping thresholds each have an agreed treatment. Free gifts add COGS with no revenue of their own, and free shipping adds cost with no shipping income

Must Read: Cashback vs Discounts: Choose the right holiday strategy

5. Plan for returns, refunds, and year-end cutoff

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.

  • Confirm refunds post automatically and reverse the right accounts, restocking resalable returns and writing off damaged ones.
  • Pull last year's return rates by channel, and by product where you can, to estimate BFCM returns that will arrive after year-end.
  • For accrual clients, agree now on a year-end refund liability based on those rates.
  • Set a cutoff policy for orders paid in November or December but shipped in January. On the accrual basis, they sit as deferred revenue until they ship.
  • Decide how chargebacks and dispute fees will be recorded, since disputes on BFCM orders can surface weeks later.
  • Note each processor's and marketplace's reserve policy, so held payouts don't read as missing revenue.

Webgility solution: Returns and refunds post automatically with the correct accounting treatment, so January's returns don't become a manual cleanup project.

6. Reconcile inventory and lock down COGS

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.

  • Reconcile book inventory to a recent cycle count and to FBA and 3PL reports, and write off shrink before the season
  • Update item costs for recent purchase orders, freight, duties, and tariff changes, so COGS posts at current landed cost
  • Confirm bundles and kits relieve component inventory, and that every new BFCM SKU has a cost
  • Make sure inventory syncs across every channel and location, so stock levels hold up during the spike
  • Schedule the year-end physical count now, and agree on how in-transit inventory is handled at December 31

7. Check sales tax nexus exposure before the spike, not after

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.

  • Run each client's sales by state for the period each state measures, and compare them to that state's economic nexus threshold
  • Flag states where a strong BFCM could tip the client over, and consider registering ahead of time
  • Separate marketplace-facilitated sales, where the marketplace collects and remits, from direct sales. States differ on whether marketplace sales count toward a seller's threshold
  • Confirm that tax on direct sales posts to payable accounts by jurisdiction, and that marketplace-collected tax isn't booked as a liability the client owes
  • Check how BFCM-specific items are taxed, including shipping charges and bundles that mix taxable and exempt products
  • Put December and January filing deadlines on the calendar for every state the client files in

Must Read: Holiday Compliance Checklist: How to Stay Ahead of Nexus Rules by State

8. Check for duplicate orders and double-posted transactions

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.

9. Test accounting automation and identify exceptions before BFCM

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.

How Webgility helps you get every client BFCM-ready

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.

  • Clean baseline (step 1): See pending and failed orders, sync health, and open actions in one dashboard, so backlog cleanup starts from a list instead of a hunt

 

  • Channel mapping (step 2): Manage account mappings in one place. Match channel products to the right QuickBooks items, down to the variant level, so one product doesn't split into two inventory records
  • Order-to-payout reconciliation (step 3): Fees, refunds, and Amazon reserves post as separate lines, and Shopify and Amazon deposits post as transfers that match the bank. Shopify payouts keep their actual payout date, so payouts crossing into December land in the right month

  • Promotions (step 4): Each Shopify discount code posts as its own line item, so you can report discount cost and margin by promo
  • Returns and order changes (step 5): Posted orders update when source orders change, including Shopify order edits, so post-BFCM changes don't need manual re-entry

 

  • Inventory and COGS (step 6): Reconcile Amazon FBA inventory with QuickBooks, sync product quantities and costs, and accurately record inventory adjustments to keep COGS and profit margins reliable

 

  • Sales tax (step 7): Each transaction gets its state's tax rate, and marketplace-collected tax stays separate from tax the client owes
  • Duplicate prevention (step 8): A minimum order date stops orders already in the books from downloading again. BigCommerce source filters and Amazon FBM controls decide which orders come in at all
  • Exception handling (step 9): Order flags catch at-risk orders before posting, with direct fixes for customer, store connection, and QuickBooks connection issues. Ambiguous mapping alerts flag unclear item matches, and summary emails surface sync errors

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.

FAQs

1. When should accountants start preparing for BFCM 2026?

Start in October. Reconcile outstanding transactions, verify account mappings, and test automation before holiday sales increase.

2. Can BFCM sales trigger sales tax nexus in new states?

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.

3. What accounting reports should clients review after BFCM?

Review P&L statements, SKU-level profitability, cash flow, inventory valuation, and outstanding settlements to understand actual holiday profits.