Free Cash Flow & Accounting Controls Templates

Free Excel workbook + PDF guide

Plan Short-Term Cash and Strengthen Everyday Accounting Controls

Use a formula-driven 13-week cash forecast, bank reconciliation, petty-cash register and practical controls checklist in one coordinated pack.

What is included?

13-Week Cash Forecast

Enter weekly cash inflows and outflows, monitor the minimum cash buffer and assign actions before a projected shortfall becomes urgent.

Bank Reconciliation Template

Record deposits in transit, outstanding payments and unrecorded ledger items while the workbook checks that adjusted balances agree.

Petty-Cash Register

Track vouchers, receipts, approvals and the physical cash count with clear exception flags.

Cash Controls Checklist

Assign owners, due dates, evidence and progress across receipts, payments, bank access, reconciliations, forecasting and reporting.

Who will find this useful?

This pack is designed for small organisations, finance teams, accounting students and business owners who want a more disciplined short-term cash process. The sample values are replaceable, and the workbook clearly separates input cells from formulas.

Important scope note: IAS 7 governs historical statements of cash flows. The 13-week forecast in this pack is an internal management tool, not an IAS 7 statement. Controls should be tailored to organisation size, risk and applicable law.

Request the free pack

Enter your email address to receive two secure links: the Excel workbook and the PDF quick guide.

Website

Email address I agree that Accounting Support may email the requested download links. I can ignore the message or request removal from future optional communication.

We use your email to deliver this resource and maintain limited delivery and security records. Never submit passwords or confidential financial information.

How to use the workbook safely

1. Replace the blue sample input cells with your own approved figures.
2. Review the 13-week closing cash balance and every minimum-buffer warning.
3. Complete the bank and petty-cash reconciliations and investigate differences.
4. Assign an owner and evidence to each relevant cash control.
5. Do not rely on the workbook unless MODEL STATUS shows PASS.

Continue learning about cash-flow reporting

• Statement of Cash Flows: IAS 7 Practical Guide
• How to Prepare a Statement of Cash Flows under IAS 7
• Operating Cash Flow Ratios: Formulas and Interpretation

Sources and professional boundary

The reporting distinction follows the IFRS Foundation's IAS 7 overview, while the control checklist is informed by COSO's principle-based internal-control guidance. This resource provides general educational information and does not replace legal, tax, audit or accounting advice.