cancel
Showing results for 
Search instead for 
Did you mean: 
eliz619
New Member

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. You'll need to enter your QuickBooks Online (QBO) account password to unprotect the sheet. Since you’ve already tried, I encourage you to give it another go, ensuring the password you enter is correct.

 

If it doesn't work, I recommend contacting our support team for further assistance. They can help you resolve password issues, add custom fields, and troubleshoot any technical problems with your account.

 

Here's how to reach them:

 

  1. Log in to your QBO account.
  2. Navigate to the Help (?) menu.
  3. Open the Search tab and select Contact Us.
  4. Input a brief explanation of your concern in the provided field, then click Continue.
  5. Choose the Chat or Callback option.

 

 

The support hours for QBO Advanced users are available 24/7, so you can get help whenever you need it.

 

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us