Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
R
Raymond22
May 10, 2024
Question

Spreadsheet Sync - Bill Upload Error

  • May 10, 2024
  • 1 reply
  • 7 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
JanbonNQuickBooks Team
QuickBooks Team
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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement