QuickBooks HelpQuickBooksHelpIntuit

Using WorkPapers Groupings & statements

SOLVEDby QuickBooks1Updated January 26, 2024

QuickBooks Online Accountants are able to create simplified financial statements by combining the existing Workpapers product with a new seamless workflow called “Groupings & statements”, allowing the creation of financial statements in just a few steps.

Groupings & statements users can:

  • Create and organise groups for financial statements (for example, balance sheets and Income Statement)
  • Deliver timely communication to firm users by adding notes to groups and accounts
  • Work collaborative and seamlessly within their firm by adding attachments to groups and accounts
  • Save time by utilising the “drag-and-drop” functionality
  • Quickly share financial statement details with clients and colleagues by using the “export to Excel” and “export to PDF” functionalities
  1. Sign in to the QuickBooks Online Accountant.
  2. Open a client company.
  3. Select the Workpapers option in the Accounting Review menu.C29C4D02-622E-4105-9D22-10C32A9A658B.png
  4. Select the tax year review (for example, 2018).
    Select_Tax_Year_UK
  5. Select Grouping & statements:
    Grouping_&_Statements_UK

The trial balance details display.

Users have the ability to delete or modify the attached file. You can apply the option of “Delete” or “download” to the file.

Modifying_Attachements_UK

Users can add other accounts to a group using the “drag-and-drop” functionality:

  1. Select the accounts to group.
  2. Drag the account into a new group using the option highlighted below:
    Drag_Account_Workpapers_UK

The account is added to the group.

You can add additional notes and attachments or “ungroup” by selecting the Update option.

You can export reports to Excel in order to make additional changes, as well as generate a detailed report with the following:

  • Notice to Reader (NTR)
  • Balance Sheet
  • Simplified Income Statement

Go to Run report and select the Export as excel:

Export_as_Excel_UK

The report exports to an Excel sheet with designated tabs:

Workpapers_Excel_sheet

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this