All articlesTally

A Lender Statement Is Not a Bank Statement

It arrives looking like one, with two columns and a running balance. But it is written from the lender side of the account, and the balance on it is money the client owes.

Ajay Suryawanshi7 min read- views
A Lender Statement Is Not a Bank Statement

A client sends what they call a statement. Two columns, a running balance, dated rows, a closing figure. Everything about it says bank statement, and it goes into the import alongside the real ones.

It is not a bank statement. It is the lender's statement of the client's account with the lender, written from the lender's side of that relationship, and the balance at the bottom is money the client owes rather than money the client has.

Post it as a bank account and the client's balance sheet gains an asset that is actually a liability, at full value, on the wrong side.

Read the column headings, not the shape

There is a reliable tell, and it is in the heading row rather than anywhere in the data.

A bank heads its two money columns Debit and Credit, or Withdrawal and Deposit. Both are written from the bank's side of an account in which the customer holds money.

A lender heads them Payable and Receipts, before a Balance. Payable is what the lender charged: a disbursement, interest, a late fee. Receipts is what it took in against that: a payment, or a retail loan knocked off.

No bank heads its columns that way, because the relationship is the other way round. When you see Payable and Receipts on a document a client calls a statement, you are holding a lender's account of what it is owed.

Pro tip

Make this a ten-second check at intake, before anything is imported. The heading row answers it, and it is far quicker than discovering the problem from a balance sheet that will not tie.

The arithmetic says the same thing

If the heading leaves any doubt, the running balance settles it.

On a lender statement the balance moves like this:

balance = the balance before + Payable - Receipts

A charge raises it. A payment lowers it. That is the behaviour of an amount owed, not an amount held. On a bank statement the deposit column raises the balance; here the receipts column lowers it, because the receipt is the lender receiving.

So in the client's own books the account is a liability: a loan under Loans (Liability), or the lender carried as a creditor. Never a bank account, and never grouped under Bank Accounts where it will join the bank balance in every report that totals that group.

Which is the same family as two other accounts

This is the third document in a set, and seeing them together makes the rule easier to keep than learning each one separately.

DocumentWhat the balance isPosting
Bank statementMoney heldAn asset: money in debits it
Credit card statementMoney owedA liability: a charge credits it
Lender statementMoney owedA liability: a charge credits it

The last two behave identically, and for the same reason: the balance is an obligation, so the thing that increases the obligation credits the account and the thing that discharges it debits the account.

An overdraft or cash credit account is the odd one out. It arrives from a bank, with a bank's column headings, and is still a liability whenever it is overdrawn, which is covered in why an OD or CC account is not a bank balance. The card version is here.

Important

Because opening plus charges less receipts equals closing on these documents exactly as it does on an overdrawn account, a wrongly grouped loan account still reconciles perfectly. The arithmetic is not what tells you it is in the wrong place.

What the entries actually are

Once the account is in the right place, the rows sort into three kinds and only one of them is interesting.

A disbursement raises the loan and puts something on the other side: cash at bank, or an asset, or a party the lender paid directly on the client's behalf.

A repayment lowers the loan and credits the bank. The split between principal and interest is the part that matters, and it is the part a statement does not always break out. Where it does not, the interest is worked from the lender's own schedule rather than guessed from the instalment, because the split changes every month even when the instalment does not.

Interest, fees and charges raise the loan and are expenses. Interest is an expense of the period it relates to, not of the month it was charged, which matters at a year end. Processing and late fees carry GST, and whether that is creditable is the same question as on any other finance charge.

A note on what a reader should do with one

If you use anything that reads statements, the useful question is what it does when a document is not the kind it expected.

The wrong behaviour is to read it anyway, because the two columns line up and the balance chains. It will produce a clean import of a liability into an asset.

The right behaviour is to recognise the document by its own heading and say what it is, so that the account type travels with the reading rather than being assumed from the folder it was in.

Greenote identifies a lender statement from that heading row, marks it as a loan account rather than a bank account, and posts it through the same rule a credit card uses, since both are liabilities for the same reason. It does not try to split an instalment into principal and interest, because the statement is often not the document that knows.

Conclusion

Two columns and a running balance are not enough to tell you what a document is. The heading row is.

Payable and Receipts means a lender writing about what it is owed, the balance is a liability, and a charge credits the account exactly as it does on a card.

The cost of getting it wrong is not a failed import. It is a clean one, into the wrong half of the balance sheet. See what Greenote reads, or how a statement reaches Tally.

loan account in tally under which headloan statement entry in tallylender statement of account accountingloan under loans liability tallynbfc statement of account entry
Read on your own PC

Turn bank statements into Tally vouchers on your own PC

Greenote reads 100+ Indian banks and posts clean vouchers straight into Tally, from your own PC. The statement is not uploaded, and nothing is typed by hand.

Free trial: 7 days or 5 statements, no card. Works with Tally Prime & ERP 9.

Share this article