Using QuickBooks Online Advanced reporting tool Spreadsheet Sync
by Intuit• Updated 2 weeks ago
With QuickBooks Online Advanced, you have several options for creating custom reports. You can use QuickBooks Online's report functions, or Excel-based Spreadsheet Sync for spreadsheet reporting.
With Spreadsheet Sync, you can upload and download QuickBooks Online Advanced information and use customizable templates for formatting your data.
- With Spreadsheet Sync, you can upload and download QuickBooks Online Advanced information and use customizable templates for formatting your data.
Create a detailed Profit & Loss, Trial Balance, or Balance Sheet report with Spreadsheet Sync
Spreadsheet Sync lets you pull current QuickBooks Online Advanced data into a formatted spreadsheet and create pivot tables you can segment with slicers.
It includes the following report templates:
- The Simple Management Report includes 3 formatted spreadsheets:
- Trial balance
- Balance sheet
- Profit & Loss (standard)
- Other QuickBooks Online report templates include:
- Statement of Cash Flows
- Inventory Valuation Summary
- Supplier Balance Summary or Detail
- A/P Aging Summary or Detail
- Customer Balance Summary or Detail
- A/R Aging Summary or Detail
- Expenses by Supplier
- Sales Reports by product or service, class, or customer
To learn more, see How to create and edit reports in Spreadsheet Sync.
For more information
For more information, review our article Create custom reports in QuickBooks Online Advanced.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountantby QuickBooks•Updated July 04, 2024
- Create and edit reports in Spreadsheet Sync in QuickBooks Online Advanced or Accountantby QuickBooks•2•Updated July 04, 2024
- Spreadsheet Sync troubleshootingby QuickBooks•1•Updated May 28, 2024
- Get started with Spreadsheet Sync for QuickBooks Online Advanced and Accountantby QuickBooks•5•Updated September 02, 2024