Sage One - Processing payment providers commissions

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • adrianb@servatech.co.za
    Junior Member
    • Aug 2011
    • 10

    #1

    [Question] Sage One - Processing payment providers commissions

    When using a payment provider like Payfast, a commission is deducted when payment is made by the provider. So, if an item was sold for R100 using the online payment provider, and an invoice was created for the R100, how is the shortfall after commission allocated in Sage One.
    e.g.
    Sale Price - R100
    Commission - 3,5% + 2.00 = R 5-50
    Payment received - R 94-50
    If this R 94-50 is then allocated to the invoice, there is a shortfall of the commission, namely R5-50.
    1) I cannot see a way in Sage to part allocate the amount to exclude the shortfall, as Sage auto allocates the full amount? (we download weekly so the allocation "steals" some from a later transaction, leaving the last one with a bigger shortfall.
    2) Assuming that 1) was resolved, the invoice should then show a balance of R5-50. I assume then that the shortfall should be done by a GL transaction as a bank charge, but also cannot work out how to do that?
    Being a non-accountant type of person, is there a correct way of dealing with this issue?
    Any feedback is kindly appreciated.
    Servatech
    http://www.servatech.co.za
    https://www.ic-express.co.za
  • adrianb@servatech.co.za
    Junior Member
    • Aug 2011
    • 10

    #2
    In case this helps anybody in the future, I found a way to solve this problem.
    1) You are able to part allocate in Sage One by selecting the icon which looks like a "Trident two prong fork" This allows one to allocate the portion of the provider payment - minus the providers commission per transaction.
    2) One needs to then do a Customer Adjustment and offset the commission portion as a decreasing amount offset as "Bank Charges" - VAT is also catered for.

    A long winded way of doing it especially if you have hundreds of monthly sales (like we do) where a payment provider is used, who just deducts the commission portion from their payment per sale, rather than just invoicing once monthly for commission charges.
    Servatech
    http://www.servatech.co.za
    https://www.ic-express.co.za

    Comment

    • dellatjie
      Silver Member

      • Sep 2012
      • 335

      #3
      What I do with my clients is I go to the line item, and split it between the payment and the commission.

      So in your example R100 would go towards the customer, and -5.50 would go towards commission.

      Comment

      Working...