Freelance expenses spreadsheet layout
Keep every transaction on one tab, the log. Build summaries on other tabs that read from it. If you type figures into a summary by hand, the two will drift apart.
| Column | What goes in it | Example |
|---|---|---|
| A: Date | The day you paid | Mar 4 |
| B: Payee | Who you paid | Adobe |
| C: Description | What it was and why | Creative Cloud, monthly plan |
| D: Category | One of a fixed list (below) | Software & Tools |
| E: Project | Client or job, or "General" | Rivera Bakery rebrand |
| F: Amount | Number only, no currency sign | 59.99 |
| G: Paid with | Card, bank, cash | Business card |
| H: Receipt | Link to the image or file name | receipts/0304-adobe.jpg |
| I: Business share % | 100 unless it is mixed use | 100 |
| J: Deductible amount | =F2*I2/100 | 59.99 |
Freeze the header row and turn column D into a dropdown (Data validation in both Sheets and Excel) so categories are spelled the same way every time. A typo like "Sofware" quietly drops a row out of your totals.
GigBooks keeps the same structure without the formulas: each income and expense sits inside a project with a category and a receipt photo, and recurring costs like subscriptions post automatically. Get it on Google Play
Business expense categories for taxes
Schedule C groups expenses into its own set of lines. You do not have to copy them exactly, but keeping your categories close makes the year-end transfer quick. A workable list for a freelancer:
| Category | What belongs here |
|---|---|
| Office Supplies | Paper, ink, postage, small desk items |
| Software & Tools | Subscriptions, plugins, cloud storage |
| Equipment | Computers, cameras, larger gear |
| Communication | Phone and internet (business share) |
| Marketing | Ads, website hosting, domain, printed portfolio |
| Professional Services | Accountant, lawyer, subcontractors |
| Travel | Out-of-town trips for work |
| Transportation | Local business driving, parking, tolls, rides |
| Meals | Business meals (record who and why) |
| Other | Fees, dues, insurance, anything that fits nowhere else |
Ten or so categories is enough. Too many and you spend time deciding; too few and "Other" becomes half your spending. If one kind of cost keeps landing in Other, give it its own category. What counts as deductible is covered in our 1099 deductions list.
Formulas to track business expenses in a spreadsheet
Assume the log tab is called Log, with data from row 2 down. On a Summary tab:
- Total by category: =SUMIFS(Log!J:J, Log!D:D, A2) with the category name in A2
- Total by project: =SUMIFS(Log!J:J, Log!E:E, A2) with the project name in A2
- Total for one month: =SUMIFS(Log!J:J, Log!A:A, ">="&B1, Log!A:A, "<"&C1) with the first day of the month in B1 and the first day of the next month in C1
- Category by month: add both conditions to one SUMIFS, or use a pivot table with Category as rows and Date (grouped by month) as columns
Use column J, the deductible amount, for tax totals, and column F when you want what actually left your account.
Add income to see profit
An expenses sheet tells you what you spent. To know what you earned, add an Income tab with date, client, project, invoice number and amount. Then profit for any project is income for that project minus expenses for that project.
| Project | Income | Expenses | Profit |
|---|---|---|---|
| Rivera Bakery rebrand | $4,800 | $620 | $4,180 |
| Podcast artwork (retainer) | $1,500 | $85 | $1,415 |
| General (not tied to a client) | $0 | $410 | -$410 |
| Total | $6,300 | $1,115 | $5,185 |
Figures are an example. Laid out this way, the totals turn straight into a profit and loss statement.
A monthly routine that keeps the sheet usable
- Once a week, enter anything you paid and save the receipt image with a consistent name (month, day, payee).
- At month end, download your bank and card statements and tick off each business line against the log.
- Add anything missing: fees, automatic subscriptions, and cash purchases are the usual gaps.
- Check the Other category and move rows that belong elsewhere.
- Note the month's profit and move a share of it to savings for tax (see how much to set aside for taxes).
A spreadsheet works well while volume is low. It gets harder when receipts pile up on your phone and you are matching photos to rows weeks later. If you notice you are entering a month at a time, the routine has stopped working and you will start missing small costs.
Skip the weekly catch-up
In GigBooks you tap the project, snap the receipt and enter the amount. The home screen shows the month's income, expenses, profit margin and category breakdown.
Get it on Google PlayiPhone version coming soon
More guides
- 1099 Deductions List: What Freelancers Can Write OffA plain 1099 deductions list for freelancers and contractors: common write-offs, the ordinary-and-necessary test, mixed-use costs, and the records each one needs.
- How Much to Set Aside for Taxes When You're Self-EmployedHow much of your 1099 income to set aside for taxes: what the money has to cover, how to work out your own percentage, and how it ties in with quarterly estimated taxes.
- How Long to Keep Receipts for Taxes as a FreelancerHow long to keep receipts for taxes if you're self-employed: how the IRS retention periods work, which records to hold longer, and whether photos of receipts are enough.
- Self-Employed Profit and Loss Statement: Example and TemplateHow to write a self-employed profit and loss statement: the sections, a worked freelance example, profit by client, and what lenders and landlords look for.
Published by Zoranta, the developer of GigBooks.