Adding credit card processing fees to invoices

Wondering if anyone can recommend a solution for adding a 2% credit card processing fee to invoices for customers paying by credit card? Some of the dilemmas I am facing is automating the process. For example when a salesperson writes an order and it is sent to the warehouse for shipment the order amount needs to be pre-authorized for the order total plus the 2% processing fees. Additionally there could be backorders and freight added to the order thus changing the total. In a perfect scenario there would be a way to calculate the total automatically.

Any recommendations or examples of others doing similar scenarios on Sage 2016 would be appreciated.

Thanks

Scott Payne

Parents
  • We must do the same when customers pay their open invoices by Credit Card after taking the full duration of their net day terms.
    We created an item code of "/CRCD" to use for CREDIT CARD PROCESSING FEES. This is linked to a GL account that captures and reports Bank & Merchant Fees.
    The proper amount has to be calculated (currently by manual process as we are not automated for this variable amount) and entered on the EXTENSION box of the order or invoice. Funds are collected by the hit to credit card and then posted to proper GL bucket to capture such additional 'transfer' fees. We also provide a copy of this invoice to the customer as it will show as part of their annual expenditures for their annual filings.
  • in reply to Dean @ MRI
    While not the exact same thing, I have done something similar by using a negative discount percent on the totals tab of the invoice. This of course assumes that you are not using the discount for something else. The discount percent would have to be entered manually.

    If it needs to get fancier, you would have to do some scripting.
  • in reply to TomTarget
    Thanks for the reply Dean,
    I did explore this scenario already but the "Discounts" in Sales order post values to the same account used by AR discounts. Since this is ultimately an income it needs to post to a different account. Other issues I face with this overall plan is automating the process. I need it to not rely on action from a salesperson. My thoughts were to somehow use a script to trigger inputting the negative value in the discount field based on the terms code or credit card payment selection. I know how to write crystal reports but never VB Scripts. Regardless the biggest hang up is that it posts to the wrong GL account and excludes freight totals.

    I can't believe more people are not doing this? It is legal in 38 states to now charge a "processing fee" for using credit cards. Most companies build the cost in the margins but that is difficult with distribution with lower margins.

    I am going to keep investigating! Thanks..
Reply
  • in reply to TomTarget
    Thanks for the reply Dean,
    I did explore this scenario already but the "Discounts" in Sales order post values to the same account used by AR discounts. Since this is ultimately an income it needs to post to a different account. Other issues I face with this overall plan is automating the process. I need it to not rely on action from a salesperson. My thoughts were to somehow use a script to trigger inputting the negative value in the discount field based on the terms code or credit card payment selection. I know how to write crystal reports but never VB Scripts. Regardless the biggest hang up is that it posts to the wrong GL account and excludes freight totals.

    I can't believe more people are not doing this? It is legal in 38 states to now charge a "processing fee" for using credit cards. Most companies build the cost in the margins but that is difficult with distribution with lower margins.

    I am going to keep investigating! Thanks..
Children