Importing credit card transactions [in-depth guide]
This guide will assist you in the event that you are not able to auto-download credit card transactions via the OFX connector for the workflow designed in the Credit card connector screen.
Method 1 - .OFX download/import
Most banks/credit cards allow you to download an electronic statement/report of the transactions within a specified date range.
When you go to export the statement of transactions, there may be an option to choose a file type. If they do offer multiple file types, then look for a file type called OFX, QFX or similar. As these are industry-standard financial files.
You can take these files and import them right into the Credit card connector screen so you can process them as if the system was able to download them automatically.
If this works, then you will want to set up a reminder to do this as a daily or weekly manual process.
Method 2 - .CSV download/import
If your bank does not offer any type of formatted OFX file, yet you can download a report of the transactional data, similar to it looking like an excel file. Where each row of data is a single credit card transaction. Then you can take this file and add a header row to resemble the importable fields allowed in Workamajig's connector screen.
- For a detailed list of the importable fields available, please refer to the Import matrix: credit card transactions (credit card connector) [guide].
NOTE: You can manually import this type of file in two places. 1. The Connector screen so you can have users review & process their own transactions which then turns them into charges, or 2. Import them directly as approved & posted credit card charges, skipping the Connector screens workflow.
With the file now ready for importing, ensure it's properly saved as a CSV formatted file (if on a Mac, save it as CSV MS-DOS).
Then import the CSV file in the Connector screen & process them using the Connector screens workflow.