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.
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: 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.****
Update From Plaid
- Great news! This issue with our American Express integration has been resolved!
This Item should now be updating regularly, and you should see all up-to-date transactions for the account, once a /transactions/get API request is made.
Should the API call return an ITEM_LOGIN_REQUIRED error, please prompt your user to re-authenticate through Plaid by following the flow for initializing Link in Update Mode, in order to restore the Item to a good state. Once restored, be sure to confirm that you are successfully retrieving account and transaction information for this Item. If this is not the case, or you find that there are still missing or delayed transactions, definitely let us know so that we can investigate further (please include the latest request_id?).
Thanks again for your patience whilst we worked to resolve this! Let us know if you have 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
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 search your connection for any new accounts or cards associated. For example, if this were a brand new connection, you might see one line for the master account (designated with an Asterik). But then after using the Update Accounts option, you may see several sub accounts appear. These would be the cards you connect to your GL Accounts. NOTE: Only cards has active charges will appear for setup.
Preview Transactions - This lets you see all of what is currently being synced over. Mainly for troubleshooting purposes. Such as verifying Pending charges.
Verify Credit Card Connector Screen
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.
If you feel there are recent charges that are missing from the Connector, then one thing to check is to see if there are any Pending charges. Where we only bring in the charge was its been processed fully by the credit card company.
From the Connections > Credit Cards Plaid section. Click on the Card/Account in question. Then from that plaid setup screen, click on more > Preview Transactions.
This will then show a screen of all recent charges for that card/account.
Look at the column with the header of Pending. If there are any rows that say True, then those transactions are still pending from the credit card company. Workamajig has no control over when these will ready, but we usually see this take anywhere from a few hours to a few days.