For teams that run on Billit
Billit cash flow forecast for 13 weeks
Billit shows income, expense and cash flow charts per month, quarter and year, and keeps open sales and supplier invoices with their due dates. A view of the weeks ahead, with fixed costs like rent, wages and VAT added, is usually kept in a separate sheet.
How it goes today
- Filter the unpaid sales invoices in Billit and copy them to a sheet.
- Do the same for the supplier invoices still to pay.
- Look up the bank balance at the bank.
- Add rent, wages and VAT yourself and work out the balance per week.
How it can go
See each Monday which of the next thirteen weeks will be tight.
Each Monday you get a thirteen week overview: open sales invoices by due date, adjusted for how late each customer paid before, open supplier invoices by due date, and fixed amounts you enter once, such as rent, wages and VAT. It starts from the bank balance you fill in, shows the expected balance per week and marks weeks below a level you set. It shows what is open in Billit; it does not predict when a customer actually pays.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Billit key in the portal, never in the chat.
With Hypamoon, each Monday, make a thirteen week cash overview from Billit: open sales invoices by due date, shifted by how late each customer usually pays, open supplier invoices by due date, plus the fixed costs I give you once, such as rent, wages and VAT. Start from the bank balance I fill in, show the expected balance per week, mark weeks that drop below the level I set, and email it to me.
You copy the API key and the PartyID of your company yourself from your profile in Billit. Billit allows this key for a connection used only for your own administration. It stays yours.
More for teams on Billit
- My invoices are made in a sheet, and now that e-invoicing is required I type them again in Billit.
- I only find out an invoice did not arrive when the customer has not paid.
- Supplier invoices come in wrong or twice, and I only notice when my accountant asks.
- I have three files in Billit and I open each one to see what is still open.
- Everything for Billit