Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello all! I have searched and searched for a solution to an issue I am having with QBO. I am a General Contractor and job cost each of my projects. One of the continuing hurdles I face is when I return materials and given a refund (funds directly deposited into my bank account). Just to be clear, not a vendor credit...but an actual refunds of dollars.
So my example is this, I purchased $212.35 worth of material from Home Depot and booked this into QBO again Job Name = Hardy Remodel. I then ended up returning $83.36 worth of material to Home Depot, and in the perfect world, I would like to reduce the expense of $212.35 by the $83.36.
I just have no idea how to book this refund against the Hardy Remodel job. I even tried to enter in a negative "Bill" but QBO does not allow me to do that. Any ideas would be greatly appreciated!!
Thanks!
Solved! Go to Solution.
Good Afternoon, sachinpatel25!
Thank you for the additional information. I have put together a quick video of how I would handle it. There is an important step in the recording of these transactions. You would need to find out what account your Item is reporting to. Is it Materials on Profit and Loss? If so, enter the refund to go to the same account and customer/project. You can use the “Deposit” transaction type in the checking account register to record the refund received. The video will have the steps I took to record transactions into the same account and under the same Customer/Project.
Would love to hear if this solution did the trick for you.
Regards,
Anna
There is a BILL credit is QB desktop, but not in Online. But there are so many different ways to do this.
I would do one of the following things: (this is if you do not already have the cash back recorded somewhere, and it is physical cash you received back)
1. Make an adjusting entry. Date it the date of your return.
Then you CREDIT the Materials account (where the original material purchase was posted)
And you DEBIT the Sales (or the account where you posted this billed amount to the customer). Sometimes people set up the expenses that are billed for as INCOME or INCOME: Reimbursed Expenses, and some people actually just credit the expense. So pull up your bill to the customer, see where the materials you billed for are posted, and this will be your DEBIT.
NOTE: Make sure you put the customer name in both the lines, under column for NAME.
OR
If it was near the date of the purchase, you can always go into the original purchase, add a line and post it to the same expense or COGS account, then make a note under Description, "returned "X" items, cash refund on xx/xx/xxxx. And put ( $xx.xx) in the amount column. This is negative by the way. If there is already a number in the transaction, and the credit/negative, does not exceed the initial amount it will let you add this negative line. If it is more than the transaction you cannot.
NOTE: This should already be posted to the client, so the new amount will automatically show on the job cost report.
-formybookkeeper.com
There is a BILL credit is QB desktop, but not in Online. But there are so many different ways to do this.
I would do one of the following things: (this is if you do not already have the cash back recorded somewhere, and it is physical cash you received back)
1. Make an adjusting entry. Date it the date of your return.
Then you CREDIT the Materials account (where the original material purchase was posted)
And you DEBIT the Sales (or the account where you posted this billed amount to the customer). Sometimes people set up the expenses that are billed for as INCOME or INCOME: Reimbursed Expenses, and some people actually just credit the expense. So pull up your bill to the customer, see where the materials you billed for are posted, and this will be your DEBIT.
NOTE: Make sure you put the customer name in both the lines, under column for NAME.
OR
If it was near the date of the purchase, you can always go into the original purchase, add a line and post it to the same expense or COGS account, then make a note under Description, "returned "X" items, cash refund on xx/xx/xxxx. And put ( $xx.xx) in the amount column. This is negative by the way. If there is already a number in the transaction, and the credit/negative, does not exceed the initial amount it will let you add this negative line. If it is more than the transaction you cannot.
NOTE: This should already be posted to the client, so the new amount will automatically show on the job cost report.
Regards,
formybookkeeper@gmail
Hi, sachinpatel25!
You will need to use the same "Account" and "Customer/Project" for the original charge and refund to have these transactions go to the same place in QuickBooks.
So let's say:
Hi Anna - Thank you very much for your guidance and the step by step instruction. Let me throw a wrench into this by supplying additional information that perhaps I should have included before.
(1) Whereas your example assumes the original purchase of $212.35 was made by credit card, in actuality we used our Debit card and therefore our cash balance in the bank immediately decreased by $212.35 so I assume the "Credit Card Credit" screen would not be where I book the refund.
(2) When booking our expenses, not only do we tag each expense under "Customer/Project", but we also use the Item Details and not the Category Details.
Overall, if there is an equivalent screen to Credit Card Credit that can be used for refunds that are made to our Debit Card (our Bank Account) then this would be exactly how I would like to book the refund.
I've attached a picture of how we book our expenses if it is of any help. Thanks so much!
Good Afternoon, sachinpatel25!
Thank you for the additional information. I have put together a quick video of how I would handle it. There is an important step in the recording of these transactions. You would need to find out what account your Item is reporting to. Is it Materials on Profit and Loss? If so, enter the refund to go to the same account and customer/project. You can use the “Deposit” transaction type in the checking account register to record the refund received. The video will have the steps I took to record transactions into the same account and under the same Customer/Project.
Would love to hear if this solution did the trick for you.
Regards,
Anna
Hi Anna - Amazing! I was able to follow your video step by step and was able to achieve what I was trying to do. Thank you very much for the video as it helped me navigate through the appropriate screens to ensure I was recording this refund appropriately. I would have never tripped upon the "Track Return for Customers" so that I could tag the refund to the Hardy Remodel client. Thank you very much for taking the time to put this together. You're a rock star!
Thanks,
sp
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