Skip to main content
A
AspireCFO
January 17, 2025
Question

SpreadSheet Sync Error - Blank Account

  • January 17, 2025
  • 1 reply
  • 0 views

I am attempting to import a 230 line journal entry from a .csv spreadsheet into QBO.  My error indicates that the "Accounts does not exist in QB".  I have gone through my spreadsheet to ensure that the accounts used match to the QBO chart of accounts.  I have tried once with names of accounts and once with account number (never both), and both times the import indicates the "Account does not exist in QB". 

 

Spreadsheet Sync did not work either as it indicated the Account field cannot be left blank - which it was not.

 

Please advise.

1 reply

F
FateCandylaneT
January 17, 2025

Managing spreadsheet syncing errors ensures accurate workflow of your imported entries, AspireCFO.

 

When using a transaction template to post data to QuickBooks Online, errors may occur if the data does not match validated criteria. Criteria are validated if they have been manually added to QBO or uploaded using a Spreadsheet Sync list template such as Accounts or Inv Items. 

 

If data is incorrectly entered into a transaction or posting template, Spreadsheet Sync will return an error message. With that, make sure you are using a Spreadsheet Sync posting template. You can find them under Manage Records > Records to create or edit.

 

Thus, it's best to consider creating a new sheet to ensure error values or fields are correct and aren't damaged, so QuickBooks recognizes them when importing.

 

For more details and information on the fix, refer to this article: Spreadsheet Sync troubleshooting.

 

However, if the error persists, I suggest contacting our Live Support Team to help investigate your case and get a fix for the issue you're experiencing. To do this:

 

  1. Log in to your QuickBooks Online (QBO) account and go to the Help (?) menu.
  2. Select the Search tab and click the Contact Us button.
  3. Enter a topic in the What can we help you with? page.
  4. Then, choose a way to connect (Have us call you or Chat with us).

 

Additionally, you'll want to seek additional guidance from our Live Expert Assisted team to help you handle spreadsheet imports and provide assistance in keeping track of your overall transactions.

 

Moreover, you can check out this reference to help you review and track transactions imported into your file: Run a report in QuickBooks Online.

 

Your needs are important to us. Count on our team to be here whenever you need further assistance managing spreadsheets in your account. Stay safe.

Terms & ConditionsAccessibility statement