Freelancers often mix up money invoiced and money received, and a quarterly summary is where the difference shows. Record both columns: what you billed and what actually landed in your account, then list expenses by category. How your income is counted for tax, and when estimated payments are due, is for a qualified accountant to confirm.
Invoiced, received and outstanding
A client invoice sent on 28 February and paid on 14 April belongs to the first quarter if you think about invoicing and the second if you think about cash. Your summary should show both dates so nothing is lost either way, and your accountant can choose the method that applies to you.
| Invoice | Date sent | Amount | Date paid | Quarter received |
|---|---|---|---|---|
| Website build | 12 Jan | CA$3,000 | 20 Jan | Q1 |
| Logo work | 25 Feb | CA$800 | 10 Apr | Q2 |
| Monthly retainer | 1 Mar | CA$1,200 | 3 Mar | Q1 |
In this made-up case Q1 invoiced total is CA$3,000 plus CA$800 plus CA$1,200, which is CA$5,000. Cash received in Q1 is CA$3,000 plus CA$1,200, which is CA$4,200, with CA$800 still outstanding.
Expense lines that most freelancers need
- Software and subscriptions.
- Phone and internet, with the share you use for work noted.
- Equipment and repairs.
- Travel, parking and client meetings.
- Professional fees and bank charges.
For mixed-use lines such as a phone, record how you split the cost and keep that reasoning in your notes, then confirm the approach with your accountant.
A worked quarter
Using the CA$4,200 cash received, say costs were software CA$210, phone share CA$135, equipment CA$520, travel CA$165 and fees CA$48. Add them: CA$210 plus CA$135 is CA$345, plus CA$520 is CA$865, plus CA$165 is CA$1,030, plus CA$48 is CA$1,078. Cash received less costs is CA$4,200 minus CA$1,078, which is CA$3,122.
How much should I set aside?
Your accountant should give you a percentage or method that fits your situation. For arithmetic only, if you moved 20 per cent of each payment into a separate account, the CA$4,200 would produce CA$840. That figure is an illustration, not a suggestion.
What should I do with unpaid invoices?
Keep a separate list of unpaid invoices with the date sent, the amount and the due date, and review it when you do the quarterly summary. Chase anything that is more than a few weeks past due with a short, polite message. An unpaid invoice is not cash you can plan with, so keep it out of the set-aside calculation until it lands. Note any partial payments with their dates so the outstanding balance stays accurate.
Finally, keep last quarter's summary next to the new one. Looking at both side by side shows trends you will not notice otherwise: a subscription that crept up, a client who now pays later than before, or a month when equipment spending jumped. These small observations help you decide what to ask your accountant, and they make the next quarter faster because the categories are already in place.
A fifteen-minute quarterly routine
- Export the account statement for the three months.
- Match each deposit to an invoice and update the received date.
- Categorise every expense line.
- Total the columns and save the page as a PDF named with the quarter.
- Email it to your accountant or save it in your tax folder.
If you want to filter and group transactions by category and export to CSV, trackers with a report builder can do it; SpendixAI offers that, but it is built for India and INR, so a Canadian freelancer will likely be better served by a sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


