● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Profit and Loss Tracker
Profit and Loss Tracker spreadsheet in a browser frame, hero view
BOOKKEEPING & BUSINESS FINANCE

Profit and Loss Tracker

Ask most small business owners what they earned last month and you will get an answer. Ask what they kept and the room goes quiet. This profit and loss tracker pulls your income and expenses into one file and turns them into a clean monthly statement, so the kept number is never a guess again.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Earned is one number. Kept is the one that matters.

It starts with two simple logs. The Income Log records every payment that lands, with who paid you, which account it belongs to and the date. The Expense Log does the same for every cost the business pays, sorted into its account as you type. The Chart of Accounts tab explains the income and expense accounts up front, so your entries land in the right places from the very first week.

Pick any month on the Monthly P&L tab and you get a finished statement: every line in place, each one also shown as a share of that month's income, which makes heavy costs easy to spot. The Annual P&L then lines all twelve months up side by side, so your strongest months and your slow, steady leaks sit in the same view. The Dashboard keeps the year headline on one screen.

The Tax Summary turns the same numbers toward the end of the year, with a quarterly estimate based on the tax rate you set yourself, so setting money aside becomes routine instead of a scramble. Nothing connects to your bank: you log entries yourself in about ten seconds each, which keeps the figures private and entirely yours. Setup takes about five minutes, and the EXAMPLE file shows a full set of books first.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one click copy link, so the tracker lands in your own Google Drive
  • BLANK Excel workbook, a clean fresh start for your own books
  • EXAMPLE Excel workbook with realistic sample books already entered, showing how logs turn into statements
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Google Sheets on a free Google account, and in Excel 2021 or Microsoft 365
  • The Excel files also import into Google Sheets in a few clicks
  • No bank connection by design, your figures stay private in your own files
  • Every currency works because amounts are plain numbers
  • Use it on computer, tablet or phone, and message us on Etsy if you get stuck

Questions about this template

The things buyers ask us most.

Does it connect to my bank account?

No, deliberately so. Every payment and cost is logged by you, about ten seconds an entry, so your numbers stay completely private and never depend on a bank feed working. Nothing about your business leaves your own files, and the tracker keeps working even if you change banks or accounts along the way.

I am self employed. Is this too big for me?

Not at all. It was built with freelancers, sole traders and small teams in mind, people who do their own books and want a proper statement without accounting software or a monthly subscription. If you can type a date and an amount, you can run it: the logs take your entries and the statements build themselves at the end of the month.

Can I rename the accounts or add my own?

Yes. The Chart of Accounts tab holds the full list of income and expense accounts, and you can rename entries or add new ones to match your business. Just use the same spelling in the Income Log, the Expense Log and the statements, and everything keeps flowing to the right lines on your monthly and annual P&L.

Does it work out my taxes for me?

It gets your numbers ready and estimates a sensible amount to set aside, quarter by quarter on the Tax Summary tab, using the tax rate you enter. It does not file anything for you and it is not a substitute for a tax professional. Think of it as arriving at your accountant's office already organised, figures in hand.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Order Tracker

Every order on one line: status, ship-by date, amount paid and balance due, all kept current.

$7.50 $3.00
View on Etsy
Inventory Tracker

Stock levels, reorder alerts and profit per item, kept up to date as you log.

$7.50 $3.00
View on Etsy
Sales Tracker

Log each sale once and see revenue after fees, top products and your best channels clearly.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00