![]() ![]() So basically you take your Earnings (B18) and subtract your Business Expenses (H18) and any Investments into Roth accounts (K3) from that. Let’s take a look at the formula for taxes, located in the cell B19. Now let’s talk about the bottom part of this spreadsheet, which is where the fireworks really fly. Total Up Your Income For Maximum Analytical Prowess I will give you a few different spreadsheet variations for you to download if that’s the case so you can benefit from my super barebones (yet awesome) sheet. There’s probably a sliding scale of folks reading with some on the “self-employed” end, and some on the “Employed” end. “Freelancing Work” could be one of them, or perhaps “Youtube Ad Revenue” could be another. Obviously, just rename all of these as you see fit. ![]() So if you want to copy this spreadsheet, you can just add as many income streams as you need beneath Income Stream 7. I do a simple formula in my Google sheet that automatically adds all my earnings, expenses, and business expenses below each column. If you invest in a ROTH IRA, you can subtract that money from your taxable income at the end of the year, too.īeneath all these columns are “Total” buckets. I like to also track how much money I’m investing. All the numbers you see above are random, by the way. The top of my personal finance spreadsheet is divided up into four buckets: earnings, expenses, business expenses, and investments.Īs a solopreneur, I need to calculate my business expenses so I can subtract it from my taxable income at the end of the year. Let’s break down the spreadsheet, how it works, and how you can get your own copy. I was flying blind, and one simple spreadsheet helped me consolidate thousands of dollars overnight. Youtube ad revenue, Facebook ad revenue, online courses, oh my! The year before*, my online course business blew up and I had no idea how much money I was making every month from all my different side hustles.* I remember early 2019 when I first created this spreadsheet. The past few years, I’ve tracked hundreds of thousands of dollars through one single spreadsheet. Total Up Your Income For Maximum Analytical Prowess. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |