Skip to content

AnandKumar9/ExpenseTracker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ExpenseTracker

  1. Open the latest transactions csv in US Expenses/Transactions History/ folder, and check the latest date it has QuickSilver card transactions for. Also, ensure that the actual sheet's latest QuickSilver transactions are for the same date.
  2. Download transactions from CapitalOne website with the start date being a date prior to the above date, and save it in US Expenses/ folder.
  3. From the downloaded csv, remove any transactions for which entries have already been made in the sheet.
  4. Make manual entries for cash, checking account, 2 BOA credit cards, and FSA transactions. Again, ensure that any of these transactions are not already in the sheet.
  5. Run this Python script.
  6. Copy the formatted transactions from Console, paste in Google Sheet's script, modify all 'unknown' (and any other necessary) transactions to have the appropriate name and category, and run the Google Sheets script.
  7. Move the local csv from US Purse Strings/ to US Expenses/Transactions History/ folder.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages