Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
DJohn5845
Level 1

Landed Costs

I'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?

4 Comments 4
GianSeth_A
QuickBooks Team

Landed Costs

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:

 

  1. Open the account register for your Clearing Landed Costs Account. You are looking for a zero-sum flow. For every Landed Cost calculation that deducts from this account, there must be a corresponding vendor charge that adds to it.
  2. Ensure that the transactions listed in this account are properly offsetting. If you see the deduction for the landed cost but don't see the $500 increase from the original vendor invoice, the link is broken.
  3. Check the original vendor invoice where you used the Freight - Inbound item. If the transaction is not appearing in the clearing account register, it may be pointing to the wrong place.
  4. If you find transactions that are incorrectly listed or missing their pair, you should:
  • Edit the transaction to associate it with the correct Clearing Landed Costs Account.
  • Delete and re-enter the transaction if it was recorded in a way that prevents it from offsetting correctly.

 

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.

DJohn5845
Level 1

Landed Costs

I have taken those steps and nothing seems to change.   It is still posting the "Freight-Inbound" Item to our Offset Inventory.  

DJohn5845
Level 1

Landed Costs

So this it what my invoice would look like:

 

1) All Vendor Info., Date, Ref No., Amount Due, Etc.

2.  ITEMS TAB:

DISCRIPTIONQTYAMOUNT
Product #1840924.00
Product #26283.20
Product #3255.00
FREIGHT - INBOUND1500.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.  

JaneDave_I
QuickBooks Team

Landed Costs

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.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us