Contractor pack · 2 workbooks

Know which jobs make money, and the week cash gets tight.

A job costing & WIP schedule plus a 13-week cash flow forecast. Type the contract, cost and billing numbers you already know; the files work out percent complete, over/under billing, profit by job and your lowest cash week.

$39USD · 2 .xlsx files (8 tabs + 7 tabs) · instant download
Buy on Etsy Buy direct

Checkout and instant download on Etsy (Etsy may add sales tax or VAT). 14-day file guarantee.

  • For Microsoft Excel & Google Sheets
  • No macros, no add-ins
  • Built by a CFO with 20+ years of experience
UYNOS Contractor Cash & WIP Pack: two Excel spreadsheets. Shows the actual Dashboard tabs of the 13-week cash flow forecast and the job costing & WIP workbook with fictional sample data.
Contractor Job Costing & WIP Schedule + 13-Week Cash Flow Forecast: rendered from the actual workbook with fictional sample data. Not an app screenshot.

What it does for you

Contractor Job Costing & WIP + 13-Week Cash Flow, in plain terms.

  • Stop being the bank on your own jobs

    The WIP schedule shows each job’s over- or under-billing, so you see where you have done the work but not sent the invoice.

  • Catch a cost overrun before the final invoice

    The Dashboard flags jobs with low margin, cost overrun, or over/under billing.

  • See the cash gap before it hits

    13 weeks of cash in and out. If any week falls below your minimum buffer, the status switches to WATCH and names the week.

  • A Checks tab in each file

    Live tie-outs say OK or ERROR, so a typed-over formula does not go unnoticed.

Inside the file

See the actual tabs.

Every image is drawn from the workbook itself with its fictional sample data. Select an image to open it full size.

Demo with one input changed (week 7 equipment $36,000 instead of $12,000): closing cash by week chart dips to $5,300 in week 7, below the $8,000 buffer, and Dashboard cell B11 shows a WATCH warning.
Demo with one input changed (week 7 equipment $36,000 instead of $12,000): closing cash by week chart dips to $5,300 in week 7, below the $8,000 buffer, and Dashboard cell B11 shows a WATCH warning.
What's included: two workbooks, 15 tabs. 13-Week Cash Flow Forecast (7 tabs) and Contractor Job Costing & WIP (8 tabs), with thumbnails of the Start here, Dashboard and Checks tabs and a list of every tab.
What's included: two workbooks, 15 tabs. 13-Week Cash Flow Forecast (7 tabs) and Contractor Job Costing & WIP (8 tabs), with thumbnails of the Start here, Dashboard and Checks tabs and a list of every tab.
Unedited crops of the Jobs tab (six sample jobs with contract, cost, billed and cash received) and the Forecast tab (13 weeks of cash in and out, closing cash 15,000 to 56,700). Fictional sample data.
Unedited crops of the Jobs tab (six sample jobs with contract, cost, billed and cash received) and the Forecast tab (13 weeks of cash in and out, closing cash 15,000 to 56,700). Fictional sample data.
How it works in three steps: enter settings such as opening cash and buffer, type weekly cash and job numbers in the blue input cells, then read the Dashboard status and flagged jobs. Previews are real cells.
How it works in three steps: enter settings such as opening cash and buffer, type weekly cash and job numbers in the blue input cells, then read the Dashboard status and flagged jobs. Previews are real cells.
Worked example in the WIP workbook: job J-101 is 75% complete with $58,000 billed, so it is flagged under-billed by $9,500. After changing one cell to $67,500 billed, the flag clears to OK.
Worked example in the WIP workbook: job J-101 is 75% complete with $58,000 billed, so it is flagged under-billed by $9,500. After changing one cell to $67,500 billed, the flag clears to OK.
Over/(under) billing by job chart from the WIP workbook sample data: J-104 under-billed $32,909 and J-106 over-billed $20,267, with plain-English notes on what bars above and below zero mean.
Over/(under) billing by job chart from the WIP workbook sample data: J-104 under-billed $32,909 and J-106 over-billed $20,267, with plain-English notes on what bars above and below zero mean.

What's included

2 .xlsx files (8 tabs + 7 tabs).

  • UYNOS_Contractor_Job_Costing_WIP_v1.2.xlsxStart here, Settings, Jobs (up to 40 jobs), Costs log (optional, up to 500 lines), WIP Schedule (print or save as PDF), Dashboard, Checks, Read Me.
  • UYNOS_13-Week_Cash_Flow_Forecast_v1.2.xlsxStart here, Settings, Forecast, Actuals, Dashboard, Checks, Read Me.
  • Fictional sample dataBoth files ship with sample numbers so you can see them working before you type your own.

Method in the WIP file: percentage of completion, cost-to-cost. Percent complete = cost to date ÷ estimated total cost (capped at 100%). Earned revenue = percent complete × (contract + approved change orders). Over/under billing = billed to date − earned revenue.

How it works

Three steps.

  1. Download the file from your Etsy account (Purchases) and open the Start here tab.

  2. Type your own numbers in the input cells (colour-coded; the legend is on the Start here and Read Me tabs). Formula cells calculate everything else.

  3. Read the Dashboard. If Checks says ERROR, the Checks tab tells you what to fix.

Compatibility

What we checked, and what we have not.

Recalculated and checked in Google Sheets and LibreOffice Calc, with the results compared against a separate calculation.

Microsoft Excel 2016+ / Microsoft 365BUILT FOR
Standard functions only. Not yet opened in Excel (desktop, Mac or online) by us; covered by the 14-day file guarantee.
Google SheetsCHECKED
Uploaded and recalculated; results matched.
LibreOffice CalcCHECKED
Full recalculation; results matched a separate calculation.
Apple NumbersNOT TESTED
Macros, add-ins, external linksNONE
PhoneFine for viewing; data entry is easier on a computer.

Honest limits

What it is not.

  • Not tax, legal or accounting advice, and not a substitute for your accountant. Your accountant decides how revenue is recognized for tax and financial statements.
  • Not connected to your bank, QuickBooks or any other software. It does not file anything.
  • No 1099/W-9 tracking, estimating or bid templates in this pack.
  • Not a physical product. Nothing is shipped.

Questions

Before you buy

Anything else: support@uynos.com. Real replies within 2 business days.

Do I need accounting knowledge?

No. Each file has a Start here tab with a worked example. The WIP terms (percent complete, over/under billing) are explained in the Read Me tab.

How many jobs can I track?

Up to 40 jobs on the Jobs tab and up to 500 lines in the optional Costs log.

Can I give the WIP schedule to my bank or bonding agent?

You can print the WIP Schedule tab or save it as PDF. Whether it meets a particular lender’s or surety’s requirements is up to them, so ask what format they want.

Is the 13-week cash flow file the same as the one sold on its own?

Yes. The pack includes the same 13-Week Cash Flow Forecast workbook. You do not need to buy both.

Will it work in Microsoft Excel?

It is built for Excel 2016 or later and Microsoft 365, using standard worksheet functions only (no macros, add-ins, external links or passwords). Our own testing so far was done outside Excel (see Compatibility above). If anything does not work in your Excel, the 14-day file guarantee applies.

How do I use it in Google Sheets?

Upload the .xlsx to Google Drive and open it with Google Sheets (or File > Import). Chart styling can look slightly different from Excel.

How do I get the file?

You buy on Etsy and download the .xlsx from your Etsy account (Purchases). It is a digital file; nothing is shipped.

What is the refund policy?

If the file will not open or calculate correctly in current Excel or Google Sheets, message us through Etsy (or email support@uynos.com) within 14 days of purchase. If we cannot fix it within 2 business days, we refund you in full. Because files download instantly, we do not refund for change of mind. Your consumer rights under local law still apply.

What does the license allow?

Single-user license: use it for your own business or for your own clients. Please do not resell or share the file itself.

How was it made?

Designed by UYNOS with AI-assisted tools and reviewed by a finance professional (a CFO with 20+ years of experience). Results were checked by recalculating the file and comparing against a separate calculation. The images on this page are renders of the actual file with fictional sample data.

A planning tool, not tax, legal or accounting advice

It calculates from the figures you enter and does not know your full tax position or legal obligations. It is not IRS-reviewed and does not file anything. Check your inputs and talk to a qualified accountant or tax professional before making tax, financing or legal decisions.

Get the file

Contractor Job Costing & WIP Schedule + 13-Week Cash Flow Forecast

$39USD · 2 .xlsx files (8 tabs + 7 tabs) · instant download
Buy on Etsy Buy direct

Checkout and instant download on Etsy (Etsy may add sales tax or VAT). 14-day file guarantee.

Related templates

Often used together