With Spreadsheet Sync, you can generate both high-level reports and routine transaction reports.
Advanced templates include P&L reports, trial balance, and balance sheet. Examples of other financial reports include Statement of Cash Flows, A/P Aging Summary, Sales reports, and more.
To run a report:
- Select Build Reports in the toolbar.
- In the Build report task panel, under Company or Group, select the company data you want to use.
- Select Company Settings in the toolbar to access companies or groups assigned to you.
- Select Select data source and then Reports to select either a Profit and Loss - Account Details or a Profit and Loss - Multiple Periods report.
- Click on Select data to get to open the parameters window.
- In the Presets field, enter a name to save your filters as a preset or choose a previously saved preset.
- In the dropdown menus for Basis, Class, Location, Customer, or Item, choose how to filter the data.
- Under Date Macro, choose a time period or check the boxes next to From Date and To Date to set an exact date range.
- Under Options, choose whether to download data as an Excel Table or Raw Data and in a New Sheet or Current Sheet.
- Data will automatically download from QuickBooks Online Advanced. You can refresh information at any time by selecting Refresh in the toolbar.
- See How to create and edit reports in Spreadsheet Sync to learn more.