Industries
Ecommerce (Amazon and Shopify)
Finbryn untangles Amazon and Shopify payouts into sales, fees, refunds and reserves inside QuickBooks Online or Xero using A2X or Link My Books. We track cost of goods sold by SKU, watch state sales tax nexus as revenue grows, and close the books by business day five so you know margin by channel, not just total cash in the bank.
Management report
Illustrative client · August 2026
USD
| Line | Aug | Jul | |
|---|---|---|---|
| Revenue | 142,380 | 131,904 | +10,476 |
| Cost of sales | (51,260) | (48,115) | (3,145) |
| Gross profit | 91,120 | 83,789 | +7,331 |
| Payroll | (46,300) | (45,900) | (400) |
| SoftwareNoted | (6,480) | (5,490) | (990) |
| Rent | (8,000) | (8,000) | 0 |
| Other operating | (9,215) | (9,870) | +655 |
| Net income | 21,125 | 14,529 | +6,596 |
Reviewer's note
Software is up on last month after two seats were added mid-month. Revenue includes one milestone invoice that will not repeat next month.
Illustrative. An example of the document, not a client's figures.
Exceptions report
Where the books usually hurt
Marketplace payouts land as one lump sum that hides sales, fees, refunds and reserves
Cost of goods sold gets estimated instead of tracked by SKU and inventory location
Sales tax nexus creeps across states as revenue grows and nobody notices until a notice arrives
Multiple sales channels mean multiple ledgers that never quite reconcile to the bank
Why ecommerce bookkeeping breaks down first
A marketplace payout is not revenue. It is gross sales minus fees, refunds, advertising spend and a reserve the platform is holding back, all wired to your bank as one number. Sellers who record that single deposit as income end up with a profit and loss that has nothing to do with what actually happened in the store that month.
Finbryn connects Amazon Seller Central and Shopify to QuickBooks Online or Xero through A2X or Link My Books, so each payout arrives already split into sales, marketplace fees, shipping, refunds and reserve movements. From there our team reconciles the connector's output against the bank deposit and against Seller Central and Shopify reports directly, because connector feeds can drift from platform data during high-volume months like November and December.
Sales tax nexus and cost of goods sold
Economic nexus rules mean a seller can owe sales tax in a state without ever setting foot there, once sales there cross that state's threshold. We track state-by-state exposure against your sales data and flag when a new state is close to triggering a filing obligation, then coordinate with your sales tax platform or a credentialed preparer for the actual filing.
Cost of goods sold gets the same treatment. Instead of one blended cost percentage, we track landed cost by SKU using your supplier invoices and any freight or duty documentation you provide, so a margin problem in one product line does not hide inside an average that looks fine.
What changes when you switch to Finbryn
You keep the QuickBooks Online or Xero file you already own; nothing moves to a system you cannot access if the relationship ends. A named pod handles your account, with a recorded handover memo any time that pod changes. Books are reconciled weekly rather than left until month end, and the close lands by business day five with a management report that separates channel-level revenue from fees and refunds.
When a marketplace issues 1099-K forms or when you pay contractors, we prepare the underlying data; a credentialed signer or your existing preparer handles the actual filing. Pricing is published on our pricing page rather than quoted after a sales call.
Catch-up work is common here: if your books have been running on raw bank feeds for a year, we cost that separately based on transaction volume and back-months, then move you onto monthly bookkeeping once the backlog is cleared.
Questions
Frequently asked questions: Ecommerce (Amazon and Shopify)
Do you connect to both Amazon and Shopify at the same time?
Yes. Multi-channel sellers get one consolidated set of books with revenue and fees broken out by channel, even when Amazon, Shopify and a wholesale channel are all feeding the same file.
Will you tell me when I owe sales tax in a new state?
We monitor your sales by state against published economic nexus thresholds and flag when you are approaching one. The actual registration and filing is handled by a sales tax platform or a credentialed preparer.
How do you handle marketplace reserves that get released later?
Reserves held by Amazon or another marketplace are tracked as a receivable until released, so your cash flow reporting reflects money that is coming but not yet in the bank.
Can you clean up a year of messy Seller Central transactions?
Yes. Catch-up and cleanup work rebuilds the chart of accounts and reconciles historical payouts month by month until the books match what actually happened.
How do you handle 1099-K forms from Amazon or Shopify Payments?
Amazon and Shopify Payments issue Form 1099-K based on gross payment volume, which is not the same as your net revenue after fees and refunds. We reconcile the 1099-K figure to your books each year so the gap is documented and handed to your credentialed preparer, not left for you to explain.
Do you work with A2X or Link My Books?
Yes, either one, depending on which the seller already has connected to their marketplace and accounting software.
Can you track cost of goods sold by product?
Yes, when landed cost and inventory data are available from the seller's supplier records or 3PL.
What are the common bookkeeping challenges for a ecommerce (Amazon and Shopify) business?
Beyond the basics, sales tax nexus creeps across states as revenue grows and nobody notices until a notice arrives and multiple sales channels mean multiple ledgers that never quite reconcile to the bank come up often in this industry. We build the chart of accounts and reconciliation process around those specific patterns rather than a generic template that ignores how the business actually operates.
What software do you support for ecommerce (Amazon and Shopify)?
We work inside Shopify and Amazon Seller Central, along with the other tools listed on this page that are common in the ecommerce (Amazon and Shopify) industry. If you have no file yet, we set one up in your name so you own it from day one.
Related services
- BookkeepingMonthly bookkeepingOngoing monthly bookkeeping: transactions sorted into categories, accounts reconciled and month-end reports delivered in the software you already use.
- BookkeepingCatch-up and cleanup bookkeepingMonths or years of books brought up to date and reconciled, with a written record of every adjustment, so monthly bookkeeping can start from a clean base.
Next step
Talk to the team that would run your books
A short call covers your setup, your software and what a first month would look like. You get a written scope and price after it.