This report lists all bank transactions. The number of rows present on the sheet depends on the filters that were on the transactions screen when the report was exported.
Report Details
Bank Transactions Reports will generate as an excel file named as follows:- TXN_[Engagement Name]_[Date and Time Report Generated]
This report has one Tab Transactions, with the following details
- All columns in the system are listed.
- Columns H through N are multi currency fields.
- Columns O-AL in blue are editable (and the changes can be imported back into the system via Excel Sync)
- Columns T and U are the Valid Default Category fields - Main and Sub. These are generated via the AI Categorization button on the Transactions screen.
- Columns V, W and X (VisCategory1, 2 and 3) are the columns that generate the Visualizations. Only 100 unique entries are supported in these 3 columns.
- Columns Y through AG are the Custom Fields (1 through 9). And are used for extending the Valid8 data model. Common uses include:
- Normalizing the Statement Description (Column J). Doing this in a different column leaves the data intact as it came from the PDF, but allows you to change the descriptions.
- Extending data on transactions for Wire Transfers or ACH Transfers.
- Columns AH through AS are the Counterparty and related Location fields. These are generated via the AI Categorization button on the Transactions screen.
- Item fields in Columns AT through BE will display all the Image details that are matched one-to-one with Transactions. If there are multiple items for a transaction, these will not show, as they are only generated on the Bank Transactions and Image Detail Reports (TXN-M and TXN-A).
- Bank Transfer information is shown in Columns BF to BM.
- Sorting by Column BF (Xfer Match ID) will group each pair of transfers together.
- The rest of the columns (BN onwards) are related to the account period.