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?
E
efish123
March 16, 2023
Question

Spreadsheet Sync

  • March 16, 2023
  • 2 replies
  • 3 views

Hello 

 

Does spreadsheet sync "invoices and bills template" allow you to create vendor bills from Excel to post to QBO?

 

Thanks

2 replies

R
Rea_M
Level 10
March 16, 2023

Hello there, @efish123.

 

I have some insights about using Spreadsheet Sync in QuickBooks Online (QBO) so you can manage your data accordingly.

 

Spreadsheet Sync is an add-on feature available in the Advanced version of QBO. Yes, its list (invoices and bills) templates allow you to create new data, like vendor bills from Excel, to post to QBO. Then, you can pull that data into an Excel spreadsheet, edit it, and then post it back to QBO Advanced. 

 

If you wish to learn more about how Spreadsheet Sync lets you sync Excel to your QBO Advanced account, please see this article: What's Spreadsheet Sync?.

 

Also, you may want to check out this article as your reference to guide you in resolving common errors when using Spreadsheet Sync in QBO: Spreadsheet Sync troubleshooting.

 

Please feel free to leave a comment below if you have other concerns about Spreadsheet Sync in QBO. I'm always ready to help. Take care, @efish123.

S
Sharon2665
April 21, 2023

If you have two QBO accounts that are not both advanced are you still able to run reports in spreadsheet sync using both companies?

 

L
LollyNino_CQuickBooks Team
QuickBooks Team
April 21, 2023

Welcome to the QuickBooks Community. @Sharon2665. Let me discuss how Spreadsheet Sync works, and I'll make sure you can properly handle your reports in QuickBooks Online Advance (QBOA)

 

If you have two QuickBooks accounts, but they are not both QBO Advance, it is impossible to use since the Spreadsheet Sync tool is only available in QuickBooks Advanced subscriptions. That said, I recommend an upgrade for both companies so you can use it. 

 

For more details, check out the following article: Upgrade or downgrade QuickBooks Online. It includes instructions on how to switch back to your previous subscription.

 

Also, check out this article as your reference to guide you in resolving common errors when using Spreadsheet Sync in QBO: Spreadsheet Sync troubleshooting. 

 

I've also included a couple of detailed resources about working with Spreadsheet Sync, which may come in handy moving forward:

 

 

Please let us know if you have any questions or concerns besides the Spreadsheet Sync feature. I'll be glad to help you further. Have a good one and take care always! 

P
pacbandc
June 12, 2023

i am trying to sync my qkbs with excel

 

MariaSoledadG
MariaSoledadGQuickBooks Team
QuickBooks Team
June 12, 2023

Let me guide you on how you can sync QuickBooks with Excel, pacbandc.

 

One of the advantage when you're able to synchronize one software to the other is that it stabilizes the incoming and outgoing data making sure it's updated and compliant across the board. Aside from the ability to access a piece of data when you need it, it also enhances your efficiency at work. 

 

With QuickBooks Online (QBO) Advanced, you're able to open Spreadsheet Sync and sign in while working. Spreadsheet Sync works only with Excel Office 365.

 

You can use one of the following methods to install Spreadsheet Sync. To do so, you can follow the steps outlined below:

 

  • From the Reports tab:
    1. Select Business overview, then Reports.
    2. Select the Create new report ▼ dropdown and select in spreadsheet.
       
  • From Settings ⚙:
    • Select Spreadsheet Sync.

 

Then, allow the Spreadsheet Sync add-in:

  1. In the pop-up window, select Let’s Go.
  2. In the next pop-up window, select Open Link.
  3. Once Spreadsheet Sync downloads, it'll prompt Office 365 to open. Select Trust this add-in.
  4. Select Sign in.
  5. Enter your QuickBooks Online user ID and password.
  6. Select Sign in.

To give you more details about the process, you can also check out this article for detailed steps: Install And Open Spreadsheet Sync.

 

However, if you're using other versions of QuickBooks Online (QBO), you can work with your Excel file separately from QuickBooks and import or export data to or from Excel. I've added these articles that will show you the process:
 

 

Moreover, learn from this article how you can filter specific information like accounts or customer data to ensure you'll get the data you need: Customize Reports In QuickBooks Online.

 

Please get back to us if you have any questions when syncing Excel with QBO. We're here to make sure everything is covered for your business needs.

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