How to import card charges/transactions manually

If you can't link your bank or credit card account, you can manually upload your charges by following these steps.  

Create a new Bank Connection

  • If this is the first time you'll importing for this card, you'll need to create a new bank connection
    • Go to Purchases > Connections
    • Click on Add Bank Connection - This is your Destination File when importing.
    • Create an Unlinked Account - You'll be prompted for an account type and unique name.
    • Select/Unselect the relevant products you'll use the account for (Purchase Reconciler and/or Deposit Verification)



Importing Transactions for Unlinked Connections other than Global Rewards

  • Go to your bank/card portal and download the charges
    • Select the date range
      • Note:  Be careful not to overlap prior imports dates and don't include days with pending charges.  This generally means you'll need to have a few days lag before importing data.
    • Download into csv format
    • Include Extended Details if available
  • Verify +/- amounts are correct
    • Go to Purchases > CSV Upload
      • Select the Source File (that you just downloaded)
      • Select the Destination Account
      • Map the columns
        • Look for a preset first to see if we've already mapped the card type for you.  If not, you can manually select the mapping.
        • Note:  Make sure that charges are positive numbers and refunds/credits are negative numbers.
      • Select Accept Column Mappings 
      • Verify that there are no rows with errors - Look at the Source File box on the left side of the page.
      • Select Import Rows at the bottom of the page.

    Importing Transactions for Global Rewards

    Go to your bank/card portal and download the charges

      • Select the date range
        • Note:  Be careful not to overlap prior imports dates and don't include days with pending charges.  This generally means you'll need to have a few days lag before importing data.
      • Download into csv format
      • Include Extended Details if available
    • Verify +/- amounts are correct
      • Credit - make sure negative number
      • *deposit - remove (best to sort by status, vs filter then remove these)
      • posted - make sure positive number
      • funds transfer - remove
      • reversal - make sure negative number
      • Declined - remove
        • Note: If you need to change positive to negative or vice versa. best method is to add -1 to a blank cell. Copy -1 and highlight values you need to change. Click paste special and change to multiply. Value will change.
      • Save the CSV.
    • Go to Purchases>CSV Upload
      • Select the Source File (that you just saved)
      • Select the Destination Account
      • Map the columns
        • For Global Rewards you will need to manually map as follows:

      • Select Accept Column Mappings
      • Verify that there are no rows with errors - Look at the Source File box on the left side of the page.
      • Select Import Rows at the bottom of the page.  

    If you have any questions or concerns, please reach out to support@revealmarkets.com.