On the Bank Reconciliation screen, enter the date range for the bank statement and related bank account for which you are currently working and click Search. This generates a list of all the EFT and check payments, deposit and withdrawals entered in Tres during the time period entered.
Before you start, confirm the Cleared Bank Beginning Balance matches the Beginning Balance on the Bank Statement for which you are working. If not, check the balance from the previous statement. If there are still discrepancies, please contact our support department for assistance (support@trestechnologies.com).
Compare the items listed on your bank statement with the items in the search results in Tres. All of them should be marked as cleared by checking the box that says not cleared in the Date Cleared column for each transaction. Clicking items that already have a check mark will remove the cleared date.
Click on the column header to sort the column. In the example below, the information is sorted by Date in descending order.
Resize columns by hovering over a column header until the column is highlighted and move to the outside edge of the column until your cursor changes to horizontal arrows. Click and hold to slide the edge of the column in either direction to the preferred size.
Reorder columns by dragging and dropping.
Clicking on the Type will open the Payment, Deposit or Withdrawal.
Once all items have been checked save the changes. Notice the totals at the bottom of the screen change when the reconciliation is saved. Compare the Cleared Ending Balance to the statement ending balance. If there is a variance start by checking if the Money In and Money Out totals match the bank account to identify what type of transaction might be missing or not cleared.
Money In – Is comprised of Deposits, EFT and Checks paid to the Agency
Money Out – Is comprised of Withdrawals, EFT and Checks paid by the Agency
Review the items for that category against the bank statement again. Check or uncheck any additional items needed or add a missing transactions and save again. Check your totals and repeat the steps until the Cleared Ending Balance matches your Ending balance on your bank statement.
If an item is on the Bank Statement but not in Tres, it will need to be added.