How to Complete a Reconciliation

Accessing Reconciliation

1. Log in to Velocity Reconcile with your username and password.
2. On the VelocityReconcile homepage, navigate to the left-hand menu and find the section titled “Reconciliation.”
3. Select the Reconciliation type that you will be completing.
    

Reconciliation Page

1. After selecting your desired Reconciliation, you will be brought to the Reconciliation’s page. Please use the following steps to do so.
1. Select the Bank/OEM. *The option will change based on your selected reconciliation type
2. Upload your DMS or Accounting ledger
3. Upload the bank, OEM, or lender statement
4. Click Reconcile
5. Your Reconciliation results will appear below the Reconcile button. 
   ^{*The option will change based on your selected reconciliation typ}
2. Once the above steps have been completed, Reconciliation results will appear beneath the Reconcile button:
1. Summary- shows a count of all the records in each file, and those that have been matched in both
2. Matched - shows all items that have been matched between both files
3. DMS/Accounting Only - shows items that are only on the titled documents ledger
4. Bank/OEM/ Lender Statement - shows items that are only on the titled documents statement
5. All Data - Shows all data, with the mis-matched row for both documents appearing first on the list
3. Clicking on one of the tabs will display a list of the reconciled items.
1. Line items that are mismatched will be listed at the top 
2. You can click on the Hide Perfect Matches button to display only the mismatched items in both files to simplify your work.
3. The DMS/Accounting and Bank/OEM/ Lender tab(s) display only mismatched items from statements.  
4. All Data - Shows all data, with the mis-matched row for both DMS and Bank appearing first on the list 
   
4. At the top-right corner of the Reconciliation Results is an option to Export to Excel. This will allow you to export an .xlsx file of the results you have displayed. Please note that using the Hide Perfect Matches button and then downloading an .xlsx file will result in only the mis-matched items being added.
5. Once you have the file you need, you are all done!