- Click on Checks on the top menu bar.
- Select Check Reconciliation.
- Enter the account number or click on the question mark
to use the account lookup function. - Enter the date range or click on the drop-down menu to select the dates on a calendar.
- Check off the Show Only Checks box (optional).
- Click Load.
- Click Change, if you need to change the starting balance. Verify this is the opening balance on the bank statement.
- When the account transactions load, all of the deposits will already be checked as cleared.
If there are deposits in transit you will need to remove the check mark from the appropriate box.
- Indicate the items that have cleared by placing a checkmark in the box on the left.
- The Import Bank Transaction File will open. Browse for, then select the csv file.
- Indicate which columns the information is in.
- Click Import. A summary will populate.
- The Exception Report will open once you click OK.
The deposits will be on the exception report, as well as any other discrepancies.
- Select Print Reconciliation Report.
- Click Export to Excel to save it in Excel.
- Click Close & Save to finish.