Expense Tracker#

Log daily expenses to Notion via natural language chat. Type something like "chicken rice 5" and it auto-parses the item, amount, category, and payment method — then writes it to your Notion database.

Supports bilingual input (English + Chinese), 10 spending categories, and multiple payment platforms.

Setup#

1. Create a Notion integration at https://www.notion.so/my-integrations

2. Share your expense database with the integration

3. Set environment variables: text

   export NOTION_API_KEY="your_token_here"
   export EXPENSE_DATABASE_ID="your_database_id_here"
   
   

Required Notion Database Schema#

PropertyTypeNotesNametitleExpense descriptionAmountnumberNumeric value in SGD, no currency prefixBank NameselectOCBC, TRUST, DBS, Revolut, 支付宝, 微信, OCBC BUSINESSCategoryselectFood, Transport, shopping, business, Groceries, Leisure, Bills, medical, investment, EducationTransaction DatedateISO 8601 (YYYY-MM-DD)

Usage Examples#

InputItemAmountCategoryBankchicken rice 5chicken rice5.00FoodOCBCgrab to school 12.50grab to school12.50TransportOCBC咖啡 3.50 支付宝咖啡3.50Food支付宝notion labs 33 revolutnotion labs33.00businessRevolutdinner with jy 57 trustdinner with jy57.00FoodTRUSTdriving class 90driving class90.00EducationOCBC

Commands#

• /today — List today's expenses with running total
• /summary — Current month breakdown by category
• /month [month] — View a specific month (e.g., /month march)
• /budget [amount] — Set monthly budget; shows remaining on each log
• /bank [name] — Filter expenses by payment method

Parsing Rules#

• Amount is usually the last number: "2 coffee 9" → item="2 coffee", amount=9
• Strips "$" or "SGD" prefixes
• Supports decimals: "3.50", "12.5"
• Bank detection is case-insensitive: "ocbc" = "OCBC"
• Chinese platforms: "支付宝" / "alipay" → 支付宝, "微信" / "wechat" → 微信
• Default bank: OCBC (when none specified)
• If user specifies category explicitly (e.g., "chicken rice 5 business"), uses that override
• All amounts in SGD, rounded to 2 decimal places

Troubleshooting#

If logging to Notion fails:

1. Verify your NOTION_API_KEY environment variable is set and valid
2. Confirm your EXPENSE_DATABASE_ID is correct and the database is shared with your integration
3. Ensure database properties match the schema above (exact names, case-sensitive)
4. Check that the integration has write permissions