Recording Payments by Visa/Mastercard

Hi there,

I have a question about receiving/recording payments made by Visa/Mastercard. Someone previous to me has set up Sage to receive payment using the credit card feature with no discount fee, as the fee is only deducted monthly and it varies significantly in the cards - ie Visa isn't just 2.95% - it depends on what type of Visa it is, etc. Our merchant provider then deposits the total amount of credit card payments the following day into our bank account. When I reconcile, this is a pain as I have to manually add up the different deposits to make sure that they are correct.

How would you handle this? Use the receive payment by cheque feature and in the cheque number spot type either Visa/Mastercard, deposit to my cash clearing account and then 'deposit' them the following day? I am leaning toward doing it this way, but if someone has a different idea please let me know! (or confirm that this is the way to go).

Thanks!

  • 0
    You haven't told us why the reconciliation is a pain, nor where the credit card payments are linked but my guess is that someone linked the credit card customer payments directly to the bank account.

    In a default chart of accounts with no modifications, the account 1080 has been set up for VISA Receivable (this number and name can and often is changed on setup but the concept should be followed). If you link the payments to go there, then on each Receipt, the deposit is not made to the bank, it is made to the holding or clearing account 1080. At the end of the day, the report from your machine or credit card merchant's website should match the amount received in this VISA account. This mimics reality. No money has yet to be deposited to your bank account, so don't show it in your bank account. Assume this amount for the total VISA sales is $1500.

    When you see the deposit to your bank account, you can then do a general journal entry to post the amount over to the bank. One entry for $1500 should show up on the merchant's report, your bank account and your bank statement, and therefore you books. The discount is a different entry or different lines on the same journal entry if it is taken on the same day.
  • 0 in reply to Richard S. Ridings
    Ahh! I didn't realize that the default was to a clearing account. The person prior to me set it up to deposit to the our main bank account. The reason it is a pain is that when reconciling, on my bank account statement it just has the total that was deposited that day, and I have to then manually add up all the Visa/Mastercard receipts for that specific day. It also means that I don't 'receive payment' on Sage until the following day, which I don't like doing.

    For example, a customer came in today and bought and paid $500 using a Visa. I then have to wait until tomorrow (when it is deposited into the bank account) before I can receive it using Sage.

    Thank you! This was very helpful.
  • 0 in reply to wendy555
    Glad my assumption was correct. Sage 50 allows you to work in reality as much as possible, so I always follow what the reality of the entries are, then follow that in the program. You received the money today, post it today. Deposit was tomorrow, or Friday, so post the deposit tomorrow or on Friday. The clearing accounts allow you to do it that way.