Create and edit reports in Spreadsheet Sync in QuickBooks Online Advanced or Accountant

You can use Spreadsheet Sync's report templates for analyzing and presenting QuickBooks Online Advanced or Accountant data.

In this article, you'll learn:

• The two types of report
• How to use the Simple Management report
• The types of QuickBooks Online reports available in Spreadsheet Sync
• How to run QuickBooks Online reports in Spreadsheet Sync

QuickBooks Online reports

QuickBooks Online reports can be created and customized in Spreadsheet Sync. They don't include pivot tables.

You can also choose to download QuickBooks Online Advanced transaction or account data into a data table.

These reports and tables are organized by category. See the types of QuickBooks Online reports and data tables available in Spreadsheet Sync section below.

1. Advanced reports include formatted pivot tables that can be automatically filled with QuickBooks Online Advanced data and then used to generate charts and graphs.
   1. There are two package advance templates of this kind: Management Report and Smart Profit & Loss report.
2. QuickBooks Online reports can be created and customized in Spreadsheet Sync. They don't include pivot tables.
   1. You can also choose to download QuickBooks Online Advanced transaction or account data into a data table.
   2. These reports and tables are organized by category. See the Types of QuickBooks Online reports and data tables available in Spreadsheet Sync section below.

Select Quick refresh from the toolbar to update a report with the latest QuickBooks Online Advanced data. You can also fill templates manually.

Note: 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.

Using the Simple Management and Smart Profit & Loss reports

The Simple Management Report lets you quickly analyze the financial health of a company or companies. They include formatted pivot tables you can segment with slicers.

• The Simple Management Report includes three formatted spreadsheets:
  • Trial Balance
  • Balance Sheet
  • Profit & Loss (standard)
• Smart Profit & Loss includes a formatted spreadsheet for showing P&L data in detail.

See Using Spreadsheet Sync’s advanced reports to learn how to create an advanced report.

Types of QuickBooks Online reports available in Spreadsheet Sync

Choose a QuickBooks Online report to analyze or present a company's data.

1. Select Run report on Spreadsheet Sync homepage. 
2. Select report from the dropdown or search for the report by typing in the report name.
3. Select the report you want to run.

Types of report

Standard reports

In the Standard tab, the reports are organized into several categories. The categories include:

• Business Overview: This section includes statement of cash flows, balance sheet, inventory valuation summary, profit and loss, trial balance, and budget reports.
• For my accountant: This section of reports is dedicated to accountant reports. These reports are often used by your accountant to help prepare your year-end reports and taxes.
• What you owe: This section includes reports detailing information about what money you owe and the suppliers you owe money to.
• Who owes you: This section includes reports about the customers who owe you money. Reports in this category include A/R Aging Summary, Collections Report, Open Invoices, and other reports designed to help you manage your customer receivables.
• Expenses and suppliers: This section includes reports about your expenses and purchases. Here you’ll find detailed information about purchases including Purchase Order reports, and other purchasing information.
• Sales and customers: This section includes reports detailing information about your sales made to your customers. This category reports in detail about sales of products and services and details about customers who purchase your products and services.
• Bank transactions: This section includes reports about your payments and transfers.
• Employees: This section includes reports on employee time tracking information in QuickBooks.

Custom reports

All custom reports created in QuickBooks Online through "Custom Report Builder (CRB)" will be available in this section of spreadsheet sync.

Note: Grouping/pivot actions applied to these reports in CRB, don't carry over. The report will be in tabular format with field columns. Any additional formatting like pivots or charts can be applied to get the desired insights.

Run QuickBooks Online reports in Spreadsheet Sync

To create and edit a QuickBooks Online report, follow these steps:

1. In the Spreadsheet Sync panel, select Run a report.
2. Select your QuickBooks Online Advanced or Accountant company from the Select company ▼ dropdown.
3. Select Select report to choose the report or template you want to use.
4. Select the filters you want to apply on the report.
   1. Under Date range, select whether to see weekly, monthly, quarterly, or yearly data and the start and end dates of your data period. (For multiple period reports, select filters for a total time period and comparative time periods.)
5. Select Run report to generate the report on the spreadsheet.

Format your report

You can add or delete columns and rows to format the report. Spreadsheet Sync will save your formatting preferences.
Note: Deleted rows can't be recovered.