To add a new loan to Loan Manager, there are some preliminary steps to make before running Loan Manager:
- Evaluate if this is a loan that Loan Manager can track. Loan Manager doesn’t track interest-only loans, so if your loan requires you to make regular payments of interest over time and the entire principal in a single payment at the end of the term, Loan Manager isn’t the right tool
- Verify the liability account for the new loan exists in your QuickBooks chart of accounts and that it is active; if not, add it or change its status
- Verify the payment account (normally a bank account) which will be used to make payments on the new loan exists in your QuickBooks chart of accounts and that it is active; if not, add it or change its status
- Verify the expense account which will be used to record interest expense for the new loan exists in your QuickBooks chart of accounts and that it is active; if not, add it or change its status
- Verify the expense account which will be used to record other fees (such as bank fees) for the new loan exists in your QuickBooks chart of accounts and that it is active; if not, add it or change its status
- If your loan has escrow payments associated with it, verify that the asset account which will be used to record prepaid expenses (such as property taxes or insurance) for the new loan exists in your QuickBooks chart of accounts and that its active; if not, add it or change its status
- Verify the vendor or other name to which payments will be made exists; if not, add the vendor or other name
- Enter the journal entries in QuickBooks so the current balance of the liability account associated with your new loan equals the original amount of the loan
- Have in front of you the following information about the new loan: the origination date, the term, the interest rate, whether your lender uses daily compounding (and if so, whether it’s on a 360 or 365 day basis), the payment amount, the sequential payment number, the due date of next payment, and the escrow amount (if any)
Since Loan Manager reads information from your QuickBooks chart of accounts when it first loads, if the accounts required to set up the loan do not exist when Loan Manager starts, you won’t be able to set up the loan properly – even if you open a window within QuickBooks to add the accounts while Loan Manager is running.
Here’s the main window of Loan Manager:
To add a new loan, click the Add a Loan… button. The Add Loan window, the first step in the process, appears. Since we’ve already followed the steps in our checklist, our accounts already exist and the balance of our liability account equals the Original Amount of the new loan. In this example, that amount is $200,000.00. Choose your liability account and Lender (a vendor or other name) from the pull down menus. Enter the Origination Date for the loan, the Original Amount (which in our example is $200,000.00), the Term and the type of number the entered Term represents (weeks, months, or years).
Once this information is correct, press the Next button to bring up the second screen in the process of adding a loan. On this screen, enter the Due Date of Next Payment, the Principal Amount, and the Next Payment Number. For a new loan, the Next Payment Number will normally be 1 provided that you’re setting up the loan before your first payment is due. Choose the Payment Period (one of weekly, bi-weekly, semi-monthly, monthly, bi-monthly, quarterly, semi-annually, or annually) from the pull down menu. Specify whether the loan has an escrow payment associated with it, and if so, enter the Escrow Payment Amount and the Escrow Payment Account. The Escrow Payment Account is normally an asset account because escrow payments are being made in advance of the expense being incurred. If you want QuickBooks to remind you before a payment is due, make sure the checkbox is checked.
Once this information is correct, press the Next button to bring up the third screen in the process. Enter the Interest Rate for your loan as a percent. Choose the Compounding Period for you loan, which will default to the Payment Period you entered on the previous screen. You’ll also have the option of setting the Compounding Period to Exact Days to specify that your lender is using either a 360 or 365 day year to calculate interest. If you choose this setting, you’ll have the additional option of specifying the Compute Period as either 365/365 or 365/360. This information would normally be found in your original loan documents. Choose your Payment Account, Interest Expense Account, and Fees/Charges Expense Account from the pull down menus. Normally, the Payment Account is a bank account, such as a checking account.
When this information is correct, press Finish. You’ll see a screen similar to the one below. In our example, we added a new loan with a principal of $200,000 at a 10% interest rate, a 60 month term with monthly payments, and a $2,000.00 monthly payment. Since this loan is not is not fully amortizing with those provisions, there is a balloon payment at the end of the term. Clicking on the Payment Schedule tab will display the payment information for the loan; the Contact Info tab will display the relevant information for the vendor or other name we specified as the Lender. This information is maintained in QuickBooks itself, not Loan Manager.
It’s important to understand that Loan Manager is primarily a tool to calculate payment schedules and to simplify the process of distributing interest and principal payments to the appropriate GL accounts. When you create a new loan in Loan Manager, the outstanding balance for that loan will start as $0 – until you record a transaction in the liability account in QuickBooks itself. Once the liability account is increased to reflect the loan’s principal, Loan Manager can assist you to record the regular payments. Likewise, when you remove a loan from Loan Manager, you are not making changes to the liability account balance. Since we completed our checklist steps before running Loan Manager, which included recording the loan balance in the liability account, the balance was displayed correctly once we added the loan. Had we not completed that step, the Balance column for our new loan would show the balance of our liability account, or $0.
For more information on using Loan Manager, see our related articles on deleting a loan and recording a debt re-financing.
(+1 rating, 1 votes)
Loading...
I upgraded to QuickBooks Pro 2014 in Apr. I have already entered in two new loans in loan manager and they are working fine. Recently I refinanced a loan and followed the steps QB gave to zero out the old and set up the new. I set up in loan manager and it appears to be correct. When I ‘set up payment’ everything looks good…I click ‘ok’ so that I can ‘write a check’ and print it but the pop up window goes away and I am back on the Loan manager screen. The other two loans take me to write a check but for some reason this one wont. Any ideas?
Nothing immediately comes to mind. Loan Manager is one of the older, less frequently used parts of QB, so it may be that you’ve uncovered a glitch with your particular installation and QB 2014. The normal steps to troubleshoot are to make sure you are on the latest release, try to recreate the behavior with screenshots, and contact Intuit.
Just a following on. The interest due never changes even if I change the frequency of payment. The interest due also does change even if I change the start state of the first payment. So if I make my first payment 1 month and every month it is the same interest due even if I start paying one year later and only pay on the loan once a year. I should have a full extra year of interest due plus I should have to pay for a total of 12 months interest. Instead it always looks like the total interest due if I start paying one month after the loan started and always 1 months interest regardless of the other terms entered.
I have QB11 Pro. I support Don’s comment. I’ve tried to enter simple loans but the interest does not seem be calculated properly. I have tried to enter a $12,000 loan with 5% interest as a test. The annual interest would be $600 which should mean $50 in monthly interest. I get less than $20 in interest as being the correct amount.
Perhaps I’m missing something obvious.
Dary, this isn’t easy to troubleshoot unless you can provide screenshots of the data you’re entering into each of the Loan Manager screens. When your interest amount is so much less than it should be, it’s usually an indication that you’ve entered any one of or a combination of principal, interest, or periods incorrectly. Note that interest rate is the annual interest rate, not the monthly rate even if your payments are monthly.
Can you setup a daily or weekday payment period in QB 2012 Loan Manager?
Unfortunately, there’s a glitch in using QB 2012 Loan Manager on systems with IE 9, and the fixes require settings that we can’t make to our systems, so we’re not in a position to test this for you. That said, it’s not likely that Loan Manager will do daily payment periods; the shortest period you’d likely be able to do with the tool is weekly. Intuit’s view is that Loan Manager is used very infrequently, so they don’t devote the resources to update that utility. Therefore, you’d probably be better off managing loans in tools such as Excel, which would give you the ability to have daily or weekly payment periods, and enter either detail or summarized data into QB via general journal entries.
The setting “exact days” and 365/360 does not work. Quickbooks does not calculate the correct interest and principal. This has been an issue for years and Intuit has not fixed it.
Don – Can you give a specific example of the data you are using, what QB calculates and what value you expect? Also, please indicate your QB version (year) and release.