Automated Banking SMS Accounting System
Bank SMS in, bookkeeping out — parsed, logged and summarised automatically.
The problem
The client tracked every transaction by hand, copying bank SMS notifications into a spreadsheet at the end of each day. Entries were missed, categories were inconsistent, and building a monthly picture of spending took hours.
The solution
We built an n8n pipeline that ingests incoming bank SMS, parses amount, merchant, date and account, then writes a normalised row to Google Sheets and pushes a running summary to Telegram. A GPT-4o-mini agent sits on top: the owner can send a voice message asking “how much did I spend on suppliers this month?” — Whisper transcribes it, the agent queries the sheet and replies, and monthly financial reports are generated on demand.
The result
Manual bookkeeping dropped from roughly an hour a day to zero, with a complete, searchable transaction history and instant monthly reports.




