Performing Reconciliations

• • All reconciliation tasks are done on the main 'screen' for each Recon - the Reconciling Items and Summary page. Return to the Dashboard by either clicking on the arrow next to the name or by clicking on the dashboard menu item

  • This is a list of all unreconciled items for the account.

  • It also shows a summary of the datasets and the balances and differences.

  • Export to Excel will export both the Summary and the List of Reconciling Items to Excel

  • Enter your search phrase to find the particular transactions you are looking for. Find search tips here. Clear the Search and return all items by clicking on the dismiss cross in the Search box.

  • Checking 'Include match items' will return all items, matched and unmatched, which match the criteria. You won't be able to select, check or add notes and labels to matched items but you can View the match and undo it if needed.

  • Add a Label by clicking in the label box. If there is a master list of available labels it will be shown for you to choose from. You can also add your own label if there is not one that matches your requirement

  • You can add the same label or note to multiple transactions by selecting them and clicking on the More link on the Selected Items pop up. Select from the list of available labels or add your own and type in your note then click Apply

  • Filter the transactions for all your selected items by clicking on the View selected transactions link

>

• • Select All will select all records that have been returned.

  • Scroll down to return more items. Use the Up arrow in the bottom left of the screen to return to the top of the page.

• • Hide Columns by clicking on the Hide Columns Button and selecting the columns you don't want to see. You can bring them back at any time by deselecting them. Hidden columns will still be used in Auto And Suggest Matches

Auto Match

• • Click on the Auto Match Button to Run the auto match rules. These have been defined by an administrator per Recon Template

  • A message appears in the right had corner of the screen 'Auto Match Started'.

  • It will fade after a few seconds.

  • Once the screen refreshes the auto match rules have run and you if any matches have been made the count of Reconciling items will decreased

Suggest Match

• • If there are any Suggested Matches which you need to verify and reject or ignore the blue link with the number of suggestions will appear between the Auto Match and Export to Excel button

  • Clicking on it will take you to all Suggested Matches.

  • Undo the Last Match made on this screen by clicking on the Undo Match button

Manual Match

There will be items that auto match cannot reconcile because there is not enough information available to identify a pattern and make a match. These transactions can be matched manually.

• • Select the transactions you want to match using the select check box. The Transactions selected must sum to zero or have a difference between -5 and +5

  • As you select items pop up will appear in the top right of the screen showing the total of the selected items and two options: Match and Clear

  • Click 'Match'

  • If the difference is between -5 and +5 a balancing entry will be created and included in the match to ensure it sums to zero. You can add a reason for this difference if required

  • The items will be matched and be removed from the Reconciling Items list

  • Balancing entries are added to their own dataset and included in the summary

  • If you selected the wrong transactions click clear to remove the check from all of them