Solved

How to record loan interest expense alongside loan payment from cash on hand

Forum|Forum|7 years ago
December 11, 2018
5 replies
0 views

Hi. I made a loan payment from cash on hand. How can I record this, since I'm unable to modify the expense in the details sections of "write checks," because you can't use "write checks" with cash on hand. I need to show that 458.95 is taken off of the loan, but I need to show that 40.50 of it is interest expense. Problem occurs when I try to designate 40.50 to an expense account on the register of cash on hand, it doesn't reduce the total loan. Thanks for your answer.

QuickBooks Desktop

Best answer by Rustler

@ wheel house

cash has to be tracked in QB, you do that by creating a bank type account called cash and funding it

then you use write checks on the cash bank account (do not print the check)

on the expense tab for your transaction

loan liability account 408.45
interest expense 40.50

Only the principal portion reduces the loan, the interest paid does not

A

arkvalleyinfoAuthor

Edit: I noticed you're in QB Pro 13.0. Sorry about that. =)

A

arkvalleyinfoAuthor

Do you have a Cash on Hand (Bank type), Interest Expense (Expense), and Loan Liability (either Long-term (>12 months) or Other Current (<12 months) Liability) account in your Chart of Accounts (CoA)?

A

arkvalleyinfoAuthor

Hi, Tiffany. I just did some account rearranging and I now have a Cash on Hand account. It's a bank type. I have an interest expense account as well. And a Loan Liability account. I think I resolved my own problem. I do have one question that was born out of the response by Rustler below. In my long term loan liability account, should the balance be made up of only the principal amount?

A

arkvalleyinfoAuthor

@Wheelhouse
Yes, the principal is tracked in the Loan Liability account, the Interest is tracked in the Interest Expense account.
Though I'm a Certified QB User and Educator, I am NOT a CPA. It is always best to check with your accountant on which accounts to use.

Hope this helps!
Tiffany V.
Certified QuickBooks User/Educator

RustlerAnswer

@ wheel house

cash has to be tracked in QB, you do that by creating a bank type account called cash and funding it

then you use write checks on the cash bank account (do not print the check)

on the expense tab for your transaction

loan liability account 408.45
interest expense 40.50

Only the principal portion reduces the loan, the interest paid does not

A

arkvalleyinfoAuthor

I may need to set up the loan differently in light of this information. I guess I should only put the principal in the loan account? So the loan is only made up of the principal, and the interest is just tracked in the expense account?

W

wesmahler

This is one way of doing it. Although I don't like this way. Because then you can't see the loan history, and the transactions don't really match up to the statement. Obviously, if no payment was paid, interest would incur irregardless if a payment was made, and would be added to the outstanding loan balance. Although it's not the prettiest. I prefer to have a mortgage loan liability account, and track the interest. Unfortunately quickbooks only allows you to make an ugly journal entry, instead of just being able to add an expense for interest like a credit card account works. But then you have the loan transactions, outstanding principle owed, interest payments, and payments to the loan account. If you were to match it to a loan transaction statement, it would match this.

Sign up

Login with SSO

Login to the community

Login with SSO