Bank statements

How to import a AU Small Finance Bank statement into an expense tracker

Import an AU Small Finance Bank statement into an expense tracker and add the cash spending the statement cannot show, then check the totals.

Editorial illustration for How to import a AU Small Finance Bank statement into an expense tracker

To import an AU Small Finance Bank statement into an expense tracker, download your own statement for the period from the bank's net banking or app, upload it in PDF, CSV or Excel form against the right account, review the rows and verify the totals. Then add the cash spending by hand, because a bank statement only shows what passed through the account.

Where does the statement come from?

Sign in to your own net banking or mobile app, open the account, and look for the statement or e-statement area. Menus change, so look for the idea instead of a fixed route. Choose your dates, pick a format if more than one is offered, and download. If you cannot find it, ask the bank's customer care how to download an account statement for your account type.

How do you import it?

  1. Add the account in the tracker first, so that each row keeps the account it came from.
  2. Select the account before uploading.
  3. Upload the PDF, CSV or Excel file. If you are catching up, several files can go in one batch.
  4. Review the rows before saving. Check dates, debit and credit, and rows that look like page headings.
  5. Save and open the import history to see each file's status.

Why is the statement only half the picture?

Many people, especially those running a small shop or stall alongside their home, pay for things in cash. Vegetables from the mandi, an auto fare, a repair paid on the spot: none of it appears on a bank statement. If you track only the file, the month will look cheaper than it was. Adding the cash by hand closes that gap.

How do you add cash spending quickly?

Keep a scrap list during the week, with an amount and a word each, and enter them together at the weekend. SpendixAI lets you add expenses by hand, singly or several at once, which suits a list like this. Say your statement shows ₹63,400 of debits for the month, and your cash list shows ₹4,850. The month's spending is 63,400 plus 4,850, which is ₹68,250. Without the cash you would have understated it by about 7 per cent.

SourceAmount (hypothetical)How it gets in
Bank debits in the statement₹63,400Imported from the file
Cash spending from your list₹4,850Added by hand
Total spending₹68,25063,400 plus 4,850

Does it help to keep home and shop money apart?

If the same account pays for the household and for supplies, label each row as you review it, using separate categories such as Home groceries and Shop supplies. SpendixAI Pro covers one personal workspace and is not a team or approvals tool, so for proper business accounts you would need other software or a CA's help. For your own picture of where money goes, categories are enough, and the Export centre has Tally, Zoho Books and QuickBooks templates if your accountant wants the data.

How do you verify the import?

Compare opening balance plus credits minus debits with the closing balance on the statement. Say you start at ₹18,500, receive ₹70,000 and pay out ₹63,400. Then 18,500 plus 70,000 is 88,500, minus 63,400 is ₹25,100, and the statement should show the same closing figure. If the tracker's debit or credit total differs, count rows and look at the review screen for a row that was skipped or read twice.

What if the layout does not read cleanly?

We cannot promise that every AU Small Finance Bank statement layout will parse perfectly. If the PDF looks muddled, try the CSV or Excel version for the same period. You can also fix rows on the review screen before saving. A failed import triggers an Import failed notification, so you will not be left guessing.

Before you finish

  • Write down the last date you imported.
  • Check the closing balance against the statement.
  • Enter the week's cash list.
  • Add rules for the payees you pay every month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports