Working with the Spreadsheet Sync user interface in QuickBooks Online Advanced and Accountant

This article explains Spreadsheet Sync's tab and panel functions within Microsoft Office Excel. Make sure you’re signed into your QuickBooks account through Spreadsheet sync to see all the features and functions explained below. Follow the steps found here to sign into Spreadsheet Sync from your QuickBooks Online company.

In this article, you'll learn about the functions of the following tabs:

• Group
• Get Started, Run report, and Quick refresh
• Create or edit records, Clear Sheet, Update Fields, and Post to QuickBooks
• Help

Group

Group lets you import your QuickBooks Online Advanced or Accountant company data into Spreadsheet Sync. You’ll find this button in the Spreadsheet Sync tab.

• Admins can view their company list on this page under the Companies section.
• You can also put your companies into Groups to create consolidated reports. 

Get Started, Run report, and Quick refresh

Get Started helps you choose your activity. You’ll find this button in the Spreadsheet Sync tab. Available options are:

• Run report from the latest company data, or start with a template.
• Run multi-company report by grouping companies to get a consolidated financial report.
• Create or edit records like transactions, lists, or other records and sync with QuickBooks.
• Create and sync budgets by creating or editing an existing budget and then saving it to QuickBooks.

Run report directs you to:

• From the Select company ▼ dropdown, select a QuickBooks Online Advanced or Accountant company, you want to use for a report.
• From the Select report ▼ dropdown, select a report. Reports include:
  • Standard accounting reports such as Profit & Loss and trial balance as well as transaction, inventory, and sales reports.
  • Custom reports created using custom report builder in QuickBooks.
• From the filters section, select a date range or multiple time periods for your data as well as filter by class, location, or other categories (filters will vary depending on the type of report).

Quick refresh lets you update the data in your spreadsheet at any time. Select:

• Quick refresh to refresh data according to filters previously selected.
• Automatic refresh to automatically update selected sheets every time you sign in to Spreadsheet Sync or when you open the workbook. 

Create or edit records, Clear Sheet, Update Fields, and Post to QuickBooks

Create or edit records lets you post data to QuickBooks Online Advanced or Accountant or download data, make bulk edits, and then repost it.

• Use list templates to automatically add customers, suppliers, employees, account types, or journal entries to your QuickBooks Online company.

Clear Sheet lets you clear the data and formatting from a spreadsheet and return to the original template.

Update Fields makes visible within a transaction template any new customers, suppliers, employees, accounts, or journal entries added to your QuickBooks Online company. 

• Field items can be added in QuickBooks Online Advanced or Accountant by using a Spreadsheet Sync list template such as Class and Location, or Supplier and Customers.
• Field items appear in dropdown lists within a transaction template. For example, in an Invoices & Bills record, you must fill in the customer, supplier, item, and account from a dropdown list. 

Post to QuickBooks lets you post any data added to a Spreadsheet Sync records template to your QuickBooks Online company.

Accessing Spreadsheet Sync

The following user types can access Spreadsheet Sync:

• Primary Admin
• Company Admin
• Standard (All access)

The following parameters apply to Accountant users:

• Team members must have been provided client access
• Only clients with Advanced SKUs can use Spreadsheet Sync
• An Accountant user is considered a Company Admin on their client's company, thus all Accountant users should be able to access Spreadsheet Sync within a client's Advanced file.

Help

Help connects you to our community of QuickBooks Online Support.