AU Small Finance Bank statement analyser: Excel in, ITR-ready report out
AU Small Finance Bank is one of the newer names to appear on a statement header, and it shows in the data. As a digital-first bank, its Excel and CSV exports typically carry cleaner, more human-readable narrations than the older public-sector formats, and that works in a CA's favour. When the payer or payee name is spelled out rather than buried in codes, Greenote Lite's party ledger comes out crisper: more counterparties named, and a shorter Suspense list left to chase down.
Works with Excel and CSV statements from netbanking. Got a PDF? That is coming to the full Greenote desktop app.
How to export your AU Small Finance Bank statement as Excel or CSV
- 1Log in to AU Small Finance Bank internet banking, or the AU mobile app, and open the account statement section for the account you need.
- 2Select the account and set the date range for the period under audit; a full financial year may need more than one download, depending on the portal's range limit.
- 3Choose the Excel or CSV download rather than PDF. Greenote Lite reads .xls, .xlsx and .csv.
- 4Upload the file exactly as downloaded; the engine finds the transaction table on its own, and password-protected files are fine.
Menu names shift between netbanking versions, so treat the steps above as a guide — the constant is the format: take the Excel, XLS or CSV download, not the PDF. Greenote Lite does not read PDF statements; the full Greenote desktop app does, and is available now.
What Greenote Lite does with an AU statement
AU's cleaner, digital-first narrations give the engine more to work with, and it uses all of it:
- UPI, NEFT and IMPS rows are read for the counterparty name, which on AU statements is usually spelled out clearly, so repeated payments to the same party roll up as one line with one total in the party ledger.
- Debit and credit are taken straight from the amount columns, so direction never depends on reading the narration text; a mislabelled description cannot flip a payment into a receipt.
- UPI rows typically carry the full VPA, giving the ledger a stable anchor even when a name is written slightly differently from one month to the next.
- Card and merchant rows carry usable merchant names, so a year of spends groups naturally by vendor instead of scattering across hundreds of separate rows.
- Rows that genuinely carry no readable counterparty, such as terse charge or reversal entries, are grouped honestly under Suspense/Unknown rather than being guessed.
The download is a four-sheet Excel workbook: a party ledger of who paid whom, every transaction categorised and named, a category summary, and an ITR summary with AIS/SFT flags. See why the party ledger comes first or the full statement-to-ITR workflow.
AU statement questions
AU is a digital-first bank, and its UPI rows carry the full VPA beside the name. That VPA acts as a stable key, so a supplier whose name is typed differently from one month to the next still rolls up as one party with one total instead of splitting into duplicates. Cleaner input, fewer stray rows to reconcile.
Either. Both the XLS and the CSV download carry the same narrations and amount columns the engine parses, so pick whichever your netbanking or app version offers. Just avoid PDF, which Greenote Lite does not read.
Not in Greenote Lite, which reads Excel and CSV only. Export the XLS or CSV statement from AU netbanking or the app instead; it typically sits right next to the PDF option. PDF statements are planned for the full Greenote desktop app.
Try it on a real AU statement
Your first statement is free — the trial processes the first 300 transactions so you can judge the quality end to end. Verify your email with a one-time code (no password, no card), and the file is deleted the moment your report is ready.