Sage 100

 View Only
Expand all | Collapse all

Credit card surcharges on Sage 100

  • 1.  Credit card surcharges on Sage 100

    Posted 11-29-2024 10:33

    A customer messaged me asking how they could implement a surcharge for credit card paying customers beginning January 1. I though this was a timely topic since credit card usage seems to be increasing and the fees quickly add up. 

    I found an older message thread discussing how Sage 100 users might recoup their credit card feels through billing back surcharges to their customers. I created a summary and put it in our content library.

    If you find anything that needs to be added/changed please let me know.


    We are going to start adding a 3% surcharge to invoices paid by credit card effective January 1, and I am trying to figure out the cleanest way to get that set up.  



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------


  • 2.  RE: Credit card surcharges on Sage 100

    Posted 11-29-2024 11:02



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Credit card surcharges on Sage 100

    Posted 11-29-2024 11:23

    I added this disclaimer: 

    Disclaimer: State or federal law and/or merchant agreements may not allow surcharges.Consult with your merchant agreement and state/federal laws to ensure that you are in compliance with current rules/law governing surcharges.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 4.  RE: Credit card surcharges on Sage 100

    Posted 12-01-2024 01:19

    Paya has a nice fee recovery solution. It's installed into Sage 100 where it will post separately for auditing and reporting. If you sign up for the premium version, the system will automatically restrict fee recovery in states where it's not allowed.



    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 5.  RE: Credit card surcharges on Sage 100

    Posted 12-01-2024 13:55

    @Bill Pfahnl - Interesting.  Do you have a link handy to share?



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 6.  RE: Credit card surcharges on Sage 100

    Posted 12-01-2024 16:36

    Here you go, @Jeff Schwenk
    Nuvei | Click2Pay
    Product Information PDF



    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 7.  RE: Credit card surcharges on Sage 100

    Posted 12-03-2024 09:13

    Interesting, @Bill Pfahnl, I don't think I was aware of that.  Not sure if and how much you've worked with it, but does it essentially bill for the cc surcharges/fees after-the-fact?  Anyone else familiar?

    @Wayne Schulz, I see your doc in our Content Library mentions DSD's SO-1507 (Surcharge Calc for Invoice Entry), but DSD's SOPT enhancement (S/O Surcharge by Payment Type) is more applicable here.

    • HOWEVER, one of the biggest caveats with using something like the DSD mod is related to whether the customer is sending click-to-pay (CTP) invoices:  Ideally you want to include the surcharge on the invoice you send to the customer, but if it's a click-to-pay invoice you don't necessarily know if they'll actually pay it by cc; they may decide to mail a check in for this invoice - so now you have to reverse the surcharge.  Several months ago I heard that Fortis was working on addressing this, but I haven't seen anything as of yet – although I'm thinking for example:  Modify the CTP web page so that it adds a surcharge for cc payments, and modify the Fortis function that imports into A/R Cash Receipts Entry to have it include a G/L distribution line for the surcharge (which of course would require a field somewhere in Sage 100 for designating the default G/L account, as well as a place to specify the surcharge %).


    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 8.  RE: Credit card surcharges on Sage 100

    Posted 02-25-2026 12:58

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



  • 9.  RE: Credit card surcharges on Sage 100

    Posted 02-25-2026 14:36

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



  • 10.  RE: Credit card surcharges on Sage 100

    Posted 02-25-2026 16:18

    I wonder if some creative wording would work?  "All orders will have a 3% processing fee added.  All cash orders will have a 3% discount.". 

    Probably something to ask a lawyer.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 11.  RE: Credit card surcharges on Sage 100

    Posted 02-25-2026 16:38

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



  • 12.  RE: Credit card surcharges on Sage 100

    Posted 02-26-2026 08:41

    Thanks, Doug. Unfortunately Connecticut doesn't allow convenience fees. The best you can do is quote the full credit card price and discount from there for cash. 

    I talked with this client last night. I believe their best option is to treat their products as if all users are going to pay by credit card. Mark them all up 4% with no indication of doing so for the purpose of recouping a processing fee. Then, as a "plan b" if multiple customers complain introduce "our new discount for cash" plan which takes x% off for payment by check or ACH.

    Personally I think not many people are going to notice and I advised them against paying for an enhancement or customization since there were likely to be more questions that arose during the implementation that would raise the cost even more.

    I think they are going to raise price 4% across the board and let that be their recovery of processing costs.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Connecticut
    ------------------------------



  • 13.  RE: Credit card surcharges on Sage 100

    Posted 02-26-2026 10:08
    I had this same discussion yesterday but with a client in california.

    The best I could come up with was mark it up 2.5% then show a 2.5% discount if the client picks ACH or Invoice Me later on their website, and then add a "Cash Price" to all pages.

    > I think they are going to raise price 4% across the board and let that be their recovery of processing costs.

    The real question is - if you could just raise your prices by 4% across the board, why not just do it anyway? 

    --

    Calvin Morrison | Operations Manager, ERP + Integrations




    Book time with me here   

    Kissinger Associates, Inc.
    Office: 800-562-5456 x217
    | Mobile: 215-429-9384
    calvinm@kissingerassoc.com
    | kissingerassoc.com
    Get Support: support@kissingerassoc.com

    Real World Experience  |  Real-Time Service  |  Real ResultsTM






  • 14.  RE: Credit card surcharges on Sage 100

    Posted 02-26-2026 08:41

    Re: Kevin's mention of 'wording', here's something very basic I did for a client recently:



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------