What is in the expense tracker spreadsheet?

Settings (business name, year, currency), a categories tab with monthly budgets, an expense log, an income log and a monthly summary by category with totals, the amount marked tax-deductible, income and net.

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel. It uses only standard formulas and no macros.

Can I use it as a bookkeeping spreadsheet for my small business?

Yes, for simple cash bookkeeping: log money in and money out and read income, expenses and net per month. It is not double-entry accounting software and it does not file taxes.

Can I change the categories?

Yes. Type your own categories and budgets in the editor before you download, or rename them later in the Categories tab. The dropdown in the expense log follows the list.

How do I record a refund?

Type it as a negative amount in the same category. The totals go down by that amount.

Expense Tracker Spreadsheet for Small Business - Excel & Google Sheets

Expense tracker spreadsheet for your small business

Write down every business expense once: the date, who you paid, the category, the amount, how you paid and whether you consider it tax-deductible. The spreadsheet sorts it into months and categories for you.

Set a monthly budget per category and see what is spent and what is left for the year. Add your income too, and every month shows income, expenses and net. It runs in Excel and Google Sheets with plain formulas and no macros.

A simple bookkeeping spreadsheet for expenses and income

Most freelancers and shop owners do not need accounting software to know where the money goes. This bookkeeping spreadsheet has an expense log with room for 1,000 rows, an income log for 500 payments, and a summary that turns both into a monthly profit picture. Pick categories from a dropdown so the totals stay clean.

Category, payment method and Yes/No dropdowns
Up to 20 categories with your own names
Income vs expenses = net for each month
Year total for every row

Monthly budget by category

Type a monthly budget next to each category (or leave it blank). The categories tab multiplies it by twelve and shows spent this year, the amount remaining and the share of the budget used, so you see an overspend in advertising or software early.

Tax-deductible totals from the expenses you mark

Mark each expense Yes or No and the summary totals what you marked as deductible per month and for the year, ready to hand over at tax time. What counts as deductible depends on where you live and your business, so ask your accountant or tax preparer; the spreadsheet only adds up what you mark.

A small business spreadsheet that stays yours

The file is yours to keep: no subscription, no account, no bank connection. Choose your business name, the year and your currency symbol before you download. Every total is a visible SUMIFS formula you can check, and dates outside the chosen year are left out, so next year you start a fresh copy.

How it works

Pick a design and open it in the editor.
Change the text and colors. The preview is free and shows a watermark.
Pay once with a card through Stripe and download the clean file right away.

Ready when you are

Try it free, pay only for the clean file.

Start editing free