ZorantaGuides
GigBooks

GigBooks › Guides

Freelance Expenses Spreadsheet: Columns, Categories and Formulas

A freelance expenses spreadsheet needs one row per transaction and a fixed set of columns: date, payee, description, category, client or project, amount, payment method, and a link to the receipt. Totals by category and by month are then a formula away.

Below is a layout that works in Google Sheets or Excel, a category list that lines up with how expenses are reported on Schedule C, and the formulas to summarize it.

Three colored project folders standing on a desk

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.

ColumnWhat goes in itExample
A: DateThe day you paidMar 4
B: PayeeWho you paidAdobe
C: DescriptionWhat it was and whyCreative Cloud, monthly plan
D: CategoryOne of a fixed list (below)Software & Tools
E: ProjectClient or job, or "General"Rivera Bakery rebrand
F: AmountNumber only, no currency sign59.99
G: Paid withCard, bank, cashBusiness card
H: ReceiptLink to the image or file namereceipts/0304-adobe.jpg
I: Business share %100 unless it is mixed use100
J: Deductible amount=F2*I2/10059.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

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:

CategoryWhat belongs here
Office SuppliesPaper, ink, postage, small desk items
Software & ToolsSubscriptions, plugins, cloud storage
EquipmentComputers, cameras, larger gear
CommunicationPhone and internet (business share)
MarketingAds, website hosting, domain, printed portfolio
Professional ServicesAccountant, lawyer, subcontractors
TravelOut-of-town trips for work
TransportationLocal business driving, parking, tolls, rides
MealsBusiness meals (record who and why)
OtherFees, 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:

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.

ProjectIncomeExpensesProfit
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

  1. Once a week, enter anything you paid and save the receipt image with a consistent name (month, day, payee).
  2. At month end, download your bank and card statements and tick off each business line against the log.
  3. Add anything missing: fees, automatic subscriptions, and cash purchases are the usual gaps.
  4. Check the Other category and move rows that belong elsewhere.
  5. 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.

This is general information, not tax advice. How expenses are reported and which costs are deductible depend on your situation. See IRS Publication 334 or ask a tax professional.
GigBooks

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 Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of GigBooks.