E-Commerce Business Achieves 90-Day Cash Flow Visibility & Eliminates Late Penalties

The Starting Point

The client ran a Paramus-based e-commerce business selling on three platforms: Shopify (direct site), Amazon FBA, and Etsy. Annual revenue $1.4 million across the three channels. The business had been operating for four years with no consistent bookkeeping system.

Operational symptoms when the engagement began:

• Chaotic platform reconciliation — Shopify, Amazon, and Etsy each settled to bank on different cycles. Owner had no consolidated view of revenue or fees.
• Missed quarterly estimated tax payments — owner had paid IRS late-payment penalties three quarters in a row, totaling $1,800. NJ underpayment penalties added another $850.
• Cash flow surprises — owner had been forced to delay vendor payments twice in the prior six months because revenue timing didn't match what looked like cash on hand.
• No multi-state sales tax tracking — owner had crossed economic nexus thresholds in 6 states under post-Wayfair rules but was not registered or collecting in any of them. Estimated exposure: $35,000+ in uncollected tax.
• Inventory accounting essentially non-existent — COGS was treated as cash spent, not as inventory matched to sales. Distorted both monthly P&L and tax return.

The ProAxis Approach

90-day implementation across four parallel workstreams:

Days 1-30: QuickBooks Online Implementation

Set up QuickBooks Online with multi-platform integrations: Shopify direct sync, A2X for Amazon settlement reconciliation, manual Etsy import via CSV. Built chart of accounts for e-commerce — separate revenue accounts per platform, separate fee accounts (Amazon FBA fees, Shopify fees, payment processor fees), inventory account with periodic adjustment process.

Days 30-60: Reconciliation Catch-Up & Monthly Close Process

Reconciled the prior 12 months across all bank accounts, all credit cards, and all platform settlements. Identified and corrected $18,000 of misclassified expenses. Established a fixed monthly close calendar — books closed by the 10th of each month with P&L delivered to owner by the 12th.

Days 60-90: 90-Day Cash Flow Forecast Model

Built a 90-day rolling cash flow forecast in Google Sheets pulling from QuickBooks data. Inputs: pending Amazon disbursements (14-day cycle), Shopify settlement schedule, Etsy payouts, vendor payment terms (Net 30), upcoming quarterly estimated tax payments, sales tax remittance schedule, and seasonal revenue patterns. Updates automatically on the 10th of each month after monthly close.

Parallel Track: Multi-State Sales Tax Voluntary Disclosure

Initiated voluntary disclosure agreements (VDAs) with 4 of the 6 states where the business had crossed economic nexus thresholds. VDAs limited the look-back period to 3 years (vs unlimited if states discovered the exposure independently) and waived penalties. Total state tax assessment: ~$22,000 (vs estimated $35,000+ exposure without VDAs). Set up TaxJar for ongoing monthly state filings going forward.

Key Lessons

• Multi-platform e-commerce needs platform-aware bookkeeping. Generic bookkeepers don't reconcile Amazon settlement statements correctly. The reconciliation is non-trivial and platform-specific.
• Post-Wayfair sales tax is the silent killer. Most e-commerce sellers cross economic nexus thresholds in 5-10 states without realizing it. Discovery via state audit is far worse than voluntary disclosure.
• Cash flow forecasting changes business decisions. The owner had been operationally cash-positive for years but couldn't see when. Now visibility enables aggressive but informed growth investments.
• Late-payment penalties compound. $2,650/year in penalties was small individually but represented systematic operational failure. Fixing the close process eliminated them entirely.

Related ProAxis Services Used in This Engagement

• E-commerce Bookkeeping
• E-commerce Multi-State Sales Tax
• Fractional CFO (cash flow forecasting)
• Multi-State Tax Compliance
• Wayfair Economic Nexus Glossary Entry