True outflow is what you spent on yourself plus whatever you have fronted and not yet recovered. Those are two numbers, and keeping them apart is the whole trick. Once you can see both every month, a late client payment stops feeling like a surprise shortfall.
What are the two numbers?
Own spending is the personal and business costs that nobody will repay you for. Fronted cost is anything a client will repay. Imagine a month with A$3,200 leaving your account. Of that, A$410 was fronted for clients. Own spending is 3,200 minus 410, which is A$2,790.
How do I calculate the carried amount?
Fronted costs from earlier months that are still unpaid count too. Suppose A$180 from last month is still outstanding and A$150 of this month's A$410 was repaid within the month.
| Item | Amount |
|---|---|
| Fronted last month, still unpaid | A$180 |
| Fronted this month | A$410 |
| Repaid this month | A$150 |
| Carried at month end | A$440 |
180 plus 410 minus 150 is A$440. That figure is money out of your pocket working for clients.
What formulas can I use?
In a sheet with Amount in C, Status in D and Date in B, from row 2 to 500:
- Own spending for November: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Personal", $B$2:$B$500, ">="&DATE(2026,11,1), $B$2:$B$500, "<"&DATE(2026,12,1))
- Fronted this month: the same, with "Fronted" in place of "Personal".
- Repaid this month: use "Repaid".
Both Excel and Google Sheets accept these functions as written. Check that your date cells are real dates, not text, or the date tests will return zero.
Why does it matter for planning?
Your savings plan and your bills run on the money in your account. If A$440 is tied up with clients, your usable cash is lower by that much. Watching it prevents the awkward month when everything is fine on paper but nothing is in the account.
Can an app save me the formulas?
When a sheet stops being enough, SpendixAI tags business versus personal, so reimbursable spending is easy to filter and export. It is built around India and INR and is not offered as a promise for Australia. Treat it as a feature list to compare against.
How long should unpaid costs sit before I act?
Know each client's normal payment time and use it as your yardstick. If a client usually pays within three weeks, a fronted cost still unpaid after five is worth a note. Do not set a universal deadline; clients differ, and a reminder that matches their own pattern sounds reasonable rather than pushy.
Keep a column with the date you fronted the cost and the date you billed it. The gap between those two is your own delay, and it is often longer than the client's. Closing it, by billing weekly instead of monthly, can improve cash flow without any difficult conversation.
How do I bill costs without chasing every month?
Add reimbursable lines to the invoice you are already sending. A separate invoice for A$18 invites delay; a line on the main invoice goes through with everything else. If you work on a retainer, agree upfront that costs will appear as a separate line each month, so there are no surprises. Fewer, larger invoices are easier for a client to process and for you to track.
Month-end checklist
- Total own spending and fronted costs.
- Update the carried amount.
- List what is more than a normal payment cycle overdue.
- Decide whether to raise the matter with the client.
This is about records. Tax and accounting treatment is outside the article; ask an accountant what applies to you.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

