Freelance Consultant Income and Expense Spreadsheet Template
A consultant's income is lumpy: a retainer from one client, a milestone from another, and a travel reimbursement that is not really fee income at all. This sheet keeps those apart so each month shows what the work actually brought in.
How a consultant gets paid, and what that means for the sheet
Consultants are usually paid in one of three shapes: a monthly retainer, fixed-fee milestones, or a day rate billed after the work. Many clients pay on net 30 or net 60 terms, so the invoice date and the day the money lands can sit weeks apart. Log Income when the payment arrives, and keep the invoice number in the Description.
Travel and materials often come back as a reimbursement line on the same invoice. Log the cost as an expense and the repayment as its own Income row, so a trip never hides inside your fee. When a milestone is paid as a deposit and a balance, enter two rows for the same client. A credit note is its own row too.
One example month, logged
Invented numbers, to show the shape. Each row below is one line on the Transactions tab.
| Client | What it was | Income |
|---|---|---|
| Harbor Logistics Group | Monthly advisory retainer, March | $3,500 |
| Pinecrest Health Partners | Operations review, milestone 2 of 3 | $5,200 |
| Atlas Ridge Capital | Two-day leadership workshop, facilitation fee | $2,400 |
| Linden & Pryor | Pricing analysis, final invoice | $1,800 |
| Income total | $12,900 | |
| Category | What it was | Expense |
|---|---|---|
| Software & subscriptions | Slide and diagram software, annual | $96 |
| Software & subscriptions | Survey tool for client interviews | $39 |
| Travel | Train fare to client site, round trip | $184 |
| Travel | Hotel, two nights on site | $420 |
| Professional fees | Bookkeeper, monthly | $150 |
| Contractors | Freelance researcher, market scan | $900 |
| Marketing | Industry summit conference pass | $650 |
| Home office | Standing desk converter | $210 |
| Equipment | Laptop docking station | $140 |
| Expense total | $2,789 | |
In this example the month ends with $12,900 in, $2,789 out and $10,111 left before you set anything aside for tax.
The P&L tab sorts the same rows by category:
| Expense category | Month total |
|---|---|
| Software & subscriptions | $135 |
| Equipment | $140 |
| Contractors | $900 |
| Marketing | $650 |
| Travel | $604 |
| Home office | $210 |
| Professional fees | $150 |
| Expense total | $2,789 |
Where a consultant's purchases go
- Travel: Client site visits belong here: train or flight fares, hotels, rental cars and meals on the road. Put the client name in Client / Vendor so you can match each trip to a reimbursement later. If one trip serves two clients, split the receipt into two rows.
- Contractors: A researcher, an analyst or a subject-matter expert you bring onto one engagement goes under Contractors. Name the client and the engagement in the Description, so a filter on the Transactions tab puts the project's cost beside its fee.
- Professional fees: Bookkeeper invoices and a lawyer's review of your contract template belong in Professional fees. Keep one row per provider invoice. If a firm bills advisory work and bookkeeping together, split the invoice into two rows.
- Software & subscriptions: Video calls, slide tools, survey platforms and research databases are all subscriptions. If one plan serves consulting work and a side project, split the receipt by your own rough share of use and write the split in the Description.
Four tracking tips for a consultant
- Start every Description with the engagement name, such as 'Pinecrest ops review'. One filter then shows every fee and every cost for that project, which is how you see whether a fixed-fee scope held up.
- List each milestone in the Invoices tab, then log the payment in the Transactions tab only when it clears. Type a retainer billed on the 1st but paid on the 20th into the Cash Flow tab under the month it lands.
- On the last day of each month, list your finished engagements and confirm each has a final row in the Invoices tab. Scope changes get agreed on a call and forgotten, so note each one in the Description when it happens.
- Put the client's name in Client / Vendor on every reimbursable expense. At invoice time, filter by that client and you have the exact list to attach. Ask your tax adviser how reimbursements should be reported.
Two formulas worth a cell of their own
These use the kit's Transactions tab (Type in column B, Category in C, Client / Vendor in E, Amount in F). Excel and Google Sheets both support SUMIFS.
- Spend in your biggest category, here Contractors:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Expense",Transactions!C:C,"Contractors")returns $900 on the example month. - Income from one client:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Income",Transactions!E:E,"Harbor Logistics Group")returns $3,500 on the example month.
Questions
How do I track a consulting retainer in a spreadsheet?
Log one Income row each time a retainer payment arrives, and write the month it covers in the Description. If the client pays late, the row carries the real payment date, while the Invoices tab shows it as Due or Overdue until you enter a Date paid.
How do I log travel that the client pays back?
Enter the trip as a Travel expense and the repayment as a separate Income row with the word reimbursement in the Description. Filtering the Transactions tab on that word then shows pass-through money apart from fee income, and the P&L tab keeps the trip on its own Travel line.
Already built
The Freelancer Finance Spreadsheet Kit has the Transactions, Invoices, P&L, Cash Flow and Tax Set-Aside tabs wired together, with this kind of example data on every tab. One Excel file, $29.
Free: the Tax Set-Aside tab as a standalone Excel file
One working tab: type your quarterly income, expenses and the rate you choose, and it shows what is still to put aside. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on tracking freelance money. Unsubscribe in one click. Privacy.
The same sheet for other freelancers
- All freelancer spreadsheet guides by profession
- Freelance Graphic Designer Income and Expense Spreadsheet
- Income and Expense Spreadsheet for Freelance Photographers
- Freelance Social Media Manager Income and Expense Spreadsheet
- Freelance Translator Spreadsheet for Per-Word Income and Costs
- Freelance UX Designer Income and Expense Spreadsheet
- Freelance Video Editor Spreadsheet for Income and Expenses
- Freelance Virtual Assistant Income and Expense Spreadsheet
- Freelance Voice-Over Artist Income and Expense Spreadsheet
- Income and Expense Spreadsheet for Freelance Web Developers
- Freelance Writer Income and Expense Spreadsheet for Articles
- Online Tutor Income and Expense Spreadsheet for Lesson Payouts
More freelancer finance guides
- Excel or Google Sheets for freelancer finances? What actually differs
- Freelance expense categories for a spreadsheet: a starter list that stays short
- How to build a freelance income and expense tracker in a spreadsheet
- A simple 12-month cash flow forecast for freelancers
- Freelancer profit and loss (P&L) in a spreadsheet: a one-page layout
- Freelancer runway: three spreadsheet formulas for how long your cash lasts
- Freelancer tax set-aside: what goes into the number, and how to track it
- Invoice tracker spreadsheet: formulas for paid, due and overdue
- Budgeting on irregular freelance income: the baseline-pay method
- How to track freelance income by client in a spreadsheet
General information about using spreadsheets, not financial, tax or accounting advice. Example numbers are invented. Categories are for tracking and do not say what is deductible.