Multi-Channel Sales Reconciliation Worksheet
A six-tab Excel worksheet that compares Etsy + Shopify + in-person sales totals to bank deposits, surfaces fee shortfalls and refund mis-postings, and rolls up to a per-channel monthly P&L — the 30-minute monthly close for makers selling across multiple platforms.
A six-tab Excel worksheet for makers selling on more than one channel. Tab one is a Read Me with the reconciliation method written out plainly. Tab two is Channel Settings — per-channel fee % and fixed fee for Etsy, Shopify, Square, Stripe, Faire, and cash, defaulting to US rates as of May 2026 but fully editable. Tab three is Sales by Channel — paste up to 200 orders across all your channels and the workbook calculates expected fees and expected net per row. Tab four is Bank Deposits — paste 60 deposits, tag each with a channel, and the workbook compares to the matching-period channel net and flags shortfalls. Tab five is the Monthly P&L — pick year and month, see per-channel orders, gross, fees, refunds, net, and effective fee % roll up automatically. Tab six is the Reconciliation Log — anything flagged REVIEW lands here for resolution before you close the month.
- A Channel Settings tab where every fee assumption (Etsy, Shopify, Square, Stripe, Faire, cash) is editable — defaults are US rates as of May 2026, change them once and every other tab updates
- A Sales by Channel grid that takes 200 rows across all your channels and calculates expected fees and expected net per row using your Channel Settings — no more re-doing fee math one channel at a time
- A Bank Deposits matcher that ties each deposit to a channel + period, computes the expected amount from the Sales tab, and flags shortfalls outside your tolerance threshold
- A Monthly P&L by channel — orders, gross, fees, refunds, net, and effective fee % rolled up from the Sales tab when you pick a year and month
- A Reconciliation Log that auto-populates with every REVIEW-flagged deposit so nothing falls through the cracks at month end
- Every tab designed to close the month in one session, not a weekend project — paste, scan, resolve, save
Educational tool only — not financial, tax, or legal advice. Channel fee structures change periodically; verify the current rates on your latest payout statement before relying on the defaults. Country-specific processing fees, currency conversion fees, regulatory operating fees, and chargebacks are not modeled in this US-default workbook. The Monthly P&L output is a reconciliation aid, not a financial statement; have a qualified accountant review your books before filing taxes or making business decisions on the numbers it produces.
Why multi-channel reconciliation is harder than single-channel
On one channel, the gap between gross sales and bank deposits is one fee schedule and one settlement cadence. On three channels, it is three of each — and they don't line up. Etsy deposits 3–5 days after the sale, Shopify 1–2, Square next-business-day, and cash never deposits at all. Each channel takes a different cut of every order, and refunds post in whichever month the customer asks for the money back, not the month they bought.
The worksheet is built around the three failure modes that explain almost every gap: channel fees you never logged, refunds posted to the wrong period, and mis-categorized in-person sales. Each gets its own tab and its own automatic check.
How the deposit-matching tab works
On the Bank Deposits tab, every row is a deposit from your bank statement, tagged with the channel that funded it. The Expected column sums every row in Sales by Channel for that same channel within the match window (default 7 days) and compares to the deposit amount. If the variance is within your shortfall threshold (default $5), the row is marked MATCH; otherwise REVIEW.
REVIEW rows automatically copy onto the Reconciliation Log so you have a single page that says "fix these before closing the month." The most common cause of a REVIEW status is a refund or chargeback that hit the deposit but wasn't logged on the Sales tab — once you add the negative-revenue row with a note in column K, the variance disappears and the status flips to MATCH.
When to use this and when to outgrow it
The worksheet is the right tool until you hit one of three points: 50+ orders a month per channel, four or more channels, or any month where you pasted but didn't reconcile because it took too long. The first signals are when paste-and-categorize starts pushing past 30 minutes. The second is when you start losing accuracy because the dataset is too big for spreadsheet error-checking.
Ardent Seller's Etsy connector replaces the Etsy column of this worksheet automatically. The Shopify and Square connectors are on the roadmap — until they ship, the worksheet covers those channels and the connector covers Etsy, side by side. The Spreadsheet vs Inventory Software Decision Guide (linked below) walks through the threshold in more detail.
Or skip the spreadsheet entirely
A worksheet reconciles after the month ends. Ardent Seller reconciles continuously — the Etsy connector imports every order with each fee captured as a separate ledger entry, and Profit & Loss reports subtract fees so the margin you see is the margin that hits your bank account. The Etsy side of this workbook is the workflow the connector replaces today; use the worksheet for the channels still on the manual list.
Native Etsy connector
OAuth-secured sync. Orders, fees, refunds, and shipping import as separate ledger entries; inventory pushes back automatically. The half of multi-channel reconciliation that doesn't need a worksheet.
Profit & Loss reports
Per-channel P&L runs continuously, not at month-end. Marketplace fees, refunds, and shipping costs subtract automatically — what you see is what you keep.
Etsy Sellers — full workflow
How Etsy shop owners combine the connector, true-profit reports, and the per-event ledger end-to-end — the workflow this worksheet mirrors for every channel that doesn't yet have a connector.
Frequently asked questions
Do the default fees match my channels exactly?
The defaults are US rates as of May 2026 — Etsy 6.5% transaction + 3% processing + $0.20 listing + $0.25 processing fixed; Shopify Payments 2.9% + $0.30; Square in-person 2.6% + $0.10; Stripe online 2.9% + $0.30; Faire 15% wholesale; cash 0%. Every value is a yellow input cell on the Channel Settings tab — verify against your most recent payout statement and override anything that doesn't match. The Sales tab and the Monthly P&L tab read the cells you edit, so a single change propagates everywhere.
What if a deposit covers multiple channels (like a Stripe payout from my Shopify store)?
Tag the deposit with the upstream channel that earned the revenue (Shopify, in this example) so the expected amount matches the orders on the Sales tab. The processing fee that Stripe takes is already baked into your Shopify Channel Settings row when you use Shopify Payments. If your Shopify store routes through a separate Stripe account, set the Shopify fee to 0% on Channel Settings and tag the deposits as "Stripe" instead — pick whichever method makes the deposit row match cleanly.
How do I handle Etsy Offsite Ads, Shopify gift cards, or other one-off charges?
Use the Refund / Adjustment column on the Sales tab as the catch-all for one-off deductions: enter Offsite Ads commission as a positive number in column I for the order that triggered it, and the expected net drops accordingly. For Shopify gift card sales, log the gross as a sale but enter the gift card amount as an adjustment so the expected net matches the (smaller) cash deposit. The pattern is "anything that reduces the deposit but isn't a standard fee goes in column I with a note in column K."
Why does the Monthly P&L tab use SUMPRODUCT instead of SUMIFS?
SUMIFS can't filter by YEAR() or MONTH() on a date column directly — it requires fixed text criteria. SUMPRODUCT with array math handles the year/month filter without forcing you to add a helper column for "April 2026" on every Sales row. The tradeoff is that SUMPRODUCT is slower at very large scale; if the Sales tab grows past 200 rows you'll feel it, which is one of the signals to switch to a real reporting tool.
When should I switch from this worksheet to a connector?
Around 50 orders a month per channel, three or more channels, or the first month where you skipped the close because it took too long. Below that, the worksheet is the cheaper tool — 30 minutes a month and zero subscription cost. Above that, paste-and-categorize compounds into hours, accuracy slips, and a missed reconciliation cycle costs more than any inventory tool. Ardent Seller's native Etsy connector handles the Etsy column automatically; Shopify and Square connectors are on the roadmap. The Spreadsheet vs Inventory Software Decision Guide (linked in Related resources below) walks through the threshold with checkboxes if you want to test it against your shop.
Related resources
Etsy Fee & True-Profit Calculator
A working Excel calculator for Etsy sellers — every fee broken out, bulk reconciliation across 60 orders, and a listing-price solver that targets a margin AFTER Etsy takes its cut.
Etsy Seller's Inventory & Fee Survival Guide
A 18-page narrative guide to Etsy's fee structure, fee-aware pricing, multi-channel inventory, returns, and the signal that says it is time to add a second sales channel.
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
End-of-Month Closeout Checklist
Seven steps to a clean monthly close — sales reconciliation, inventory counts, expense review, P&L, planning, reordering, and backup. Print one each month.
Schedule C Tax Expense Tracker
A working Excel expense tracker organized by IRS Schedule C category. Drop-down picker on every row, a Monthly Summary that builds itself, a year-end Schedule C view, and a mileage log with the deduction calculated for you.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
Should I Raise My Prices? Decision Tool
A live web tool that runs the +10% / +20% / +30% price-hike math for one product — including the volume drop that comes with each — and tells you which scenario clears the most monthly profit.