Bank Account Reconciliation
Rentec Direct property management software provides all the tools needed to accurately reconcile your Rentec Direct account with your bank account statement.
Pro Tip: Entering outstanding journal entries before reconciling helps to ensure your account balances.
Learn more about Rentec Direct's Full Accounting Options: Assets, Liabilities, and Equity with a True Balance Sheet
Bank Account Reconciliation
The following steps will guide you through verifying that your Rentec Direct account ledgers match your bank account transactions.
In your Rentec Direct account:
- Click on Banking
Right-click on a bank account and choose Reconcile
Tip: There is also a Reconcile button at the top of each bank ledger page
- Enter the Statement End Date, the Opening Balance, and the Ending Balance as printed on your bank statement.
- Click on Begin which will take you to the Reconciliation screen
- Unreconciled transactions processed near and up to the Statement End Date indicated will automatically be displayed.
- To change the date range of transactions, click on Statement End Date then enter a Custom date range or select Include all Dates to select all unreconciled transactions
Unreconciled Debits & Withdrawals will be on the left and unreconciled Credits & Deposits on the right.
Pro Tips:
* Easily scroll through each list independently
* Click on the Maximize Ledgers button under Bank Reconcile to extend the list of transactions
- At the top, you will see:
- The Cleared Balance which is the value you entered for Opening Balance in step 3 and adjusts as you check or un-check transactions.
- The Statement Balance is what you entered as the Ending Balance in step 3
- The Difference value is the difference between these two balances. The goal is to make the difference $0.00 indicating that your bank statement and online ledger match.
- There are two methods for proceeding:
- Quick Method: Click the box at the top of each list to the left of Date to mark all transactions.
- Long Method: Review the debits on the left and credits on the right against your bank statement and mark the checkbox next to each matching item.
- If the Difference value at the top is $0.00, it is a high likelihood that your bank statement and online ledger match perfectly. You can click on Finish to complete the reconciliation, which will mark all associated transactions with an R in the bank account ledger and the reconciliation screen will close.
- If the Difference value does not equal $0.00, it means there is a discrepancy.
- First, look at the bottom of each list, and un-check any transactions that are within the Rentec ledger that happened after your bank statement was printed. Those transactions will get reconciled on the next statement. If the difference value now equals $0.00, click on Finish.
- If the Difference value does not equal $0.00
- Make note of any transactions on your statement that are not within your Rentec ledger and click Finish Later
- Enter into the appropriate ledger any missing transactions (typically these are property-related expenses which you'll want to post within Properties, or tenant income which posts on Tenants)
- You can now return to the reconciliation and mark the checkboxes next to the missing transactions. When done, click on Finish.
System Notes:
- If the difference value was not equal to $0.00, the software will automatically post an adjustment to the account for the difference. If you prefer the adjustment not to be posted to the ledger, simply delete it afterward.
- If your account appears to be correct, but still doesn't balance review the convenience fees reflected on your bank statement that are not indicated in your Rentec Direct account.
- Learn more about how to Undo Bank Account Reconciliation
How to Clear Past Transaction as Reconciled
Some clients have asked how to mark all transactions as reconciled without reviewing every historical bank statement. To accomplish this, follow the simple instructions below.
In your Rentec Direct account:
- Click on Banking
- Right-click the bank account and choose Reconcile
- Enter Today's date, and put 0.00 for beginning and ending balance, click on Begin
- Select Mark All on the next screen
- De-select any transactions you do not want to be included, then click on Finish. If an adjustment is automatically posted, you can then optionally delete the adjustment value if you wish.