Skip to main content
R
Raymond22
May 10, 2024
Question

Spreadsheet Sync - Bill Upload Error

  • May 10, 2024
  • 1 reply
  • 0 views

Hello,

 

Whenever I try to upload Bills, I get the following error:  Transaction line Bill / Vendor Credit Memo cannot have both Item and Account. Please refer to Notes and Control tab of the template workbook.

 

I am using the template for "Invoices and Bills" and it doesn't even have a column for Item or Account.

 

Any help is most appreciated.

 

Thanks!

 

 

1 reply

J
JanbonN
May 10, 2024

Hello there, @Raymond22. Allow me to route you to the appropriate team to help you further with your Spreadsheet Sync issue.

 

Since you’ve confirmed that your template doesn’t include columns for items and accounts, yet you’re still encountering that error, I suggest contacting our dedicated Spreadsheet Sync Support Team. They possess the tools to rectify this error, ensuring a successful import of your bills into QuickBooks Online. Please note that they're available Monday to Friday from 6:00 am to 6:00 pm PT. 

 

Here's how to reach them:

 

  1. Sign in to your Spreadsheet Sync.
  2. Select Help.
  3. Click Contact Us.
  4. Follow the on-screen instructions.

 

Additionally, you can also create and edit budgets in Spreadsheet Sync.

 

Let us know if you have other concerns with your spreadsheet sync. We'll be here to help you in any way we can.

Terms & ConditionsAccessibility statement