Splitting a Statement into Card Holders

Need to track the transactions in a statement by card holder? Utilize our custom columns to achieve this.

Credit care accounts are sometimes categorized on the statement by card holder. Valid8 groups all transactions by just the account though. But there is a method that you can split out the transactions into the individuals. For this we utilize the additional columns (custom columns) that we provide within the application by updating one of these columns within excel.

There are 4 Steps to split out and display Card Holders:

Step One: Extract out the account information to excel

On the Transactions section select the Account you want to break up by card holder, by using the Accounts filter on the far right pane.
- This will filter the total transactions down to just the ones you want to categorize, typically a credit card account(s).
Click Export > Bank Transactions, Excel. This will create an Excel extract (on the Exports section) with just the account(s) filtered in the step above. Download and open that Excel file.

Step Two: Update a custom column to indicate which card holder for each transaction

Click Enable Edit on the spreadsheet to allow editing.
Sort the data so that transactions are showing in account statement, page then transaction date order:
- Multi-sort by AccountPeriodID (column BP), then by statement Page Number (column BX) and finally transaction Sequence (Column BY). This orders the transactions in the same order they show on the actual physical statement.
Columns Y through AG are the custom columns in the application. Edit one of these to change the header to Card Holder.
Update this newly named column with the card holder. Typically you will have whole pages that are for a card holder, which is easy to update. When you have two card holders on the same page, the sorting by Date will have the transactions grouped.

Step Three: Update the new card holder information into the system

Save the file - as file Type CSV UTF-8 (Comma delimited). Confirm OK that this will save only the first sheet.
Back within the Valid8 application, use the Excel Sync feature to bring the data into the system. Add the Notes for what was changed, and select the CSV file you saved.

Step Four: Enable the new column in your grids

On the Transactions grid, using the menu button on the header of a column, turn on the Card Holder column.

Related Articles