Skip to main content
May 24, 2025
Question

Importing project invoices - incorrect bill-to address

  • May 24, 2025
  • 1 reply
  • 0 views

Hi

I am trying to import sales invoices for projects.  

For the "customer" import field, i am using the format "customer:project".  This seems to work correctly as the invoice is imported an assigned to the correct project.  However the only problem is the bill-to address on the invoice is being filled from the customer bill-to, and not the project bill-to.  Is there any way to import project invoices and have it use the project's bill-to address.

 

Thank you

Robert

1 reply

May 24, 2025

Let us share some information on how importing invoices works in QuickBooks Online (QBO), SBRM Robert.

 

When importing sales invoices in QBO, the customer:project format is a way to associate the invoice with the correct project. However, QuickBooks by default uses the customer's bill to address rather than the project's custom bill to address when generating an invoice. After importing invoices, we can manually edit each invoice to update the bill to address the project-specific address. Here's how:

 

  1. Go to Sales on the left side menu and choose Invoices
  2. Tap View/Edit.
  3. In the Bill to field, edit the address to update it to the project-specific address.
  4. Press Save and close

 

 

To learn more about importing invoices, you can check out this article: Import multiple invoices at once in QuickBooks Online.

 

If your project has a unique address that needs to be used often, we can set up a custom field or notes on the project itself. To add a custom field under the Project category, check out this article: Add custom fields to sales forms and purchase orders in QuickBooks Online.

 

Moreover, refer to these articles for future reference about customizing invoices and creating projects in QBO:

 

 

The Community always has your back if you need further assistance with importing invoices or other data in QuickBooks. You have a good one, SBRM Robert.