Before importing a loan statement PDF, decide what you want from it. If you only need the EMI amounts, your bank statement already has them, and importing both would count each EMI twice. Import the loan statement when you want the interest, principal, fees and balance lines, and review every row before saving.
Do you need to import it at all?
The EMI leaves your bank account, so it already appears in the bank statement you import. The loan statement shows the same payment from the lender's side, with the split into interest and principal. That is useful for a loan page but it is a different view of the same money.
- Want only your monthly spending? Import the bank statement and skip the loan statement.
- Want the interest paid, fees and the balance? Take them from the loan statement, in a sheet or as reviewed rows.
- Want both? Import the bank statement for the EMI and use the loan statement for the split, without importing the EMI rows again.
How do you turn the PDF into a table?
- Check whether the lender offers an Excel or CSV version of the statement. If it does, use that.
- If not, upload the PDF directly. In SpendixAI, statements can be uploaded as PDF, CSV or Excel, and you review rows before saving. Layouts differ, so do not assume every line will be read correctly.
- Some Excel versions can read tables from a PDF through a data import option. Check yours. Google Sheets does not do this on its own.
- Copy the table into a sheet and clean it: one header row, one transaction per row, dates in one format and numbers without the rupee sign.
- Save as CSV and upload it.
Which columns do you map?
| Column in the statement | Maps to | Watch for |
|---|---|---|
| Date | Transaction date | Day and month swapped in text dates |
| Narration | Description | Long text split over two lines |
| Debit or amount paid | Amount | Which column is money out and which is money in |
| Credit | Amount, with the opposite sign | A payment to a loan can appear as a credit |
| Balance | Reference only | Do not import it as a transaction |
How do you avoid double-counting EMIs?
Pick the account before importing, because each transaction keeps the account it was imported into. Say your bank account already has an EMI of ₹12,400 on 5 August. If the loan statement shows an EMI received of ₹12,400 on 5 August, it is the same money. Keep one of the two, and delete or do not import the other in the review step.
SpendixAI flags possible duplicate imports, but a payment seen once from the bank side and once from the lender side is not an exact copy, so do not rely on the flag alone. Look at the amount and date yourself.
Check the result
After importing, add the rows for one month by hand and compare them with the statement. Take an invented month: EMI ₹12,400, of which interest ₹5,900 and principal ₹6,500. Check that ₹5,900 plus ₹6,500 is ₹12,400. If the numbers in your tracker agree with the statement, the import worked. If not, look at the import history, fix the rows and import again.
If you use a sheet instead, give the loan its own tab with the date, narration, interest, principal and fee in separate columns, and a small block at the top that sums each one. Keep the bank-statement import on a different tab so the two do not mix. Once the numbers match for a month or two, you can trust the setup.
A short routine
- Check the import history shows the status of the file
- Review any failed or duplicate rows
- Compare one month with the PDF
- Keep the original PDF in your loan folder
Useful ideas start with a clearer picture of your own spending.
Explore your reports
