This guide is designed to assist you in the situation where 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 then 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 processes.
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 and process their own transactions which turns them into Charges, or 2. Import them directly as approved and posted Credit Card Charges, skipping the Connector screens workflow.
With the file now ready for importing, ensure its 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 and process them using the Connector Screens workflow.