Web Design Agency monthly financial report
A web agency report should show work done against money collected for each project. That gap is where cash goes missing.
The six numbers for a web design agency
| Number | How to work it out | What it warns you about |
|---|---|---|
| Projects in progress and their value | From your project list | The work that has to turn into cash |
| Collected against work done | Cash received ÷ value of work completed | Projects running ahead of payments |
| Final payments waiting on launch | Balances due at launch | Cash the client controls |
| Care plan revenue | Monthly hosting and maintenance billing | The base that pays every month |
| Payroll, share of revenue | Team cost ÷ revenue | Projects priced below the hours they take |
| Weeks of payroll in the bank | Cash ÷ weekly payroll | Room for a slipped launch |
Use these six in place of the general ones on the template's Report tab.
What to watch in a web design agency
- Projects stuck waiting on client content
- Final payments more than 30 days past launch
- Work outside the original scope that has not been billed
Not sure how much cash you should hold? Use the web design agency cash calculator.
Get this done for you every Monday
One Page CFO reads your QuickBooks, builds your 13-week cash forecast and your one-page report, and a CFO checks both. $500 a month.