Skip to main content

Track costs by customer or project in QuickBooks Online

Assign a QuickBooks Online customer or project to PO and bill line items, so you can track costs by customer or project in QuickBooks

If you use QuickBooks Online, you can assign a QuickBooks customer or project to the line items of a Purchase Order (PO) or a bill. When Settle syncs the PO or bill to QuickBooks, each line keeps its customer or project, so you can track costs by customer or project in QuickBooks.

Before you start

  • QuickBooks Online is connected to Settle.

  • Track expenses and items by customer is on in QuickBooks. You find it in QuickBooks under Account and settings > Expenses.

  • You can edit the PO or bill.

Settle reads this QuickBooks setting, and your active QuickBooks customers and projects, each time it syncs with QuickBooks. When the setting is on, PO and bill line items show a Customer/project column. If you just turned it on or added a customer, go to Sync Center and click Sync now.

If you remove a customer or project from a line in Settle, Settle doesn't remove it in QuickBooks. Remove it in QuickBooks too.


Add a customer or project to a PO line

  1. Open the PO.

  2. On the Details tab, go to Line items. If you don't see the Customer/project column, scroll the line items to the right.

  3. Click the Customer/project cell of a line item.

  4. Select the customer or project. Projects show under their customer.

Purchase order PO-2220 line items with the Customer/project column, its list of QuickBooks customers and projects open on one line

If the PO's line items are set to Display as: Matrix, click Expense details on an item group instead. Select the Customer/project and click Save.


Add a customer or project to a bill line

  1. Open the bill.

  2. On the Details tab, go to Line items. If the line items can't be changed yet, click Edit under them.

  3. Click the Customer/project cell of a line item and select the customer or project.

  4. Click Done editing.


Add a customer or project to many lines at once

  1. On a PO or bill, select the line items with their checkboxes. On a bill, click Edit under the line items first.

  2. In the bar that opens at the top, click Set expense details.

  3. Select the Customer/project and click Apply.

Two PO line items selected, with the bar at the top showing 2 items selected and the Set expense details button

Customers and projects on line items are not available for NetSuite or Xero.

Did this answer your question?