How to Reconcile The Loan Bank Account
I have set it up so all the loans come out of one bank account. It makes it easier to reconcile. Also this account does not need to be reconciled as often as the rent account. Which should be reconciled every month to make sure the Tenant customer accounts are accurate.
The principle and interest change every single month for every loan account. If you wanted to be completely accurate you would have to go in and change the amount of principle and interest for each loan every single month. This is a lot of work. If you do not it makes your profit and loss statement slightly inaccurate but in is an insignificant amount. We do a correction at the end of the year to make the principle and interest completely accurate for the taxes. You can also do the correction quarterly or semi annually before you do the P&L. The directions for the correction is under a different instruction sheet called Loan Interest Adjustment.
We put the principle and interest amount of the month we are changing and memorize it for
- Get Bank Statement for the month you are reconciling
- Get Loan Statements for the month you are reconciling. If you can’t find the Loan Statements you can look then up online.
- Benchmark
- Columbus First
- Click Banking
- Click Reconcile
- Select the correct checking account (Columbus First)
- Check that the begining balance in QB matches the begining balance on the bank statement
- Type in the ending balance
- Click Continue
- Click top right corner to make the screen bigger
- Double click the amount to sort the numbers in order from smallest to highest
- Check Hide Transactions After the Statement’s End
- Go through the bank statement and check off all the amounts that match QB
- After you are finished, highlight all the amounts on the bank statement that are not checked off.
- Check the previous statement and see which ones are already memorized. Put an M in front of the amount.
- Go to the memorized transaction list
- Double click the amount column to sort the memorized transactions in ascending order.
- Find the first one that is memorized.
- Double click on the loan amount to open it up.
- Change the date to match the statement. You can put it one day different to make it easier to find later.
- Click Save and Close
- Put a dot on the bank statement next one till all transactions are entered.
- X out the memorized transaction screen and go back to the reconciliation screen. You will see all the duplicates of the transactions you just entered. They have the same address as the other ones and they are white. This is where you will see the different date.
- Click the correct one to reconcile it and put a check on the bank statement.
- Double click the wrong one to open it up.
- Go to the top left and click edit, then right click to bring up the menu then click delete check
- It will ask “Are you sure you want to delete this check” Click OK
- You will then be on a screen with a different unrelated check. (It is the next one in sequence) X that check out to go back to the reconciliation screen.
- Make sure it has been reconciled and check off on the computer and the bank statement.
- There will be a few transactions left that need to be changed that are not memorized. Circle them with the highlighter.
- Then double click them to open up the check.
- Search the loan statement for the matching transaction with the wrong amount. The Loan statements are in numerical order by loan number. If you do not have the bank statement you can login to online banking and get the principle and interest and total amount.
- Change total amount and principle and Interest
- Memorize
- Add to group. Group name = Benchmark Loans or Columbus First Loans.& Click OK
- Save and Close
- It asks you if you want to record your changes, Click Yes
- On the top left bar click Lists
- Click Memorized Transaction List
- There should be two memorized transactions with different amounts
- Find the one with the old amount
- Right click the mouse and click Delete Memorized Transaction.
- Minimize or x out of memorized transaction list.
- You are now back on the reconcile screen.
- After all transactions are checked and the difference is Zero click reconcille now and you are done for that month. Yeah!