Virtually all of Inform’s transaction display windows are organized in a grid format with the following features, which make it easier to manage large amounts of data or data from different sources.
- Sort the data by field header such as date
- Filter the data by field contents such as rent
- Export the data with combination of the above
The Bank function contains three windows, one of which is informational and two of which are transactional. Navigating to the following areas results in one of the Bank functions:
- File > Company > Bank opens the Setup tab. DDI uses this screen set up a new reconcilable account. Do not change it consulting DDI Customer Caresupport@ddisys.com.
- Accounting > Bank Reconciliation > Bank Ledger opens to a detailed list of every line item that affects the bank.
- Accounting > Bank Reconciliation > Bank Reconciliation opens the active and historical reconciliations.
- Go to Accounting > Bank Reconciliation > Bank Ledger.
- On the default bank account that appears, choose a beginning date and click Search to populate the screen.
The result is a detailed accounting of every transaction dated on or following the selection.
- To sort the selection click on a header, click once to sort ascending and again to sort descending.
- To refine the selection, open the filter in the top left of data window
- To refine the selection, open the filter at the top of the window. The box to the left of the field header contains qualifiers. The default is “contains.”
The example below is filtered for line items containing the Source Receipts Vendor “rent.”
- To export the selection, right-click anywhere in the active window and choose Export to Excel or pdf.
- Assign a folder location and file name.
- You can change the file to various versions of excel, generic (csv), text (txt) and pdf.
Go to Accounting > Bank Reconciliation > Bank Reconciliation.
- All uncleared transactions are supported by the sort, filter and export capability.
- The same conventions apply to bank reconciliation as to bank ledger with regard to sorting, filtering and exporting.
- However there is one main difference. An “in progress” or “active” bank reconciliation supports nested transactions where there is a parent record expandable to show the children beneath.
- Clearing the parent clears all children
- Clearing one or some children does not clear the parent
- Each parent record has a unique filter
- Exporting to excel preserves the nested layers.
Example of active reconciliation window filtered for cash receipts
Example of active reconciliation window filtered for cash receipts with filter turned on