Skip to content
  • There are no suggestions because the search field is empty.

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 card accounts are sometimes categorized on the statement by card holder. Currently, Valid8 groups all transactions by the main account holder, but there is a method that you can label the transactions with each individual card holder. Utilize the custom columns in the Excel export, and the Excel Sync to add your changes to the platform.

There are four steps to this process.

Step One: Extract the credit card account transaction data to Excel

  • In the Bank Transactions section select the account you want by using the Accounts filter on the left-hand filter pane.
    • This will filter the total transactions down to just the ones you want to categorize, typically a credit card account.
  • Click Export > Bank Transactions, Excel. This will create an Excel extract (in 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 Editing on the spreadsheet to allow editing.
  • Multi-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 appear on the statement PDF.
  • 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 cells with the card holder. Typically, you will have whole pages that are for a card holder, which is easy to label. When you have two card holders on the same page, then sorting by Date will have the transactions grouped.

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

  • Save the file - as file Type CSV UTF-8 (Comma delimited).
  • 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 gear button near the top-right of the transaction grid, enable your Card Holder column.