CA Day celebration 2024 Easy Office
LCI Learning

Vehicle loan taken from bank

This query is : Resolved 

16 March 2013 Cost of Acquisition 137,000
Less: 20% Downpayment 27,400
Loan Received in Bank Acc 109600
Interest Payable on Loan Receipt for the period of 36 Months - 14738.25
( as per Repayment Schedule on Reducing Balance Method)
Amortization Schedule for 1st Year Date

Openig Balance Interest Principal Total Instalment Closing Balance 5-

May-12 109,600.00 753.50 2,696.50 3,450.00 106,903.50 5-Jun-12 106,903.50 759.46 2,690.54 3,450.00 104,212.96 5-Jul-12 104,212.96 716.46 2,733.54 3,450.00 101,479.42 5-Aug-12 101,479.42 720.93 2,729.07 3,450.00 98,750.35 5-Sep-12 98,750.35 701.54 2,748.46 3,450.00 96,001.89 5-Oct-12 96,001.89 682.01 2,767.99 3,450.00 93,233.90 5-Nov-12 93,233.90 640.98 2,809.02 3,450.00 90,424.88 5-Dec-12 90,424.88 621.67 2,828.33 3,450.00 87,596.55

Closing Balance of Bank is 87596.55

but as per my accounting Ledger Balance Shows 96738.25

I Accounted entry as follow

Bank A/c Dr 109600.00/-
Prepaid inTerest on Loan A/c Dr 14738.25 Loan Payable A/c 124338.25

then deduct every month 3450.00 as per above interest and principal schedule.


Can any one reconcile the balance n show me how to rectify the error


In Addition as per Bank Balance confirmation report there is some accrued Interest of 542.00 what kind of interest is this? pls Help

Atharparkar@gmail.com



16 March 2013 Your first accounting entry needs to be modified as follows:

1. Asset Account Dr. 137,000
To Bank Account 27,400
To Loan Account 109,600

2. For EMI payments:
Loan Account Dr. (Amount of principal)
Interest on loan Account Dr. (Interest Amt)
To Bank Account (EMI amount)

You need not pass entry for total interest (Rs.14,738.25) at the beginning itself. It will be booked along with the EMI entry as displayed in (2) above.

The reason being the interest does not accrue at the beginning itself. It gets accrued over the period of the loan. Hence, the entire interest should not be booked at the beginning.

16 March 2013 The accrued interest Rs.542 would be the interest for the period 5-Dec-12 to 31-12-12 since the balance confirmation would be as on 31-Dec-12. You can also calcualte the same as the interest amount displayed in the next EMI divided by 31 days and multiplied by 26 days od Dec 2012.


16 March 2013 Thanks a ton Vivek,1st time Got a clear answer from CA Club.

One more querry I have seen somewere interest for the full 36 month is shown as Prepaid then reversed. which one is better method prepaid interest or monthly expense out method as u said.

Kindly suggest

17 March 2013 The question of prepaid interest does not arise since you have not paid anything. The schedule of repayment is provided by the bank as a document displaying how your EMI would be adjusted between interest and principal repayment over the period of the loan.

The justification for recognising interest on a monthly basis is provided in my first reply.



You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query