Cashflow Planner

A comprehensive and structured framework for managing your Cashflow.

Step 1

Enter forecast income for each month then the total receipts will be calculated for you.

Step 2

Enter forecast expenses for each month then the total expenditure will be calculated for you.

Step 3

Repeat Step 1 & Step 2 for Year 2 and Year 3.        
       

Year 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A. Receipts
Cash Sales (inc Credit/Debit/Gift card sales)
Cash received on goods returns
Credit Sales Due - 30 days
Credit Sales Due - 60 days
Credit Sales Due - 90 days
Proceeds of Loan Drawdowns from Bank
VAT refund
Owner Equity/Director Loans
Grants Received
Cash received from sale of other assets
Other:(i.e Rental Income)
A. Total receipts
B. Expenditures
Payments Due - 30 days
Payments Due - 60 days
Payments Due - 90 days
Capital Expenditure
Production & Staff Costs
Wages and Salaries (inc. overtime & commission)
PAYE / N.I.
VAT payment
Personal Life Assurance
Pension Contributions
Corporation & Preliminary Tax
Principal/Directors Remuneration Drawings
Utility & Professional Business Expenses
Rent & Rates (Inc. Water)
Business Insurance
Professional Fees
Repairs & Renewals
Royalty Payments (Franchising)
Electricity
Gas
Phone & internet - Office & Mobile
Operating Expenses
Cleaning & Security & other premises costs
Postal & Courier Costage
Motor Fuel & Service
Motor Tax & insurance
Subs to professional associations
Entertainment (Staff)
Entertainment (Customers)
Travel Expenses
Advertising Expenses
Stationery & Office Supplies
Financial Expenses
Bank Term Loan Repayments
HP/ Leasing Repayments
Loan Interest Payments
Bank Charges
B. Total expenditure
A - B Cashflow Surplus (+) /Deficit (-)
Opening Cash balance (start month)
Closing Cash balance

 

 

Note: If you wish to download a blank Excel version of the Cashflow Planner (for working offline), simply disregard steps 1-3 and click the “Download” button.

Notice

We have taken all reasonable steps to exclude viruses from this file, but we cannot guarantee such exclusion and you should therefore take appropriate steps in respect of any such risk.

 

Note: This information is provided for illustrative purposes only and is based on the accuracy of information provided. It does not constitute a contract. We are not recording and will not use the information quoted by you in our calculators.

Disclaimer

Please read this information carefully before using this tool.


This tool is intended to provide information based on stated assumptions and your inputs. It is not intended to be used as a substitute for professional financial advice. It is not intended to be relied on for the purposes of making a decision in relation to a financial product. Users should consider obtaining advice from a qualified advisor before making any financial decision. Allied Irish Bank (GB) gives no warranty, express or implied, as to the accuracy, reliability and completeness of any information, formulae or calculations provided through the use of this tool and does not accept any liability for loss or damage whatsoever, which may be attributable to the use of this tool. Use of this tool shall constitute acceptance of the terms of this agreement.