|
Key Takeaways:
|
It's the 12th of the month. QuickBooks reads $47,000. You greenlight a $22,000 restock before lunch, because the books look healthy.
They don't. That $47,000 includes a wholesale invoice sitting unpaid in Accounts Receivable. Your actual spendable cash is $9,200.
This is the cash position fiction that quietly hits every brand running net-30 wholesale alongside daily DTC payouts. The books aren't wrong, QuickBooks is doing exactly what it's designed to do. The problem is you're reading it like a bank balance when it isn't one.
Here's what's actually happening, what it's costing you, and how to fix it.
When you ship a wholesale order, QuickBooks books the full invoice to Accounts Receivable immediately, not when the cash actually arrives. That $38,000 sitting unpaid with a retail partner shows up on your balance sheet looking identical to money in the bank.
Meanwhile, Shopify and Amazon push real cash to your bank feed every single day. That cash is spendable. The A/R isn't. But QuickBooks' default view blends both into one number, no flag, no separation, no color difference. Money-you're-owed and money-you-have look exactly the same on the dashboard.
The specific gap lives between two reports most founders never run together: the Accounts Receivable balance on the Balance Sheet and the actual bank balance on the Cash Flow statement.
One tells you what you're owed. The other tells you what you have. Reading just one, or worse, the blended dashboard figure, is where the bad spend decision gets made.
Net 30 day payment terms aren’t inherently bad. They’re standard in wholesale.
The issue is how they interact with fast-moving ecommerce cash flow.
Here’s a common scenario:
|
Channel |
Revenue Recorded |
Cash Received |
|
Shopify |
Same day |
Same day / 2 days |
|
Amazon |
Same day |
Within settlement cycle |
|
Wholesale |
Same day |
30-60+ days later |
QuickBooks records all three as revenue immediately.
But only one of them creates immediate liquidity.
Without clear visibility into receivables timing, owners often assume:
That assumption breaks fast during:
The business can technically be profitable while still running into cash shortages.
This is not a bookkeeping mistake.
And it’s usually not your accountant’s fault.
The problem is structural.
QuickBooks was designed to track accounting entries, not to automatically expose the operational cash timing differences between wholesale and ecommerce channels.
When data flows in without detailed reconciliation:
Most finance teams end up working across:
That creates fragmented visibility.
As transaction volume grows, the gap between “reported revenue” and “actual available cash” becomes harder to spot.
Here's the difference between the status quo and a correctly separated view:
What most founders see in QuickBooks:
|
Line |
Amount |
|
Cash & bank balance |
$47,200 |
That $47,200 includes $38,000 in open wholesale A/R. Spendable cash is actually $9,200.
What a clean, separated view looks like:
|
Line |
Amount |
|
Actual bank balance |
$9,200 |
|
A/R- wholesale net-30 (due in 18 days) |
$38,000 |
|
Spendable today |
$9,200 |
To get there manually in QuickBooks: Run Reports → Balance Sheet, filter by bank accounts only. Then run a separate A/R Aging Summary, filtered to net-30 wholesale customers.
Two reports. Never one blended number for spend decisions.
Webgility keeps ecommerce payouts, wholesale receivables, and settlement activity separated automatically, making actual liquidity easier to track.
That gives finance teams a cleaner operational cash view without relying on manual reconciliation.
Three things need to happen:
Fix Net-30 cash gaps by separating cash from receivables, planning for delays, and automating syncs with Webgility.
Stop reading the QuickBooks dashboard as a cash position. Run Reports → Balance Sheet filtered to bank accounts only. That number is your spendable cash. Everything else is a receivable.
Create a simple rolling 30-day cash projection that keeps A/R and realized cash in separate rows. Mark every wholesale invoice with its realistic collection date, not the invoice due date, the date it actually tends to clear. For most retail partners, that's day 35-42, not day 30.
Manual separation breaks down as order volume grows. The structural fix is ensuring every channel posts to its own discrete QuickBooks account — Shopify payouts to one account, Amazon settlements to another, wholesale invoices tracked separately in A/R with aging visibility front and center.
This is exactly what Webgility automates. Each channel's payouts, fees, and outstanding invoices sync to separate QuickBooks accounts at the point of transaction, so accurate cash visibility stops being something you maintain and starts being something you just have.
FlatSpec, an eyewear importer on Shopify and Amazon, described it simply: Webgility "works in the background and does exactly what I need, reconciling sales across platforms and bringing it all into QuickBooks."
If you're running wholesale net-30 alongside Shopify, Amazon, or any DTC channel on QuickBooks, there is a reasonable chance this gap is sitting in your books today. Most mixed-channel brands don't find it until a cash crunch forces the question.
Webgility runs a full reconciliation audit, every channel, every payout, every A/R classification, and shows you exactly where your cash position is being overstated and how to fix the underlying sync so it doesn't happen again.