User Guide · Bring in data
Loan statements
Post disbursements, EMIs, interest and charges from a lender's statement.
- 1Open Loan Statements from the sidebar.
- 2Choose the Client and the Loan Ledger — the loan account in Tally. Ledgers under the loan groups (Secured Loans, Unsecured Loans, Loans (Liability), Term Loans and the like) are listed; use Show all ledgers or Type manually for any other.
- 3Drop the statement (PDF, Excel or CSV, up to 200 MB) and click Upload & Process.
- 4In review, choose the other side for each entry: the bank ledger for EMIs and disbursements, or an expense ledger such as Interest on Loan or Bank Charges.
Each line of the statement becomes one voucher. EMIs are posted as one amount; they are not split into principal and interest. The voucher type is decided by the ledger you choose:
| Entry on the statement | Other ledger you choose | Voucher posted in Tally |
|---|---|---|
| Loan disbursed | Bank | Receipt — Bank Dr, Loan Cr |
| EMI or repayment | Bank | Payment — Loan Dr, Bank Cr |
| Interest, processing fee, bounce charges | Expense ledger | Journal — Expense Dr, Loan Cr |
| Waiver or reversal | Expense ledger | Journal — Loan Dr, Expense Cr |
The review screen follows the lender's statement, so an EMI may show as a Receipt and interest as a Payment. That is expected — Tally receives the voucher types in the table above.
Avoid double entry: if the same EMI is also on the client's bank statement (same amount, within three days), we flag it. Push it from one statement only.
The loan template on the page has three money columns: Debit for anything that increases the loan (disbursement, interest, charges), Credit for anything that reduces it (EMI, repayment), and Balance for the amount outstanding.