Contractor Cash Flow Excel Template | Contract Cash Flow, Applications, Retentions and Pipeline

For contractors and subcontractors who wait on certificates and payments. It shows when costs go out before certified money comes in, so you can see a cash squeeze coming. Applications, certifications, payments and retentions are each tracked with day counts. A weekly cash check and a plain English guide to UK Construction Act payment rights are included.

What it covers

• Contract cash flow showing costs out against certificates in
• Applications diary tracking applied, certified and paid, with day counts
• Retention ledger tracking both halves until they are paid
• Job bank of signed and likely work ahead
• Weekly cash check with five numbers every Friday
• Payment rights under the Construction Act, in plain English

Who it is for

Suits building contractors, subcontractors, groundworkers, M&E firms and specialist trades working on staged payments.

What is inside

• How To Use and Quick Start guides, from download to working in ten minutes
• Contract Cash Flow
• Applications Diary
• Retention Ledger
• Job Bank
• Weekly Cash Check
• Payment Rights
• Notes and Actions, Log and Diary and Monthly Review tabs

How it works

Open the file in Microsoft Excel and read the How To Use tab first, it takes two minutes. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.

What you get

• One editable Excel (.xlsx) workbook with 10 tabs
• Built for Microsoft Excel, no macros and no formulas for you to write
• Example rows included so you can see every feature working
• Commercial licence, use in your own business, not for resale
• Instant digital download, no physical item shipped

Small print

Template only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.