The integration we now have with plaid.com will allow you to connect to many credit card/banking institutions to import transaction data into the Credit Card Connector.
***NOTE: Capital One is currently not supported by Plaid (our vendor). American Express support is under continuous development by Plaid and may have intermittent (delayed) download issues.****
Please note: Not all credit cards and/or banking institutions are guaranteed to work with this product but most are supported. Please contact support with any questions.
NOTE: You do NOT need to set up an individual account with plaid.com. Plaid is a 3rd party developer and does not have a client service team. So please email firstname.lastname@example.org with any feedback or issues, and we will submit a ticket to plaid. Workamajig has set up the necessary connections needed for this integration. You will only need to set up the connection in Workamajig via the steps outlined below.
If you do not see the Plaid Connections section, please email your account manager at email@example.com.
For security purposes, the card numbers are encrypted and only the last four digits are displayed.
If you already have your credit card(s) setup as Vendors, you can skip this part.
If this a new card/bank or you are new to Workamajig, you must create a Vendor record for your credit cards financial institution that you will be sending payments to.
GL Account Setup
You will need to set up a GL Account for each credit card account you have.
Go to Menu > Admin/Manager > System Setup > GL Settings > GL Accounts.
You can choose to Insert Row at the bottom or click the three dots of an existing account to Insert An Account Below.
In order to Save the setup, the main details that need to be filled in are Account Name, Accounts Number, Account Type = Credit Card, and Vendor (that already exists in your system).
While not required, but if you have multiple cards we do recommend you make a "Credit Cards" roll-up account to keep things organized. This roll-up account can be added at any time to your setup. Note that if you want the roll-up account first, you still have to choose a Vendor in order to Save, but that aspect of the account setup will not be used once you push another account under it.
If all is Saved, then continue with the setup of your account(s)/card(s). You may even want to close out of the GL Accounts page and reopen it.
Next, populate the following fields.
How Will This Card Be Used - choose "Import Credit Card transaction data from bank".
Card Users - Search for each user in the system that you want having access via the Connector screen.
Credit Card Number - Though this is marked as being required, it is not for this function. Please leave the field blank. When the account is linked via the Plaid Connection, this field will be auto-filled by the system.
Once all Saved and no issues with the GL Accounts screen, then you can move onto the remaining setup of Plaid.
Go to Menu > Admin/Manager > System Setup > Connections.
From here click the + next to Plaid Connections.
This will start the walk-through screens to set up your card(s).
Next, you can Search to Select your bank.
- Additionally, if you are unable to connect, it may be that there is another URL you use to connect to your card. Be sure the URL you use to access your online account, matches the URL shown at the bottom of the card search. For example:
You will be prompted to Enter the credentials that you use to access that bank/card online.
NOTE: Use the login credentials for the "master" account card, if you are using multiple sub-account cards.
NOTE: There will be more screens in this process to authorize your account
Once confirmed, you will be taken back to the Connections page in System Setup. We currently recommend you refresh your browser at this point.
Now you can map your card(s) with a pre-setup GL Account for that card.
Click on the newly added Plaid Connection.
Single Credit Card Account
Choose the GL Account that maps to the designated cards transactions.
Clicking out of the row will auto-save your choice.
And you're done! Transactions should now start to appear in the Credit Credit Connector.
Multiple Credit Cards Under a "Master" Account Card
NOTE: Following the connection setup, it may take some time for the system to display the sub-account credit cards. In testing, this has ranged from 1min - 10min.
The above setup is the same when you have multiple credit cards that are considered sub-accounts of the main credit card.
The main credit card account will be designated with an * at the front of the name. Single account cards will have this same designator.
With multiple sub-account cards, you will only map the sub-account cards to a GL account. Do NOT connect the main credit card to a GL account
Other screen functions
From the Bank screen, you can click on ...more
Refresh List: This will go to your institution and pull in any new "Sub-Account" cards that have been added. You would then need to map any new entries to the proper GL account.
Reconnect: This allows you to re-authenticate the connection to the institution. Typically used when the password or user ID has changed.
Update Accounts: This will go to your institution and pull in any "master" account cards that have been added.
Verify Credit Card Connector Screen
BETA TESTING NOTE: During the Beta Process, we have not turned on auto-download. This is to better control how the transactions are being brought into Workamajig. Once there are no issues or after the beta period, the system will auto-download transactions each evening. For now, you will need to click on the download button for each card for the transactions to be imported from your credit card institution. Instructions for this are below.
Now go to the Credit Card Connector screen to verify the transactions are syncing over.
As an Administrator you can go to Menu > Purchasing > Today-Purchasing > Incoming Charges> Open the Credit Card Connector.
At the top of the page, click download. The system will begin the importing of transactions.
Select each credit card from the credit card drop-down list and repeat.
NOTE: This is only necessary during the Beta Testing period. Once this feature is released, the system will auto-import the transactions each evening from your credit card institution.
As a Card User setup in the GL Account, you can go to your Notifications bell and click on the connector there for that card.
Example of downloaded transactions:
Same example with the details expanded:
This should pull in the last three months of transactions. So even if you have no data for today, you should see something.
NOTE: If you do not see any transactions appear, click on Download from the top of the Connector to perform a sync.
If it's working, then please go to the Credit Card Connector guide for next steps.
If it is not working, please review the steps above to see if a step was missed. If it is still not working, then please email firstname.lastname@example.org with your issue and provide as much detail, including screenshots, as you can.