JAServices Financial
JAServices FinancialJuan Rodriguez, Fractional CFO and ControllerQuickBooks Online International Certified

Thirteen week cash flow

Sample E-Commerce Co.

Sample data, names changed
Week of August 6 through November 4, 2026
Dated from the ledger, not averaged

Week by week, on the actual dates

 

Every commitment below sits in the week it actually falls, taken from this year's payment history. The three inputs you control are underneath. Change them and the whole calendar moves.

Amex charges about $22,540 a week. Pay less than that and the bottom row shows the balance climbing, against a card with $0 of Pay Over Time left. Over the last twelve weeks the card was paid $20,580 a week, which is $1,960 short and is exactly why the balance went from $42,853 in January to $62,856 now. Paying it down slower does not free up cash, it moves the shortfall onto the card.

Week beginningAug 6Aug 13Aug 20Aug 27Sep 3Sep 10Sep 17Sep 24Oct 1Oct 8Oct 15Oct 22Oct 29
Heavy commitment week Closing balance below zero Closing balance below your floor
Read this as a draft. The dated commitments and the bank balances are solid, and this model runs only on cash moving through three reconciled bank accounts, so the weeks below hold up. The wider cleanup is not finished. Payables are mid reconciliation against vendor statements, inventory has not been counted, an old processor account is empty but still carried, and the shareholder balance is unresolved. None of that changes these weeks. It does mean the rest of the financials will still move.

The two weeks that decide this

Commitments do not arrive evenly. The SBA loan, the vehicle loan, the Line of credit minimum and a payroll run all land inside the same seven days twice in this window, on top of the Amex draw that never stops.

Sep 17 to Sep 23
$12,340
Payroll and payroll taxes $6,405. SBA loan $3,258. Vehicle loan $791. Line of credit minimum $1,886. All of it before a dollar of Amex or suppliers.
Oct 15 to Oct 21
$12,340
Payroll and payroll taxes $6,405. SBA loan $3,258. Vehicle loan $791. Line of credit minimum $1,886. All of it before a dollar of Amex or suppliers.

Where every line comes from

Dated, not averaged

The earlier model repeated one average week thirteen times. This one places each commitment on the date it has actually landed all year. Below is the evidence for each, so nothing here is a guess dressed up as a schedule.

CommitmentEach timePattern in the ledgerDates in this window
Payroll and payroll taxes$6,405 Fourteen runs since January, every other week, never more than $56 apartAug 12, Aug 26, Sep 9, Sep 23, Oct 7, Oct 21, Nov 4
Rent$5,765 Seven for seven, between the 7th and the 10th, identical amountAug 10, Sep 9, Oct 9
Store credit card$1,914 The 14th of every month without exception. Amount varies, this is the averageAug 14, Sep 14, Oct 14
SBA loan$3,258 The 17th, seven for seven, same amount every monthAug 17, Sep 17, Oct 17
Vehicle loan$791 Same day as the SBA payment all yearAug 17, Sep 17, Oct 17
Line of credit minimum$1,886 Statement due the 21st. This is the minimum, not a paydownAug 21, Sep 21, Oct 21
Overseas contractor$980 Sixteen payments since January 2, every other weekAug 14, Aug 28, Sep 11, Sep 25, Oct 9, Oct 23
Amex$22,540 a week Thirty five payments in thirteen weeks, roughly three a week. Card closes the 15th and debits the 10thEvery week
Supplier wires$6,125 a week The main suppliers and the smaller factories. Order driven and genuinely lumpy, so this one is an assumption you setSpread evenly
Everything else$5,005 a week Utilities, insurance, smaller contractors, fees. What is left after the named linesSpread evenly
Receipts$36,750 a week Twelve full weeks to July 27, averaging $36,750 with a middle range of $29,960 to $40,670Every week
What is solid and what is not. The seven dated lines are as close to certain as anything in this business. The Amex figure is measured but it is a policy choice, not a bill on a date. Supplier wires and receipts are the two real unknowns, which is why both are sliders rather than numbers on the page.
Still being vetted. The P&L ties to QuickBooks line for line and is close, but a number of GL accounts are still being worked through. Payables are the largest piece. Vendor balances have not been reconciled in a long time and that work is underway now. Inventory, prepaid inventory, an old processor balance and the shareholder balance are all still open. Nothing on this page depends on them, so do not read the rest of the financials as settled on the strength of it.
The thing this model cannot soften. Amex is a charge card. There is no Pay Over Time room left and the line of credit is at its limit, so a short week cannot be bridged by borrowing on these cards. It has to be bridged by holding a supplier wire, cutting advertising, or putting money in, and those decisions land better made in advance than in the week itself.
Sample E-Commerce Co. · Thirteen week cash flow · Sample data, names changed · Juan Rodriguez, JAServices Financial Confidential · Remote, Available Globally