Axis Bank Integration with SYSTACC

Overview

Accounting software built for travel

A travel business sees a steady flow through its Axis Bank account: client receipts by NEFT, RTGS and UPI, supplier and airline payments, cheques and bank charges. SYSTACC brings that statement and your books together with bank reconciliation.

Open Bank Reconciliation, pick your Axis Bank ledger and choose one of the two Axis templates. The AXIS template takes the regular account statement as Excel or CSV. Axis puts account details above the transactions, and that block can be a different length each time, so SYSTACC finds the transaction header row on its own. It reads the transaction date, value date, cheque number, particulars, debit or credit, amount and balance, and stops before the legend at the end of the file. The AXIS - Detailed template reads the detailed statement, with transaction date, cheque number, particulars, separate debit and credit columns and balance. You see a preview before anything is saved.

Then every line is matched to your books. A credit is matched to a receipt, and a debit to a payment, on the same Axis Bank ledger, for exactly the same amount, on the value date or the transaction 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 credits.

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, so you know the gap before month-end. Uploaded files are listed by date, and you can delete a single line or a whole file and upload again.