This is a script I implemented about a year ago. It's different from yours as it's a typical convenience fee, however, it may be able to be modified to look for Deposit Type Cash instead of Deposit Type Credit Card, and to have fee subtracted instead of added.
Accounts Receivable Cash Receipts Entry
Custom VB script to calculate a credit card convenience fee in Sage 100 Accounts Receivable, Cash Receipts Entry. The convenience fee will be added as a General Ledger Line Type on the Lines tab of Sage 100 Accounts Receivable, Cash Receipts Entry and the amount of the convenience fee will be included in the cash receipt total.
The Sage 100 script will add a fixed percentage fee as a General Ledger Line Type on the Lines tab of Sage 100 Accounts Receivable, Cash Receipts Entry. The convenience fee percentage will be defined in a Sage 100 user defined table. If a convenience fee is calculated, a new General Ledger Line Type with the general ledger account number and convenience fee amount will be added on the Lines tab of Sage 100 Accounts Receivable, Cash Receipts Entry Lines tab.
A Sage 100 "Convenience Fee" user-defined check box field will be added to the Sage 100 Accounts Receivable, Cash Receipts Entry header tab that is always checked when Deposit Type is Credit Card and unchecked if the Deposit Type is not Credit Card. The user will have the ability to check and uncheck the Convenience Fee check box. The ability to uncheck the box will be useful if the user decides to not charge the customer the convenience fee. The Sage 100 general ledger account number the convenience fee is charged to will be configurable by the user in a user-defined table. The program will compare the general ledger account number in Accounts Receivable, Cash Receipts Entry to the Accounts Receivable, Cash Receipts Entry defined in the configuration table, and also evaluate the Convenience Fee user-defined check box field to determine if the convenience fee will be calculated for the customer cash receipt.
A convenience fee will be calculated and added to the customer cash receipt as a General Ledger Line Type on the Lines tab of Sage 100 Accounts Receivable, Cash Receipts Entry when the following conditions are true: 1. The Convenience Fee user-defined check box field located on the Header tab of the Cash Receipts Entry is checked, and 2. The Deposit Type field located on the Customer Header tab of the Cash Receipts Entry is Credit Card.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------
Original Message:
Sent: 02-25-2026 14:35
From: Wayne Schulz
Subject: Credit card surcharges on Sage 100
Has anyone manage this type of situation where the state disallows surcharges to recover credit card fees but is ok with offering a discount for cash/ACH?
Naturally the tricky point is you don't know how the customer will pay until the invoice is due. I know you can write down the invoice through cash receipts entry however that seems like it would get cumbersome and/or require someone to make some calculations on an ongoing basis while doing cash receipts.
Maybe I have this all wrong but my suggestion in Connecticut to recover CC fees is just raise prices 4% and presume everyone pays by credit card and be happy to make more money when some don't.
Or am I overlooking something super basic?
------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Connecticut
------------------------------
Original Message:
Sent: 02-25-2026 12:58
From: Wayne Schulz
Subject: Credit card surcharges on Sage 100
Just to add to this - because a client just sent me an email.
Here in Connecticut - you generally cannot collect a credit card surcharge. Unlike many other states that have loosened these rules, Connecticut law strictly prohibits businesses from adding a fee on top of a listed price just because a customer chooses to pay with a credit card.
The Connecticut "loophole" is your price has to either:
a. Be stated at the credit card price - and you can give a discount for cash
b. Be stated both ways on the invoice
In my personal opinion it seems like the quick fix to this is to presume that all transactions are going to be made by credit card so adjust your prices up by the processing fee of about 3%.
------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Connecticut