Local Shift › Income & expense tracker

Guide

Freelance interpreter income and expense tracker spreadsheet

How to organize what you billed, what was paid and what you spent, in one simple workbook.

Why a spreadsheet is often enough

Most freelance interpreters do not need accounting software on day one. They need to know three things: what they have billed, what has actually been paid, and what they have spent on the work. A spreadsheet answers all three, costs nothing to run, and keeps your data in a file you control.

The trick is to enter each fact once. If an assignment appears in three different tabs, the numbers will drift. Instead, keep one assignment log and let totals read from it.

Income: one row per assignment

For income, a good assignment log records:

• Date, client or agency, and a job reference number
• Language pair, assignment type (medical, legal, community and so on) and mode (in person, phone, video)
• Start and end time, and the hours that result
• Rate type: hourly, minimum block or flat fee
• Amount billed, invoice number, and whether it has been paid, with the date it was paid

The “paid?” column does most of the work. Filter it to “No” and you have a chasing list. Add the invoice date and you can see which clients pay slowly.

Expenses: keep the list short and consistent

For expenses, the habit that matters is recording each one when it happens, with the same categories every time. A simple log has a date, a vendor, a category, an amount and a note about the receipt. Category ideas that many freelancers use, which you can rename to suit yourself:

Whether any particular expense counts as a business deduction depends on your situation and where you live. We list categories only to help you organize. A tax professional can tell you what applies to you, so take them your totals and receipts.

Put it together: the summary view

Once income and expenses live in clean logs, a summary tab can total them by month and quarter. Three views are worth having:

1. Billed by month, so you can see how busy you have been.
2. Unpaid by age, such as 0–30, 31–60 and 61+ days, so you know who to follow up with.
3. Totals for your tax preparer: billed, paid, miles and expenses for the year, in one place.

A summary like this is not a profit-and-loss statement, and it does not calculate taxes. It simply puts your own numbers side by side.

Small things that save big headaches

• Start a new copy of the file each year, or add a year setting so totals only count that year.
• Back up the file. A cloud folder or a weekly copy to a USB drive is enough.
• Use data checks, such as a flag when an assignment has no client or no date.
• Keep confidential details out. Use reference numbers, not party names.

Ready-made options

We made two files so you do not have to build this from scratch. The free Interpreter Earnings & Mileage Tracker is an assignment log with automatic hours and fees, paid and unpaid totals, and monthly mileage and earnings totals. The full Interpreter Business Kit has eight tabs: Start Here, Settings, Clients, Assignments, Invoice, Mileage, Expenses and Summary, with hourly, minimum-block and flat-fee billing, a printable invoice, an expense log with editable categories, and the unpaid-by-age view. We tested the import and formulas in Google Sheets and LibreOffice. Both are plain spreadsheets with no macros or add-ons. Sample data is included and easy to clear.

Prefer to build your own? The columns above are all you need.