cancel
Showing results for 
Search instead for 
Did you mean: 
eliz619
Level 1

How do I add a column to a template in spreadsheet sync

I would like to add a column to the Spreadsheet Template to reflect one of my custom fields. I would like to add a column to the Customers Template. I tried to follow what little information I found online 

  1. (Optional) To create and edit transactions and their custom fields, select Select custom field columns. This will also allow you to add the transaction to the template.

 

I can't find the "Select custom field columns".

The sheet is protected? Is this the issue? it asked for a password and I tried both my QBs password and my Microsoft password.

 

I am running QBs Online Advanced.

 

Thanks,

Elizabeth

1 Comment 1
jeanbiverly_
QuickBooks Team

How do I add a column to a template in spreadsheet sync

Hey there, Elizabeth. It’s great to see you taking the initiative to enhance your spreadsheet capabilities. I'm here to assist you with this task and ensure you can achieve your goals.

 

You can't find the Select custom field columns option because the sheet is protected. To unprotect it, you'll need to enter the password. This is the one specifically set for that Excel document, not your QuickBooks or computer password. I recommend coordinating to the person who created or last modified the document. They should be able to provide you with the password.

 

If it doesn't work, I recommend contacting our technical support team for further assistance. They can help you resolve password issues, add custom fields, and troubleshoot any technical problems with your account. You can reach them by signing into Spreadsheet Sync and selecting Help, then Contact Us. Our dedicated team is available Monday to Friday, 6AM-6PM PT.

 

For more detailed guidance on editing your record templates, visit this article: Import data using Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

To help you manage Spreadsheet Sync better, I’ve also included an article on some common questions: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

You can always return and drop a comment if you need more help, Elizabeth. I'm here to support you every step of the way. Take care and have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us