Weekly Expense Tracker: Free Template for the Self-Employed

Get the free weekly expense tracker template

The Google Sheets version sits at the top because that's what most people came for. The other three formats use the exact same structure, so moving from one to another means nothing new to learn.

• Google Sheets (one-click copy). Hit the link and click Make a copy, and your own copy lands in your Drive, auto-totaling as you type and ready to share with your accountant in two clicks.
• Excel (.xlsx). The same dropdowns and formulas as the Sheets version, and it opens in Excel 2010 and later.
• PDF. Print-ready, so you can fill it in by hand or in Acrobat.
• CSV. Raw data for accountants, QuickBooks imports, or your own spreadsheet.

The template belongs to you the moment you click, and we don't ask for your email to hand it over. I built it from 2.4 million real receipts, so the category list matches what a real business actually reaches for.

And if typing receipts isn't your thing at all, there's a way to skip the spreadsheet entirely. More on that near the end.

If you got paid on a 1099, you may unlock two big tax breaks

Before you scroll on, here's the part that can put real money back in your pocket.

If you got paid on a 1099 form this year, even once, the IRS already counts you as a business. It isn't scary, and being a business opens up two tax breaks a regular paycheck never gets. Most people never claim them.

• The miles you drive for work. For 2026 the IRS lets you knock 72.5 cents off your taxable income for every mile you drive for work. Drive 5,000 work miles and that's a $3,625 deduction (5,000 × $0.725). Most people keep the gas receipt and forget to write down the miles, and the miles are usually worth far more than the gas. Our free mileage log makes it easy, and our app can track the miles for you by GPS.
• A home office. This is the big one, and the one people lowball. The only rule is that the space has to be used just for work, like a desk or a spare room, not the kitchen table you also eat dinner at. The easy way to claim it is $5 a square foot, so a 150-square-foot room is a $750 deduction. The bigger way deducts your business share of rent or mortgage interest, utilities, and insurance, which often runs into the thousands. The math is a pain to do by hand, so our free home office calculator figures both ways from your address, for renters and owners alike.

Here's why a weekly tracker matters for this. Every one of those costs is a deduction, which means it comes straight off the income you pay tax on. Write them down all year and they add up to a big slice of tax you simply don't owe. Skip them and you hand the IRS money for nothing.

You are not a rare case here. Nearly 31 million Americans file as self-employed on a Schedule C, and a single 1099 is all it takes to join them. A weekend of side work, a few delivery shifts, an Etsy shop, one freelance gig: any of it counts. If that's you, our free 1099 expense tracker drops every cost onto the right Schedule C line for you.

Why track expenses weekly instead of at year-end

Here's the number that makes the case for a weekly habit. 28.5% of those 2.4 million receipts have no category attached at all. Almost a third get filed without a tag. And the people filing them use a one-tap app where picking a category takes a single tap. On a paper pile or a free-text spreadsheet, the blank rate runs even worse.

Every uncategorized receipt becomes a guess at tax time. It's a guess about a $42 charge from last July, made in a panic the night before your return is due. Guesses don't survive an audit, and they usually get rounded down to nothing.

A weekly review is the fix. When you sit down once a week, you're sorting receipts you collected days ago, not months ago. You remember that the $42 was supplies for a job, so you write it down while it's fresh. By April the work is already done, and the totals are real instead of reconstructed.

A weekly rhythm gives a one-person business three things a year-end scramble can't:

1. You catch cash-flow problems early. When you check weekly, you spot a category creeping up and can set a soft cap for the next week. That beats finding out in February that you spent twice what you thought on subscriptions.
2. The records hold up. Receipts you categorize close to the purchase are accurate, while the ones you tag eight months later are mostly guesswork.
3. Tax season stops being a project. Ten minutes a week across the year beats a lost weekend in April rebuilding the whole thing from a shoebox.

The 15 expense categories real small businesses use

A real business spends across more than six or eight categories. So I went and looked at exactly what people buy. Across 2,429,865 receipts from 12,310 small businesses on Shoeboxed since January 2024, here are the categories that show up most often:

The top three, Meals, General Retail, and Auto/Fuel, cover almost a third of every receipt small businesses file. Each of those three gets its own category in the template, instead of being buried in a sub-line.

A quick note on Groceries at #4: lots of self-employed folks track grocery runs out of habit, and most of those don't qualify on Schedule C. The template keeps the column so you can still log it, and the label reminds you it usually isn't deductible.

The fix for blank categories is a dropdown menu of set choices, not a box you type into. In our own data we see one single category, cost of goods sold, spelled four different ways: COGS, Cost of Goods, Cost of Goods Sold, and Purchases Cost of Goods. Real data runs messy. Your tracker can stay clean.

Your weekly 10-minute review, step by step

This is the whole habit. Pick a regular time, like Sunday evening or Friday at close, and run the same short loop each week.

Step 1: Gather the week's receipts

Pull together everything from the last seven days: the paper receipts in your wallet, the email confirmations from Amazon and Uber, the photos in your camera roll, and the parking stub still folded in your jacket. A week's worth is a small, manageable pile, which is the whole point.

Step 2: One row per receipt

Fill the six fields across each row: date, vendor, amount including tax, category, business purpose, and notes. Don't overthink it. The template runs left to right, so type what you see on the receipt.

Step 3: Pick the category from the dropdown

Click the Category cell and pick from the 15 options. Don't free-type. The dropdown keeps one category from turning into four near-misses. Each receipt type belongs in its own category, and consistency is what makes the totals usable in April.

Step 4: Write one line of business purpose

This is the field most people skip, and it's the one an auditor cares about most. "Gas to drive to a job on Pine Street." "Printer ink for invoices." One specific sentence per receipt. While it's a week old you remember, but eight months later you don't.

Step 5: Check the running total and save the original

Glance at the auto-total at the bottom. That's your spending log for the year, building one week at a time. Then save the original receipt as a photo, scan, or filed paper. The sheet works as the index, and the receipt itself proves the expense. If you lost a receipt, write a quick note covering the date, vendor, amount, and reason. That beats nothing.

That's the loop. Most one-person businesses settle into a review that takes about ten minutes, and the file does the math for you all year.

The 4 things every expense entry needs, per the IRS

The IRS spells out what counts as an adequate record. Every entry needs four elements.

"You should be able to prove the elements of an expense or use of property. Generally, you must have documentary evidence, such as receipts, canceled checks, or bills, to support your expenses."

Source: IRS Publication 463.

The four required elements per entry:

1. Date. The day you paid.
2. Amount. What you paid, including sales tax.
3. Vendor or payee. Who you paid.
4. Business purpose. Why this expense counts as business.

The template ships with a column for each of the four. An entry without a business purpose is half a record. For the official line on which expenses qualify in the first place, see Schedule C and its instructions.

Real deduction math: what weekly tracking is worth in 2026

Walk through the numbers with me.

Say you're a Schedule C filer with 100 business receipts a year averaging $50 each. That's $5,000 in business expenses. At a 24% federal bracket, typical for self-employed earning $80K to $160K, that $5,000 cuts your tax bill by $1,200.

Now apply the 28.5% blank-tag rate from our data. If 28.5% of your receipts get filed without a category, $1,425 of that $5,000 lands in a what was this? pile at tax time. Some of those entries get lumped into "Other," and some get dropped, because you can't confidently defend an expense you can't explain. Whatever slips through is money you already spent but can't deduct, and at a 24% bracket that $1,425 is up to $342 in tax you didn't have to pay.

Scale that to 500 receipts a year and the number at risk runs closer to $1,710. The weekly review is what closes the gap. Two minutes per receipt while it's fresh beats eight hours of forensics in April, and it keeps your real deductions on your return instead of in the "Other" pile.

What 20 years of receipts looks like

Shoeboxed launched in 2007. We've processed receipts for almost twenty years, and we see what real small-business expenses look like at scale every day.

That's where the 2.4 million number comes from, and it isn't a survey or an estimate. It's the actual mix of what our customers spend money on, sorted and categorized by real people in our Durham office so the records would hold up if the IRS ever asked.

Paper isn't dead. A big chunk of what our customers send us still arrives by mail, phone photos make up another big chunk, and email forwards round out the rest. That input mix is exactly why the template comes in four formats. However your receipts show up, there's a version that fits.

Audit-proofing: 3 small habits that hold up under review

The IRS doesn't audit at random, they flag returns where the records look thin. These three habits cover most of what holds up under review.

Habit 1: Photograph thermal receipts the day you get them

The thin paper receipts from gas stations, drug stores, and restaurants fade in 6 to 12 months. By the next tax season, half of them read as blank slips. Snap a photo the same day, before the ink walks off.

Habit 2: Categorize as you go, not at year-end

This is the whole argument for a weekly review. Remember the 28.5% blank-tag rate from our data? Almost all of those are last-minute filers trying to remember in March what a charge in July covered. A weekly pass means every receipt gets its category while you still know the answer.

Habit 3: Write the business purpose in one sentence per receipt

Specific beats generic every time. "Boxes and tape to ship an order." "Gas for the drive to a job at 4400 W Pine." Specific is what an auditor wants to see when they ask why this expense belongs on your Schedule C.

If you run a home office, our free home office calculator walks through what a defensible claim looks like. No signup.

If you'd rather not type at all

I'll be straight with you. Typing receipts into a spreadsheet is the slowest way to do this. Some people like the control, but most people skip the typing when they can.

Here's what we built at Shoeboxed for the second camp:

• Magic Envelope. Stuff your receipts in the postage-paid envelope and mail it to us. Our team in Durham scans the paper, and the software pulls the date, total, vendor, and category into your account. It works like a bookkeeper who lives in your mailbox.
• Mobile app. Snap a photo of any receipt. The software reads vendor, amount, date, and category and writes them into your account. You never type a number.
• Automatic mileage tracking. The app logs your business trips by GPS in the background, then texts you a daily summary. Tap the trips that count as business.
• Real US support. When you have a question, you reach a real support team in our same Durham office. More about the team.

We keep the actual receipt image, not just the numbers, and you keep everything for as long as you have an account. You can download or export all of it even if you leave.

If the spreadsheet is enough, keep the spreadsheet. If you ever want to stop typing, Shoeboxed Pro runs $29 a month with a 30-day money-back guarantee. And whether you sign up or not, the free home office calculator is worth two minutes, since most home-based filers leave four figures on the table every spring.

Start a Shoeboxed account →

Either way, the template above belongs to you.

Frequently asked questions

What is a weekly expense tracker?

A weekly expense tracker is a spreadsheet or app where you record every business expense once a week, with the date, vendor, amount, and category for each one. Reviewing weekly instead of at year-end means you categorize each receipt while you still remember what it was for, which is what makes the totals usable at tax time.

What is the difference between a weekly expense tracker and a weekly spending log?

They're the same tool with two names. A weekly spending log and a weekly expense tracker both record what you spent, by category, week by week. The template on this page works as either one, so pick whichever name makes more sense to you.

How often should I review my weekly tracker?

Once a week is the point. Pick a regular time, enter the week's receipts, pick a category for each from the dropdown, and check the running totals. The review takes about ten minutes for most one-person businesses, and it keeps tax season from turning into a project.

Can I use the tracker for personal and business expenses?

You can, and many self-employed people do. Keep business and personal on separate rows or separate copies so the business totals stay clean for Schedule C. The category labels flag the common personal lines, like Groceries, that usually don't qualify as a business deduction.

Is there a free weekly expense tracker?

Yes. The Google Sheets template above is free, and so are the Excel, PDF, and CSV versions. None of them ask for your email or run a free trial in the background. They ship with the 15 categories real small businesses use, drawn from 2.4 million receipts.

Wrap

A weekly expense tracker works because it's small enough to keep up with. Ten minutes a week, the 15 categories built from real receipts, the four IRS-required fields in every row, and the totals build themselves across the year.

Want the same template framed for month-end? Grab the Google Sheets expense tracker. If you work in Excel, the Excel expense spreadsheet is the same tool. And if you're paid every two weeks, the bi-weekly budget template gives each paycheck its own column.

Tracking income too? The free Income and Expense Worksheet adds a second tab for the money coming in, same 15 categories on the expense side.

Ready for full books instead of just expenses? The Shoeboxed accounting spreadsheet template tracks income and expenses and maps every category to its Schedule C line.

Grab whichever format fits how you work. It's yours the moment you click, and we'll be here either way, almost twenty years into this.

About the author

I'm Doug. I bought Shoeboxed in late 2025 with an SBA loan and 5% down, so I run a small business and sweat the same tax bill you do. I'd used Shoeboxed myself back in 2010 at a previous gig and called it magical even then, and I use it daily now. I write these guides because the surest way to grow Shoeboxed is to help small business owners keep more of what they're legally entitled to.

Sources

• IRS Publication 463, Travel, Gift, and Car Expenses (adequate records).
• About Schedule C (Form 1040), IRS.
• Standard Mileage Rates, IRS (2026 business rate, 72.5 cents per mile).
• SOI Tax Stats, Nonfarm Sole Proprietorship Statistics, IRS.
• Recordkeeping for small businesses, IRS.
• Shoeboxed aggregate receipt data: 2,429,865 receipts across 12,310 active small-business accounts since January 2024 (28.5% filed with no category).