Plaid connection [in-depth guide] – Workamajig

Notes

The integration we now have with plaid.com will allow you to connect to many credit card/banking institutions to import transaction data to 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.

NOTES

AMEX clients using the @Work or MyAtWork version must use the individual cardholder's login credentials to download transactions. The global/primary account login credential do not allow access.

NOTE ABOUT PLAID: 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 support@workamajig.com 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.

For security purposes, the card numbers are encrypted and only the last four digits are displayed.

Vendor setup

If you already have your credit card(s) set up as vendors, you can skip this part.

If this is a new card/bank or you are new to Workamajig, you must create a vendor record for your credit card 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', 'account number', the 'account type' should be 'credit card', and add a 'vendor' (that already exists in your system).

While not required, 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: 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.

After you save, continue with the setup of your account(s)/card(s). You may even want to close out of the GL accounts page & 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 to have access to 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 is Saved and there are no issues with the GL accounts screen, then you can move on to the remaining setup of Plaid.

System setup

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).

Click Continue.

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 card's 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 subaccounts appear. These would be the cards you connect to your GL accounts. NOTE: Only cards that have 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 [in-depth guide] for the 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 support@workamajig.com with your issue and provide as much detail, including screenshots, if you can.

Pending charges

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. We only bring in charges once it's 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 be ready, but we usually see this take anywhere from a few hours to a few days.