![]() On the input sheet, enter the information in the table below. The information entered on the setup sheet is reflected on the input sheet. The name of the expense item, account name, and store name are entered on the setup sheet.Įxpense items are categorized into income and expenses (taxes, savings, fixed and variable expenses). Input sheet Annual sheet Slicer functions How to use the household account book (Google Spreadsheet) Setting Sheet Pick up only the information you want to know by expense, account, store, etc.Compare monthly household accounts on the annual sheet.Record daily household accounts on the input sheet.Enter expense items, account names, and store names on the setup sheet.It is recommended for those who want to do a thorough analysis, as it allows analysis from various perspectives, such as by expense item, by account, or by store. PivotTable is a tool that allows you to aggregate and analyze large amounts of data. I want to keep track of my household finances in a Google Spreadsheet.
0 Comments
Leave a Reply. |