Features/Banking/Bank Statement Import

Coming in an updateIn testing now, and arriving in a software update.

Your bank's statement, read as it is.

Give Bank Import the file your bank sent: its PDF, even a password-protected one, an Excel sheet, a CSV, or a photograph of the paper. Every line comes in with a ledger already proposed, and nothing is posted until you tick it.

Download free for 30 days See a statement read
Open it with 2D on the Feeding menu

Every planComet, Orbit and Nova all include Bank Import.

Statement of Account September 2026 password
DateNarrationAmountgoes to
01/09NEFT CR Anmol Hardware42,000.00 CrAnmol Hardware ✓
02/09ATM WDL25,000.00 DrCash in Hand ✓
03/09NEFT DR Prime Polymers60,000.00 DrPrime Polymers ✓
07/09IMPS DR Shop rent28,000.00 DrShop Rent ✓
10/09SMS charges17.70 DrBank Charges ✓
Five of the eleven lines on the demo company's September statement, and where each one lands.
What it reads

Whatever your bank gives you.

No converting to Excel first, no deleting the rows above the table, no telling it which column is which. Columns are found by their headings, below the bank's letterhead, so any bank's layout is read.

  • The bank's own PDFPassword protected too. The password opens the file and is kept nowhere.
  • ExcelAn old .xls or a new .xlsx, exactly as the bank sends it.
  • CSV or textA plain export, with nothing to map.
  • A photographJPEG or PNG of a printed statement or a passbook, read on your own PC.

A photograph is read by character recognition, which fetches its language file once and then works without a connection. A scanned PDF with no text in it is refused with a sentence that says so, rather than read wrongly.

Bank Import in Vertex ERP reading a password-protected PDF statement for the demo company: 11 lines read, the running balance checked on all 10 links, money in 2,00,000.00 and out 1,64,017.70, and a ledger marked SURE on each line.
The demo company's September statement, opened with its password: 11 lines, the running balance checked on every link, a ledger proposed on each.
On menu 2D

Every line arrives with its ledger.

Choose the bank account, choose the file, type the password if it has one, and press Read statement.

  • The balance is checkedEach line is proved against the running balance on the statement, so a line read wrongly cannot slip through.
  • A ledger on every lineA receipt against the customer, a payment against the supplier, the ATM against cash in hand, the fee against bank charges.
  • Nothing posts on its ownYou look down the list, change any ledger, and post only what is ticked.
  • The bank's words are keptEach line becomes a receipt, payment or contra with the narration as the bank printed it, and a cheque on the statement is marked cleared.
Strongest first

How a line finds its ledger.

Four sources are asked in order, and the first that knows the answer wins. What it is sure of says so, and what it is guessing says that too.

SureLikelyMaybeUnmatched
  1. What a line like it went to last timeLast month's rent went to Shop Rent, so this month's does too. The more you post, the more it knows.
  2. How the money movedA cash withdrawal belongs in cash in hand and a charge the bank took belongs in bank charges, whatever the narration calls them.
  3. A name it recognisesA party or an account from your own chart, found in the narration.
  4. Suspense, and never a guessWhen nothing fits, the line goes to the suspense account you chose and says it is unmatched.
The second time

Import a statement twice, and nothing doubles.

  • Lines already imported are skippedEach line is recognised again, and the screen says how many it already has.
  • A hand-keyed twin is flaggedA line with the same date and amount as an entry you keyed yourself is marked and left unticked.
  • Reconciled as it postsImported lines are struck off in Bank Reconciliation, 2E, without being matched a second time by hand.
  • The password is not storedNot with the import, not in a log, not in the browser. Next month's statement asks again.
  • Checked on real statementsA password-protected PDF and the same month's Excel file were read side by side, and agreed on all 151 transactions.
  • It stays on your PCThe statement is read by the software on your machine. Nothing is uploaded to read it.
Where it lives

The screens around it.

Each one opens from its menu number and its letter.

BankFeeding menu 2

  • 2DBank ImportRead a bank statement and turn its lines into ledger entries
  • 2EBank ReconciliationMatch the bank’s statement against the books, and hold the difference
  • 2FCheque PrintingPrint cheques against a payment

Reports, in partReports menu 3

  • 3CCheque RegisterCheques issued and received, and which have cleared
  • 3TCash & Bank BalancesHow much is in each bank and in the till, one line each
  • 3HCash-BookCash and bank movements with a running balance, a book per account

Master, in partMaster menu 1

  • 1VBank Account MasterAccount number, IFSC and branch for each of the company’s own bank ledgers
Read next

From the same reader.

Party Ledger ReconciliationTheir statement against your ledgerPurchase Bill ImportA supplier's PDF becomes a purchaseBankingReconcile, cheques, balances
Free for 30 days

Read this month's statement into your own books.

The complete software, every module. On day thirty-one it asks for a licence key, and everything you entered stays exactly where it is.

Read about the trial See plans & prices
Vertex ERP for Windows and MacFrom vertexerp.co.in
Windows
1.1.12 · 183 MB
Mac
Apple silicon
Trial
30 days, every module
Card
Not needed
Download