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.