Skip to main content

How to Set Up and Use Landed Cost in ConnectBooks

Set up landed cost and split freight and tariffs across your products.

Landed cost helps you split shipping and related costs across your products, so each product carries its true cost. This guide shows you how to set up landed cost with QuickBooks, explains the tabs on the landed cost page, and shows you how to allocate freight costs.

Setting up landed cost

Click Landed Cost in the left menu. If you see "Contact Support to Get Started", our support team turns it on for you.

Step 1: Select clearing accounts

Choose your QuickBooks file. Then, from the dropdowns, select the clearing accounts for freight and tariffs. These accounts track shipping and tariff costs separately.

Step 2: Choose manufacturing and freight vendors

Select the manufacturing and freight vendors from the dropdown list. You can add or remove vendors as needed. If the same vendor handles both manufacturing and freight, contact support for help with the setup.

Step 3: Add freight items

When you enter freight bills in QuickBooks, set them up as service items, not expenses. This lets ConnectBooks separate shipping costs from other charges like packaging or handling, which should go under different expense items.

Select your freight items, then click Next.

Step 4: Sync with QuickBooks and finish

At the top of the setup page, click Sync QuickBooks, then click Done. This imports your bills from QuickBooks, and your setup is complete.

The landed cost tabs

The landed cost page has several tabs to help you manage and track your costs.

Open Bills

This tab shows all bills that don't have shipping allocated yet.

Updated Bills

This tab shows all bills that already have shipping allocated.

Products

This tab lists all products with their QuickBooks names. You can enter measurements and tariff rates for each product. If you only know the total cubic meter (CBM) value, enter 1 in the first 2 boxes and the total CBM in the third.

Settings

On the Settings tab, you can set up your vendors, QuickBooks items and clearing accounts.

Vendors: select or add vendors.

QuickBooks Items: mark items as freight or remove them.

Clearing Accounts: select or change your clearing accounts.

Allocating freight and calculating landed cost

This section shows how to allocate bills with landed cost, so your costs are split correctly.

Step 1: Go to the Open Bills tab

Go to the Open Bills tab on the landed cost page to see all bills that aren't allocated yet.

Step 2: Pair manufacturing and shipping bills

Select a manufacturing bill and a shipping bill to pair. To make this easier, add the container number to the memo field in QuickBooks for both bills. Then you can search and match bills by container number. You can also allocate 1 manufacturing or shipping bill to several freight or manufacturing bills if needed.

Step 3: Review and allocate

After you select the bills, click Review to go on to the allocation. You can see the amounts allocated.

Step 4: Export to QuickBooks

Click Update Cost and Export to send the updated information to QuickBooks. If you use QuickBooks Desktop, sync with the Web Connector to export the data. Once done, the bills move to the Updated Bills tab.

More features

Add a bill

To add another manufacturing or shipping bill, click Add Bill and select another bill.

Edit CBM

To change the CBM, click the CBM box. A window opens where you can enter the correct value. Check Save for all if needed, then click Save.

Delete an exported bill

To delete an exported landed cost record, go to the Updated Bills tab, click the 3 dots next to the record and select Revert. Once it is reverted, you can delete or export the record again.

Archive a bill

To hide a bill without allocating shipping, go to the Open Bills tab and click the archive icon. To unarchive it, select Show Archived and click the icon next to the bill.

For more help setting up or using landed cost, contact our support team. We're happy to help.

Frequently asked questions

I don't see my latest bills. What should I do?

If you use QuickBooks Online, click Sync QuickBooks under your company name at the top of the landed cost page.

Can 1 shipping bill cover several manufacturing bills?

Yes. You can allocate 1 manufacturing or shipping bill to several freight or manufacturing bills.

I only know the total CBM for a product. What do I enter?

Enter 1 in the first 2 boxes and the total CBM in the third.

Did this answer your question?