91-93584-44502 | support@quick2tally.com
Quick2Tally

Bank Statement

Import a bank statement from Excel (or a scanned PDF) as receipt, payment and contra vouchers. Auto Ledger learns from your past Tally entries and fills the party or expense ledger for you.

Need help? Call or WhatsApp 93584-44502. Free installation and demo support.

Step 1 – Connect Tally

  1. Open your company in Tally.
  2. Open QuikAccount and go to the sheet you want to use.
  3. Click Connect Tally on the QuikAccount ribbon. The Tally Company box at the top right shows the company name, GSTIN, state and books start date. Check it is the right company.

Step 2 – Paste the statement

  1. Open the CASH & BANK sheet.
  2. In cell F1, select the bank ledger as it is in Tally.
  3. Paste:
    • Date → Voucher Date (column D)
    • Narration → Particulars (column F) – becomes the narration in Tally
    • Withdrawal → column L, Deposit → column M
    • Cheque no. → Instrument No. (optional)
  4. Amounts with commas, spaces or "Cr/Dr"? Click Clean Amount.
  5. PDF statement? Click Scan Docs to read it into the sheet – see How to import a PDF bank statement in TallyPrime.
Bank statement pasted in the CASH & BANK sheet

Step 3 – Fill party / expense ledgers automatically

  1. First time only: click Learn from Tally. QuikAccount studies your past bank entries in Tally.
  2. Click Auto Ledger. Rows with a known narration get their Party/Expense Name (column H).
  3. Click Fill Empty Party for the rest, or type a name. Double-click a cell or press Ctrl+Shift+S to search.
  4. A ledger not in Tally? Just type the name – it is created on Validate.
  5. Click Save Rules to remember your choices for next month. View Rules lets you edit them.
CASH & BANK ribbon with Auto Ledger, Learn from Tally and Save Rules
Party names filled by Auto Ledger

Step 4 – Validate and export

  1. Click Validate (or press Alt+Shift+V). Cells with errors turn red and are listed on the Error sheet with links to each cell.
  2. New ledgers are copied to the LedgerCreation sheet and new items to the ItemCreation sheet. Open that sheet, click Validate, then Export to Tally, and come back.
  3. Validate again until you see Validation Success.
  4. Click Export to Tally (or press Alt+Shift+E). The Report sheet shows every voucher with its status.

Advantage

Auto Ledger

Party names filled from rules learnt from your Tally data.

Receipt, Payment, Contra

Voucher type decided by the amount and ledger; contra detected automatically.

Instrument no. and date

Cheque number and date carried to Tally.

Bill reference

Against existing or new reference.

Bank reconciliation

Fill Banker’s Date and the entries are reconciled in Tally.

PDF statements

Scan Docs reads PDF or image statements.

Global Network Of

Happy Clients

0

Transaction Processed

0

Partners

0

Trusted by 10,000+ Tally Users

For Utility, Support and Service

Trusted by Tally users

4.9 Star Google Rating Based on 300+ Reviews

Kamal Jain, FCA, CCA
Kamal Jain, FCA, CCA 1 review

Recently

Great software, User friendly & Superb support. All GST reports shows accurate results. Multiple formats for each voucher to suit our need. Whatever format of data you have, you can export that to tally. Good Job... QuikAccount Team!

Sanjay Jain
Sanjay Jain 1 review

Recently

Software is user-friendly. It provide lot of option to cater your need and give results in desired format. Also it ask for minimum data and most of the fields are either auto-calculated or imported from tally which makes working on this software very faster.

Prachi Shah, Senior Executive
Prachi Shah, Senior Executive 1 review

Recently

Superb tool to integrate excel data in Tally. We have imported complex e-commerce reports with this tool and it has imported large data accurately and very fast too. Company provided one click import option for multiple e-commerce platforms.

Get in touch

Share your details and we will get back to you.