Federal Bank statement analyser: Excel in, ITR-ready report out
Federal Bank is a private-sector bank whose statements are typically clean: UPI, NEFT and IMPS rows usually spell the counterparty out in something close to plain English rather than burying it in codes. On readable narrations like these, Greenote Lite's party ledger comes out crisp, with more rows resolving to a named party and a shorter honest Suspense list for you to work through by hand.
Works with Excel and CSV statements from netbanking. Got a PDF? That is coming to the full Greenote desktop app.
How to export your Federal Bank statement as Excel or CSV
- 1Log in to FedNet internet banking (or the Federal Bank mobile app) and open the account statement view.
- 2Select the account and set the date range covering the period under audit.
- 3Download the Excel or CSV version rather than PDF; in most portal versions it sits alongside the PDF option.
- 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 a Federal statement
Cleaner input lets the engine go further, and on Federal Bank statements that shows up directly in the ledger:
- UPI rows are split into their segments and the payer or payee name is lifted out cleanly, so repeated payments to the same party roll up as one line with one total in the party ledger.
- NEFT and IMPS narrations typically carry the counterparty name alongside a reference and an IFSC; the engine keeps the name and drops the codes and reference numbers.
- Debit and credit amounts arrive as separate columns and map straight to money out and money in, so a row's direction never depends on reading the narration.
- Card and POS rows carry the merchant name, so spends are grouped per merchant and a year of swipes reads as a ranked list instead of hundreds of loose rows.
- Rows whose counterparty is genuinely unreadable, such as terse charge, reversal or interest entries, are marked Suspense/Unknown rather than guessed, so the ledger stays trustworthy.
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.
Federal statement questions
Not in Greenote Lite, which reads Excel and CSV only. Export the spreadsheet version from FedNet or the app instead; it typically sits right next to the PDF option. PDF statements are planned for the full Greenote desktop app.
Federal Bank spells the counterparty out on UPI, NEFT and IMPS rows instead of hiding it behind codes, so transfers read as who-paid-whom with little guesswork. Card and POS rows carry the merchant name too, so a year of swipes collapses into a ranked per-merchant list rather than hundreds of loose entries.
Both typically work, as long as you download Excel or CSV rather than PDF. The app and netbanking exports can differ slightly in column order and date format; the engine detects the table layout rather than assuming one fixed template.
Try it on a real Federal 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.