How to track freelance income and what records to keep

Income for actors and models consists of numerous small payments from various clients, with different payment terms and settlement methods. After a year of such work, someone who hasn't kept records cannot answer three simple questions: how much did I earn, who owes me money, and is it profitable to take a shoot for a specific amount? Below is a practical system that takes only fifteen minutes a week.

Three Tables That Are Enough

You don't need professional accounting software. Three sheets in a standard spreadsheet are sufficient.

1. Projects

One row for every job. Columns:

• shoot date;
• client — production company, agency, direct client;
• type of work — film, series, commercial, catalog, runway, voiceover;
• role or description;
• number of shifts or hours;
• agreed amount;
• net amount to be received after deductions;
• payment deadline per contract;
• actual payment date;
• status — pending, paid, overdue, disputed;
• comments.

The most critical columns are "payment deadline" and "actual payment date." Money is often lost because of their absence: a client fails to pay, the actor forgets, and six months later, it feels awkward or futile to bring it up.

2. Expenses

One row for every work-related expense:

• date, amount, category, comment, and which project it relates to.

Typical categories for actors and models include: transport, training, portfolio and test shoots, cosmetics and grooming, casting outfits, agency fees, communication and internet, rehearsal space rental, health and fitness, taxes, and commissions.

3. Castings

Formally, this isn't about money, but this table reveals your work efficiency:

• date, project, channel (agency, website, direct request, referrals), format (self-tape, in-person, online), result.

After six months, this table answers the question of where the actual money is coming from. Often, the result is surprising: the channel that takes up the most time brings in the least amount of work.

How to Calculate Your Real Rate

The amount in the contract is not what you actually earned. Your real rate is calculated as follows:

1. Take the net amount received after taxes and commissions.
2. Subtract direct expenses: travel, taxis, meals, parking, if not reimbursed.
3. Subtract preparation time: fittings, rehearsals, time spent memorizing scripts.
4. Divide by the total time spent, including travel and preparation.

Logic example: a shoot for a hypothetical 100 units looks good, but if 12 units went to travel and the total time spent was 14 hours instead of 8, the real hourly rate is half of what you had in mind. This isn't a reason to refuse the job — it's a reason to understand what you are comparing the next offer against.

Accounting for Downtime

A freelancer lives by the year, not by the shift. Calculate your average monthly income over a rolling 12-month period — this is the only figure that makes sense for planning. A month with three shoots and a month with zero is a normal distribution; panicking over the latter is pointless if the annual average is stable.

What to Archive

A minimal archive that prevents most problems:

• Contracts with all appendices and signatures — permanently, as long as usage rights are active, and for several years after.
• Payment confirmations and invoices — for the entire period required for tax reporting in your jurisdiction, usually several years.
• Correspondence regarding terms — at least until full payment is received, preferably longer. Include screenshots from messaging apps.
• Expense receipts that you track — according to reporting deadlines.
• Permissions to use materials in your portfolio — permanently.

Practical organization: a cloud folder, with subfolders by year, and further subfolders by project. Name files in the format "date — client — document type." Searching such an archive takes seconds.

How to Avoid Losing Money on Forgotten Debts

The most common financial loss in freelancing is not low rates, but unpaid work that was forgotten. Use this simple procedure:

1. On the day of the shoot, enter the project into the table with the payment deadline.
2. Set a reminder for "payment deadline plus three days."
3. If the money hasn't arrived — send a polite email with your payment details and the contract number.
4. After another week — send a follow-up email, copying the accounting department.
5. Next — have a written conversation with the producer or director.

More than half of overdue payments are not due to malice, but to a lost document or an accountant on vacation. A polite, timely reminder solves the issue without damaging relationships, while staying silent for three months turns the matter into a conflict.

Reminder Phrasing

A short, professional email works best: project name, shoot date, contract number, amount, agreed payment deadline, a request to clarify the payment status, and your payment details at the end. No emotions and no apologies for "bothering" them — this is a standard business procedure.

Consistency Over Precision

A perfect system that you maintain for one month is worse than a messy one that you maintain for three years. A habit that sticks is:

• On the day of the shoot — one row in the project table, 30 seconds.
• Once a week — enter expenses and check for overdue payments, 15 minutes.
• Once a month — summarize totals and look at averages, 30 minutes.
• Once a year — organize the archive, calculate annual income, and review your rates.

Annual Review: What to Analyze

• Total income and its structure. What share comes from film, commercials, or catalogs. Often, the "main focus" brings in less money than a side activity.
• Average check by work type. This is the basis for revising your rates.
• Casting conversion. How many auditions per one booking, broken down by channel.
• Expenses vs. Income. If spending on portfolios and training exceeds income for three consecutive years, it is no longer an investment, but a model that needs to change.
• Repeat clients. Those who hire you a second or third time are your real client base; they deserve separate attention.

Emergency Fund and Seasonality

Acting and modeling have seasonal peaks and valleys: slumps usually occur during long holiday periods and during the "off-season" for commercials. A useful rule is to keep a reserve for three to six months of basic expenses. This should be calculated based on mandatory spending: housing, food, communication, transport, and minimum professional costs, not on income.

A second rule: set aside a percentage of every payment immediately, rather than at the end of the month. Choose a manageable percentage; the key is mechanical regularity, not the amount.

Taxes: General Logic

Specific tax regimes, rates, and deadlines vary by market, so here are only the universal principles:

• set aside the tax portion upon receiving each payment, not right before the filing deadline;
• keep a separate account or at least a separate line in your records for taxes;
• clarify who is responsible for the tax in each contract — you or the client acting as an agent;
• keep track of expenses even if they don't currently reduce your taxable base; this data will be useful if you change your tax status;
• consult a professional once a year — it is cheaper than trying to figure it out yourself.

What Tracking Provides Besides Money

An unexpected effect: neat records change the conversation about your rate. An actor who says "I feel this is too low" and an actor who says "My average rate for a shift in this format is X, with twelve projects last year" are in two different negotiating positions. The latter sounds convincing because they operate with facts, not feelings.

The second effect is peace of mind. Most of a freelancer's financial anxiety stems not from a lack of money, but from not knowing how much they have and when it will arrive. A spreadsheet relieves this anxiety better than any reassurance.

Current projects and terms can be found in the castings section.