ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
HOW TO USE
2
1Create a copy of this google sheet in your drive
3
2A Treasurer tab will be created in the menu
4
3Last Month / Current month / Custom month will create an expense sheet for that particular month
5
4Auto update will setup a trigger to create an expense sheet of last month on 1st of every month
6
5Please verify the expense sheet since the script may misbehave if formatting of these email messages change in future
7
8
WHY TO USE
9
1Get all your online expenses from UPI apps | Wallets | Credit/Debit Cards at a single place for easy budgeting
10
2Automate the process to create an expenses sheet on the 1st of every month
11
3No privacy worries since the script asks for minimum permissions and none of your data ever leaves the Google servers
12
4Fully open source project where you can contribute as well https://github.com/5amyak/Treasurer
13
5Currently, the supported apps are PhonePe, PayTM, AxisBank CC, ICICIBank CC etc.
14
15
HOW IT WORKS
16
1Metadata sheet is used to scrape mails from your gmail account to create the expenses sheet
17
2Please go to Extensions -> Apps Script from menu to understand how the regex is getting used in GmailScrape class
18
3Add new rows in metadata sheet to extend the usage
19
20
21
22
23
24
25
26
27
28
29
30