// readme

india2actual

Get your Indian bank statements into Actual Budget, with real payee names instead of UPI reference strings.

·
·

Why this exists

1. Actual has no bank sync for Indian banks, and is unlikely to get one soon. (more below). The only way to get transactions in is to download a statement and import it yourself. This tool makes that as painless as it can be: hand it the file your bank gave you (CSV, Excel or PDF) and it either produces a clean CSV for Actual or puts the transactions straight into your budget.

2. UPI transactions are unreadable as they come. Your bank describes two orders from the same shop like this:

UPI/DR/412345678901/SWIGGY/YESB/swiggy@ybl/Payment
UPI/DR/419876543210/SWIGGY/YESB/swiggy@ybl/Payment

Every line has a different reference number, so Actual treats them as two different payees. A few months in, you have hundreds of junk payees, reports by payee tell you nothing, and Actual cannot learn your categories.

This tool pulls the name out of each line, so both become simply Swiggy:

| Date | Payee | Notes…