Manaz Afzal Book a consultation

Work snippet

13-week cash view for a service business

Concept DesignIllustrative integration walkthrough. Business details, figures and records are worked examples.

A rolling weekly cash view for the coming quarter, read from the open invoices, bills and fixed costs already in Xero, with a floor the balance should not cross and every assumption on the page.

The problemCash surprises arrive with no warning.

What changesA weekly 13-week view with a buffer line and the assumptions written down.

Area
Cash
Tools
Xero · Google Sheets
Typical scope
US$180-400
Timeline
About 3 weeks · fixed milestones

The problem

A profitable month can still be a tight one. Customers pay a few weeks after the job, materials and wages go out first, and BAS and super land on fixed dates, so the bank balance tells the owner where cash was, not where it is going.

  • A bank balance that dips after a big materials order
  • Late-paying customers not factored in
  • Supplier bills paid before cash arrives
  • No view of next month, only last month

Approach

  1. Look

    Read-only review of open invoices, open bills, and 12 months of how customers actually pay.

  2. Model

    Open invoices are timed on each customer’s real days to pay. Bills are timed on due dates. Overheads sit on their actual dates.

  3. Check

    The opening balance is agreed to a reconciled bank account. Week 1 is compared to what actually happened.

  4. Update

    A weekly update takes about 20 minutes and shows what changed and what to do.

Exhibit

13-week cash view (AUD, ex GST)
Minimum buffer $20,000W1$22,000W2W3W4W5$17,500W6W7W8W9W10W11W12W13$53,000
WeekW1W2W3W4W5W6W7W8W9W10W11W12W1313 wks
Cash in
Open customer invoices26,00022,00016,00011,0007,0004,0002,0001,000-----89,000
New work invoiced--4,00010,00016,00022,00026,00029,00031,00032,00033,00034,00034,000271,000
Total cash in26,00022,00020,00021,00023,00026,00028,00030,00031,00032,00033,00034,00034,000360,000
Cash out
Open supplier bills13,00010,0008,0005,0003,0001,500500------41,000
Materials, new orders-2,5005,5008,50011,00013,00014,50015,50016,50017,00017,50017,50018,000157,000
Subcontractors3,5003,5004,0004,0004,0004,5004,5004,5004,5005,0005,0005,0005,00057,000
Rent and overheads9,5003,2003,2003,2009,5003,2003,2003,2009,5003,2003,2003,2009,50066,800
Loan repayments-2,400---2,400---2,400---7,200
Total cash out26,00021,60020,70020,70027,50024,60022,70023,20030,50027,60025,70025,70032,500329,000
Net movement-400-700300-4,5001,4005,3006,8005004,4007,3008,3001,50031,000
Closing cash22,00022,40021,70022,00017,50018,90024,20031,00031,50035,90043,20051,50053,00053,000

Assumptions written under the table

  • Opening cash $22,000, the bank balance on the first day, agreed to the Xero bank reconciliation.
  • Open customer invoices are collected on each customer’s usual days to pay from the last 12 months.
  • New work uses booked jobs plus a prudent run-rate; it is a range, reviewed each week.
  • Supplier bills are paid on their due dates. Materials follow new work at a fixed share of revenue.
  • Overheads and loan repayments are on their actual dates.
13-week cash view: closing cash by week, with week 5 at $17,500 against a $20,000 buffer.

How to read it

  1. The lowest week is marked. In this model, week 5 closes under the minimum buffer.
  2. Cash in and cash out are split so the cause of a dip is easy to see.
  3. The assumptions are listed under the table, so anyone can challenge them.

Scope

AreaIncluded
ReviewOpen invoices, open bills and 12 months of payment timing, with findings
ModelA 13-week Google Sheets model, with cash in, cash out and closing cash by week
BufferA minimum cash buffer agreed with the owner and shown on the chart
Opening positionOpening balance agreed to a reconciled bank account
AssumptionsWritten under the model and reviewed with the owner
Weekly updateA 20-minute routine and a checklist, run together for the first two weeks
Not includedAnnual budgets and profit forecasts, which are scoped separately

Milestones and fee

MilestoneDeliverableTimingShare of fee
M1 ReviewFindings and assumptions listWeek 125%
M2 Model built13-week model on your Xero dataWeek 235%
M3 First two updatesTwo weekly updates run togetherWeeks 2 to 325%
M4 HandoverChecklist and walkthroughWeek 315%

Typical scope for this kind of project: US$180-400

About 3 weeks · fixed milestones. The systems health check (US$150, fixed) comes first and confirms the scope. Extra hourly work is US$35 per hour, agreed before it starts.

Discuss an engagement.

Outline the operational problem through the contact form. I respond with a recommended starting point, including whether the US$150 systems health check is the appropriate first step.

Related work snippets

Next step

Bring me the work that repeats.

I scope it in writing, test it against your current process on your own data and hand over everything I build.

Book a consultation