LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

Housing loan entry in tally

Prabhu Ind (Trading ) (56 Points)

24 November 2015

help me ,

How pass the Housing loan entry in tally erp9 .

House Property Total Amount is Rs.60,00,000/- . 1. 20,00,000/- advance Paid to Seller . 2. Balance Rs.40,00,000/- is Loan .

Amt.Financed from Pvt. Bank :Rs. 40,00,000/-

Principal Amount : Rs.57,491/- . Rate of Interest : 15.5%

Duration : 116 Months

Future Installments : Rs.76,28,624/-

Reply
Follow
Share

15 Replies

Vivek Kurup (.) (355 Points)
Replied 24 November 2015

Hi prabhu, This statement is not sufficient for accounting, as it doesnt provide interest-principal bifurcation. But you can book loan processing charges and interest on advance using this statement. However, from the inception of Paying EMIs, you need to know the actual interest debited in the loan account by the bank. For that, you may contact the bank to issue one. Its true that we can etimate the interest using financial calculators, but in most of the cases, it may not be the actual interest debited. So its always advisable to get the statement showing correct interest.

(Guest)

debit the property(make it fixed asset) i.e 60lacs...dr -- to cash/bank 20lacs--to loan a/c 40lacs...

make a loan a/c(long term liab/noncurrent)...make interest from loan a/c....when u pay the loan deduct principal amt from loan a/c and interest from interest a/c...interest a/c is current a/c though..

1 Like

Prabhu Ind (Trading ) (56 Points)
Replied 26 November 2015

Thank you sir

Prabhu Ind (Trading ) (56 Points)
Replied 26 November 2015

Dear Sir ,

Kindly check the statement up-right side they are provide intrest paid and pricipal paid . i am waiting for your answer .

Thanks,

Prabhu

(Guest)

U can do the accounting this way if u want...

put the principal repayments in debit of loan a/c...i.e debit the loan a/c with Rs. 57,491...

put the interest repayments in interest on loan a/c...(this amount goes to profit and loss, that is y its better to keep it seperate)..... so debit interest on loan a/c with Rs. 2,05,656...

(alternatively u can prepare single a/c for loan, but this one is easier to undrstand)

if u still dont undrstand u can PM me

Prabhu Ind (Trading ) (56 Points)
Replied 26 November 2015

Sorry Sir , I can not understand . i really confused about the Loan statement .

(Guest)

i am sorry...i donno how to explain properly

Prabhu Ind (Trading ) (56 Points)
Replied 26 November 2015

ok sir , thanks your support .

Prabhu Ind (Trading ) (56 Points)
Replied 26 November 2015

ok sir , thanks your support . i have knowledge only OD and CC A/c , without knowledge in housing Loan

(Guest)

ur welcome....if u want i can give u my number and u can whatsapp me...

Prabhu Ind (Trading ) (56 Points)
Replied 30 November 2015

+91 9025844433 my whatapp

(Guest)

u need to text me on whatsapp buddy..

9987173688... my name is ubaid just tell me that u are from CCI ill reply when i have the time :D

Karan Vinodbhai Karia (Student) (22 Points)
Replied 12 December 2015

MR.PRABHU ENTRY FOR HOME LOAN WOULD BE AS FOLLOWS:

WHEN YOU PAY ADVANCE

1. SELLER DR. XXXX

TO BANK/CASH A/C XXXX

WHEN PROPERTY IS PURCHASED AND TOTAL AMOUNT IS PAID

2. PROPERTY DR. XXXX

TO SELLER A/C XXXX

TO LOAN A/C XXXX

3.WHEN YOU THE PAY LOAN INSTALLMENT:

LOAN A/C DR. XXXX

INTEREST ON HOME LOAN A/C DR. XXXX

TO BANK/CASH A/C XXXX

ALSO YOU WOULD BE ELIGIBLE FOR BENEFIT OF REGISTRATION FEES PAID FOR PURCHASE OF PROPERTY AND PRINCIPAL AMOUNT OF LOAN UNDER SECTION 80C OF INCOME TAX ACT, 1961 AND INTEREST UNDER HOUSE PROPERTY HEAD.