Loan Interest Adjustment
- Look at the loan paper. Note the PRINCIPAL BALANCE number.
- Go to Quickbooks
- Go to Lists, Chart of Accounts or click on Accnt Icon in top row
- Scroll down to 2200 Mortgages
- Scroll down to the mortgage that is the same as the statement in front of you. They are in the order of the loan numbers
- Double click to open up the register.
- Note the number in the month PRIOR the the month you are fixing
- Subtract the number on the prior month (November) from the Principal Balance number from the statement
- Double click on the Current month (December) you are fixing. The check will pop up.
- Take the number you subtracted and overwrite the amount in the mortgage column
- Hit the TAB button multiple times until you reach the third line. The difference in interest will automatically be calculated.
- Take the number that pops up and subtract (or add) it from the second line Interest expense
- Replace the Interest expense amount with your new calculated number. Delete the number below
- In the memo areas type in yea for Year End Adjustment so you know that loan has been corrected for the year
- Click Save and Close
- Now look back on the register of the month you are working on and make sure it is the same as the Principal Balance number on the bank statement. This is very important that they match up.
- X out of the register in the top right and go on to the next one.
- At the end file the loan statements in the correct file.