Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have added a refund following the step outlined: create a vendor credit, then bank deposit, then pay bills to link the two.
The problem is that by doing this now there is a charge (the original purchase), the credit (the refund), and also a deposit of the same amount which is being counted as another credit. So essentially there is double the credit actually given. This is obviously incorrect. Can somebody help me here?
Thanks
Solved! Go to Solution.
To solve reports, after properly adding the vendor credit per the link below "enter a refund from a vendor", I had to delete the manually added deposit so that there was only the actual bank deposit added from banking matched to the vendor.
After taking care of the duplicate deposit I had to go into the vendor expense table, by selecting it from the vendors tab, and made sure the blue "online banking matches" deposits were the only ones there and that the "accounts payable" was the account the deposit is linked to.
Working with multiple vendor credits and deposits at the same time made things a bit tricky by applying partial vendor credits to a particular deposit. Once I had properly gone through the initial "pay bills" screen I had to hit the refresh button to make the "bill payment" populate so that I could properly allocate funds from the vendor credits to the corresponding deposit. BE CAREFUL. This can be easily missed as there is no way of knowing that the funds are not allocated correctly without physically going into the "bill payment" after the initial "pay bills" screen.
Occasionally an additional refresh is required to correct the "open" or "overdue" bills.
Thank you to all that helped me take care of this issue. Hopefully this explanation helps another.
It sounds like your bank deposit was extra. You would just match the credit against the bill once when processing bill pay.
-Lubov
A/Z Bookkeeping
Thank you Lubov.
I new something wasn't right. I deleted all the bill pay and the deposits and then re-added the deposits once directly through the bank account. Do I need to use bill pay now to match the two or is there another way to match the transactions?
Here is an updated report.
Hello A PUNK,
The process you mentioned earlier is correct when recording the refunds.
When you create the bank deposit, make sure you selected the correct accounts:
When you create a bill payment to link the vendor credit and the bank deposit, make sure the TOTAL PAYMENT AMOUNT is zero ($0.00).
This will not cause any duplicate transactions since we are only offsetting the vendor credit and the bank deposit through the bill payment.
After that, the report will show you the correct information. You might also want to browse these links to know more about vendor credits:
Keep us posted if you require additional help.
Hello James,
So simply adding the deposit from the bank account is not enough? I am currently getting correct reports for the vendor although the vendor total is higher because the deposit is not reflected in the expense table.
I'm here to clear things out for you, A PUNK.
We created the bank deposit to record in QuickBooks that you've received the amount. Then, you used the A/P account so you can tie the refund to the vendor credit. The vendor credit you've created is used to decrease the quantity on hand of the items you're returning.
To offset/link the vendor credit and bank deposit, we'll have to create an expense, check, or bill payment. You can follow the steps below:
If you wish to do it using a bill payment, you can follow the steps above provided by my colleague JamesDuanT.
Doing this process won't generate any duplicate transactions since we're only linking the vendor credit to the bank deposit through a check, expense, or bill payment.
I encourage you to check this article to learn more about how to record a refund from a vendor in QuickBooks Online: Enter a refund from a vendor.
I'm just a few clicks away if you have further questions about how refunds work QuickBooks. You can always tag me in your comments.
I think I understand. I am fine with using the bill method.
So you're saying that even though there is a vendor credit (creating a -60.00 in the vendor expense table) and a deposit (also creating a -60.00 in the vendor expense table) that since they are in 2 separate categories (i.e. payroll invoice and accounts payable) that the report and actual expenses will work out correctly even though the "total" at the bottom of the vendor table is off because of the doubled credit from the VC and the deposit?
Yes, you're understanding it right, A PUNK. Let me ease your confusion.
We create a vendor credit to add back the inventory item to the stock. While the deposit is created to show the funds are returned to the bank.
Just as long as the vendor's open balance at the top right corner is correct, then everything is good.
We're just here to help you out if you have other concerns. Feel free to let us know.
Thank you for confirming Kristine.
To solve reports, after properly adding the vendor credit per the link below "enter a refund from a vendor", I had to delete the manually added deposit so that there was only the actual bank deposit added from banking matched to the vendor.
After taking care of the duplicate deposit I had to go into the vendor expense table, by selecting it from the vendors tab, and made sure the blue "online banking matches" deposits were the only ones there and that the "accounts payable" was the account the deposit is linked to.
Working with multiple vendor credits and deposits at the same time made things a bit tricky by applying partial vendor credits to a particular deposit. Once I had properly gone through the initial "pay bills" screen I had to hit the refresh button to make the "bill payment" populate so that I could properly allocate funds from the vendor credits to the corresponding deposit. BE CAREFUL. This can be easily missed as there is no way of knowing that the funds are not allocated correctly without physically going into the "bill payment" after the initial "pay bills" screen.
Occasionally an additional refresh is required to correct the "open" or "overdue" bills.
Thank you to all that helped me take care of this issue. Hopefully this explanation helps another.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here