Bank
The bank statement matched to the books, and the difference explained.
Import the statement as it comes from your bank. Lines are matched by amount, date, cheque or UTR number and the party's name, and charges and interest are posted from it.
LiveIncluded in every plan
kestrelvalley.probahostack.com/accounts/bank
| Line | Matched to | Date | Amount |
|---|---|---|---|
| UTR 4821…93, Riverline | Receipt 0188 | 12 Nov | ₹37,524 |
| Cheque 004512 | Payment 0071 | 12 Nov | −₹14,160 |
| Bank charges | Posted from the line | 12 Nov | −₹236 |
| NEFT, unknown party | Not matched | 12 Nov | ₹5,000 |
UTR 4821…93, Riverline₹37,524Receipt 0188 · 12 Nov
Cheque 004512−₹14,160Payment 0071 · 12 Nov
Bank charges−₹236Posted from the line · 12 Nov
NEFT, unknown party₹5,000Not matched · 12 Nov
Matching
Import, match, reconcile.
- Bank statements from CSV or Excel, in the formats Indian banks use
- Lines matched by amount, date, cheque or UTR number and the party's name
- A bank reconciliation statement for any date
Reconciliation, 12 Nov1 line left
Books₹6,48,200
Bank₹6,53,200
Not matched₹5,000
Cheques and charges
The small entries post themselves.
- Bank charges and interest posted from the statement
- Post-dated cheques, and returned cheques with their charges
Cheque 004498Returned
Bank charges₹354
BillOpen again
Questions
What people ask about Bank.
Which banks' statements can we import?
Statements from Indian banks in CSV or Excel. PDF statements aren't read.
What about a cheque that bounces?
Record it as returned, with the bank's charges, and the bill is open again.
Works with
Receipts and payments find their line.
Matched lines close the receipts and supplier payments you recorded in Sales & billing and Purchases.
Bank: LiveBilling: LivePurchases: LiveBooks your CA can work with: Live