featured article

What Your CPA Needs From Your Ecommerce Books in January

Konstantine Christofakis

November 13, 2026

Your CPA needs a closed set of books and the evidence behind each number, not a folder of platform exports. Concretely: a profit and loss statement and balance sheet through December 31 that tie to bank, card, and loan statements; a year-end inventory value backed by a count and a roll-forward; a bridge from each platform's Form 1099-K to booked sales; a roll-forward of every sales tax liability account; clearing accounts that explain themselves; and a short memo listing what you are unsure about. Everything below is the detail of that list, and the reason a CPA asks for each piece.

Why exports are the wrong handoff

A CPA billing by the hour who receives raw settlement files will rebuild your books before preparing anything. That is the expensive way to file. Worse, a CPA working from a P&L with one line called "Amazon" cannot see that revenue includes marketplace facilitator tax, that fees are netted inside sales, or that inventory never got relieved for liquidated units. They will either ask, and wait, or make an estimate you will not like. The package below removes the guesswork.

The handoff package

1. Statements that tie

  • Year-end P&L, by month and by channel if you track channels as classes or locations.
  • Balance sheet at December 31.
  • Bank, credit card, and loan statements for December, with the reconciliation report for each account showing zero unexplained difference.
  • Any marketplace financing or merchant cash advance agreement, with the payoff balance at year-end.

A reconciliation report that shows a stubborn $1,812.40 "uncleared" from April is not a detail. It means some transaction posted twice or never posted, and the CPA cannot tell which.

2. Revenue by platform, with the 1099-K bridges

Payment apps and marketplaces must furnish Form 1099-K by January 31, per the IRS page "Understanding your Form 1099-K." So the revenue section cannot close until February's first days. Prepare the books side in December so that when each form arrives you only drop in Box 1a and confirm the reconciling items. The method is in matching the 1099-K to your books.

For each channel, give the CPA gross sales, shipping income, discounts, refunds, each fee category, and net deposits, plus the bridge from the form to those figures.

3. Inventory and cost of goods sold

This is where most ecommerce returns go sideways, and where CPAs spend the most questions.

  • Year-end inventory value by location: each warehouse, 3PL, and FBA.
  • The count support behind it, including the date of each count and who did it.
  • The costing method in use (FIFO, for example) and confirmation that it did not change during the year.
  • A roll-forward from opening inventory to closing inventory, explained in the worked example below.
  • A list of write-downs, write-offs, donations, and liquidations, with dates and units.

4. Balance sheet accounts that often go unexamined

  • Marketplace clearing accounts. At December 31, each should equal what that marketplace owed you: any settlement that closed but had not paid out, plus December activity in the settlement still open, including amounts held in reserve. Nothing else.
  • Reserve or held funds. Amounts a marketplace holds back belong on the balance sheet as a receivable, not missing from revenue.
  • Owner contributions and draws. Separate from operating expenses.
  • Loans. Principal and interest split, with the lender's year-end statement.
  • Fixed assets. Equipment purchased in the year, with invoices.

5. Contractors and vendors

A list of non-employee payees with totals, addresses, and W-9 status. IRS Publication 1099 for 2026 says the minimum threshold for reporting certain payments rose from $600 to $2,000 for tax years beginning after 2025. Which of your payees that affects is your CPA's call; your job is the list. Keep the W-9s in one folder; the CPA will ask for them.

6. Sales tax

A roll-forward of each sales tax payable account: tax collected, less refunds, less amounts remitted, equals the ending balance. Also a statement that marketplace facilitator tax nets to zero and sits outside revenue. The year-end check is laid out in reconciling what the marketplace collected.

7. The memo

One page. List anything you were not sure how to book: a lawsuit settlement, a large prepaid ad credit, a vendor dispute, a product recall, a state notice. A CPA who reads about an issue in January can plan for it. One who finds it in March charges for the surprise.

The worked inventory roll-forward

Illustrative numbers. Take a seller with three locations: a 3PL, FBA, and a small office stockroom.

  • Opening inventory, January 1, 2026: $412,000.00
  • Purchases in 2026 at landed cost, freight and duty allocated: $1,180,000.00
  • FIFO COGS booked from sales: $1,095,400.00

Expected closing inventory: $412,000.00 plus $1,180,000.00 equals $1,592,000.00. Minus $1,095,400.00 equals $496,600.00.

The December counts, valued at FIFO layers, total $471,300.00. The books say $496,600.00. The gap is $25,300.00, and the CPA will want it explained before anything else.

Working through the year's records:

  • Lost and damaged FBA units Amazon reimbursed. The reimbursements were booked as other income, $14,800.00 at landed cost of the units, but the units were never relieved from inventory.
  • Liquidated units. A September liquidation lot was recorded as a sale at recovery value, but its $6,900.00 of landed cost stayed in inventory.
  • Unexplained shrink. $3,600.00 remains after the two items above.

Check: $14,800.00 plus $6,900.00 plus $3,600.00 equals $25,300.00. The gap is fully assigned.

Each line needs its own correcting entry, dated in the year it happened, and the shrink figure goes in the memo. How the reimbursements and the shrink are treated for tax is the CPA's decision. Your job is to give them the three numbers and the support, not a single "inventory adjustment" for $25,300.00 in December.

Clearing accounts at December 31

Illustrative numbers. An Amazon settlement period closed December 29 and disbursed January 2 for $38,450.00. December 30 and 31 activity in the next, still-open settlement nets to $6,200.00. On December 31, the Amazon clearing account should hold exactly $44,650.00. If it holds $58,370.00, the extra $13,720.00 is an older settlement that never got matched to its deposit, or a deposit posted to the wrong account. Find which before handoff. A CPA who sees an unexplained clearing balance has to choose between reclassifying it to income or leaving it on the balance sheet, and neither is right without the detail.

Getting there without rebuilding the year

Most of this package falls out of the ledger if settlements were posted at the transaction level all year. ConnectBooks reconciles the sales, fees, refunds, and reimbursements in marketplace settlements and syncs them to QuickBooks or Xero as summarized entries or item-level detail, runs FIFO COGS per SKU with landed cost allocated, and reports inventory value and aging by warehouse. The year-end P&L becomes a report you run, not a project you rebuild.

If you do not yet have a CPA who works with marketplace sellers, the ecommerce accountant directory lists firms that do. And if the books still need the full December treatment, start with the year-end accounting checklist and come back to this list when the counts are done.

What to deduct, how to treat the shrink, and what to file are questions for your CPA. Giving them a package they can trust is the part that belongs to you.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo