Skip to content
lesslater

Guides Purchasing

Cash flow budget for a webshop with a month-by-month example

How to build a cash flow budget for a webshop, see when purchases for the fourth quarter drain the account, and understand the difference between a cash flow budget and a profit budget.

Updated 18 November 2026 · 5 min read

A cash flow budget shows how much money comes into and goes out of the account month by month, and what the balance is expected to be at the end of each month. For a seasonal webshop it is mainly purchasing that decides whether the money stretches, because the goods for the Christmas season have to be paid for several months before customers buy them.

The difference between a cash flow budget and a profit budget

A profit budget shows whether the business makes money. Revenue is recorded in the month the product is sold, and cost of goods sold is recorded in the same month as the cost price of the products sold. A cash flow budget instead shows when the money actually moves. Goods bought in September and sold in November do not affect the result in September, but they do affect cash in the month the supplier has to be paid.

This means a webshop can have a healthy profit budget for the whole year and still run short of money in October. You need both budgets, and they are built on the same figures: the profit budget answers whether the business works, and the cash flow budget answers whether there is money in the account along the way.

Cash flow budget example with purchases for the fourth quarter

A webshop has 300,000 DKK in the account on 1 August. Customers pay when they order, so receipts follow sales. The goods for the Christmas season are delivered and paid for in September and October. All figures are in DKK and excluding VAT to keep the example simple.

Month Receipts from sales Purchases Fixed costs Net Closing balance
August 400,000 150,000 180,000 70,000 370,000
September 380,000 450,000 180,000 −250,000 120,000
October 420,000 500,000 200,000 −280,000 −160,000
November 750,000 250,000 260,000 240,000 80,000
December 900,000 150,000 240,000 510,000 590,000
January 300,000 100,000 180,000 20,000 610,000

Over the six months the balance rises from 300,000 DKK to 610,000 DKK, but in October the account is 160,000 DKK overdrawn. That is the kind of gap a profit budget does not show, and you need to know about it well in advance so there is time to arrange an overdraft, move an order or negotiate the payment terms.

How payment terms and lead time move the money

Payment terms decide how long you can sell the goods before they have to be paid for. If the supplier of the October order of 500,000 DKK gives 30 days of credit from delivery, the payment moves to November. October then has a net of 420,000 − 200,000 = 220,000 DKK, and the balance ends at 340,000 DKK. November has a net of 750,000 − 250,000 − 500,000 − 260,000 = −260,000 DKK, and the balance ends at 80,000 DKK. The lowest balance in the period is then 80,000 DKK in November instead of minus 160,000 DKK in October, even though exactly the same goods are bought.

Lead time works the other way. The longer the lead time, the earlier the order has to be placed, and if the supplier requires a deposit when ordering or payment on shipment, the money also leaves earlier. A supplier with a 90-day lead time and a 30% deposit on ordering means that part of the Christmas goods is already paid for in August. Such suppliers should have their own lines in the budget, so the payments appear on the right dates.

What to include in the budget

  • Receipts from sales in the month the money is received. Payment providers often pay out with a few days’ delay, and returns take money back out.
  • Purchases on the date each supplier has to be paid, calculated from the order date, lead time and payment terms.
  • Fixed costs such as salaries, rent, warehouse rent, software and shipping agreements.
  • Marketing, which for many webshops rises sharply in November and December.
  • VAT, which is collected from customers and has to be paid on the dates that apply to the business. The VAT sits in the account for a while, but it is not the business’s money.
  • Loan repayments and any payout of profit.

Cash flow budget in Excel or another spreadsheet

A cash flow budget can easily be built in Excel, Google Sheets or another spreadsheet. Put the months as columns and receipts and payments as rows, and let one row calculate net as the sum of receipts minus the sum of payments. The closing balance is the previous month’s balance plus the month’s net. The hard part is not the formulas but keeping purchases up to date, because they change every time an order is moved, changed or delivered in several parts.

How it connects to the purchasing budget

The cash flow budget builds on the purchasing budget. The purchasing budget says how much may be ordered each month, and the cash flow budget shows when those orders have to be paid. Read more about setting the monthly budget in the guide on purchasing budget and cash flow.

In lesslater you can set a purchasing budget per month and per supplier and see the payments for the next six months for both placed orders and orders planned from the forecast. See more under budget.

See your own products in lesslater

Create an account and connect your webshop. The first 14 days are free, and no credit card is needed. If you would rather go through it on your own data with us, book a demo.

No credit card · No commitment · Data in the EU