Forum Discussion

SusieExpTech's avatar
SusieExpTech
Experienced Cover User
2 years ago

Reconcile a payment made through our website for an inventory item

Hi Guys,

 

We have launched an online store as part of our business. We have just made a sale for an item that is in our inventory (in a quantity of 5) to a customer.

 

What I thought I would do is enter the sale as a new sale invoice to take the inventory count of 5 out of our stock. But now I'm stuck with the credit card surcharge and reconciling the payment in my bank feed.

 

Sale amount to the customer is $695.50, but the deposit amount in my bank feed is $667.31. I can match this amount in my bank feed, but im left with the $12.19 outstanding on my Sales Invoice's "Balance due".

 

Im wondering if this is the best way to be doing my online sales transactions? And what do I do to record my transactions efficiently for tracking inventory and recording credit card surcharges?

  • Hi SusieExpTech

     

    Thanks for your post.

     

    In this matter, if your customer will pay you, you can wait for the balance to be paid before you allocate the $12.19 and $667.31 to the invoice. If there's no payment you will not be able to match you may need to adjust or edit the invoice.

     

    We also suggest checking with your accountant about this matter. You may check These Articles Allocating bank transactions and Matching bank transactions for more information.

     

     

    Please don't hesitate to post again if you need help in the future.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

     

    Cheers,
    Leneth
     

    • SusieExpTech's avatar
      SusieExpTech
      Experienced Cover User

      Thank you for your response Leneth_A 

       

      The customer was charged and paid the amount of $12.19 as a credit card surcharge fee from our web provider and our web provider keeps the $12.19 and deposits our sales monies in the amount of the difference.

       

      I have decided against recording it as a Sales Invoice and do it as a Journal Entry instead. What I have done is created a new sales account as an Other Income account for Webstore Sales: Parts. This also assists Management in viewing reports for Webstore Sales against regular Purchase Orders - as they prefer to keep it separate to monitor the difference between the two.

       

      I have entered this sale as a Record Journal Entry against the Webstore Sales account in the full amount, separating the $12.19 as a Transaction Fee, and our sales monies is in the exact amount that is deposited into our account, recorded against our Business Bank Account. EG:

       

      Acct     Name                            Debit        Credit

      1-xxxx  Bus. Acct                       $667.31

      6-xxxx  Transaction Fee             $12.19

      4-xxxx  Webstore Sales: Parts                    $679.50

       

      Then I have completed an Adjust Inventory for the part in our inventory in a quantity of -5 for the sold items, against the account that I created for the Webstore Sale: Parts. EG:

       

      Item Number         Quantity      Unit Cost    Amount     Account

      (Part #)                    -5                $xxxxxx       $xxxxxx      4-xxxx Webstore Sales: Parts

       

       

      • Princess_R's avatar
        Princess_R
        MYOB Moderator

        Hi SusieExpTech 

         

        Thank you for your response. It's great to know that you had this resolved and we appreciate providing the exact workaround you did to this concern. It will help other user find this information with the same issue. 

         

        Please feel free to post again and we'll be happy to assist.

         

        Cheers,

        Princess