To reload the entries list (in case you created new ones, in a different window) hit the yellow “Refresh Entries” button.
Once the Matched Balance (Purple) equals the Statement Balance (Orange) the Reconcile button will become available, the remaining amount is displayed in pink.
The Matched Entries will indicate when they have not been saved, a yellow exclamation icon will be visible (circled in blue), before you leave or when you are ready to reconcile click “Save”.
· To process by uploading a csv or excel file, choose the Statement type you are uploading and then drag the file to the drop zone to upload the file. If a file is already uploaded for this session, the green plus button above the drop zone appears so that you can reopen it without having to re-upload the file.
· At the top of the uploaded statement there is aggregate data to show you how many items the system has matched to the uploaded document, the percentage of the statement that matches and the value of the entries that do not have a match.
· For entries with “No Match” or an “Unbalanced Multiple” (yellow instead of green) there may be 3 buttons to allow you to easily create a transaction (Red)
o CT – Custom Transaction, AP – Liability,
o CE – Cash Entry
o An “Unbalanced Match” is where an entry in the upload has 2 or more matches in the system, but not the same amount in the upload, or the reverse where there are 2 or more in the upload but less in the system
· Beside Each green match type indicator e.g. “Single” there may be up to 2 icons (bright purple), a warning indicator, saying that the entries it matches are not in the matched list , or a not equals sign, just to indicate a “fuzzy” match, e.g. the day does not exactly match based on the match settings in finance settings
· To retry matching the upload with possibly newly created entries hit the “Rematch Upload”
· The “Match Successes” button will move all matched, Green “Single or “Multiple” entries from the un-reconciled list to the matched list.