Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI've set up my Landed Cost account but it isn't posting correctly.
These are the Accounts I set up:
* Clearing Landed Costs Account as a Other Current Asset
*My Item Account:
Freight - Inbound using the Expense Account Clearing Landed Costs Account
Income Account Misc. Revenue
I have several invoices from my Vender and only one of them includes the freight charge of $500.00. When I add the freight charge I use the Item of "Freight - Inbound" and then all the products that were included on the invoice. I then save the invoice. When I go back to use only Calculate Landed Costs for this and the other invoices everything seems to work great.
My problem is that when I go to check that everything is working properly and the "Clearing Landed Costs Account" is $0.00 it shows it is a negative $500.00. It seems that all the Landed Costs have been deducted from there but there is no charge to it. The $500.00 freight cost is being added to the Offset Inventory account. How do I fix this?
I appreciate the efforts you've made, @DJohn5845.
Based on your description, your accounts and items are set up correctly. Since the Landed Cost Clearing Account shows a negative balance of $500.00, the cost was likely allocated but remains unoffset by the original entry.
To resolve this, review the Landed Cost Clearing Account register to identify the specific transactions causing the negative balance:
By ensuring all freight charges and landed cost allocations post to this account, the balance will return to $0.00 as intended.
If you have further questions, let us know in the comments. We're always here to help.
I have taken those steps and nothing seems to change. It is still posting the "Freight-Inbound" Item to our Offset Inventory.
So this it what my invoice would look like:
1) All Vendor Info., Date, Ref No., Amount Due, Etc.
2. ITEMS TAB:
| DISCRIPTION | QTY | AMOUNT |
| Product #1 | 840 | 924.00 |
| Product #2 | 6 | 283.20 |
| Product #3 | 2 | 55.00 |
| FREIGHT - INBOUND | 1 | 500.00 |
3. EXPENSE TAB:
| Clearing Landed Costs Account | -100.00 |
4. In my Clearing Landed Costs Account. It doesn't ever show the $500.00 increase but it does show the Five $100.00 decreases.
I've tried to start completely over and reset everything up, including deleting the original invoices and putting everything back in.
Hello, John. Thanks for providing those details. It's clear that you've done the legwork on @GianSeth_A's suggestion.
At this stage, we need to dig a bit deeper to see why your book isn't updating correctly. I'd recommend a one-on-one session with our Live Support team. They have the tools to securely access your account and run a full investigation to get this sorted out.
I'm here if you have any questions in the meantime.
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