User Guide · Bring in data

Bank statements

Upload a statement; every entry is read, checked against the balances and given a suggested ledger.

  1. 1Open Banking from the sidebar.
  2. 2Choose the Client and the Bank Ledger — the client's ledger for this bank account in Tally. Only ledgers under the bank groups are listed; if yours is missing, choose — Can't find it? Show all ledgers — or click Type manually.
  3. 3Drop the file into Statement File. PDF, Excel (.xlsx, .xls) and CSV are accepted, up to 200 MB each, and you can pick several files at once.
  4. 4Click Upload & Process. We estimate how many vouchers the file holds and how many credits you have, then start reading it.
  5. 5When it is done, the Upload Summary opens. Click Review all transactions & push to Tally to begin reviewing.
For the best results use the digital PDF, or the Excel or CSV download from net banking. If your bank's layout is not read, click Download Template (.xlsx), copy in the Date, Narration, Debit, Credit and Balance columns, and upload the template instead.

Password-protected PDFs

There is no need to remove the password. We ask for it before processing (Unlock & Estimate), or you can click the lock icon in the Document Library and enter it there. You get five tries per file. Password-protected Excel files cannot be opened — save an unprotected copy and upload that.

Scanned or photographed statements

We try to read scanned pages with text recognition, but the results are less dependable. If nothing can be read, the file fails and no credit is used. When only some pages are scanned, the readable pages are processed and we tell you which pages were skipped, so you can add those entries yourself. A digital statement is always the better choice.

The balance check

Before saving a statement, we check that the opening balance, plus all credits, less all debits, equals the closing balance printed on it (within ₹5). If it does not add up, some entry has been misread — so the statement is not saved and no credit is charged. Upload the Excel version from net banking, or use our template.

Document Library

The panel on the right lists every statement for the client with its date range, bank ledger, status and number of transactions.

StatusWhat it means
QueuedWaiting to start.
Processing…Being read. Most statements finish within a few minutes.
ProcessedReady. Click the eye icon to review the entries.
FailedCould not be read. Open Details to see why. Nothing is charged.
Needs PasswordClick the lock icon and enter the PDF password.
Confirm DatesSome dates could be read either as DD/MM or MM/DD. Click the chip and choose the right format.
Low BalancePaused for want of credits. Buy credits, then click Resume — there is no need to upload again.
  • Download Original gives back the file you uploaded. Original files are kept for 90 days.
  • Stop processing cancels an upload that is still running.
  • Reprocess tries a failed upload again.
  • Delete upload removes the statement and all its transactions. Credits already used are not returned. Once any entry from it has been pushed to Tally, undo the push before deleting.

The same file twice, and overlapping statements

If you upload a file that is exactly the same as one already uploaded for this client, we stop and ask first. Choose Upload anyway only if you really want a second set of vouchers. If two statements merely overlap in dates, the repeated entries are marked Duplicate? — they are not charged, and they are left out of the push unless you include them.