BUSINESS BACKGROUND
The client is a US-based health-and-supplements e-commerce brand founded by a medical doctor and her husband. The business operates a full multi-channel e-commerce bookkeeping footprint across five platforms: a Shopify storefront (direct-to-consumer), Amazon FBA, Amazon Seller Central, Fullscript (a practitioner dispensing platform), and PayPal. Operating cash flows through a primary bank, while card spend is distributed across four cards held by both founders.
On paper: a healthy seven-figure e-commerce brand. In the books: a picture muddier than the founders realized, one that required disciplined multi-channel e-commerce bookkeeping to untangle. A legacy bank account was still cluttering the active reconciliation set. Revenue was arriving as lump sums. Inventory was not being tracked monthly. The result was a P&L the founders could not fully trust.
KEY CHALLENGES
The client came to GATP with a familiar set of multi-channel e-commerce bookkeeping problems. None were catastrophic individually but together, every monthly P&L was slightly fictional.
- Shopify payouts landed as lump-sum ACH deposits – collapsing gross sales, refunds, and ~3% gateway fees into one line, understating true revenue visibility by as much as 12%.
- Amazon generated multiple small ACH deposits per week with no settlement-summary discipline, making the channel unreadable for margin analysis.
- Full script revenue was booked without separating fulfillment cost from gross revenue, inflating the top line and making the practitioner channel look more profitable than it was.
- PayPal was reconciled by feel, not by statement, a chronic multi-channel e-commerce bookkeeping gap.
- Roughly $200,000 of supplement inventory sat on the balance sheet at a stale annual value. Without monthly true-ups, gross margin was an estimate, not a measurement.
- A legacy closed bank account was still active in QuickBooks, adding noise to every reconciliation run.
“On a multi-channel e-commerce brand, every dollar of gateway fee, refund, and inventory movement that gets buried in a lump-sum entry is a dollar you stop seeing. Six months of that and you’re flying blind on margin.”
— GATP Solutions, internal review note
IMPACT
The downstream consequences of broken multi-channel e-commerce bookkeeping were real and compounding:
- The founders could not answer the most fundamental supplement brand question: did this month make money on a unit basis?
- Tax preparation required painful manual reclassification each April, paying a professional to clean up twelve months of structurally broken multi-channel e-commerce bookkeeping entries.
- Pricing and channel strategy decisions were being made without accurate, channel-level margin data.
- Inventory was treated as a year-end fire drill rather than a monthly operational metric, distorting COGS and gross margin throughout the year.
REQUIREMENTS & EXPECTATIONS
The client required a bookkeeping partner who understood multi-channel e-commerce bookkeeping at the platform level. Specific expectations included:
- Channel-by-channel revenue visibility: gross sales, refunds, and fees broken out per platform every single month.
- Monthly inventory true-up against actual ending stock via Shopify Analytics, not an annual or quarterly adjustment.
- Full reconciliation of every operating bank, all four credit cards, and PayPal to a $0 difference each month.
- A predictable, written monthly close with P&L commentary, balance sheet review, anomalies, and vendor flags, delivered by the 10th of every month.
- AI-augmented multi-channel e-commerce bookkeeping delivery that achieves faster turnaround than a traditional firm, without sacrificing accuracy.
STRATEGIC APPROACH
GATP sequenced the multi-channel e-commerce bookkeeping engagement in five structured blocks, each designed to deliver a clean answer without making the founders wait a quarter for results.
Block 1: Channel-by-Channel Deposit Breakdown
Every deposit from every sales channel is now split into its source components. Shopify payouts break into Sales, Refunds, and Fees via a standard journal entry pulled from the Shopify Payouts report. Amazon settlements are pulled from Seller Central’s Settlement Summary report and booked as a single structured entry covering product sales, FBA fees, promotional rebates, shipping credits, and a clearing-account plug for timing differences. Full script invoices split into gross revenue and supplement-fulfillment cost. PayPal is reviewed transaction-by-transaction, the foundation of rigorous multi-channel e-commerce bookkeeping.
Block 2: Tooling for Accuracy at Speed
PDF bank statements run through 2QBO, validated against opening balance, closing balance, and transaction count before import. A Master Vendor List drives consistent categorization, eliminating the ‘Amazon booked four different ways’ problem that plagues multi-channel e-commerce bookkeeping at scale.
Block 3: Monthly Inventory Adjustment
Each month, GATP pulls the Month-End Inventory Value report from Shopify Analytics, compares it against the QuickBooks Inventory Asset balance, and passes the difference as a journal entry against COGS. As of December 31, 2025, the inventory asset is anchored at $199,722.40 and trues up monthly. Gross margin is now a number, not a guess.
Block 4: Account Hygiene
The legacy closed bank account was confirmed and removed from the active reconciliation set. Every operating bank, every credit card, and PayPal now reconcile to $0 difference monthly, no silent open balances, no drift.
Block 5: AI-Augmented Delivery
GATP uses Claude AI inside the multi-channel e-commerce bookkeeping workflow to sanity-check categorizations against prior periods, surface anomalies before the client sees them, and draft the monthly observations email. The AI removes spreadsheet archaeology. The team spends time on calls that require judgment: unusual vendors, margin shifts, owner-draw questions, and cash-flow flags.
“We were running five sales channels off one lump-sum line of income. The first month GATP closed the books, we could finally see what each channel was actually doing and where the fees were eating us. That changed how we priced.”
— Founder of the US-based health & supplements e-commerce brand
COMPREHENSIVE SOLUTION
GATP’s comprehensive multi-channel e-commerce bookkeeping solution for the client operates on a locked monthly cadence across every layer of the business:
| Area | What GATP Does |
| Revenue Reconciliation | All 5 channels split monthly: gross sales / refunds / fees – core multi-channel e-commerce bookkeeping |
| Inventory Management | Monthly true-up of Inventory Asset vs. Shopify Month-End report; COGS adjusted accordingly |
| Bank & Card Reconciliation | All banks, Chase x2, Amex x2, PayPal, reconciled to $0 every month |
| Tooling | 2QBO for PDF-to-QBO conversion; Master Vendor List for consistent categorization |
| Monthly Observations Email | P&L, BS, anomalies, vendor flags in founders’ inbox by the 10th |
| AI-Augmented Workflow | Claude AI for prior-period checks, anomaly detection, and observations drafting |
| Tax-Prep Handoff | Clean books handed off, no catch-up reclassification at year-end |
MEASURABLE RESULTS
5 Sales Channels Reconciled Monthly | $199.7K Inventory Asset Trued-Up Monthly | $0 Reconciliation Difference Every Month | By 10th Observations Email Delivered Monthly |
Inside three monthly closes, four things changed for the client:
- The founders stopped guessing at margin. Gross sales, refunds, gateway fees, fulfillment cost, and inventory movement each appear on their own line across all five sales channels, the P&L now answers ‘which channel is paying us?’ at a glance.
- The inventory asset is no longer a year-end fire drill. Monthly true-ups mean tax season inherits a clean balance sheet, not three months of catch-up multi-channel e-commerce bookkeeping corrections.
- The close is predictable. By the 10th of every month, founders receive a written observations email covering P&L, balance sheet, anomalies, and items requiring approval.
- AI-augmented multi-channel e-commerce bookkeeping delivers enterprise accuracy at a price point a traditional firm cannot match, without trading away precision.
KEY TAKEAWAY
Most seven-figure e-commerce founders hit the same wall. A second sales channel gets added, then a third. The bookkeeper who managed the single-Shopify era cannot keep Amazon settlements, Full script splits, and inventory movement straight. The P&L starts showing numbers that contradict what the founders’ gut is telling them. By tax season, someone is being paid to clean up twelve months of structurally broken multi-channel e-commerce bookkeeping.
The lesson: multi-channel e-commerce bookkeeping requires platform-level discipline from the beginning. Lump-sum deposit entries are not a minor inconvenience, they are a compounding distortion that hides every dollar of gateway fee, refund, and inventory movement from the P&L and poisons every business decision downstream.
“Your Shopify is scaling. Your books shouldn’t be the thing holding you back.”
— GATP Solutions, e-commerce positioning
CLIENT IMPACT
The impact of accurate multi-channel e-commerce bookkeeping extended well beyond cleaner numbers:
- Pricing decisions are now anchored to real, channel-level margin data, not estimates or gut feel.
- Founders know by the 10th of every month exactly where the business stands: which channel grew, which channel contracted, and what the inventory position is.
- Tax preparation is now a handoff, not a reconstruction project, saving meaningful hours and professional fees every April.
- The business has a financial foundation it can scale on. Whether adding a fourth sales channel, renegotiating supplier terms, or modeling a price increase, the numbers are now trustworthy.
- AI-augmented multi-channel e-commerce bookkeeping means the client receives enterprise-grade financial discipline at a price point scaled to a $1M–$10M brand.
LET’S TALK
GATP Solutions provides multi-channel e-commerce bookkeeping for health-and-supplement brands, Shopify-plus operators, and multi-channel D2C founders running between $1M and $10M. We split deposits the right way, true up inventory monthly, reconcile every channel, and put AI inside the workflow so accuracy and turnaround stop being a tradeoff.
If your monthly P&L does not tell you which channel is paying you, we should talk. We will review your channel-by-channel revenue, your inventory tracking, and your close cadence, no pitch, just clarity on where you stand.
