Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Rose-A
Moderator

Reply to message

Thanks for checking in with us, 99duckey.

 

For now, tracking landed costs in QuickBooks Online is unavailable. As a workaround, you can create an expense clearing account. Here's how:
 

  1. On your QuickBooks Online dashboard, click Accounting in the left panel.
  2. Choose Chart of Accounts.
  3. On the Chart of Accounts screen, click the New tab.
  4. Choose Bank or Expense for the Account Type. You may choose any detail type you want for your clearing account.
  5. Type in the Name for the clearing account.
  6. Make sure you do not type in any amount on the balance before clicking Save and Close.

clearing account1.PNG clearing account2.PNG

 

After that, you can do the following:

1.  Enter a bill and use that clearing expense account as the expense for the transaction
2.  Edit the original bill as follows:

  • 2a. Increase the total amount for each item by a portion of the new bill.
  • 2b. Change to the account portion of the bill at the top, select the clearing expense account, enter the amount of the bill as a negative number
  • 2c. Save the edited bill and click through any warning you may get about payments being applied.
  • 2d. Insure the clearing expense account is zero balance, if not go back and adjust the item totals.

 

Once done, QuickBooks will use the edited bill to update the purchase cost. If any of the items were sold between the original transaction and the additional bills, the system will automatically make the adjustment to the COGS account for the change in purchase cost.

 

I'd suggest visiting this link if you need help in managing your items: Set up and track your inventory in QuickBooks Online. On the same link, you'll find what report to pull up to see your best sellers.

 

Ping me in if you have additional questions about QuickBooks items. It's my priority that all of your concerns be addressed. Have a fantastic day!

Need to get in touch?

Contact us