A quarter of weekly cash columns, five billing changes, six planning steps for a hire and a note on using examples.
A quarter of weekly cash columns for a New Castle County, DE IT firm's client rollout
Illustration only, invented figures: an IT firm starts the quarter with $46,250, collects $18,740 of client fees each week, runs a $31,860 payroll every two weeks and pays $3,975 a week in other costs. In week 3 of this invented case it buys 28 workstations at $1,265 each, $35,420, for a client rollout, and the client repays $39,480 for them in week 11.
| Week | Cash in | Payroll | Other costs | Rollout purchase | Ending cash |
|---|---|---|---|---|---|
| Week 1 | $18,740 | $0 | $3,975 | $0 | $61,015 |
| Week 2 | $18,740 | $31,860 | $3,975 | $0 | $43,920 |
| Week 3 | $18,740 | $0 | $3,975 | $35,420 | $23,265 |
| Week 4 | $18,740 | $31,860 | $3,975 | $0 | $6,170 |
| Week 5 | $18,740 | $0 | $3,975 | $0 | $20,935 |
| Week 6 | $18,740 | $31,860 | $3,975 | $0 | $3,840 |
| Week 7 | $18,740 | $0 | $3,975 | $0 | $18,605 |
| Week 8 | $18,740 | $31,860 | $3,975 | $0 | $1,510 |
| Week 9 | $18,740 | $0 | $3,975 | $0 | $16,275 |
| Week 10 | $18,740 | $31,860 | $3,975 | $0 | -$820 |
| Week 11 | $58,220 | $0 | $3,975 | $0 | $53,425 |
| Week 12 | $18,740 | $31,860 | $3,975 | $0 | $36,330 |
| Week 13 | $18,740 | $0 | $3,975 | $0 | $51,095 |
In this invented 13-week cash flow forecast the balance dips to -$820 in week 10, the only week below zero, and ends week 13 at $51,095. A small line of credit draw in week 10, repaid in week 11, is the kind of request this sheet points to.
Getting paid sooner at a New Castle County, DE marketing agency: five billing changes
Before an agency asks how a business can improve cash flow with a loan, it can check how soon its own invoices go out and come back:
- Bill pass-through media and print costs when the agency commits to them, not after the campaign closes
- Issue the monthly fee invoice on the first business day of the month it covers
- Put card and bank-transfer payment links on every invoice
- Move annual software subscriptions to monthly billing where the vendor offers it
- Review unbilled hours every Friday so finished work does not wait a month for an invoice
Planning a CAD drafter's first quarter on paper at a Newark, DE engineering consultancy
How to prepare a cash flow forecast for a hiring plan comes down to putting the wage and the revenue on the same calendar:
- Write the start date, the gross pay per payroll and the employer payroll taxes on the weeks they fall
- Add the software seat and workstation the drafter needs, on the week each is paid
- Estimate when the first billable drawings go out on an invoice, using the client's actual payment terms
- Carry each week to an ending balance, as in the IT firm sheet above
- Mark the week with the smallest balance and the size of the shortfall, if there is one
- Ask whether that shortfall is a one-time gap or one that repeats with every hire, since the answer points to a loan or a line
Putting your own numbers into an example: an auto repair shop's weekly parts deliveries
The figures in these articles are invented, so the useful part is the structure. The six posts apply it to separate costs: an online tea seller's stock and pouches, hotel heat-treatment gear and guest e-bikes, an IT firm's SOC 2 audit, what moves a loan offer, repayment periods at an ENT office and franchise renewal costs. An auto repair shop reading the weekly sheet would swap in its own weekly card and fleet-account receipts, its payroll dates and its parts supplier's statement date. A shop that pays for parts weekly but collects from fleet accounts monthly may see its low weeks land just before those monthly payments, which is the pattern to describe on a call to (302) 532-4470.
By Truecrest Business Loans · Updated