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

Excel Sync

Using Excel, you can make multiple changes to your transaction data and sync those changes back into the system.

Excel Sync is a three-step process:

Step One: Download the Excel file of Transactions

From the Bank Transactions screen, click the Export button to create an Excel file.

The data exported will be limited by any Filters applied to the transactions.

The Export files are all displayed on the Exports screen. To view a file, click the  download button associated with the file you want to view. To view the filters that were applied to each file when they were created click the filter details button. 

Step Two: Update Fields

The columns that can be changed are colored blue and these changes include:

  • Updates to data read in from the Statement Upload process (Columns H through L)
    • Changing of Description is not recommended. Leave this field as created by the OCR process and create a Custom Description column (using one of the 9 Custom Columns.)
  • Updates to the three data visualization columns (Columns V, W and X)
    • These columns draw the Visualization cashflow diagram within the web application.
    • Originally named VisCategory1, 2 and 3, these columns can be renamed. Limit the unique values to 100 for each of these columns, otherwise the file will fail to load.
  • Updates to the nine custom columns Valid8 gives you to extend the data model (Columns Y through AG).

Save the file as a CSV UTF-8 (Comma Delimited) file (File > Save As in Excel) when you are ready to load it back into the system.

Step Three: Upload the Changed file back into the System

From the Bank Transactions screen, click the Excel Sync tab, then click the upload button to choose and upload your sync file. Enter a description of what you are changing in the Notes field for change management purposes.