Bank Transactions (TXN) Report
This report lists all transactions in an Excel spreadsheet format.
Report Details
Bank Transactions Reports will generate as an Excel (.xlsx) file named as follows: TXN_[Engagement Name]_[Date and Time Report Generated]| Columns | Description | Excel Sync |
| A — B | Unique ID values for bank transaction or check item | No |
| C | Date of transaction | No |
| D | Amount of transaction | No |
| E | Amount of check item | No |
| F — N | Multi-currency fields | No |
| O | Automatically set transaction type | Yes |
| P | Check number if applicable | Yes |
| Q | Description from bank statement | Yes |
| R — S | Legacy fields from transaction list template | Yes |
| T — U | Valid8 default categories generated by AI Categorization | No |
| V — X | Custom datavis columns. These columns power visualizations in the platform. Only 100 unique labels per column are supported. | Yes |
| Y — AG | Custom fields for any additional labels used for extending the Valid8 data model. | Yes |
| AH — AT | Counterparty and related Location fields. These are generated via the AI Categorization button on the Transactions screen. | No |
| AU | Any assigned Stories will be listed here. | No |
| AV — BG | Check image item details that are matched one-to-one with a transaction. 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). | No |
| BH — BO | Bank transfer information. Sorting by Column BH (Xfer Match ID) will group each pair of transfers together. | No |
| BP — CE | Related to the bank account statement period. | No |
| CF — CN | Related to ERP data if applicable | No |