Wednesday, April 17, 2019

Saved Search for Unreconciled Bank Transactions

To do the Saved Search:
1. Navigate to Lists > Search > Saved Searches > New
2. Choose Transaction
3. Under the Criteria tab > Standard subtab, add the following Filters:
    Account = <the bank account you are reconciling>
    Cleared = is false
    Date = <choose a date range>
4. Under the Results tab > Columns subtab, add the following Fields:
      Date
      Period
      Type
      Number
      Account
      Memo
      Amount
5. Under the Available Filters tab, add Date and Show in Footer = Yes
6. Create a name for the Search Title and click Save & Run

Enhancement 263845: Transactions > Bank > Reconcile Bank Statement > Ability to Export Unreconciled Bank transactions to Excel, has been filed to have this feature.

No comments:

Post a Comment