Try the worksheet
Replace the illustrative values. Entries stay in this browser session only. On small screens, scroll the table sideways to view all columns.
| Description | Money in (LKR) | Money out (LKR) | Closing cash (LKR) |
|---|---|---|---|
| LKR 170,000.00 | |||
| LKR 190,000.00 | |||
| LKR 110,000.00 | |||
| LKR 130,000.00 | |||
| LKR 150,000.00 | |||
| LKR 170,000.00 | |||
| LKR 190,000.00 | |||
| LKR 210,000.00 | |||
| LKR 230,000.00 | |||
| LKR 250,000.00 | |||
| LKR 270,000.00 | |||
| LKR 290,000.00 |
Use the month when money moves
Enter receipts in the month you expect to collect them, not automatically in the month you issue the invoice. Enter supplier payments, rent, approved payroll totals and other cash outflows in their intended payment month.
The opening amount may be negative if you are modelling an existing cash deficit. Receipts and payments must be non-negative. Empty or invalid inputs stop the calculation so a missing assumption is not silently treated as zero.
- Replace the sample opening cash and all twelve monthly estimates.
- Review negative closing balances and the earliest shortfall.
- Download a copy, then test another scenario by delaying a receipt.
- Compare the model with actual cash records each month.
What the export contains
The CSV includes opening cash, each month's receipts and payments, net movement and closing balance. It can be opened in a spreadsheet and retained with your supporting assumptions. The browser does not upload or save your entries; downloading a copy is your choice.
Label expected loans or owner contributions separately in your own supporting notes. This compact model groups receipts and payments; it does not evaluate a lender's terms or determine whether funding will be approved.
Review the weak assumptions
A large uncertain receipt can hide a cash problem. Test a second scenario with that receipt delayed or reduced. Check whether recurring payments have been omitted and whether an annual bill needs a particular month.
The model does not calculate interest, tax, payroll deductions or inflation. Include any separately verified cash amounts yourself. This is a cash planning worksheet rather than a full financial statement.
Worked example
Read the first-month closing balance
Sample first month: opening LKR 150,000, receipts LKR 200,000 and payments LKR 180,000.
- Cash available before paymentsOpening cash plus receipts.
- LKR 350,000.00
- Month 1 closing cashClosing cash becomes month 2 opening cash.
- LKR 170,000.00
Change the worksheet assumptions to match your dates and records. Sample values are neither current market figures nor a business forecast.
Frequently asked questions
Does the CSV keep my inputs?
The downloaded file contains the current entered inputs and calculated balances. Browser refresh or leaving the page clears the working inputs; no server stores them.
What does a negative balance mean?
The entered plan pays more cash than is available at that point. Investigate timing, omitted funding and possible adjustments; it does not represent an approved overdraft.
Sources and limits
Assumption-based management model; no financing approval, interest, statutory calculation or guarantee is provided.
- IFRS Foundation — IAS 7 overview
Background on cash movement and the distinction between operating and financing activity; this resource is a management workflow, not an IFRS compliance assessment.
Accessed: 2026-10-08