Step-by-step guide
Bank statement matching
Import a statement CSV and reconcile its rows with existing non-cash vehicle payments.
In this guide
Where to find it
Finance → Bank reconciliation → Import bank statement
Before you start
- Record actual non-cash vehicle payments before trying to match them.
- Use a CSV under 1 MB with at most 500 rows and the template headers.
Prepare the statement
Open Finance → Bank reconciliation and choose Import bank statement. Download the CSV template. Use the headers date,amount,direction,reference,description, CREDIT or DEBIT for direction, and up to 500 rows in a file smaller than 1 MB.
Preview before importing
Choose the file in the side panel, review Preview import and then Confirm import. Duplicate statement rows are skipped. Importing does not create a payment or change a vehicle balance.
Review a suggested match
Choose Review match on a statement entry and select a payment inside the panel. Suggestions are within seven days and must match both amount and money direction. Cash payments cannot be matched.
Correct the link
Confirm the match after reviewing the payment. Use Unmatch and confirm to remove a link. Matching and unmatching require Manage Payments permission and do not move money.
What to enter
Use this alongside the fields shown in your workspace.
| Field | How to use it |
|---|---|
| Direction | CREDIT matches buyer receipts; DEBIT matches seller payments. |
| Reference | Keep the bank reference from the statement. Review the preview before confirming import. |
Worked example
Sample dataIllustrative values, not a screenshot or live customer record.
- Amount
- ₹20,000
- Direction
- CREDIT
- Reference
- SAMPLE-UTR-001
- Matching payment
- Existing buyer bank payment
A suggestion must have the same amount and direction and be within seven days. Confirming links existing records; it does not create another payment.
Common issues & fixes
No matching payment is suggested
Check the amount, date, direction, cash mode and whether that payment is already matched to another row.