Sample data: a fictional homewares brand. All figures illustrative. Book a discovery call
Brands who join before their portal is switched on get these same pages every month from their Storehouse Ai analyst, as a PDF pack. The exception is Today so far, which is in the portal only.
All figures in AUD, excluding GST. Illustrative sample data. Month figures are checked against your Xero; Now figures come in overnight and aren't checked yet. Today so far is never added into Now or Month figures.
Month · October 2026 · checked against your Xero on 5 Nov
Month-end review
Sample homewares brand · Month-end review
October 2026
Illustrative
A stronger month. Contribution margin $173,600 (28.3%), up 1.3 points on September and $8,700 (4.8%) under budget. The Online store carried it; the Shop is thin at 14.1%.
Your VIP metrics
Net revenue$612,400Sept $588,200
Contribution margin$173,600Sept $158,900
Net profit$96,420Sept $84,100
Marketing % of revenue19.4%Sept 20.2% · outside target (under 18%)
Stock at landed cost$412,800At 31 Oct
SKUs flagged5On 5 Nov
P&L against budget and last year
October 2026 against budget, September 2026 and October 2025
Line
October
Budget
September
Oct 2025
Net revenue
$612,400
$643,000$30,600 under · unfavourable
$588,200
$521,300
Gross margin
$363,50059.4%
$381,700$18,200 under · unfavourable
$347,10059.0%
$302,40058.0%
Contribution margin
$173,60028.3%
$182,300$8,700 under · unfavourable
$158,90027.0%
$135,50026.0%
Net profit
$96,420
$101,300$4,880 under · unfavourable
$84,100
$71,800
Budget: "FY27 budget", set up in Storehouse Ai on 20 Oct 2026.
Margin by channel
Online store · $392,400 · $125,60032.0%
Wholesale · $142,600 · $37,10026.0%
Shop · $77,400 · $10,90014.1%
All channels: $612,400 revenue, $173,600 contribution, 28.3%.
Tied to Xero
Net revenue $612,400 and contribution $173,600 in both Storehouse Ai and Xero. One reclassification: $12,500 of freight, duty and broker fees moved from fulfilment into cost of goods. Profit unchanged.
3 wins
Every cost line came in under budget, $25,720 in total, and revenue is up 17.5% on October 2025.
Contribution margin up 1.3 points on September, to 28.3%.
Returning customers brought 44.0% of revenue, at $135.43 an order against $105.51 for new customers.
3 fixes
Reorder nowHM-214 Stoneware mug 350 ml. 19 days of cover against a 54-day lead time. Order today; expect a gap of about 35 days.
HM-331 Glass carafe 1 L: check price, supplier and packing. 17.1% margin at landed cost after a 6.5% supplier price rise, and 11.4% of units refunded, mostly "Arrived broken".
Hold reorders of HM-412 Linen tea towel set of 2. 140 days of cover, about $8,200 at landed cost; 520 units are over 180 days old.
Stock and reorders
Stock at landed cost $412,800 across 30 SKUs: 1 Reorder now, 1 Order soon, 1 Low margin, 2 Overstock, 25 On track.
By age since received: 0–90 days $301,300 · 91–180 days $78,400 · over 180 days $33,100.
Returns flag: HM-331 Glass carafe 1 L.
Marketing, per Xero
Marketing 19.4% of revenue: $118,600 of ad spend. MER 5.2×; blended CAC $39.67.
The ad platforms report $682,400 of sales: $70,000 (11.4%) more than the revenue in your Xero.
Cash
Cash in the bank at 31 October, from Xero: $240,000.
Done for you by your Storehouse Ai analyst · prepared 5 Nov 2026
13-week cash view (including GST): lowest point $213,376 in week 3 (16 to 22 Nov).
What the month means
October was a good month that leans on the Online store. Margin is improving, but marketing is running above your target and the mug reorder is late enough to cost sales in December. Fix the mug first, then look at the carafe's price and packing before reordering it. No change to overheads is needed.
Estimates used
No estimates this month. Every freight and duty bill for stock sold had arrived.
Tied to Xero · checked by your Storehouse Ai analyst · 5 Nov 2026
All figures in AUD, excluding GST. General information, not financial advice.
Your budget is kept in Storehouse Ai. Bring it in from a spreadsheet, or set it up with your Storehouse Ai analyst, and every month's P&L is compared with it.
This sample brand's budget, "FY27 budget", was set up in Storehouse Ai on 20 Oct 2026.
Tied to Xero
Tied to Xero · checked against your Xero on 5 Nov 2026
Every line agrees with Xero once one difference is explained. Profit is the same in both.
October 2026 Xero tie-out: Storehouse Ai against Xero, by line
Line
Storehouse Ai
Xero
Difference
Explained by
Net revenue
$612,400
$612,400
$0
–
Cost of goods
$248,900
$236,400
+$12,500
Reclassification
Fulfilment and freight
$71,300
$83,800
−$12,500
Reclassification
Marketing
$118,600
$118,600
$0
–
Contribution margin
$173,600
$173,600
$0
Reclassification · $12,500 · profit unchanged. Xero books freight, duty and customs broker fees on imported stock in fulfilment (the freight, duty and broker accounts). Storehouse Ai counts them in cost of goods, at landed cost, so each unit's true cost is right.
All figures in AUD, excluding GST. Illustrative sample data. Storehouse Ai never posts anything to Xero.
Today so far · Thu 5 Nov 2026
Illustrative
Now · live from Shopify, not yet checked · updated 2:47 pm AEDT
Net revenue, orders and refunds so far today, by channel, live from Shopify, not yet checked
Channel
Net revenue
Orders
Refunds today
Online store
$7,420
78
2 · $186
Wholesale (stockists)
$3,150
2
0 · $0
Shop (Shopify POS)
$2,380
31
1 · $64
All channels
$12,950
111
3 · $250
Shopify orders only. Wholesale invoiced in Xero, profit, stock cost and ad spend update overnight.
Month · October 2026 · checked against your Xero on 5 Nov
Net revenue $612,400 from 5,240 orders.
+$24,200 on September (+4.1%)+$91,100 on October 2025 (+17.5%)
Average order $116.87 · 10,743 units · the same revenue as the P&L.
Top products
October 2026 sales by product
Product
Units
Revenue
Share
HM-501Stoneware dinner set, 12 piece Hero
870
$164,430
26.9%
HM-620Linen duvet cover set, queen Hero
560
$122,640
20.0%
HM-540Ceramic serving bowl set of 3
760
$60,040
9.8%
HM-455Hand-poured soy candle
980
$33,320
5.4%
HM-214Stoneware mug 350 ml Hero
1,240
$29,760
4.9%
HM-108Stoneware dinner plate 27 cm
775
$24,800
4.0%
HM-331Glass carafe 1 L
372
$14,136
2.3%
HM-412Linen tea towel set of 2
186
$5,208
0.9%
All other products (22 lines)
5,000
$158,066
25.8%
All products
10,743
$612,400
100.0%
By channel
October 2026 orders, revenue and average order by channel
Channel
Orders
Revenue
Avg order
Online store
4,110
$392,400
$95.47
Wholesale (stockists)
96
$142,600
$1,485.42
Shop (Shopify POS)
1,034
$77,400
$74.85
All channels
5,240
$612,400
$116.87
By week
1 to 7 Oct$138,2001,180 orders
8 to 14 Oct$142,6001,240 orders
15 to 21 Oct$131,9001,135 orders
22 to 28 Oct$147,3001,260 orders
29 to 31 Oct$52,400425 orders
The last week is three days.
New and returning customers
68.3% of October's 4,380 customers were new. Returning customers brought 44.0% of revenue.
October 2026 customers, orders and revenue, new against returning
Group
Customers
Orders
Revenue
Share of revenue
Avg order
New (first order this month)
2,990
3,250
$342,900
56.0%
$105.51
Returning
1,390
1,990
$269,500
44.0%
$135.43
All customers
4,380
5,240
$612,400
100.0%
$116.87
Repeat purchase rate, last 12 months: 37.3% (13,133 of 35,165 customers ordered twice or more).
Customer cohorts
Each row is the customers who first bought that month. Each cell is the share of them who ordered again that many months later. The percentage is always printed; darker means more came back.
Share of each month's new customers who ordered again, 1 to 5 months later, and average customer value to date
First order
New customers
Month 1
Month 2
Month 3
Month 4
Month 5
Avg value
May
2,420
9.6%
7.4%
6.6%
5.8%
5.4%
$167.98
June
2,310
10.1%
7.7%
6.5%
5.9%
–
$158.01
July
2,560
9.4%
7.1%
6.2%
–
–
$148.98
August
2,740
10.4%
7.9%
–
–
–
$137.99
September
2,830
10.8%
–
–
–
–
$126.01
October
2,990
–
–
–
–
–
$114.68
"–" means the group hasn't reached that month yet. Average value is revenue to date per customer, excluding GST.
Totals and percentages only. Storehouse Ai groups orders by Shopify's customer ID and never stores or shows customer names, emails, phone numbers or addresses.
Now · updated Thu 5 Nov, 5:42 am · not yet checked
Net revenue $79,020 from 676 orders, 1 to 4 November.
Average order $116.89 · 1,386 units · from Shopify to the end of yesterday. These figures are checked against your Xero when November is published.
By channel, so far
Now · 5:42 am
1 to 4 November orders, revenue and average order by channel, not yet checked
Channel
Orders
Revenue
Avg order
Online store
532
$50,600
$95.11
Wholesale (stockists)
12
$18,400
$1,533.33
Shop (Shopify POS)
132
$10,020
$75.91
All channels
676
$79,020
$116.89
Ad spend, so far
Now · 5:44 am
Ad spend, Meta, Google and TikTok
$15,300
MER: $79,020 ÷ $15,300
5.2×
Marketing % of revenue per Xero comes with the checked month.
All figures in AUD, excluding GST. Illustrative sample data. Now figures are never added into Month figures.
Month · October 2026 · checked against your Xero on 5 Nov
Marketing was 19.4% of revenue, per Xero.
$118,600 of marketing ÷ $612,400 of revenue, both from XeroSeptember 20.2%
Outside your target (under 18%)
What the ad platforms say they sold
Platform-reported
Sales the ad platforms report, together
$682,400
Revenue in your Xero, every channel
$612,400
The gap: what the platforms claim over your real revenue
$70,000 (11.4%)
The ad platforms report $682,400 of sales. Your Xero shows $612,400 of revenue across every channel. The platforms claim $70,000 (11.4%) more than the business actually took.
Ad spend by platform
Meta Ads$64,20054.1%
Google Ads$38,90032.8%
TikTok Ads$15,50013.1%
Together $118,600: the same as the marketing line in your P&L from Xero.
Return and cost per new customer
MER (marketing efficiency ratio): $612,400 ÷ $118,600
5.2×
Blended CAC: $118,600 ÷ 2,990 new customers (Shopify)
$39.67
Payback: $39.67 ÷ $17.95 contribution a month per customer
2.2 months
MER uses your real revenue. CAC uses Shopify's count of new customers, not the platforms'.
CAC by platform
Platform-reported
October 2026 cost per new customer by platform, using each platform's own count of new customers
Platform
Spend
New customers it reports
CAC it implies
Meta Ads
$64,200
1,980
$32.42
Google Ads
$38,900
1,350
$28.81
TikTok Ads
$15,500
620
$25.00
Platforms together
$118,600
3,950
–
The platforms report 3,950 new customers between them. Shopify had 2,990. The platforms can count the same customer more than once, so these CACs look cheaper than the blended $39.67.
Campaigns
Platform-reported
October 2026 campaigns with the platforms' own reported revenue and return
Campaign
Spend
Revenue the platform reports
Return it reports
Meta: Prospecting, broad audience
$38,500
$173,300
4.5×
Meta: Retargeting, site visitors
$25,700
$205,600
8.0×
Google: Brand search
$9,400
$94,000
10.0×
Google: Shopping
$29,500
$147,500
5.0×
TikTok: Creator videos
$15,500
$62,000
4.0×
All campaigns
$118,600
$682,400
5.8×
Email-attributed revenue (Klaviyo)
Platform-reported
$71,300· 11.6% of revenue, by Klaviyo's own attribution. Not added to revenue or profit.
All figures in AUD, excluding GST. Illustrative sample data. Platform-reported figures are never added into revenue, profit, MER or CAC.
Month · October 2026 · checked against your Xero on 5 Nov
Every $1 of stock earned $10.17 of gross margin this year.
Twelve measures, each with what it means in plain words and the figures behind it. Pin any of them as a VIP metric.
GMROI (gross margin return on stock)
$10.17 per $1
For every dollar tied up in stock, you earned this much gross margin over the last 12 months.
$4,053,550 gross margin, last 12 months ÷ $398,600 average stock at landed cost.
Stock turns
6.9 a year
How many times you sold through your average stock in the last 12 months. Higher means stock moves faster.
$2,767,250 cost of goods at landed cost ÷ $398,600 average stock.
Days of stock
53 days
How long your average stock lasts at last year's pace of sales.
365 ÷ 6.94 stock turns.
Gross margin per order
$69.37
What the average order leaves after the landed cost of what's in it.
$363,500 gross margin ÷ 5,240 orders.
Contribution margin per order
$33.13
What the average order leaves after stock, fulfilment and marketing. It pays overheads and profit.
$173,600 contribution margin ÷ 5,240 orders.
Average order value (AOV)
$116.87
What a customer spends in one order, on average, excluding GST.
$612,400 net revenue ÷ 5,240 orders, wholesale invoices included.
Marketing % of revenue (per Xero)
19.4%Outside your target (under 18%)
How much of each sales dollar went on marketing, using your books, not the ad platforms.
$118,600 marketing in Xero ÷ $612,400 revenue in Xero.
Overheads % of revenue
12.6%
How much of each sales dollar goes on running costs like wages, rent and software.
$77,180 other expenses in Xero ÷ $612,400 net revenue.
Debtor days
21 days
How long customers, mostly stockists, take to pay you on average.
$97,700 owed to you at 31 Oct ÷ ($418,800 invoiced in the last 90 days ÷ 90).
Creditor days
20 days
How long you take to pay your suppliers on average.
$186,400 you owed at 31 Oct ÷ ($839,000 of supplier bills in the last 90 days ÷ 90).
Cash conversion cycle
54 days
How long a dollar spent on stock takes to come back as cash from a customer.
53 days of stock + 21 debtor days − 20 creditor days.
Break-even revenue
$272,265 a month
The monthly sales at which contribution margin just covers overheads. Above it, you make a profit.
$77,180 overheads ÷ 28.35% contribution margin.
Industry benchmarks
Done for you by your Storehouse Ai analyst
Your analyst adds published benchmarks to your monthly pack where they exist. Each one names its source, the period it covers, how many brands it's based on and which group it describes. If any of those is missing, it isn't shown, and Storehouse Ai never makes one up.
This sample shows no benchmark figures, because none would be real.
All figures in AUD, excluding GST. Illustrative sample data. Twelve-month figures use November 2025 to October 2026.
Month · October 2026 · checked against your Xero on 5 Nov
$240,000 in the bank at 31 October.
From your Xero bank accounts at month-end.
13-week cash view
Done for you by your Storehouse Ai analyst · prepared 5 Nov 2026
Your analyst prepares this each month from your Xero bank balances, bills and invoices, your supplier terms and open orders, and it appears on this page each month. This is the October view.
Sample homewares brand · from your monthly pack
13-week cash flow forecast
Prepared 5 Nov 2026
Run rate: sales carry on at your recent pace. Stock already ordered is paid as agreed.
Lowest point $213,376 in week 3 (16 to 22 Nov), when the quarterly BAS is paid. It stays above your cash floor of $150,000 all quarter.
Cash floor: $150,000. Weeks run across; scroll sideways to see all 13. Budget and target figures are illustrative.
Weekly cash flow forecast for the next 13 weeks, in dollars. Brackets show negative amounts and a dash shows nil.
Week commencing
2 Novactual + fcst
9 Novfcst
16 NovfcstLowest
23 Novfcst
30 Novfcst
7 Decfcst
14 Decfcst
21 Decfcst
28 Decfcst
4 Janfcst
11 Janfcst
18 Janfcst
25 Janfcst
Opening cash at bank
240,000
246,000
245,376
213,376
219,376
225,376
231,376
221,920
227,920
233,920
239,920
245,920
251,920
Cash in
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
78,000
Card and wallet payouts (Shopify Payments)
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
64,000
Afterpay, PayPal and other payouts
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
14,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
32,000
Larger stockists, paid on 30-day terms
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
21,000
Other stockists
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
11,000
Shop (POS) takings
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
Total cash in
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
118,000
Cash out
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
Premises, software and insurance
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
3PL storage and pick and pack
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
27,000
Meta Ads
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
14,800
Google Ads
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
8,900
TikTok Ads
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
3,300
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
Outbound freight
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
9,500
Packaging
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
Shopify and payment fees
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
19,000
25,624
19,000
19,000
19,000
19,000
34,456
19,000
19,000
19,000
19,000
19,000
19,000
HM-214 reorder: 30% deposit
–
6,624
–
–
–
–
–
–
–
–
–
–
–
HM-214 reorder: 70% balance on shipping
–
–
–
–
–
–
15,456
–
–
–
–
–
–
Other supplier orders in progress
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
Wages
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
Super and PAYG withholding
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
–
–
38,000
–
–
–
–
–
–
–
–
–
–
Net GST paid to the ATO
–
–
26,000
–
–
–
–
–
–
–
–
–
–
PAYG instalment
–
–
12,000
–
–
–
–
–
–
–
–
–
–
Total cash out
112,000
118,624
150,000
112,000
112,000
112,000
127,456
112,000
112,000
112,000
112,000
112,000
112,000
Net cash flow
6,000
(624)
(32,000)
6,000
6,000
6,000
(9,456)
6,000
6,000
6,000
6,000
6,000
6,000
Closing cash at bank
246,000
245,376
213,376
219,376
225,376
231,376
221,920
227,920
233,920
239,920
245,920
251,920
257,920
Budget: customer receipts follow your FY27 budget, about 5% above October's pace. Stock already ordered is paid as agreed. Customer receipts, ad spend, freight, packaging and payment fees move with sales. Stock already ordered, wages, fixed costs and the BAS stay as planned.
Lowest point $224,317 in week 3 (16 to 22 Nov), when the quarterly BAS is paid. It stays above your cash floor of $150,000 all quarter.
Weekly cash flow forecast for the next 13 weeks, in dollars. Brackets show negative amounts and a dash shows nil.
Week commencing
2 Novactual + fcst
9 Novfcst
16 NovfcstLowest
23 Novfcst
30 Novfcst
7 Decfcst
14 Decfcst
21 Decfcst
28 Decfcst
4 Janfcst
11 Janfcst
18 Janfcst
25 Janfcst
Opening cash at bank
240,000
249,647
252,670
224,317
233,964
243,611
253,258
247,449
257,096
266,743
276,390
286,037
295,684
Cash in
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
81,898
Card and wallet payouts (Shopify Payments)
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
67,198
Afterpay, PayPal and other payouts
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
14,700
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
33,599
Larger stockists, paid on 30-day terms
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
22,049
Other stockists
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
11,550
Shop (POS) takings
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
8,400
Total cash in
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
123,897
Cash out
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
Premises, software and insurance
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
3PL storage and pick and pack
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
28,350
Meta Ads
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
15,540
Google Ads
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
9,345
TikTok Ads
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
3,465
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
18,900
Outbound freight
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
9,975
Packaging
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
3,675
Shopify and payment fees
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
5,250
19,000
25,624
19,000
19,000
19,000
19,000
34,456
19,000
19,000
19,000
19,000
19,000
19,000
HM-214 reorder: 30% deposit
–
6,624
–
–
–
–
–
–
–
–
–
–
–
HM-214 reorder: 70% balance on shipping
–
–
–
–
–
–
15,456
–
–
–
–
–
–
Other supplier orders in progress
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
Wages
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
Super and PAYG withholding
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
–
–
38,000
–
–
–
–
–
–
–
–
–
–
Net GST paid to the ATO
–
–
26,000
–
–
–
–
–
–
–
–
–
–
PAYG instalment
–
–
12,000
–
–
–
–
–
–
–
–
–
–
Total cash out
114,250
120,874
152,250
114,250
114,250
114,250
129,706
114,250
114,250
114,250
114,250
114,250
114,250
Net cash flow
9,647
3,023
(28,353)
9,647
9,647
9,647
(5,809)
9,647
9,647
9,647
9,647
9,647
9,647
Closing cash at bank
249,647
252,670
224,317
233,964
243,611
253,258
247,449
257,096
266,743
276,390
286,037
295,684
305,331
Target: an illustrative stretch of your budget plus 10% sales, about 15% above October's pace. You set your own target. Stock already ordered is paid as agreed. Customer receipts, ad spend, freight, packaging and payment fees move with sales. Stock already ordered, wages, fixed costs and the BAS stay as planned.
Lowest point $247,318 in week 3 (16 to 22 Nov), when the quarterly BAS is paid. It stays above your cash floor of $150,000 all quarter.
Weekly cash flow forecast for the next 13 weeks, in dollars. Brackets show negative amounts and a dash shows nil.
Week commencing
2 Novactual + fcst
9 Novfcst
16 NovfcstLowest
23 Novfcst
30 Novfcst
7 Decfcst
14 Decfcst
21 Decfcst
28 Decfcst
4 Janfcst
11 Janfcst
18 Janfcst
25 Janfcst
Opening cash at bank
240,000
257,314
268,004
247,318
264,632
281,946
299,260
301,118
318,432
335,746
353,060
370,374
387,688
Cash in
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
90,087
Card and wallet payouts (Shopify Payments)
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
73,918
Afterpay, PayPal and other payouts
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
16,169
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
36,959
Larger stockists, paid on 30-day terms
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
24,254
Other stockists
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
12,705
Shop (POS) takings
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
9,240
Total cash in
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
136,286
Cash out
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
Premises, software and insurance
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
3PL storage and pick and pack
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
31,183
Meta Ads
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
17,093
Google Ads
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
10,279
TikTok Ads
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
3,811
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
20,789
Outbound freight
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
10,972
Packaging
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
4,042
Shopify and payment fees
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
5,775
19,000
25,624
19,000
19,000
19,000
19,000
34,456
19,000
19,000
19,000
19,000
19,000
19,000
HM-214 reorder: 30% deposit
–
6,624
–
–
–
–
–
–
–
–
–
–
–
HM-214 reorder: 70% balance on shipping
–
–
–
–
–
–
15,456
–
–
–
–
–
–
Other supplier orders in progress
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
19,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
18,000
Wages
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
14,500
Super and PAYG withholding
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
3,500
–
–
38,000
–
–
–
–
–
–
–
–
–
–
Net GST paid to the ATO
–
–
26,000
–
–
–
–
–
–
–
–
–
–
PAYG instalment
–
–
12,000
–
–
–
–
–
–
–
–
–
–
Total cash out
118,972
125,596
156,972
118,972
118,972
118,972
134,428
118,972
118,972
118,972
118,972
118,972
118,972
Net cash flow
17,314
10,690
(20,686)
17,314
17,314
17,314
1,858
17,314
17,314
17,314
17,314
17,314
17,314
Closing cash at bank
257,314
268,004
247,318
264,632
281,946
299,260
301,118
318,432
335,746
353,060
370,374
387,688
405,002
Opens with $240,000 at 31 October. Every amount is cash through the bank, so it includes GST. Weekly receipts are Shopify and online sales, wholesale invoices paid by stockists and shop (POS) takings. Weekly payments are fixed costs and 3PL, ad spend, freight, packaging and fees, stock orders and wages with super and PAYG. The HM-214 reorder (2,400 units at $9.20 landed, $22,080) is paid as a 30% deposit and a 70% balance on shipping, and the quarterly BAS is $38,000 in week 3. Known bills, invoices and the estimates shown only. Brackets are negative amounts; a dash is nil.
Cash figures include GST, as they go through your bank. The BAS row is the net GST paid to the ATO. Other pages show amounts excluding GST. General information, not financial advice.
Can you afford a reorder?
Done for you by your Storehouse Ai analyst
When a reorder is due, your analyst checks it against this view and tells you in your pack or by email. The HM-214 reorder ($22,080) keeps your lowest point at $213,376, above your $150,000 floor. Reorder alerts are never held back for this check.
Cash figures in AUD, including GST, as they go through your bank. The BAS row is the net GST paid to the ATO. Illustrative sample data.
Now · from Shopify · updated Thu 5 Nov, 5:42 am · not yet checked
One SKU needs reordering now.
Figures and statuses update every night, and Reorder now and Order soon emails go out automatically, so this page and your inbox always agree. Hero products are listed first and get extra safety days.
Stock at landed cost: $412,800 across 30 SKUs (8 shown).
HM-214Stoneware mug 350 ml Hero
Reorder now
The order-by date has passed. Reorder today and you'd still be out of stock for about 35 days, from about Tue 24 Nov until the order lands around Tue 29 Dec.
Units available
760
Selling (30-day rate, out-of-stock days left out)
40 a day
Days of cover: 760 ÷ 40
19 days
Lead time: 30 days' production + 24 days' shipping (supplier record)
54 days
Safety days (hero product)
14
Suggested order: about 60 days of sales, rounded up to cartons of 48
2,400 units
Stock set aside by channel
HM-214 stock by channel, with each channel's days of cover and status
Channel
Units
A day
Cover
Status
Online store and Shop
640
34
19 days
Reorder now
Wholesale (set aside)
120
6
20 days
Reorder now
The suggested 2,400 covers both: 2,040 for the Online store and Shop, 360 for Wholesale.
By location
Brisbane warehouse
712
Shop back room
48
All locations
760
Received in the last 90 days: all 760 units.
Open stockist orders
Done for you by your Storehouse Ai analyst
Your analyst adds open stockist orders to your wholesale cover in the reorder workbook each week, so wholesale days of cover counts what's already promised.
What if delivery is later still?
Days out of stock
35
Units at risk
1,400
Sales at risk (estimate)
$33,600
Gross margin at risk (estimate)
$20,720
Up to these amounts, at $24.00 a unit with a landed cost of $9.20. Some customers will wait for the restock, so the real figure is likely lower.
Can you afford it?
Done for you by your Storehouse Ai analyst
2,400 units at $9.20 landed is $22,080. Your analyst's 13-week cash view shows your lowest point stays at $213,376, above your $150,000 floor. See the cash view
HM-540Ceramic serving bowl set of 3
Order soon
52 days of cover against a 38-day lead time plus 7 safety days. Order by Thu 12 Nov; Storehouse Ai suggests 1,900 units, in cartons of 20. Storehouse Ai emails you automatically when it's time to order.
Units available (last night)
1,300
Selling (30-day rate)
25 a day
Days of cover: 1,300 ÷ 25
52 days
Lead time + safety days
38 + 7 days
Order by: 52 − 45 days from today
Thu 12 Nov
HM-331Glass carafe 1 L
Low marginReturns
Stock is fine. The margin isn't: 17.1% at landed cost, so each unit leaves $6.50. Shopify's cost makes it look like 38.2%. And more of them are coming back.
Refunds, last 30 days
Units refunded ÷ units sold
41 ÷ 360
Refund rate
11.4%
Usual level (previous 180 days)
3.2%
Your limit
10%
Flagged because it's more than 1.5 times the usual level, and above your limit.
Spend is from Xero bills, excluding GST, in AUD. Storehouse Ai keeps the supplier record in Storehouse Ai, separate from Xero.
Sample stoneware supplier
Started from your Xero contact
Lead time: production + shipping
30 + 24 = 54 days
Minimum order
1,000 units a SKU
Carton size
Mug 48 · dinner set 4
Deposit and balance
30% on order, 70% before shipping
Currency
USD
Shipping terms
FOB, port of loading
Freight and duty
From each shipment's bills
Open purchase orders
Open purchase orders with Sample stoneware supplier
PO
Units
Arriving
PO 1041 · HM-501 dinner set
1,200
Mon 14 Dec
Hero products from this supplier: HM-214 mug, HM-501 dinner set.
Lead time achieved, and deposits due
Done for you by your Storehouse Ai analyst
How long this supplier's orders actually took against the 54 days quoted, and which deposits and balances fall due each week, come in your analyst's supplier review in the monthly pack.
Sample glassworks
Cost rise
This bill's unit price for HM-331 is 6.5% higher. Bill INV-2231 (12 Oct): $31.10 a unit. Previous bill INV-2140 (3 Aug): $29.20 a unit. SKU affected: HM-331 Glass carafe 1 L.
A cost only changes when you update your cost sheet. Your cost sheet still says $29.20, last updated 3 Aug.
Lead time: production + delivery
7 + 14 = 21 days
Minimum order
200 units
Carton size
6
Payment terms
30 days from invoice
Currency
AUD
Sample linen mill
Lead time: production + shipping
25 + 15 = 40 days
Minimum order
500 units a SKU
Deposit and balance
50% on order, 50% before shipping
Currency
USD
Hero products from this supplier: HM-620 duvet cover set.
Sample tableware supplier
Lead time: production + shipping
21 + 14 = 35 days
Minimum order
600 units a SKU
Deposit and balance
30% on order, 70% before shipping
Currency
USD
Sample ceramics workshop
Lead time: production + delivery
30 + 8 = 38 days
Minimum order
300 sets
Payment terms
14 days from invoice
Currency
AUD
All figures in AUD, excluding GST. Illustrative sample data. Supplier names are fictional.
Now · from Xero bills and your cost sheet · updated 5:40 am · not yet checked
Each HM-108 dinner plate really costs $12.60, not $8.50.
Gross margin 60.6% at landed cost73.4% using Shopify's cost$4.10 a unit Shopify doesn't show
How $12.60 is built
Product (USD 6.50 at 0.65)
$10.00
Freight
$2.10
Duty (0%)
$0.00
Customs broker
$0.30
Currency and bank fees
$0.20
Landed cost per unit
$12.60
From Xero bill INV-2198 and its shipment's freight and broker bills. Import GST isn't included: you claim it back.
Low-margin example: HM-331Glass carafe 1 L
Sell price
$38.00
Cost in Shopify
$23.50
Landed cost
$31.50
Margin, Shopify cost
38.2%
Margin, landed cost
17.1%
From Xero bill INV-2231: $31.10 a unit plus $0.40 delivery.
Your cost sheet
Built at onboarding from your supplier invoices. Storehouse Ai uses it wherever a Xero bill line isn't matched to a SKU. Edits apply from the next nightly run; published months stay as they were.
Cost sheet entries for four SKUs
SKU
Unit cost
Source
Updated
HM-214Stoneware mug
USD 4.90
Supplier invoice INV-2207
2 Sep 2026
HM-108Dinner plate
USD 6.50
Supplier invoice INV-2198
12 Aug 2026
HM-331Glass carafe Cost rise
AUD 29.20
Supplier invoice INV-2140
3 Aug 2026
HM-412Tea towel set
USD 5.70
Supplier invoice INV-1876Cost last updated 14 Oct 2025. Is it still right?
14 Oct 2025
Freight or duty bill not in Xero yet?
Upload the forwarder's or customs broker's invoice and Storehouse Ai adds it to the right shipment. Until then the cost is shown as an Estimate and corrected in the month the bill arrives, never in a closed month.
All figures in AUD, excluding GST. Illustrative sample data.
By email
3 stock alerts sent this week.
Alerts go out automatically each morning from last night's figures. Storehouse Ai holds one back only if the figures are over two days old, the same alert went out in the last 7 days, or you've marked the SKU as ordered. Every Monday you also get a weekly snapshot. Forward any of them to your adviser: there are no customer details in them.
From: Storehouse Ai alerts · Thu 5 Nov, 5:48 amReorder now: Stoneware mug 350 ml (HM-214)
Reorder nowHero
Now · figures from Thu 5 Nov, 5:42 am · not yet checked
19 days of cover against a 54-day lead time, for the Online store and Shop and for the stock set aside for Wholesale.
The order-by date has passed. If you order today, expect to be out of stock for about 35 days.
Returns, Low margin and Overstock flags appear in the app and the weekly snapshot, not as their own emails.
6 of 6 connections updated overnight.
Owners and managers can connect, reconnect or disconnect. Storehouse Ai never asks for passwords.
Connections, access level and last update
Source
Access
Last updated
Actions
Shopify
View-only access.
5:42 am
Xero
View-only access.
5:40 am
Meta Ads
Reporting access only.
5:44 am
Google Ads
Storehouse Ai reads your reports.
5:44 am
TikTok Ads
Reporting access only.
5:44 am
Klaviyo
The lowest access Klaviyo offers.
5:44 am
Times are Brisbane time. If a sync fails, Storehouse Ai retries and tells you only if you need to do something.
Your data, and who has looked at it.
Your data
The log below shows each time Storehouse Ai staff viewed or exported your data. Owners and managers can see it on this page.
Where your data is stored, and which services handle it for us, is set out in our privacy policy.
Access log
Who viewed or exported your data
What
Who
When
Published October month
Your Storehouse Ai analyst
5 Nov, 3:12 pm
Viewed October draft
Your Storehouse Ai analyst
5 Nov, 10:12 am
Sent HM-214 Reorder now alert
Storehouse Ai (automatic)
5 Nov, 5:48 am
Exported SKU table
You
4 Nov, 10:51 pm
Plain words for the numbers.
Words we use
Month and Now
Month figures are checked against your Xero and published. Now figures come in overnight from Shopify and your ad platforms and aren't checked yet. They're never added together.
Landed cost
What a unit really cost once product, freight, duty, broker and currency fees are in. Excludes import GST.
Contribution margin
Revenue less cost of goods, fulfilment and marketing. What a channel adds before overheads.
Days of cover
How long today's stock lasts at the recent sales rate.
Hero product
One of the SKUs that together make most of your gross margin. Heroes get more safety days and earlier warnings.
MER
Net revenue ÷ ad spend.
CAC
Customer acquisition cost: ad spend ÷ new customers.
Platform-reported
What an ad platform says about itself. Shown beside your real figures, never added into them.
In Storehouse Ai, and done for you by your analyst
Everything in this sample works in Storehouse Ai except the parts marked Done for you by your Storehouse Ai analyst. Those come from your Storehouse Ai analyst each month, in your pack or by email.
By hand13-week cash view
By handReorder affordability checks
By handIndustry benchmarks, with a named source
By handWholesale cover after open stockist orders
By handSupplier lead time achieved, and deposits due
How your month works
1
Your bookkeeper finishes October in Xero.
2
Storehouse Ai builds the month and checks every line against Xero.
3
Your Storehouse Ai analyst checks it and publishes it, by business day 10.
4
You get "Your month is ready". Once published, it doesn't change.