![]() ![]() If you see ways to simplify this or if you think the spreadsheet is missing an important angle, please let me know in an e-mail or a comment below this post. I’ve also left comments throughout the spreadsheet (look for the orange triangle at the upper-right corner of a cell) explaining what goes where. The first step is to open Google Drive, the platform to create and store your Google Sheets expense tracker. In addition, you’ll see a box in which you can plug in the relevant numbers for a home-office deduction, but I recognize that not every 1099-income type will claim that. If it’s for personal budgeting, and you’re not opposed to premade, I highly recommended checking out this post from r/personalfinance from about 2 years ago: I made a spreadsheet for people who don’t know how to budget v2.0. When possible, I’ve aligned types of costs with TurboTax’s vocabulary to reduce springtime tax-prep confusion. Plenty of tutorials for setting up a simple budget spreadsheet. This template is organized by types of expense, with the biggest categories in my case–travel and meals and entertainment–getting their own sheets. ![]() Here you go: Make a copy of this template (go to the File menu and select “Make a copy…”) to your Google account and get to work. I was glad to give my friend a boost past that phase, and now I want to do the same for any self-employed types reading this. Google Sheets’ native free monthly budget template is a user-friendly income and expense tracker. Instead, I had to survive some excruciatingly stupid accounting practices and eventually thumb-wrestle my way to marginal competence. Monthly Budget Template for Google Sheets. A friend of mine started freelancing at the end of last year, so I decided to give him a boring but useful present: a blank copy of the Google Docs spreadsheet I use to track my expenses.Ī systematic, easily smartphone-accessible way to record the costs of doing business–organized so you can copy the year-end totals into your Schedule C tax form–is exactly the thing I needed when I started freelancing almost eight years ago. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |