Budget & Expense

Posted on 2022-11-20 Edited on 2025-02-12

The accounting process

Use the first and second week to submit reimbursements, do the bookkeeping on the second week’s Thursday afternoon, next time: 2023/08/10

Dump the record from Mint to nyuzyt/Personal file/Transactions cvs file
- post credit karma’s acquisition of mint, use creditkarma_export_transactions to download the transactions. Read the instruction.
- remove the previous record files first
Insert a line in overall sheet prior to the previous record, then insert the copied cells
Copy the cvs tables content, without the header
Create a new sheet for this month alone
Copy from one previous month’s sheet(all the way to comments), paste the column width
Copy the records to this month’s sheet
Remove the Credit Card Payments
Remove the Loan accounts
Filter the records by account first
Check each account, modify the category and mark the transactions as verified
Copy the reverse ~ Balance columns from one previous month’s table
List single item takes more than $10,000

Generate the new hexo post with hexo new post "Bookkeeping - XXXX/XX"
Copy all content from the post for previous month, git add now(so we know what changed)
Commit the change with title Add bookkeeping for YYYY/MM
Go to the Table to Markdown website to transform excel tables to markdown tables
Remove the zeroes from sum column
Open the same file to the right window, make it narrow
Add new value to and remove old value from the multi layer pie chart for spending and income

Ask chatgpt to generate the detailed category data

对
spending table
取每一行第一个值和第二个值，生成类似
{value:251.69, name:'Restaurants'},
{value:73.15, name:'Cake & Bread'},
的数据