how to post Visa payment to pay Vendor Invoices AND regular expenses

I've looked through the forum Q and A and I've read all the responses to similar questions. This topic seems to come up a lot, but I'm still missing something. I will describe the situation.

I would like to start paying Vendor invoices using the Visa and I'll continue making regular purchases using the Visa as well.  

From reading through previous questions like this I learned I need to set up a Visa payable account and then set up the Visa through Settings/Setup/Credit Cards/Used, so I did that with 2202 Visa Payable as the Payable account and 5527 Visa Expense as the Expense Account.

For the Vendor invoices, I would like to continue to enter them through the Vendors/Purchase Invoices so I can track them easily.

For the Visa invoice, I have always entered that through Vendors/Purchase Invoices because I have Visa set up as a vendor. Then I would pay it through Vendors/Payments just like any other bill.

I am assuming I would continue to enter the Visa invoice this way, just not including the amounts of the Vendor Invoices I have already entered ? 

However, now it comes to payments and I am lost. Let's say the Visa bill is $2,000, and $800 of that is payment of several different Vendor invoices and the remaining $1,200 is the purchase of various regular expenses.

Does that mean that even though I am making a single payment of $2,000 to pay off the Visa (so $2,000 will show as a payment on our bank statement) that I will have multiple "payments" showing in Sage since I am paying multiple Vendor Invoices + a Visa invoice? It seems like that could get confusing when I go to reconcile the bank account because I'll have a single payment of $2,000 showing from the bank account, but possibly 10 or 15 payments showing in Sage that equal $2,000.

Is there another way I should be processing these Vendor invoices, Vendor payments, Visa invoice and Visa payment?

Thank you for any help. I'm trying to finish December 2022 and I don't know how to record these payments I've already made in December. I think I've posted this to the wrong category and subcategory. 

  • 0

    When you enter an expense through the A/P Module you would enter it normally using either Pay Later or Pay with VISA. If you use Pay Later, once the payment has been made using VISA this would be entered through the Payments Module. This would put a number of credit entries in Account 2202 VISA Payable. I prefer each expense to be entered individually as that is what would show on the VISA Statement.

    When the VISA statement is received I enter it as a vendor invoice using account 2202 for the total Purchases less Purchase Credits as at the date of the statement. VISA fees or interest would have to be entered on a separate line so they can be expensed to your account 5527.  This sets up an A/P which can then be paid by cheque, or e-transfer or other payment method you use through the bank. 

    The VISA statement can be used to reconcile the account 2202 VISA Payable. In theory account 2202 should be zero after each reconciliation, however, frequently there are VISA payments (vendor payments) made near the end of the statement period that don't make the current statement but will show up next month. This is OK.

  • 0 in reply to Alwyn

    Thank you Alwyn. When I enter the Vendor invoice through A/P module and choose to Pay with Visa, it posts the Invoice and the Payment at the same time, but then the payment doesn't actually show up anywhere. So the purchase invoice detail shows debit to the correct expense accounts with credit to 2202 Visa Payable, but the payment shows "no data to report." and 2202 Visa Payable shows the payment as not having been made. I am so confused by this. It shows the payment as made, but a payment is not showing up at all. Any suggestions? Thank you.

  • 0 in reply to Rose99

    The payment does show up in Account 2202. You cannot look at the payment as a separate entry as it is part of the Invoice posting. This is why Sage indicates "no Data to report." The payment is the credit to account 2202. The invoice is paid and you have the credit to record this payment as being completed by VISA. When the VISA statement is recorded as indicated earlier, the credit for this payment will come out of the Bank.

    It might help to think about the Account 2202 VISA Payable as a 'bank' account. You make lots of VISA payments from this account and monthly, when you enter the VISA Statement you are debiting (depositing) Account 2202.

  • 0 in reply to Alwyn

    Thank you so much Alwyn. You always explain things so well and in such a way that it finally "clicks." That will be helpful to NOT think of the payment as separate from the invoice and also to think of 2202 Visa Payable as a bank account. Thanks again.

  • 0 in reply to Alwyn

    I had a similar issue to Rose99 and I wanted to thank you Alwyn for your simple answer. It made so much sense and solved my problem in A/P invoices paid by Visa.