Home
Conquer 27 Mistakes
COGS Help
QuickBooks Help
Free Ezine
Free E-Book
QuickBooks Enterprise
QuickBooks Premier
QuickBooks Pro
QB Wish List
Testimonials
Contact Jennifer
Why QuickBooks?
QB Online Banking
QuickBooks for Mac
QuickBooks Payroll
QB and Turbo Tax
QuickBooks Blog
Site Map
Links & Forms
QB Damaged File
About Jennifer
Buy QuickBooks
Bookkeeping Supplies
Search this Site
Affiliate Program
Bookkeeping Help
Funny Stuff
QB eBooks
Negative A/R
Saving Money
Facebook!
Bank Recon Help
Subscribe To This Site
XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Refinance a Loan

by Peggy

The business has refinanced a loan. I need to close out the old loan and open a new one with the new balance and new account number. Can you help? Thanks.

Jennifer replies:

I'll assume that you mean to ask about the specific bookkeeping entries in QuickBooks. There might be other ways, but here's how I would do it.

It is important that the old loan has been entered and reconciled. We will transfer the reconciled balance from the old loan to the new one. I won't go into detail about reconciling here. If you need more help, here's a url where I wrote some reconciliation instructions (copy and paste into your web browser):

http://www.jenniferthieme.com/reconcile-statements.html

After the old loan has been reconciled, make a note of the ending balance. Go to the Chart of Accounts and set up a new Long Term Liability account. Name it something that looks like this:

Bank of America 9876

"9876" represents the last four digits of the loan account number, and "Bank of America" represents the name of the financial institution that holds the loan.

Once this is set up, go to the Transfer Funds screen:

Banking > Transfer Funds

Enter the date of the new loan. In the "Transfer funds from" box, select the NEW loan account (yes, you read that correctly!). In the "Transfer funds to" box, enter the OLD loan account (Yes, you read that correctly too - see the astrisk below for explanation). In the Amount box, enter the ending (reconciled) balance of the old loan account. In the memo line, type something like this:

"Closes old loan, and opens new loan 9876" or something similar. Save the transaction.

*Why are the Transfer accounts switched? It's because of the terminology of QuickBooks. The Transfer Funds From box creates a credit for that account, and the Transfer Funds To box creates a debit for that account. We are not transfering funds, we are transfering debt. So we must credit the new account to raise it's balance, and debit the old account to lower it.

Now go back to the Chart of Accounts. The old loan should have a zero balance, and the new loan should have the correct starting balance. Make the old loan account inactive by right clicking, and selecting Make Account Inactive. You can then hide it by making the appropriate selection in the Chart of Accounts.

If you could post a comment below and let me know if this was helpful or not I'd appreciate it. Thanks.




Comments for
Refinance a Loan

Click here to add your own comments

Dec 01, 2009
P. Kelly (refinance loan)
by: Amanda

I find a simple solution to the loan being posted as an expense. Just use a journal entry. Create an acct for your original bank loan in the liability section. Then post a journal entry transferring the loan out of the expense acct into the liability account. Then you can make your refinance entry as Jennifer mentioned above (create your new loan acct, etc). However, I find that making a journal entry closing out the old loan and posting the new loan amount to be a better option than the 'transfer funds' entry (my opinion). I feel it's better because the journal entry is all encompassing. It shows everything that is happening with that refinance...payoff amt, closing costs, new loan balance, insurance/tax escrow, etc. These all need to be entered and it's nice to have it all printed on one journal entry so you can see all the entries that were made and print the info out for the files. Good luck.

Jun 10, 2008
Worked perfectly!
by: Anonymous

You advice and instructions worked perfectly. This took all of 2 minutes to do, thank you!

Apr 29, 2008
Refiance a Loan
by: Peggy Kelly

Hi,

Yes, your reply was very helpful. It led to more questions, however.

I followed your instructions and understood them, but found that the old loans were originally entered as Expenses, so I couldn't "transfer funds." It appears the loans have to be entered as "Long Term Liabilities" when you use the Transfer Funds screen.

I came to this conclusion because the drop-down list in the Transfer Funds screen doesn't include Expenses. I tried to change the old loans so they would be long term liabilities and it wouldn't let me do that. So, these loans must have been set up incorrectly to begin with.

Jennifer replies:

Thanks for the info, Peggy. Yes, I try to assume that things are set up correctly when I give an answer.

You are correct that the Transfer Funds screen does not include Expense accounts. It doesn't include ANY account on the Profit & Loss statement, only accounts on the Balance Sheet. The Transfer Funds screen is truly for "transferring funds," (or debt); it's not for making adjustments of other kinds.

You have a problem on your hands. Loan payments are definitely NOT expenses. Well, let me clarify. The only portion of the loan payment that is an expense is the interest portion. The portion that pays down the principle of the loan is NOT an expense.

The profit on the P&L for this company is being understated because the principle portion of the loan is reducing it. I suggest getting professional, paid, help to rectify this problem. It's creating inaccurate financial statements, which is probably leading to incorrect tax returns.

I'm happy to help with this problem, but it's not something I can do in this format. Talk to whomever is responsible for the accuracy of the financial statements. See if that person is willing to go forward with getting the situation corrected. Whether it's me or somebody else, it's a problem that needs to be fixed.

Thanks again for the feedback.

Click here to add your own comments


footer for QuickBooks Help page