Credit Card Connector
The Credit Card Connector screen is used when you want the individual card holder(s) to update/process their own charges and submit those to an approver for review and payment processing.
Options for Bringing in Transactions | Card User Notifications | Purchasing Managers View | Typical Process | Advanced Processing | Approval Process | Resources
You can also use this screen to match up any manually created credit card charges against the downloaded transactions from the bank.
Options for Bringing in Transactions
We offer several ways to bring in your credit card transactions for processing.
1. Plaid Connections. This newer integration allows for more banks/cards to be used automatically.
2. Import the .OFX or .CSV file. In case your bank does not appear in any other method and you are able to download your cards transactions to a compatible file format. Then you can Import them into the connector screen for processing.
3. Setup a credit card provider in the GL Account. This features has slowly been deprecated by many of the banks so it may not work. NOTE: If you are getting emails about the card not syncing, then it might be time to move to the Plaid Connection, as more and more banks have deprecated the old standard of the OFX connector.
Card User Notifications
If you are a selected Card User in the GL Account Setup, then anytime there is an unprocessed transaction in Connector, you will see a line for that card in your Notifications section to review.
Clicking on the line from here will open the Connector screen for that card.
Purchasing Managers View
From the Today - Purchasing page, you can access all cards by clicking on Open The Credit Card Connector. From here you also see the cards with open totals, if any.
Typical Process
Update Transactions
Typically all that is needed is a Project and Item to code the transactions to. The setup of your system will handle the rest.
NOTE: If you have Items Are Required, yet you choose "Overhead", you do not need an Item in this instance.
Process Selected Transactions
Once you have updated your transactions and want to move them forward in the system. Click the checkbox next to the individual lines, or the top box to highlight all lines, this will trigger some additional options to appear. Choose Process Selected to move them to the next step in the process.
NOTE: Once you choose Process Selected, those transactions will no longer be visible anywhere in this screen. As they are now Charges in the system. But if you delete the Charge that was created from the transaction, then the transaction will reappear on this screen.
Advanced Processing
Update Multiple/Change Selected
This is typically used to update a multiple charges to a selected setting, such as, Project, Task or Office or the Charged By Person. Select the transactions you wish to update>click Change Selected>select the fields you need to update>click update
Mark As Cleared
This is typically used for the initial startup of this feature. Where if you have it auto-download the card's transactions, then it pulls in the past 90 days of transactions. So if you are caught up and have already paid your credit card bill for the last 30 days. Then you can check the prior 60 days worth of transactions as Mark As Processed. But this option can play a role later for when you have a credit card transaction that does not need to processed (posted to the GL) for whatever reason.
Hide Cleared Transactions and Hide Payments
The option to Hide Cleared Transactions refers to any transaction that you chose to Mark As Processed. So you can hide these from view, and in case you need to access the transaction again to edit or fully process if you flagged the transaction this way by mistake.
The option to Hide Payments refers to any transactions that have a negative amount. Typically this would be a payment you made to the credit card company that you've already accounted for. So hiding this from view helps keep the screen clean of unnecessary transactions.
Be sure to click Refresh after checking these options.
Customize your Columns
Choosing what columns you see in the grid view is a great way to limit the fields you need to view/edit, and helps keep the Connector screen clean and easy to use.
From the More button at the top of the Connector screen you can go to System Settings (if you have the rights to do so) and modify what columns you see and the order of the columns, in the grid entry view of the Connector screen.
Edit Transactions Details
While you can modify the column in the grid view for editing to have quick access to your typical entry fields, you can always expand the row to see all of the transactions details for editing. To do this, click on the 4 arrows icon to the left of the highlighted row.
Link To Unmatched Charges
From the Edit Transactions Details, there is an option at the bottom of the details to Link To Unmatched Charges. This allows you to see what Charges have been entered manually (not Processed from the Connector) in the system for whatever reason, so you can essentially Mark As Processed the transaction in the connector, since the Charge already exists in the system.
Apply to an existing Vendor Invoice
NOTE: Typically this process is done from the Select Invoices To Pay screen and choose to Pay By Credit Card.
You can apply the line to a single vendor invoice using the Invoice Number column.
Split Vouchers
NOTE: Typically this process is done from the Select Invoices To Pay screen and choose to Pay By Credit Card.
From the grid, if you have the column for Split Vouchers, then when you edit that row and check the box...
You will be presented with a panel to where you can choose open vendor invoices and determine the amount to apply.
NOTE: You cannot code a credit card charge to both a project and a vendor invoice. It is one or the other.
Split Projects
You can also apply a charge to multiple projects. If the column of check-boxes for Split Projects is not already listed, then you can Customize the columns and select the Split Projects column. Once selected, then you click the Project column which will open a separate screen to enter in multiple projects and task and how much each project should get.
Approval Process
Once you "Process" the transactions from the connector screen, those then get turned into Charges that need to be Approved. Whoever is set as your credit card approver will see these charges appear in their Items To Approve section of their Notifications.
NOTE: If you are set as your own credit card approver, then the charges will be Approved and possibly Posted upon processing them in the connector screen..
Example Approver
With the list of Submitted charges open, you can click the row for more or details, and if you have edit rights, you can click into for more details to the record itself. Ultimately the goal is to approve the list of charges.
