Running a Hustle on One Free Spreadsheet

One file, four tabs, and you can stop signing up for things.

Five free apps went unused because each one asked you to learn where things live before it would hold a single job. A spreadsheet asks nothing. You type where you want and it stays typed.

The four tabs a solo hustle actually needs

Jobs, Money Out, People, Someday.

Jobs holds one row per piece of work: the date, who it was for, what you did, the price agreed, whether it is paid. That single tab answers the two questions you keep asking yourself, which are what came in this month and who still owes you.

Money Out holds one row per thing you spent on the work: date, what, where from, and which job it belongs to. That last column is the one people leave out and later regret.

People holds one row per human: name, number, how they found you, what they last bought, one note in your own words.

Someday is a parking lot. Prices to test, people to chase, an idea you had driving. Without it, the other three tabs fill up with clutter that has nowhere else to go.

What belongs in the money tab in detail is a topic of its own, covered in free bookkeeping tools for a one-person hustle, and the People tab is a lightweight version of a customer list kept without a CRM.

Laying a tab out so entering a row takes seconds

Date in the leftmost column, because that is what you will sort by.

After that, order the columns by the sequence in which you learn things. You know the date and the name before you know the price, and you know the price before you know whether it is paid. A layout matching the order of real life means you type left to right and stop.

Never create a column you cannot fill without looking something up. That column is where the habit dies.

Use values short enough to type with one thumb: y and n, paid and owed, a two-letter code for the service. Long values invite typos, and typos break the formula in the next section.

One header row. No title row above it, no merged cells, no blank spacer rows. Merged cells break sorting and confuse the phone app in ways that are awkward to undo. Freeze the header row and leave the formatting alone until the file has earned some color.

The one formula worth learning

SUMIF. It adds up a column of numbers, but only the rows where another column matches something you name.

Put one at the top of the Jobs tab totaling the price column where the paid column says n. That cell is now the answer to how much you are owed, sitting at the top of the sheet and updating the moment you type a new row.

Put another totaling the price column where paid says y. That is what came in.

On the Money Out tab, one SUMIF per job tells you what that job cost you, which is the beginning of knowing whether your price is right.

Its relative COUNTIF counts rows instead of adding them: how many jobs this month, how many people came from one source.

That is the whole toolkit. Pivot tables, lookup functions and charts are real skills, and none of them are needed to run a one-person operation out of a single file.

Using it from a phone without wrecking the layout

Install the spreadsheet app rather than opening the file in a mobile browser. Open it once while you have signal so it caches, and it will then work in a basement or a stairwell.

Add rows at the bottom. Never insert into the middle on a phone, because that is how a row ends up in the wrong place with nobody noticing.

Do not drag columns, do not resize them, do not try to add one from a phone. Structural changes belong on a computer, at a library if you do not own one. On the phone you are only ever typing rows.

Put the tabs in the order you use them, because switching tabs is a swipe and you will be doing it standing in a driveway with one hand full.

Add a home screen shortcut so the file is one tap from the lock screen. At four taps you will tell yourself you will do it later.

Where the file lives matters as well, and the storage cap on a free account covers what happens when the account holding it fills up.

Building the whole thing in one sitting

In order.

1. Create the file. Name it the business name and nothing else, so you can find it by typing one word. 2. Rename the first sheet to Jobs and add the other three tabs. 3. Type the header rows. Do not style them. 4. Enter your last five real jobs, from your messages or from memory. This is the step that gets skipped, and it is the one that turns a blank template into a file you believe. 5. Add the two SUMIF cells at the top of Jobs. 6. Open it on the phone and add the home screen shortcut. 7. Set a repeating weekly alarm with the file name as the label.

Sending the invoice itself sits outside the sheet, and free invoicing apps and how an invoice actually works covers the document and the wording.

Where the sheet stops and the habit starts

The file is inert. It will not tell you an invoice is overdue, will not chase a deposit, will not flag the customer who drags payment out every time. Each of those depends entirely on you opening it.

So the whole thing rests on one habit: fifteen minutes, the same slot every week. Enter what is not entered, read the owed cell, send the chase messages, move one line out of Someday.

If you know you will not do that, be honest about it now. Software that nags is worth more to you than a file that waits, and the point where a sheet has stopped being enough is the subject of when a free tool starts costing you work.

Two other places a sheet gives out: two people editing at once, and any process that needs a reminder to reach somebody other than you.

Set the alarm before you close the file.