Vehicle loan taken from bank

This query is : Resolved

Athar (Querist)
Follow

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

Vivek Hebbar

Vivek Hebbar (Expert)
Follow

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.

Message likes : 1 times

Vivek Hebbar

Vivek Hebbar (Expert)
Follow

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.

Message likes : 1 times

Upgrade to CAclubindia Pro. Subscribe Now!

Athar

Athar (Querist)
Follow

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

Vivek Hebbar

Vivek Hebbar (Expert)
Follow

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.