Connect with and learn from others in the QuickBooks Community.
Join nowWe paid a bill for inventory items + shipping to our vendor, I have already entered the payment under "write checks" to the vendor for the total amount. We later received a refund (refunded directly to our checking account) for the shipping since that should have been N/C. So this was a credit for COGS-Freight In. I entered the refund in the "make deposits" screen. Now what? How do I link that refund to that vendor?
Solved! Go to Solution.
inbound shipping should be part of item cost
but since you are entering it separately, you can not link the deposit to the vendor, not is there a reason to. From what you say you posted inbound shipping to the cogs account, increasing the expense, the deposit using the same cogs account as the source account for the deposit, reduces the expense.
If you entered a bill, you said you used write checks - did you link the check to the bill and is it marked as paid
inbound shipping should be part of item cost
but since you are entering it separately, you can not link the deposit to the vendor, not is there a reason to. From what you say you posted inbound shipping to the cogs account, increasing the expense, the deposit using the same cogs account as the source account for the deposit, reduces the expense.
If you entered a bill, you said you used write checks - did you link the check to the bill and is it marked as paid
"Tips & Tutorials - if we place an order & use our debit card, when we receive the order I will use the "write checks" to enter the transaction (no PO or bill is entered)."
That;s fine; the issue is, if you need to be able to access Items or not.
"Even if I use the write checks it adds the inventory."
Because you listed Items, and did not post to accounts. The Deposit screen only provides for Accounts. A Vendor Credit provides for Items, and then a refund would be AP.
Or, a refund is just Make Deposit, as "from" COGS or Freight expense.
"That is correct that I enter the shipping expense as COGS-Freight In and then I used that same account when entering the deposit for the refund on shipping."
You are being told that inbound freight is supposed to be Costed into the products you got. Ask your own CPA about this. Example: You buy $5,000 equipment with $500 shipping inbound = $5,500 Basis.
Inbound shipping for Inventory is not posted to COGS; it isn't sold, yet. If the shipping is on the same charge listing as the products, you simply allocate it into the products, the same as any sales tax you paid. You enter it into QB not the same as how it is listed on the receipt to you.
If the shipping is a different provider, you post that to Other Asset. Then, you use Adjust Inventory, and allocate the cost per item name, for inventory to be fully costed. Like this example:
I have a client that handles sporting goods. We get Shipping, pallet fees and broker fees Not from the manufacturer. That means we use "other charge" items that all post to Other Asset. Then, we list the actual products on a Bill for vendor name = WIP; we list everything that we got, as items, fully costed from the total in WIP. We click on the Expenses tab and remove that value from the WIP account using a negative. Hit Recalc= this is a $0 Bill and considered paid.
Now the products are on hand fully costed.
WIP = work in process.