ICICI Bank reconciliation software

ICICI Bank Integration with SYSTACC

An ICICI Bank statement should not be ticked off line by line against the books. Upload it to SYSTACC and every deposit and withdrawal is matched to the receipt or payment already on your ICICI ledger. You only look at what did not match.

ICICI statement templateAutomatic matchingPossible match reviewNot matched list
ICICI Bank and SYSTACC logos above a bank reconciliation card matching ICICI statement lines to the books, with reconciled, possible match and not matched statuses
SYSTACC bank reconciliation summary for an ICICI statement: 248 lines, 231 reconciled, 11 possible matches and 6 not matched

Overview

Accounting software built for travel

Month-end for a travel business means one long ICICI Bank statement and a ledger full of client receipts and supplier payments. SYSTACC brings the two together with bank reconciliation.

Open Bank Reconciliation, pick your ICICI Bank ledger and choose the ICICI template. Upload the statement as XLS, XLSX, CSV or TSV. SYSTACC reads each line, with the transaction ID, value date, posted date, cheque or reference number, remarks, withdrawal or deposit amount and balance, and shows you a preview before anything is saved.

Then every line is matched to your books. A deposit is matched to a receipt, and a withdrawal to a payment, on the same ICICI ledger, for exactly the same amount, on the value date or the posted date. When there is one such entry, the line is marked reconciled and the receipt or payment number is recorded against it.

When more than one entry fits, the line is marked as a possible match. You open it, see the receipts or payments with that amount and date, and pick the right one. An entry already matched to another line is not offered again, so one receipt cannot settle two deposits.

Lines with nothing in the books are marked not matched, such as bank charges or a payment nobody has entered yet. SYSTACC does not post anything on its own, so you decide how each one is recorded.

Each upload shows the total lines, reconciled, possible match and not matched counts, with the statement total, the book total and the difference. Uploaded files are listed by date, and you can delete a single line or a whole file and upload again.

ICICI Bank credit cards work the same way. Choose the ICICI Bank Credit Card template, upload the card statement, and each charge and credit is matched against the card ledger.

Benefits

Why travel agencies choose this approach

01

No more ticking statements by hand

Every ICICI Bank line with one clear match in the books is reconciled the moment the statement is uploaded.

02

Only the exceptions to review

Possible matches and lines with nothing in the books are set aside, so the team works on those and nothing else.

03

One receipt, one deposit

A receipt or payment matched to one statement line is not offered for another, so nothing is counted twice.

04

The difference in one number

The statement total, the book total and the gap between them sit at the top of every upload.

How it works

From onboarding to daily books

  1. 01

    Download the ICICI Bank statement

    Export the account or credit card statement as an Excel or CSV file.

  2. 02

    Upload it to SYSTACC

    Open Bank Reconciliation, pick the ICICI Bank ledger and the ICICI template, and check the preview.

  3. 03

    Let SYSTACC match

    Deposits are matched to receipts and withdrawals to payments, by amount and date.

  4. 04

    Clear the exceptions

    Pick the right entry for each possible match, and post what is not yet in the books.

SYSTACC possible match screen: an ICICI statement credit of 45,000 with two receipts of the same amount, one selected to mark reconciled

Built with SYSTACC

Platform capabilities

ICICI statement template

Read the ICICI Bank account statement, with transaction ID, dates, reference number, remarks, amount and balance.

Automatic matching

Match deposits to receipts and withdrawals to payments, on the same ledger, by exact amount and date.

Possible match review

Choose the right receipt or payment when more than one entry fits a statement line.

Not matched list

See every line with nothing in the books, such as bank charges or unrecorded payments.

Statement against books

Compare the statement total, the book total and the difference for each upload.

ICICI Bank credit card

Reconcile ICICI Bank credit card statements against the card ledger the same way.

FAQs

Common questions

How does SYSTACC work with ICICI Bank?

You upload your ICICI Bank statement in Bank Reconciliation. SYSTACC reads every line and matches it to the receipts and payments already posted on your ICICI Bank ledger.

Which file formats can I upload?

XLS, XLSX, CSV and TSV. Choose the ICICI template for an account statement, or the ICICI Bank Credit Card template for a card statement.

How does SYSTACC decide a line is matched?

A deposit is matched to a receipt and a withdrawal to a payment, on the same bank ledger, for exactly the same amount, on the value date or the posted date. If exactly one entry fits, the line is reconciled.

What is a possible match?

When more than one receipt or payment fits a statement line, SYSTACC marks it as a possible match. You open it, see the entries with that amount and date, and choose the right one.

Does SYSTACC create entries for lines that do not match?

No. Lines with nothing in the books, like bank charges or a payment not yet entered, are listed as not matched. You decide how to record them, so nothing is posted without you.

Can I reconcile ICICI Bank credit cards?

Yes. Use the ICICI Bank Credit Card template to upload the card statement, and each charge and credit is matched against the card ledger.

What if I upload the wrong statement?

You can delete a single line, or the whole uploaded file, and upload the correct statement again.

Is there a live connection to ICICI Bank?

Reconciliation works with the statement you download from ICICI Bank. You upload the file, and SYSTACC does the matching.

Related pages

Explore more accounting topics

A live walkthrough

Books that keep pace with every ticket, refund and rupee.

Thirty minutes on the calendar. We follow a booking through to the books, and you choose the time.

  • 30 minutes
  • Live product
  • Your operation
Prefer a written quote? Request pricing
CalendlySchedule a demoPick a time. We’ll bring the product.Open the calendar