The Credit Card Vendor feature was added in a later version of Sage 500 ERP, version 2018. In Accounts Payable, Maintenance, Maintain Vendor, a Vendor can be created to represent a Credit Card (CC) for paying vendors. You may create more than one CC vendor if you are using multiple credit cards to pay your vendors. The best practice is to use the CC name for the Vendor to avoid confusion during transaction processing. For example: VISA, Mastercard, Amex, Discover
CREATE A CREDIT CARD VENDOR
Under the Main tab, put a check on "Credit Card Vendor" to enable the feature and classify this Vendor as CC Vendor.
PAY VENDOR WHILE PROCESSING VOUCHER
A voucher can be be paid during the voucher entry, using the credit card (CC) vendor previously created. To do this, process the voucher as a regular voucher and additionally, enter
"Paid by Credit Card Vendor" on the Total tab. Hover the current CC Vendor value to display the list of CC Vendors. Upon processing voucher with CC Vendor, the voucher will be considered paid by your credit card. Every due date of the Credit Card, all vouchers paid by the CC Vendor will be paid to the Credit Card company using AP Check.
Note: There is no activity against the credit card during this process as there is no connection to the actual credit card processor on the AP module. That step is performed outside of the Sage application.
3. POSTING THE CC VENDOR TRANSACTION VOUCHER
When performing a Register / Post, review the Voucher Register before posting as seen below
Upon Voucher posting, Sage 500 will create another Voucher along with the original Voucher: one for the Vendor and the other for the Credit Card Vendor.
It is best practice to maintain a copy or printout the Register before posting the batch, which will be used in succeeding steps.
The Voucher number displaying on the view, during 'Process Invoices for Payments' , for the credit card vendor, is the Voucher created for the CC Vendor and is ready for payment.
You will not see the Voucher from the original Vendor, as this was documented as paid by Credit Card in prior steps, using the CC vendor. The current payment is for remittance to the CC Vendor.
Expect the following, once the check is printed and the payment batch is posted:
4. REPORTING AFTER POSTING
Run the following Reports to understand how all this process has transpired.
- Vendor Status
- Run Vendor Status for the Original Vendor, you will see the payment for the actual Credit Card
- Vendor Status for the CC Vendor will show the payment check that was posted.
- Explorer - Voucher Lines, filtered by Vendor 'Visa' - - This will provide a detailed description of Vendor, Date, and Invoice Number from your Vendor paid through your Credit Card.
The voucher register printout will help users when entering a Payment to the Credit Card Vendor. The details included in the register displays the original Voucher number for the original Vendor. In turn this will help find and select the appropriate CC Vouchers to select for Payment.
The 'View / Edit Vouchers' may also help in obtaining the Invoice# from the Vendor by pulling up the posted CC Voucher as shown below.
5. OTHER CC VENDOR PAYMENT PROCESS - UNPAID VOUCHER TRANSFER TO CC VENDOR
In some scenarios:
Voucher posted and not paid, need to have the Voucher in Vendor's aging and not under the Credit Card Vendor.
In this scenario, when creating a Voucher for the Vendor, under the Total tab, don't fill out the 'Paid by Credit Card Vendor'
Upon posting, this Voucher will be under the Vendor's Aging Report.
To pay this Voucher under the Credit Card Vendor:
Launch AP, Activities, Process Credit Card Transfer, Select For Transfer
Then, select the Credit Card Vendor
This will show all the Vendor vouchers that the Credit Card Vendor will pay on behalf of the Vendors.