Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forΒ
Get 50% OFF QuickBooks for 3 months*
Buy nowHi Guys, Having an issue with the Spreadsheet Sync feature (QBO Advanced tier) Specifically the "Spreadsheet Sync" feature is not working correctly with Custom Fields ***Not Syncing Correctly from the Start*** I have created several custom fields that are not syncing into excel correctly with the Spreadsheet Sync add-in. For example, one of my custom fields is a basic list (that is transaction-based, and is allowed on the expense transaction type). This custom field is enabled for expense transactions on QBO. I have entered the custom field in some existing expenses (saved on QBO). However after the saving on QBO, when synced to excel via Spreadsheet Sync for editing existing transactions -> expenses/sales receipts (with the custom field included via selecting the βselect custom field columnsβ section at the very bottom when generating the expense/sales receipt template), the credentials for that specific expense do not show the custom field column filled out. Custom Fieldβs column is there in the template and list options correctly there, just none of the expenses have this custom field column filled out. ***Unable to Edit with an Error*** When I try to edit the custom field column for any of the expenses -> elect βYesβ for posting, I get an error The error states: "The data for βcustom field nameβ field is not valid for selected transaction type. Please fix the error and try to post again." This error occurs despite the custom field being a list, said custom field options are pre-populated in the excel spreadsheet as selection options (not a typo error). Expenses are enabled for the custom field on QBO -> Custom Fields section. ***Other Spreadsheet Sync Transactions Work*** I have had this custom field work successfully with some other test on bills/invoices with the custom fields correctly syncing, but not expenses.