- insert/edit transaction entries
- view transaction logs & summary
- synchronize with annual budget
- only configure once in a year
Create monthly budget spreadsheets for each month from the spreadsheet template gallery.
Optionally, create an additional annual budget spreadsheet if you want to use the synchronization feature.
Take note of the SPREADSHEET_IDs which is embedded inside the URL:
Complete steps 1 in the quickstart guide. Make sure that you copy the
credentials.jsonfile into project directory.
Update spreadsheet IDs inside config.json with your own monthly budget spreadsheet IDs.
From project directory:
synccommands, this month's spreadsheet will be used unless specified explicitly.
incomecommands, today's date will be assumed and this month's spreadsheet will be used unless date is specified explicitly.
editcommand, the transaction date will stay the same and this month's spreadsheet will be used unless date is specified explicitly, in which case the month will be determined accordingly.
# insert expense transaction in June budget budget expense "Jun 29, 40, Pizza, Food" # insert expense transaction for today in this month's budget budget expense "40, Pizza, Food" # insert income transaction in August budget budget income "Aug 2, 3000, Salary, Paycheck" # insert income transaction for today in this month's budget budget income "3000, Salary, Paycheck" # edit 4th income transaction in this month's budget (see `budget log` for transaction number) budget edit income 4 "65, Tax Return, Other" # edit 5th expense transaction in September budget (see `budget log sep` for transaction number) budget edit expense 5 "Sep 17, Mobile Plan, Communication" # execute all transaction commands within ./example.txt (path can be relative or absolute) budget insert ./example.txt
Here's what an input file might look like when using the
expense "Jun 29, 40, Pizza, Food" expense "40, Pizza, Food" income "Aug 2, 3000, Salary, Paycheck" income "3000, Salary, Paycheck"
# print monthly budget summary for all months so far budget summary # print monthly budget summary for January budget summary jan
# list all monthly budget categories & amounts for this month budget categories # list all monthly budget categories & amounts for February budget categories feb
# log monthly budget transaction history for this month budget log # log monthly budget transaction history for March budget log mar
Annual Budget Synchronization
In order to synchronize with annual budget, expense & income categories must be exactly the same across all monthly budget spreadsheets and the annual budget spreadsheet.
# update annual budget with expenses & income of this month budget sync # update annual budget with expenses & income of April budget sync apr