cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accounting_2023
Level 2

How to link two credit card transaction in QuickBooks online

My home currency is set to CAD.

Vendor charged $100 USD (Invoice in USD) from my Canadian credit card and the total amount on statement was CAD $130

after few days vendor refunded the total amount of USD $100 to my Canadian credit card account which was $115 CAD.

I created the vendor bill and marked as paid in QuickBooks for CAD $130 but now they refunded the total amount of $115 CAD, 

how do I link the bill and refund transaction in QuickBooks so that it can be shown in CAD visa chart of account, vendor account and system can calculate the net exchange loss/gain of $15

Tried putting it as a credit card expense but system is not picking gain/loss currency exchange

Thanks

5 Comments 5
AdminAndrea
Level 5

How to link two credit card transaction in QuickBooks online

Have you tried entering a Credit Card Credit for the refund transaction?  

 

+New

    Under Suppliers choose Credit Card Credit

 

 

Accounting_2023
Level 2

How to link two credit card transaction in QuickBooks online

I did try putting it under credit card credit however system is not picking up for which bill this refund is associated with and because there is a conversation rate loss after refund so QuickBooks is not posting entry of exchange gain/loss to show how much amount we have loose while converting, I am not sure if I need to post any journal entry to record this transaction

AdminAndrea
Level 5

How to link two credit card transaction in QuickBooks online

I'm not sure that you can link the actual bill to the refund - I've never tried to do that before.  I tend to use the "memo" section to capture the details so that I can match items up. 

 

This time I think you may want to do a separate entry to record the difference and make a note in the "memo" section so that you easily find all related items and reconcile your account.  

 

Wish I could give you better advice

Alex M
QuickBooks Team

How to link two credit card transaction in QuickBooks online

Hi there Accounbting_2023,

 

it's important that all your transactions are correctly entered so that your books can be well balanced. QuickBooks Online is a great tool able to keep track of sales and expenses so you can see the profit of your business. I can provide some information about supplier refunds.

 

In QuickBooks Online, there isn't a way to connect a Credit card credit to a bill or its payment, so as stated by AdminAndrea, notes on those transactions could be used to help you keep track of these transactions. As for the amount going into the Exchange gains or losses, the refund may need to be done as a journal entry, or if done as a credit card credit, a journal entry may need to be done to adjust the amount so you can report that loss.

 

If you have any other questions, feel free to reach out here. 

Accounting_2023
Level 2

How to link two credit card transaction in QuickBooks online

Hi Alex

 

Thankyou so much for the recommendation, I think you are right, will post journal entry as visa account and realized exchange gain/loss debit and expense account credit I guess this will work.

 

Need to get in touch?

Contact us