The only expenses I have input are savings and taxes, but the expenses tracking is fairly standard. I have fixed some dates for ease but please see remarks. The category and account associated with the expense should be input here. The "Fix" column is a personal note to me to remind me that there is data missing from some those rows. Expenses should be input as positives (the formula will receive these as "deductions" and reduce the account by the amount).
ā
To change the month, change the view title from "August 2020" to "Month Year". Adjust the filter to fit the YYYY - MM format.
ā
Deposits should include any money going into the accounts, including salary / income and cash deposits. Deposits should be input as positives (the formula will increase the account by the amount).
The budget is viewed both by year and by month. To change the month, change the name of the view and under the "expenses" column adjust the condition "Month" to YYYY - MM format of your selected month. Same process to change the year. Budget amounts are based on averages I googled, but are estimated on the "high" side for an average salary. Please adjust as needed.
Be sure to add your salary / income in the "salary" column, copying said annual income into each row of the column. This is the only component that is not automated. Change your percent as needed. When salary is added, the Projection columns will resolve.
ā
The primary field "account" is the vendor, or the vendor + name if there is a name specified. Unhide starting balance to input current saving/debt. For loan repayment and credit card debt, make sure to include a negative "-" sign in the Starting Balance.
ā