cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
QuickBooksHelp
Intuit

Using WorkPapers Groupings & statements

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 briefcase icon.
  4. Select the Workpapers option under the Accountant Tools menu.
    Account Tools_Workpapers
  5. Select the tax year review (for example, 2018).
    Select_Tax_Year_UK
  6. Select Grouping & statements:
    Grouping_&_Statements_UK

The trial balance details display.

Users have the ability to delete or modify the attached file. Select the icon as indicated below and 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

Need to get in touch?

Contact us