I have set up landed costs and created my first transaction. The bill that landed costs were applied to seems correct:
My question is that the account where the landed cost expenses hit, now shows a negative balance in the amount of the costs that were applied, $3,408.25 and this is coming from the bill from our freight forwarder, Gallagher Transport:
Why is this and how do I remove this in order to balance this account to $0?
Hello there, @ RKN.
You can create a bill then add the expenses. Then check it if it’s the same screenshot that shows negative.
Here’s how to create a bill:
On the other hand, you can create a check transaction in QuickBooks Desktop. This is used when you want to recognize an expense and record payment all at once. Here’s how to create a check:
After recording what you owe in QuickBooks Desktop, you can use Pay Bills to settle your payables for different vendors. Please check this article to see the steps: Pay bills in QuickBooks Desktop.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
Thank you MaryAnne. I have gone through then entire process of creating the bill for the import expense, applied these expenses to the bill that contains the product using the "Calculate Landed Cost" button on the bill for the product, and paid both bills. All seemed to function as expected, except that now we have this balance in the "Inventory Offset Account" and I cannot trace where this comes from:
The yellow cells are the expenses that were entered under the bill for freight and are resulting in a negative balance in this account. How can I trace where these expenses are coming from as I don't think that neither the freight bill or the product bill point to this account.
Thank you for getting back here, @RKN.
I appreciate you for performing the steps provided by my colleague. You'll want to run the verify rebuild tool, this helps to identify the most commonly known data issues in your company file and as well as resolve these issues. Here's how:
Otherwise, you may reach out to our technical support team so they can further investigate this and check your setup.
Here are the steps:
For guidance, I'll share some articles to help you:
Should you need anything else, don't hesitate to comment below. I'm always around to help. Stay safe and take care always.
Thank you for suggesting the data verify option. I have done this and the issue remains. Does is sound reasonable that we create a journal entry to correct the issue for now and see if it persists on our next import?
Thank you for your prompt reply, as well as sharing an update on your current status.
The Inventory Offset account is a liability account. It's generated by QuickBooks Desktop (QBDT) when you enable the Enhanced Inventory Receiving feature.
You can run a custom report to reconcile it, which isolates the negative amount you stated earlier.
Note: It's necessary to create an Item Receipt first, then enter a bill against it to relieve the Inventory Offset account.
If you have other questions about the Landed cost feature, see this article: Landed cost FAQs.
I'll be around if you need further help. Place a question below, and I'll get back to you.