INCOME EXPENSE TRACKER HOW TO
INCOME EXPENSE TRACKER DOWNLOAD
INCOME EXPENSE TRACKER FREE

This spreadsheet lets you see all of the months of the year on the one spreadsheet (I originally had it split into 12 spreadsheets – one for each month – but it is sooooo much better being able to see everything all at once). I use this spreadsheet in conjunction with my printable tax planner which you can learn more about here. If it’s an expense that was paid in USD using my travel card (so I don’t have to pay international transaction fees as I live in Australia), then I’ll also note that in this column. Then I can use the filter option to make sure I’ve paid it each month, and to file the receipt if the money for the subscription is automatically deducted from my account. If it’s a recurring expenses, I’ll also note that here. If there’s an invoice number, I’ll put it in the notes column. I use the notes column for anything really. printer paper, this helps me avoid entering the same expense twice, and so I know when I’ve scanned the receipt so I have a digital copy, and filed away the original paper copy. Because my expenses are usually the same can be similar for me e.g. You could also just keep a running total on that spreadsheet if you prefer.Īfter using the spreadsheet for a while, I added in a ‘date receipt filed’ column. I then highlight all of the cells for the month and copy that total (if you go to the bottom right hand corner in Excel it will tell you the total $ for those highlighted cells) into the ‘Income and Expenses’ tab (which I talk about below). If you click them you can filter the data so you only see the category you want e.g. The little arrows in the bottom right hand corners of the spreadsheet in the picture below are filters. But there ended up being a lot of tabs and some only had a few lines so it made sense just to combined them all. Originally I had this in an Excel file by itself, with separate tabs for each expense category. I usually classify where I think they should go, and if I get it wrong and my accountant needs to switch categories, it’s a quick and easy fix. This spreadsheet is a breakdown of all your expenses so your accountant can classify them correctly. Here’s the link to the spreadsheet if you’d like a copy: Spreadsheet to keep track of income & expenses for Etsy sellers & online business owners TAX DEDUCTIONS LIST To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). If you miss a step or need to re-watch you can pause, restart, rewind and rewatch the recording as many times as you need! To enlarge the screen of the video below, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). I keep them saved in the one Excel file using a separate tab for each spreadsheet. They were created in Microsoft Excel but you could also use them in Google Docs. I ended up creating 5 spreadsheets to track income and expenses. I could’ve gone all out and created a ton of fancy spreadsheets with crazy formulas but I wanted to keep them super simple, so that my accountant could simply open them and find the exact numbers they need using easy to follow and logically designed spreadsheets. I considered using an online based accounting system, but to be honest, I don’t know how secure they are and I don’t like that I can only access them if I have internet access. I could’ve used an accounting program like MYOB but I just don’t find those programs user-friendly. I’ve tweaked them along the way so that they’re the perfect tool for non-financial people like myself, who’d rather spend more time on their business (anyone else just want to make pretty things all day?), rather than the not-so-fun task of accounting. So I created some spreadsheets to help me track income, expenses and tax deductions and tested them for over a year. but when I hired an accountant a few years ago, they wanted everything digital not pen and paper. not! Unfortunately it’s an unavoidable part of doing business 🙁 I originally used my Etsy Business Planner to keep track of income, expenses, fees, payments, bills etc.

What is a Printable? What happens when I purchase a printable from you?īookkeeping, accounting, tax preparation.

INCOME EXPENSE TRACKER FREE

Free Printables Library – Subscribers Login.Digital planners and notebooks in Microsoft PowerPoint.Free Graphic Design Video Tutorials Library.Shop my favorite planner supplies on Amazon.

INCOME EXPENSE TRACKER DOWNLOAD

200 Blog Post Title Prompts (Exclusive Download Content).200 Blog Post Title Prompts (For Any Type of Blog).1200 Blog Post Ideas (Exclusive Download Content).

INCOME EXPENSE TRACKER HOW TO

54 Mistakes Etsy Sellers Make (And How to Fix Them).

Income expense tracker