![]() ![]() In the row below your last source of income (so if your income sources end in row 10, this is row 11) click the cell in column B and drag across to select the whole portion of the row that is under your month names.Additionally, you can bold any of your headings or numbers by selecting the cells and clicking on the “B” icon in the top white menu bar. You can also add color to any of your cells by selecting them and clicking on the paint bucket icon in the top white menu. This will add borders around all of your month names to set them apart from your data. If you let your mouse hover over it it should say “Borders.” Click on the icon and then select the first option that shows you all sides of the cell in bold. In the top white menu bar select the icon that looks like a little window. Click and hold on all of the cells that contain your month names.In the top white menu bar click on the “$” icon to convert the format of all of your numbers to currency. Click and drag over all of your cells that contain dollar amounts.Fill in the total income that you earned for each source in the corresponding month column.List every source of income that you might have here. Type your second source of income in A3, third in A4, etc. In cell A2 type in one of your sources of income.in B1 type “Jan,” in C1 type “Feb,” in D1 type “Mar,” etc.) In the top row of your spreadsheet, starting in column B, type the name of each month (ex.(Just remember to remove rows you don’t need or enter zeros for all values already in the spreadsheet before you use it so that your sums are accurate when you add your own income and expenses!) To create your own income tracker template in Google Sheets: Keep reading below for detailed written instructions on how to create your own expense tracking spreadsheet, or access my Google Sheets income & expense tracking template here to use my format and customize it to your own needs. *All amounts and details below are just for example purposes and do not reflect any of my actual earnings or expenses. It’s basic, but offers me a great overview of my earnings and monthly expenses so I can keep my business on track! ![]() It includes income and expense information for each month, monthly total profit calculations, and a year-t0-date profit total. I HIGHLY recommend watching the video if you are not familiar with Google Sheets, but all of the details are also included in the written instructions.īelow is also a screenshot of what my basic spreadsheet for income and expense tracking looks like. If you’re not a video person I’ve also spelled out step-by-step instructions below for how to create my basic income and expense tracking spreadsheet in Google Sheets. Google Sheets is a great free tool to help you put together a clear tracking system! Watch below to learn how and scroll down to access my Google Sheets income template completely free of charge. You need to be able to see how much profit you are bringing in and how your expenses are impacting your business to make smart strategic decisions. In addition, having a clear understanding of your business finances and your monthly ins and outs is also vital to growing your business. The information is essential for tax purposes. You NEED to track your business expenses and income. ![]() I will walk you through how to build a spreadsheet just like the one that I use to track my blogging income and expenses every month.Īs an added bonus, I’ve included a link below to access my income and expense template in Google Sheets completely free of charge! If you’ve never used Excel or Google Sheets before, it’s not as overwhelming as it may seem! My video tutorial below will help you learn some of the basics of how to start a new Google Sheets spreadsheet, format cells in it, and implement basic formulas. then Google Sheets might be exactly the free solution you need to keep track of your financial ins and outs for tax purposes and business planning. If you run a multi-level business you likely need more advanced software, but if you are an entrepreneur with your own start-up, a blogger, or sell hand-made crafts, etc. It does not support all of the same advanced functionality that Excel does but, for basic business purposes like tracking income and expenses, it’s a fantastic free tool! Google Sheets is basically a free online version of Microsoft Office’s Excel program. A Google Sheets expense and income tracker is easy to use and can help you stay on top of your finances to make more strategic decisions for your business or blog. Free Google Sheets Income and Expense Tracker With TutorialĬreating a small business spreadsheet for income and expenses in Google Sheets is a great FREE way to track your business progress and keep yourself organized for tax reporting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |