Period – a technical field that extracts the name of the month from the date you specify in the Date column.Date – specify the date of your income/expense.For this, you need to go to the Import your income/expenses sheet. The personal Google Sheets expense tracker template will work after you feed data into it. The pie chart will update once you change the period to filter by. Click on the B43 cell and choose the period from the drop-down list. It lets you filter out expenses by a certain period. The expense tracker Google Sheets looks as follows:
If the default ones are okay, then skip this step. Here you need to specify your categories for income and expenses.
On the Expense Tracker sheet, you’ll see the grouped rows for income and expenses. Import your income/expenses – the sheet where you can manually or automatically import data about your revenues and expenses.This sheet also contains the breakdown of income and expenses by categories/months. Expense Tracker – the sheet with the tracker itself: it allows you to filter out expenses by categories according to the selected period.The expense tracker was designed in Google Sheets and consists of two sheets: Daily or monthly expense tracker in Google Sheets is better? Google Sheets spending tracker template explained
0 kommentar(er)
