For Shopify shops

Profit, margin, cash and stock over time

Every number you run your shop on, in one table — the past and the forecast ahead. Plus a simulator to test your decisions against it before you commit.

  • AES-256 · TLS 1.3ENCRYPTEDAT REST & IN TRANSIT
  • ROW-LEVELSECURITYPER CLIENT
  • MADE & HOSTED INGERMANY
  • GDPRCOMPLIANT

Cashflow Forecast

90 daysCashDecisions2Compare toActuals6 Sep – 3 Oct 2026
6 Sep7 Sep8 Sep9 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep16 Sep17 Sep18 Sep19 Sep20 Sep21 Sep22 Sep23 Sep24 Sep25 Sep26 Sep27 Sep28 Sep29 Sep30 Sep1 Oct2 Oct3 Oct
€49k€37k€25k€12k€0k6 Sep7 Sep8 Sep9 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep16 Sep17 Sep18 Sep19 Sep20 Sep21 Sep22 Sep23 Sep24 Sep25 Sep26 Sep27 Sep28 Sep29 Sep30 Sep1 Oct2 Oct3 OctNow
Gross profit
Revenue
Online store sales
€3,242€3,242
€3,374€3,374
€3,176€3,176
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€3,308€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
€4,018€0
Units sold / day
Shopify
49
51
48
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
Average price per unit
Shopify
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
€68
Refund rate
Shopify
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
2.7%
Cost of revenue
Restock & purchasing
€0€0
€0€0
€0€0
€0€0
−€36,400€0
€0€0
€0€0
€0€0
€0€0
€0€0
−€48,000€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
€0€0
Shipping & fulfilment
−€343−€343
−€357−€357
−€336−€336
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
−€350€0
Gross profit€2,899€3,017€2,840€2,958−€33,442€2,958€2,958€2,958€2,958€2,958−€45,042€2,958€2,958€2,958€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668€3,668
Operating expenses
Operating expenses
Advertising
−€520−€520
−€520−€520
−€520−€520
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
−€520€0
Ad spend / day
Meta Ads
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
€520
ROAS
Meta Ads
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
3.4×
Payroll & contracts
−€610−€610
−€610−€610
−€610−€610
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
−€610€0
Total operating expenses−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130−€1,130
€1,234Forecast — drivers & models€1,234Actuals — booked

Trusted by online shops

The status quo

You've figured out that your bank balance doesn't reflect your financial situation.

The numbers exist. They just sit in a supplier email, a Shopify report and your accountant's file — and none of them tells you where your shop will be in three months.

Most of your net worth sits in your inventory.

Your true net worth isn't sitting in your bank balance — it has to include what the stock in your warehouse is currently worth.

Bank balance €84,000€101,000 of stock uncounted

You never see how much profit you actually make.

Stock purchases, revenue, shipping invoices, taxes — every variable cost and every bit of revenue lands on a different date. That makes it hard to tell whether a sale earns you anything in the end.

Stock paid for in JanuarySold in March

You hope you have cash for the next tax payment.

You keep the large future transfers in your head and set an estimated amount aside for tax payments, the next restock and everything else.

VAT set aside by feelRestock €10k next week

What's missing isn't another report on numbers that already happened. What's missing is the view forward: a forecast, and a plan.

The solution

All your questions answered in one table — automatically

From your accounting and your shop data, Foreqast builds a model of your shop's money and runs it forward: cash, profit, margin and inventory value. One closed month to check it against, the one you're in — and then the part that matters.

Forecast

CashProfit
Actuals
Projected by Foreqast
Aug 26Sep 26Oct 26Nov 26Dec 26Jan 27Feb 27Mar 27Apr 27May 27Jun 27
Revenue
Online store sales
€106,080€106,080
€101,320€101,320
€103,360€0
€103,360€0
€103,360€0
€103,360€0
€103,360€0
€103,360€0
€103,360€0
€103,360€0
€103,360€0
Average sales price
Shopify
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
Ordered units / month
Shopify
2184
2086
2128
2128
2128
2128
2128
2128
2128
2128
2128
Return rate
Shopify
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
Cost of revenue
Restock & purchasing
−€50,898−€50,898
−€51,923−€51,923
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
−€51,923€0
AssetsBalances at period end
Cash€91,418€93,700€97,744€101,788€105,832€109,876€113,920€117,964€122,008€126,052€130,096
Inventory€100,089€101,114€101,114€101,114€101,114€101,114€101,114€101,114€101,114€101,114€101,114
AnalysisUnit economics
Margin per unit€24.17€24.17€24.17€24.17€24.17€24.17€24.17€24.17€24.17€24.17€24.17
1

When is the next restock, and how much is it?

2

How much money do I have, including inventory?

3

How high is my margin per unit?

What makes it hard

The challenges of planning a shop — and how Foreqast handles them

Five things make a shop hard to plan. Every one of them is handled in the model above by design — hover a card for the answer.

Revenue has weekly patterns

Your Tuesday isn't your Saturday. Revenue arrives in a weekly shape that a monthly average flattens away.Solution: In Foreqast the forecast is built day by day from your own sales history, so the weekly shape stays in it — and the table still switches to weeks or months whenever you want the overview.

Payouts for orders come delayed

The order is today, the payout is nine days later. What you earned and when you can spend it are never the same date.Solution: In Foreqast your provider's payout schedule and your suppliers' payment terms are part of the model, so every amount sits on the day it really moves.

Restocks need to cover increasing sales

Sell more and the next purchase order gets bigger. The better the month, the larger the bill behind it.Solution: In Foreqast the restock hangs off your revenue forecast as a driver rather than a fixed number: it scales with what you are going to sell, and lands on its due date.

Your inventory is invisible

Stock is never held as money — it only surfaces as the bill when you reorder. But it's an asset you could sell, so it belongs on top of your cash, not missing from it.Solution: In Foreqast your stock is valued day by day and carried right next to cash, so what you are actually worth is one number instead of a guess.

Cash flow or profit — which one do you plan?

Plan only cash and you can be profitable and still run out of money. Plan only profit and you never see whether the month actually earned anything.Solution: In Foreqast one switch above the table reads the same lines as cash or as profit, so you never have to choose: cash tells you when the money moves, profit what the period earned.

Now you have a precise overview. That is the base you need to start making good financial decisions.

The decisions

From the overview to the decision

The forecast shows you where you stand and where you land if you change nothing. You need it the moment you change something: Foreqast doesn't just give you the overview, it backs the decision. Here are four you'll make on it.

Restock & purchasing

How much do you reorder, and when?

  • Frequency, day of month and average purchase value set once — the rule then applies to every future order.
  • The order amount is calculated from your revenue forecast instead of guessed, so it grows as your sales do.
  • The outflow sits in cash flow on the day it's due, and you see what's left once it clears.

Restock & purchasing

7 Sep8 Sep9 Sep10 Sep11 Sep12 Sep
Cost of revenue
Cost of revenue
Restock & purchasing
€0€0
€0€0
€0€0
−€36,400€0
€0€0
€0€0
Units sold / day
Shopify
49
51
48
50
50
50
Average purchase costManual
€28
€28
€28
€28
€28
€28
Shipping & fulfilment
−€343−€343
−€357−€357
−€336€0
−€350€0
−€350€0
−€350€0
Units sold / day
Shopify
49
51
48
50
50
50
Cost per unitManual
€7
€7
€7
€7
€7
€7
Payment fees
−€80−€80
−€83−€83
−€78€0
−€82€0
−€82€0
−€82€0
Fee rate
Stripe
2.4%
2.4%
2.4%
2.4%
2.4%
2.4%
Packaging & supplies
−€98−€98
−€102−€102
−€96€0
−€100€0
−€100€0
−€100€0
Warehouse & storage
−€340−€340
−€340−€340
−€340€0
−€340€0
−€340€0
−€340€0
Total cost of revenue−€861−€882−€850−€37,272−€872−€872

Restocking Rule

Settings

Scheduling

Recurring

Interval

Every 26 days

Payment terms

Net 30
Ordered 10 Sep → paid 10 OctSave

Efficient scaling

What happens when you raise the ad budget?

  • Revenue follows the budget, and COGS, shipping and fees follow revenue — the whole chain recalculates.
  • The gap between spending today and being paid out later is dated in the plan.
  • What's left as margin after all of it shows up straight away — in total and per unit.

Revenue & ad spend

7 Sep8 Sep9 Sep10 Sep11 Sep12 Sep13 Sep14 Sep
Revenue
Revenue
Online store sales
€3,332€3,332
€3,264€3,264
€3,400€0
€3,876€0
€3,876€0
€3,876€0
€3,876€0
€3,876€0
Total revenue€3,332€3,264€3,400€3,876€3,876€3,876€3,876€3,876
Operating expenses
Operating expenses
Advertising
−€420−€420
−€420−€420
−€420€0
−€580€0
−€580€0
−€580€0
−€580€0
−€580€0
Budget / dayManual
€420
€420
€420
€580
€580
€580
€580
€580
ROASManual
2.4×
2.4×
2.4×
2.6×
2.6×
2.6×
2.6×
2.6×
Shipping & fulfilment
−€343−€343
−€336−€336
−€350€0
−€399€0
−€399€0
−€399€0
−€399€0
−€399€0
Payment fees
−€80−€80
−€78−€78
−€82€0
−€93€0
−€93€0
−€93€0
−€93€0
−€93€0
Other expenses
−€640−€640
−€640−€640
−€640€0
−€640€0
−€640€0
−€640€0
−€640€0
−€640€0
Total operating expenses−€1,483−€1,474−€1,492−€1,712−€1,712−€1,712−€1,712−€1,712

Simulate budget adjustment

Starting 10 Sep 2026

New budget

€580 / day

Expected ROAS

2.6×
Save

Profitability

Will your shop still be profitable next month?

  • Margin after stock, shipping, fees and ad spend instead of a flat rate from memory.
  • Computed day by day rather than estimated at month end — and, from the same forecast, for the months still ahead.
  • In total and per unit, in the same table as your cash flow.

Margin

5 Sep6 Sep7 Sep8 Sep9 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep
Revenue
Revenue
Online store sales
€3,536€3,536
€3,264€3,264
€3,468€3,468
€3,400€3,400
€3,400€0
€3,400€0
€3,400€0
€3,400€0
€3,400€0
€3,400€0
€3,400€0
Average sales price
Shopify
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
€68.00
Ordered units / day
Shopify
73
67
71
70
70
70
70
70
70
70
70
Return rate
Shopify
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
2.1 %
AssetsBalances at period end
Cash€85,944€87,653€89,538€91,364€93,190€50,608€52,434€54,260€56,086€57,912€59,738
Inventory€56,779€55,144€53,412€51,704€49,996€92,696€90,988€89,280€87,572€85,864€84,156
AnalysisUnit economics
Margin€1,755€1,629€1,736€1,692€1,692€1,692€1,692€1,692€1,692€1,692€1,692
Margin per unit€24.04€24.31€24.45€24.17€24.17€24.17€24.17€24.17€24.17€24.17€24.17

Taxes

Is there a tax payment coming that will floor you?

  • VAT and income taxes build up month by month out of your own forecast.
  • Every date sits in the cash flow with an amount on it, before it falls due.
  • You see what's left after the payment — before you plan the restock in front of it.

VAT & Taxes

Next payment

€12,570

10 Sep 2026

Due over 12 months

€37,000

every filing

VAT building up

€27,600

filed quarterly

Income taxes

€9,400

prepaid quarterly

Filing calendarwhat leaves the account, and on which day
10 Sep 2026
VAT for Jul – Aug
€8,420
10 Sep 2026
Trade tax prepayment
€4,150
10 Dec 2026
VAT for Sep – Nov
€9,310
10 Dec 2026
Corporate tax prepayment
€5,240
10 Mar 2027
VAT for Dec – Feb
€9,880

1 / 4

Works with your stack

The tools you already run your shop on

DATEV
L
lexoffice
Shopify
Stripe
Meta Ads

Success stories

Shops like yours, deciding on the numbers

How other shops size restocks, set ad budget and price their range — in their own words.

All success stories

Time to value

Set up in 15 minutes

It takes one guided setup: a handful of questions about how your shop works, and your accounting connected. Foreqast generates the forecast from there — no model to build, no template to fill in. From that point on, every decision you're weighing has a number behind it instead of an instinct.

  1. 15 min

    Complete the guided setup

    Foreqast asks how your shop earns and spends — revenue, restocks, shipping, fees, ads and contracts — and you connect your accounting and your shop. That is the whole setup.

  2. Automatic

    Your forecast is generated

    Your bookings arrive already categorized, get accrued day by day and roll twelve months forward. The forecast builds itself — and stays current with every sync.

  3. From day one

    Start making decisions

    The cash curve, the tight weeks and the next dates are there. Test the restock, the ad budget or the price change against them before you commit.

FAQ

The questions shop owners ask

What shop owners want to know before they start — answered briefly. The long version lives in the documentation and the academy.

Still have a question?

The documentation explains every field; the academy walks the whole way from actuals to a finished plan.

Do I need finance skills?

No. Foreqast is built on your accounting data — your chart of accounts is already the structure of your plan. You read a forecast in plain language.

Why accounting instead of a bank feed?

Because bookings arrive already assigned to an account. Nothing needs categorizing, and your plan uses the same numbers your accountant does.

Will it work with my shop?

Shopify connects in a couple of clicks, and so do Stripe and your ad platforms. If your shop runs elsewhere, its numbers come in by CSV import with a saved mapping.

How accurate is the forecast?

It's built from your real actuals and drivers and updates on every sync, so it tracks your actual trend instead of a guess.

Is my data secure?

Your data is encrypted in transit and at rest, and only ever used to build your own forecast.

Are returns in the forecast?

Yes. The refund rate is its own driver on your revenue row — change it and the forecast recalculates revenue and stock needs immediately.

When does the money actually land?

The plan uses your payment provider's payout schedule and your invoices' payment terms rather than the order date — which is why the cash curve holds, not just revenue.

Can I plan a restock before I order it?

Yes. Restocks sit in the plan with a date and an amount before the order goes out, so you see the cash impact before you commit to the supplier.

Do I have to rebuild the plan every month?

No. Every sync carries actuals and drivers forward; the plan stays the same one and keeps itself current.

Run your next shop decision through the numbers

Connect your accounting and your shop, get your baseline in minutes, then test the restock, the budget and the price against it before you commit. Free to start.

Get early access

14 days free · no card required