HDFC Bank Integration with SYSTACC

Overview

Accounting software built for travel

Month-end for a travel business means one long HDFC 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 HDFC Bank ledger and choose the HDFC template. Upload the statement as XLS, XLSX, CSV or TSV. SYSTACC reads each line from the HDFC layout, with the value date, narration, cheque or reference number, withdrawal or deposit amount and closing balance, and stops at the statement footer so summary rows are not read as transactions. You see 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 HDFC ledger, for exactly the same amount, on the same 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, 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.