cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Steve Orme1
Level 1

why does "sync to spreadsheets" for customers update the shipping address not billing address

The new sync to spreadsheet is a great idea but unfortunately when I try to update the billing address it only updates the shipping address for the customer

3 REPLIES 3
emmam6
Moderator

why does "sync to spreadsheets" for customers update the shipping address not billing address

Hello Steve Orme1, Thanks for reaching out about spreadsheet sync.  Do you have all billing states selected in the filter under all transaction types?

Steve Orme1
Level 1

why does "sync to spreadsheets" for customers update the shipping address not billing address

Hi Emma

 

Sorry do you mean within Quickbooks Online or within spreadsheet sync ?,

 

Within the excel sync, I am using company data and selecting supplier and customer as the data to change

 

Steve

JamaicaA
QuickBooks Team

why does "sync to spreadsheets" for customers update the shipping address not billing address

Hello, Steve.

 

I can see the convenience of updating your customer's billing and shipping address using Spreadsheet sync. To provide the correct resolution, I need more information.

 

I'd like to know what template you are using to change the customer's billing address. Do your customers have the same billing and shipping address? Have you received any errors when uploading the data to QuickBooks?

 

You can read this article to learn the two types of Spreadsheet Sync templates: Post data to QuickBooks Online Advanced using Spreadsheet Sync.

 

Please know that any additional information is appreciated. I'll be on the lookout for your response. Have a great day.

Need to get in touch?

Contact us