Loan Manager - Accounting Software Secrets
book-template-default,single,single-book,postid-15898,bridge-core-2.6.3,qode-page-transition-enabled,ajax_fade,page_not_loaded,,qode-theme-ver-24.8,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.5.0,vc_responsive

Loan Manager

Loan Manager

Loan Manager

In prior versions, creating amortization schedules required Excel or some other product such as TValue to calculate loan repayment schedules.  New with version 2004 a loan manager is built in with the Pro and higher products.

Before beginning obtain all loan related information.  The actual loan document is preferred, but at a minimum the liability account will need to be set up on the chart of accounts, origination date, the loan amount, payment amount, interest rate, term of loan, payee, loan number, etc.  Next, choose Banking > Loan Manager.

QBRA-2004: Banking > Loan Manager

Next, it is time to add a loan. 

The Account Name is available from the other current liability and long term liability type accounts.  The lender is available from the vendor or other names list.  The origination date is the date the loan was funded.  The original amount is the amount that was borrowed when the loan was obtained.  And the terms should be entered as a number of months (for example, a 5 year loan is 60 months).  It is important that all this information is entered accurately to ensure an accurate schedule of principal and interest payments.

TRICK: Be sure that both the account name and lender name are set up on the appropriate list prior to opening the loan manager.  If the loan manager is already open and then the names are added, the pull down lists within the loan manager will not be updated.

QBRA-2004: Banking > Loan Manager > Add a Loan

Click the next button to proceed to the payment screen. 

On this screen, the date of the next payment is entered; the amount of the payment; payment frequency, and the loan payment number that is optional.  If the loan also has an escrow payment, it can be entered on this screen too.  By default the check box is marked to show a reminder 10 days before the payment will be due.

QBRA-2004: Banking > Loan Manager > Add a Loan > Next

The next screen is the interest information.

The interest rate is entered as a percentage.  The compounding choices are either monthly or based on the actual days.  If the latter is chosen it is possible to designate 365/365 for the period or 365/360.  The payment account is chosen from the bank accounts.  On this screen enter the interest expense account and the fees/charges expense account from the chart of accounts.

Once everything has been entered, click the finish button.

QBRA-2004: Banking > Loan Manager > Add a Loan > Next > Next

Once the loan is set up, clicking on the payment schedule will display the principal and interest portions of each payment of the loan. 

Note: A test loan entered using T-Value (difference coded to first payment) and the loan manager resulted in the same amortization schedule. T-Value is much more flexible to control exactly how the amortization schedule is calculated. But using this example, the schedule was the same

QBRA-2004: Banking > Loan Manager > Payment Schedule

With the loan manager open it is possible to have the software enter a check or bill for the payment.  It is also possible to enter a regular payment or an extra payment.  The principal and interest amounts are filled in based on the payment schedule, but can be overridden as needed.

QBRA-2004: Banking > Loan Manager > Set Up Payment

The “what if scenario” button will permit evaluating the loan based on the following choices:

  1. What if I change the payment amount?
  2. What if I change my interest rate?
  3. How much will I pay with a new loan?
  4. What if I refinance my loan?
  5. Evaluate two new loans.

Enter the new information and click on calculate to see the results.

QBRA-2004: Banking > Loan Manager > What if Scenario

More information on this topic

Overview of Version 2004

Miscellaneous Transactions