Track Telegram expenses with Data Tables and monthly reports
Log expenses by sending Telegram messages, keep them in an n8n Data Table, and get monthly reports by category, an undo command and a help menu in Telegram.
Track Telegram expenses with Data Tables and monthly reports is free on n8n.io. Made by Nam Trung Studio (n8n workflows).
How it works
- Parses the message to detect a command (/report, /undo, /help) or extract an expense amount, category (from keywords or a #tag), note, and month.
- When an expense is detected, saves a normalized row to the n8n Data Table named
expensesand sends a formatted confirmation back in Telegram. - When
/reportis sent (optionally withYYYY-MM), fetches that month’s rows for the sender’s chat ID from theexpensesData Table, aggregates totals by category, and sends a monthly summary back in Telegram. - When
/undois sent, retrieves the most recent expense row for the sender’s chat ID, deletes it from theexpensesData Table, and posts the undo result in Telegram. - When
/helpis sent or no amount is found, sends usage examples and available commands back in Telegram.
Customization
- Edit categoryKeywords in the "Prepare Configuration Settings" node to match how you talk about money — first match wins, and typing #category in a message always overrides. Set smallNumbersAreThousands to false if "50" should mean 50 rather than 50,000.
Additional info
Need credit-card statement cycles (what lands on which statement and when it's due), morning due-date reminders, category budgets with alerts, month-over-month reports and CSV export? Search "Expense Tracker PRO" on n8n.io or see my creator page for the PRO version.