Loans and the loan payment template
Adding your Loans to your REI Hub Portfolio allows you to track the flow of funds through your business, as well as things like principal paydown and estimated equity. Before you can book a Loan Payment, you must first create a loan account.
Loan Accounts in REI Hub encompass both mortgage and non-mortgage loans. Creating a loan automatically adds it to your Chart of Accounts as a Liability Account. If it is an escrowed loan, the Escrow Account is also automatically added to the Chart of Accounts as an Asset Account.
The Loan Payment Template helps you automatically break down regular loan payments into their component Principal, Interest, and Escrow (if applicable) parts.
Loan Accounts are not electronically linked in the same way as Bank and Credit Card Accounts, as loan payment transactions are typically already imported from the bank account side.
To create a Loan in REI Hub:
1) Navigate to the Loans page
Click on Accounts on the left-hand menu, and then select Loans below.
2) Click Add Loan
3) Enter the Loan's basic information
- Enter the Loan Name, Current Balance, and Date of Current Balance.
- If it is a mortgage, leave the 'This loan is a mortgage' box checked. Uncheck the box if it is not a mortgage, and any interest will be accounted for as 'Other Interest' instead of 'Mortgage Interest.'
- If the loan is escrowed, leave the 'This loan includes an escrow account' box checked. If the loan does not include escrow, uncheck the box.
4) Fill out the Loan Payment Template (optional but highly recommended)
- Monthly Payment Amount: This should be the exact amount of your recurring monthly payment.
- Paid from Account: Specify which account pays the loan so the system can look for the transaction.
- Interest Rate: Enter the exact interest rate with as many digits as required.
- Monthly Escrow Transfer Amount: This is the same amount every month (unless adjusted by your loan servicer) and can be found on your loan statement.
To not set up the loan payment template, uncheck the box. Without a payment template, you will need to manually enter the principal, interest, and escrow split when booking loan payments to this account.
5) Click Save Loan. View and edit from the Loans page
- Click on the name of the loan (in blue) to view all transactions associated with the loan.
- Click the Edit pencil to the right of the loan name to edit the loan name or payment template. For example, if the amount of your escrow transfer changes, so too would the total payment amount, and you would need to adjust the payment template to match.
- Click on View Escrow Account to see all transactions associated with that account.