Saturday, April 27, 2019

Identify transactions that have been reconciled or matched from the Balance Sheet Undeposited Funds account.

1. Create a Transaction Saved Search:
- Navigate to Lists> Search> Saved Searches> New
- Under the Criteria tab, add Account: Undeposited Funds
- Under the Results tab, group the Name and place Sum on the Amount

2. Export the file in Excel and sort by Amount.
- All zero values are reconciled transactions while non-zero valued amounts are discrepancies on the reconciliations.

 

No comments:

Post a Comment