Bank statements

How to import a Central Bank of India statement into an expense tracker

Importing a Central Bank of India statement into an expense tracker: get the file yourself, pick the account, check long narrations and match the balance.

Editorial illustration for How to import a Central Bank of India statement into an expense tracker

To import a Central Bank of India statement into an expense tracker, get a PDF, CSV or Excel copy from your own banking channel, choose the matching account in the tracker, upload the file, read the rows before saving and compare the totals with the closing balance. Long narrations and half-month periods are the two things most worth watching.

Getting a clean file from the bank

Use your own net banking or mobile banking and look for statement, e-statement or account history. I will not name exact menus, since banks rename them. Choose a date range that starts on the first of a month and ends on the last, and pick the electronic format that gives you the most rows in the cleanest form. If you only have a paper statement or passbook pages, ask the branch whether an electronic copy can be emailed to you.

Never type your login details anywhere except the bank's own screen. A tracker that asks for them is not one to trust.

What are the steps inside the tracker?

  1. Create an account with a plain name such as Central Bank savings.
  2. Upload the file against that account.
  3. Open the preview and read the first five and last five rows against the statement.
  4. Fix dates, amounts and direction where needed.
  5. Save, then open the import history for the status.

SpendixAI works in this order: you pick the account, upload the statement, review the rows, and only then save. Each saved transaction keeps its account, and the history shows the status of every upload.

What if narrations are long or cut off?

Some statements put a long description on each line, and a PDF layout may wrap it across two rows. Others cut it short. Either is fine for categorising, because only the merchant or payee part matters. But if a wrapped line was split into a separate row with no amount, delete the stray row or merge its text before saving, so it is not counted as a transaction.

How do you check a partial month?

CaseWhat to do
Statement starts mid-monthUse that day's opening balance as your starting point, not the previous month's
Two files overlapRemove the later copy of the overlapping days
A day is missing between filesDownload the missing day and import it on its own
Closing balance differsFind the row whose amount equals the difference

Here is the arithmetic with made-up numbers. Suppose the file starts at an opening balance of ₹7,300 and has credits of ₹26,000 and debits of ₹24,900. The closing balance should be 7,300 + 26,000 - 24,900 = ₹8,400. If your statement says ₹8,650 instead, the difference is ₹250, so look for a row of ₹250, such as a missing small UPI payment or a charge.

What should you tidy first after the import?

The first import leaves a heap of uncategorised rows. Do not try to sort them all in one sitting. Take the five biggest payees by amount, set a category and a rule for each, and stop. Those five usually cover most of the rupees. The rest can wait for the next few months, when new rules will have been added and a smaller list is left.

Do the same thing next month

Write down the last date you imported, and begin the next file on the following day. Then repeat the review. The first import takes the longest; afterwards the categories and your own rules do most of the sorting. If an upload fails, you will see an Import failed notification, and the file can be tried again after you check its format.

  • Pick the account first.
  • Read the first and last rows.
  • Merge or delete stray wrapped lines.
  • Match the closing balance.
  • Note the last imported date.
SPENDIXAI JOURNAL

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

Explore your reports