SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests

Prepare financial statements

This feature is only available with products on the CaseWare Cloud Engagements platform. Available products include OnPoint PCR, and CaseWare ReviewCompTax.

To prepare a financial statement, go to the Documents page and select the financial statements document to open it. Some data already populates in the document as you set up your engagement, such as the cash flow statement and the trial balance data. You can review the existing information and make any necessary modifications or customizations.

Note: See Customize financial statements layout and Customize financial statements content for all the customization tasks related to financial statements.

View guidance information

You can find guidance information in the document in the form of:

  • a Guidance area in the Document Map that holds special instructions or assumptions relevant to the financial statements document.

  • text within a yellow background that holds guidance information relevant to a specific item in the document, such as a financial statement area, a note or a report paragraph. You can hide or show the guidance information for an item by selecting the lightbulb icon () next to it.

Note: Guidance information is only available in the document if it’s been configured in your product.

Use non-consolidated data in the financial statements

In a consolidation engagement, you can remove the consolidated data from your financial statement and only use the non-consolidated data. For example, if you need to prepare separate sets of financial statements for the parent entity and the subsidiaries (consolidated entities).

The document's default setting is to include the consolidated data.

To use non-consolidated data in your financial statement:

  1. Open the financial statement and go to the Document Map.

  2. Select Settings () , then clear the Use non-consolidated data check box.

    The consolidated data is no longer available in the financial statement.

To include the consolidated data in the financial statement, select the Use non-consolidated data check box again.

Exclude prior year information from the financial statements

The prior year information displays in the financial statement tables by default. You can exclude the prior year information from the statement if it's irrelevant. For example, you can exclude the prior year information in your financial statement if the current year is not directly comparable to the prior year.

To exclude prior year information:

  1. Open the financial statement and go to the Document Map

  2. Select the Settings (), then clear the Show prior year check box.

  3. The prior year information is no longer available in the financial statement tables.

Select the Show prior year check box to show the prior year information again in all areas of the statement.

View details of accounts and groups

You can select a specific account in any financial statements table to view its trial balance data.

To view account details, select the account to display the Account Details popup which shows the trial balance data for this account.

Account Details popup

You can also expand or collapse groups to either view data for each account in the group or view the total amount for the accounts in a group.

To expand or collapse a row:

  1. Select the arrow pointing down () to expand a row.

    The expanded row shows the figures for each account in the group. It also shows any available information (such as note references) for each account.

  2. Select the arrow pointing up () to collapse a row.

    The collapsed row shows the total amount for all accounts in the group.

Note: You cannot collapse or expand groups unless the setting for Accounts in the table is either Included (Collapsed) or Included (Expanded). To learn more, see Set a default display option for accounts and groups.

Set a default display option for accounts and groups

You can predefine how groups and accounts display in each table in the financial statements. For example, you can set a table to show groups collapsed by default.

To set the display option for groups and accounts in a table:

  1. Select the desired table.

  2. Select More actions () | Edit Dynamic Table.

  3. Select Settings ().

  4. Choose the desired option for Accounts.

  5. Available options:

    • Excluded - Show groups only in the table.

    • Included (Collapsed) - Show accounts and groups in table, where groups are collapsed by default.

    • Included (Expanded) - Show accounts and groups in the table, where groups are expanded by default.

  6. Select SAVE or SAVE & CLOSE.

Review group and account balances

To review group and account balances, see Review group and account balances in the financial statements.

Replace text and field placeholders

The financial statement typically includes an introductory letter created from a template. The template’s content can include placeholders for some text and fields that you need to replace with specific information related to your engagement, organization or client.

The Placeholders indicator at the top of the Document Map tracks your progress on placeholders. It shows the number of placeholders that haven’t been replaced by actual information. You can also select the indicator to navigate to the next empty placeholder.

Placeholders indicator in Financial Statements

To replace a text placeholder:

  1. Select the text placeholder.

    Tip: The blue highlighted text in the document are placeholders.

  2. At the Text Placeholder popup, replace the placeholder text and select Save.

    Note: If you don't want to change the placeholder text, you must select the placeholder and select Save at the Text Placeholder popup so it’s removed from the placeholders count at the top.

To replace a field placeholder:

  1. Select the field placeholder.

    Tip: The blue drop-down fields in the document are field placeholders.

  2. Select a value or specify a date as indicated in the placeholder field.

Exclude content

Based on your product configuration, some notes are automatically added in the document based on your trial balance data or specific checklist responses. You can exclude some of these notes if they’re no longer needed and move them to the Notes library.

You can also exclude areas, dynamic tables, page breaks and text sections in the financial statements. For example, you can exclude some areas that you don’t want to include in the final document that will be mailed to the client.

To exclude a dynamic table, page break, text section or a note heading:

  1. Go to the Document Map and select the area where the content you want to exclude is located.

  2. Select the content you want to exclude.

    For example, if you want to exclude a dynamic table, select the dynamic table.

  3. Select More actions (), then choose Exclude from the list.

To exclude an area:

  1. Go to the Document Map and select the area that you want to exclude.

  2. At the top right corner of the page, select More actions () | Exclude.

To exclude a note:

  1. Go to the Document Map and select the note that you want to exclude.

  2. At the top right corner of the page, select More actions () | Exclude.

    The area is removed from the document. It's now available in the Notes Library.

If you attempt to exclude an item that’s available in the document due to visibility settings based on response conditions, you get a confirmation prompt. The prompt shows the details of the response conditions logic and provides a link to the checklist document so you can review and change responses if needed.

Add excluded content back in the financial statements

You can add excluded areas, content and notes back into your financial statements document.

To add an excluded area back in your financial statement:

  1. Go to the Document Map, then select Add ().

    Excluded areas display among the available options in the list.

  2. Select the area you want to add.

The selected area is added back into the financial statement. You can also drag and drop the new area to change its location in the document, see Rearrange document areas.

To add excluded content back in your financial statements:

  1. Go to the desired area, then select Add ().

    Any excluded contents display among the available options in the list.

  2. Select the content you want to add back in your financial statement.

Change engagement glossary terms and dynamic text

Note: You can only change an existing glossary term or a dynamic text output if the override option is enabled in your product.

An engagement glossary contains terms. Terms are words and phrases that can be reused throughout the product. When a term is changed, it is changed everywhere the author defined.

Dynamic text fields change if certain conditions are met. For example, if the client responds ‘Yes’ to a procedure in a checklist, then ‘Agreed’ shows in the dynamic text field.

Your documents may contain terms from the glossary or dynamic text fields. Depending on your product, you may be able to override glossary terms and dynamic text outputs.

To change an engagement glossary term or a dynamic text output:

  1. Select the document’s text area where you want to change.

    Areas highlighted in gray are either glossary terms or dynamic text fields.

  2. Select the glossary term or dynamic text to open the Data Link dialog.

    If you select a glossary term, you can select information () to see the number of places that term is used.

  3. Change the Output as desired and select Save.

When the Output condition is met, the text changes in all the places it’s used in the engagement. If a different condition is met after the change, the Output changes to match the configured output text for that condition.

Review the Statement of Cash Flows

The Statement of Cash Flows is automatically generated from the trial balance data. You can review the Statement of Cash Flows and make changes if needed. For example, you can add cash flow data that's not derived from the trial balance so it transfers through to your balance sheet.

To populate the Statement of Cash Flows in your financial statements document, select Add () | Statement of Cash Flows at the Document Map.

Note: The setup of the Statement of Cash Flows determines the edit options that are available to you. For example, you can have the option to add data in the Statement of Cash Flows but not to modify existing data.

To add data in the Cash Flow statement:

  1. Go to the group where you want to add data.

  2. Select Settings () | + Input row.

    A new row is appended to the group.

  3. Enter the cash flow data in the gray fields.

    Entries are automatically saved.

To edit existing balances in the Cash Flow statement:

  1. Go to the cash flow line where you want to modify balances.

  2. Select Settings () | Override calculated balances, then edit the balances as needed.

    Changes are automatically saved.

You can select Settings () | Use calculated balances to revert back to the original balances.

Create a note

Notes to the financial statements are important disclosures that further explain numbers on the financial statements document. You can create single notes and you can also create a note hierarchy (main category notes and subcategory notes) to classify and organize the notes.

Note: You can only have a three-level hierarchy.

To create a note:

  1. Select the Notes to the Financial Statements area at the Document Map.

  2. Select Add () | Create Note.

A new note area is added in the document with a default title Note title. You can select the default title and change it.

To create a note hierarchy, add subheadings to existing notes.

To create a note hierarchy:

  1. Select the Notes to the Financial Statements area at the Document Map.

  2. Select the note that you want to create a hierarchy for, then select Add ().

    The applicable heading displays under Heading.

  3. Select the applicable heading.

  4. A subcategory note is added in the document with a default title Note title. You can select the default title and change it.

To add content to a note, select Add () and choose one of the following content types:

  • Text Section
  • Dynamic Table
  • Page Break

You can add more than one content type in a note.

Add a note from library

Notes to the financial statements are important disclosures that further explain numbers on the financial statements document. You can add notes to include supplementary information about the results of your engagement for your client for instance.

The Notes library provides a pool of predefined notes which allows users to easily find and add notes in the financial statements document. It also features a search field where you can filter the library notes by title or by trial balance group (if available).

Use the notes library to browse, search and add notes to the financial statements.

To add a note from the library:

  1. Select the Notes to the Financial Statements area at the Document Map, then select Add () | Insert from Library.

    The Notes Library opens defaulted to the CATEGORIES tab, which shows the hierarchy of note titles (main categories and subcategories).

    Depending on your product setup, the GROUPS tab can be available so you can also browse the library based on the financial statement areas (trial balance groups) that the notes are related to.

    If you select a category or group, the number of available notes in the selected category or group displays at the View notes option at the top. If no category or group is selected, the total number of notes in the library displays at the View notes option.

    In the following figure, the library opens showing the available note categories. For instance, the Summary of accounting policies category has 61 notes within various subcategories. And since we haven't selected a category yet, the View notes option shows the total number of notes in the library (256 notes).

In the CATEGORIES and GROUPS tabs, you can browse a specific note category or trial balance group by selecting the arrow ().

In the following figure, we selected the arrow next to Summary of accounting policies to view its subcategories. Note that the View notes option now shows the number of available notes within Summary of accounting policies (61 notes).

You can select View notes to switch to a note-only view, where the library lists all the available notes in the current category or group. In the note-only view, the trial balance groups show in light gray beneath the note. A preview option is also available in the note-only view. Select PREVIEW to display a preview of the content of a specific note.

In the following figure, we selected View notes. The library now only displays the 61 notes within the Summary of accounting policies category.

The search field at the top allows you to filter the list. You can filter by title or by trial balance group. Once you start typing a keyword, the library shows the matching results.

In this example, we typed cash in the search field to filter the notes associated to Cash within the Summary of accounting policies category.

  1. Select the check box next to the notes that you want to add in the document.

    You'll notice that the number of added notes displays at the Show selected notes indicator () at the top.

    If you select the Show selected notes indicator, you can view a preview of the content of each selected note. Note that dynamic tables don’t show in the preview.

  2. Select ADD on the top right corner of the page.

  3. The note is added in the financial statements document and is no longer available in the Notes library.

    In the Document Map, the newly added notes are marked by the New Note indicator (). Once you select a newly added note, the indicator () is no longer available.

You can also use the Notes library to add notes from a specific note category using the Add () button in the note area.

To add a note from a specific category:

  1. Select the desired note category.

  2. Select Add ().

  3. The library opens showing only the notes belonging to the selected category.

  4. Select one or more notes, then select ADD.

    The note is added in the financial statements document and is no longer available in the Notes library.

You can also remove a note you've added from the Notes library. For example, if added by mistake.

To remove a note added from library from the document:

  1. Go to the note that you want to remove.

  2. Select More actions () | Exclude.

The note is removed from the document and is now available in the Notes library.

Link an account or a group to a note in the financial statements

A note reference is a link to an existing note in the financial statement. You can add note references in table rows in the financial statement. For example, to link an account or a group to an existing note that holds related details or information.

To add a note reference in a row:

  1. Select the table.

  2. Select More actions (), then choose Edit Dynamic Table.

    The table opens in edit mode.

  1. Go to the row where you want to add a note reference.

  2. Select the Add () button above the row.

  3. Choose Commentary row.

    A note reference is added right above the row.

  4. Select (Note#) to display a list the existing notes in the financial statement.

  5. Select a note from the list to reference it in the row.

    You can also select Show hidden notes to reference a hidden note .

  6. Select SAVE or SAVE & CLOSE.

The number of the referenced note displays next to the row name.

You can also reference notes in columns.

To add a note reference in a column:

  1. Add a column in the table.

    1. Select the table.

      Icons for table options display on the right.

    2. Select More actions (), then choose Edit Dynamic Table.

    3. The table opens in edit mode.

    4. Go to where you want to add a column.

    5. Select Add () at the upper table border.

    6. A column is added to the table and the column settings display on the page.

  2. Select the header of the new column and change the column type to Note reference.

  3. Enter a header and specify the desired width.

  4. Select Done.

  5. The new column is added in the table with empty references (#).

  6. Specify the note references for each row.

    1. Select an empty reference (#) to display a list the existing notes in the financial statements document.

    2. Select one or more notes from the list.

    3. You can also select Show excluded notes to reference excluded notes.

  7. Select SAVE or SAVE & CLOSE.

You can also use the above methods to change a note reference or you can change it directly from the table.

To change a note reference directly from the table:

  1. Select the note reference that you want to change.

    A list the existing notes in the financial statement displays

  2. Select one or more notes from the list to reference in the row or column.

    You can also select Show hidden notes to reference hidden notes.

Add data in the financial statements tables

You can include more information in your financial statement. You can add columns or rows into tables and rearrange rows. You can also modify the account group settings.

To add a column in a dynamic table:

  1. Select the table.

  2. Select More actions (), then choose Edit Dynamic Table.

    The table opens in edit mode.

  1. Go to where you want to add a column.

  2. Select Add () at the upper table border.

    A column is added to the table and the column settings display on the page.

To edit column settings:

  1. Select the column header.

  2. Modify the following settings as needed:

    • Type

      Choose a column type. The following columns have predefined values:

      • Prior year - prior year balance

      • Current year - current year balance

      • Current period - balance for the current period (for interim engagements)

      • Comparative period - balance for the comparative period

      • Amount variance - difference between prior year balance and current year balance

      • Percent variance - percentage difference between prior year balance and current year balance

      You can enter custom values for the following columns:

      • Input - enter text, numbers, currency values or percentages.

      • Custom calculation - enter a calculation using the calculation editor. The calculation is applied to all column cells.

      • Note reference - add references to existing notes in the financial statements.

      • Annotation - add annotations column. Select Add () in each cell in the column to add annotations.

    • Heading

      You can insert Dynamic Text or formula (fx) for the header. You can also type simple text in the Output field or combine simple text with dynamic text and formula.

    • Dimension

      Dimensions are group properties that authors can configure for the groupings to provide further categorization for accounts. For example, to have a further categorization for accounts based on location (Europe, North America, etc.).

      You can select a dimension to set the column to only display data for that dimension.

    • Width

      Select a width for your column. The width options for all columns are Narrow and Standard, except for note reference, annotation and description columns, where the width options are Small, Medium and Large.

    • Format

      For input or custom calculation columns, you can choose one of the following formats for your cell values:

      • Currency

      • Number

      • Percent

      • Text

      If you select Number or Percent, you can also choose the number of decimal places.

    • Display options

      For some column types and formats, you can select one or more display options:

      • Expand to fill the width of the page - sets the column width so the dynamic table fits the full width of the page.

        Note: This setting is enabled on the Description column by default.

      • Display zero balances - shows accounts with zero balances in the column.

      • Display opposite sign for balances - displays the opposite sign (negative or positive) for the values in the column.

      • Exclude from totals - excludes the values in this column from the calculation in the account group Total row.

      • Display symbol in heading - displays the currency symbol or percentage sign at the top of the column.

      • Show year in heading - adds the year to the heading of Current year or Prior year columns.

      • Use non-consolidated data - if this is a consolidated engagement, selecting this option removes consolidated data from the column and displays the non-consolidated data only.

    • Hide / Show ( / )

      Select this icon to hide or show the column in the table's edit mode and in the financial statement document.

    • Delete ()

      Select this icon to delete the column from the table.

  3. Select DONE.

  4. Select SAVE or SAVE & CLOSE.

To add a row in a dynamic table:

  1. Select the table.

  2. Select More actions (), then choose Edit Dynamic Table.

    The table opens in edit mode.

  1. Go to where you want to add a row.

  2. Select Add () at the left border of the table.

  3. Select one of the following row types:

    Trial balance data: to select the row data from the trial balance data. You can insert an account or group. If the group has subgroups, they are inserted into the table as well. Note that you can hide a trial balance group row in the table if needed (see hide trial balance group rows).

    Input row: to add a text field row. You can enter custom text.

    Commentary row: adds a commentary row. By default it inserts a reference to existing notes in the financial statements. You can change the default by deleting the note reference and enter a comment for the row.

    Spacing row: to add white space into your dynamic table. You can add white space to make your content easier to read.

    Page break: to add a page break between table rows.

    Custom group: to add a custom group row. Custom group rows insert a text field (to add a title or a brief description for the group) and a total row. A Total row is also inserted in the table to hold the sum of the rows within the custom group.

  4. Select SAVE or SAVE & CLOSE.

To move a row:

  1. Select the table.

  2. Select More actions (), then choose Edit Dynamic Table.

    The table opens in edit mode.

  1. Locate the row that you want to move and select the Move icon ().

  2. Drag the row then drop it in the desired location.

  3. A grid displays in the table to mark the borders of each row. Valid places to move your row have dark blue grid lines while invalid places have gray grid lines. Use the grid for guidance as you drag and drop.

Insert the firm logo

In the financial statements document, you can insert the firm logo in any text section or in the document header or footer.

To insert the firm logo:

  1. Select the text field where you want to insert the logo.

  2. Select Insert Logo Placeholder () at the formatting toolbar.

  3. The firm logo is added in the text field.

    If no logo is available in the firm template, a placeholder with a link to Cloud displays so you can upload a logo.

Note: You can only upload a firm logo in the firm template. To access the firm template, you must have the Settings Admin role or similar. For more information, see Built-in roles and Assign security roles.

If you require a physical or digital copy of a financial statements, you can print the statement. The Print option converts the document to a PDF format which you can print or save.

To print a financial statement:

  1. Open a financial statement, then go to the Document Map.

  2. Select Settings () | Document Print Settings to review the print settings for the financial statement.

    If there are custom print settings for the notes area, page breaks or a document area:

  • Select Settings () | Notes Print Settings to review the notes area settings.

  • Select More actions () | Edit Print Settings to review the settings for a document area.

  • Select More actions () | Print Settings to review the settings for a page break.

  1. Select Print () at the Document Map.

    If a bulk print option is available in your product, you’ll find a drop-down at the Print icon (). Select one of the available group of documents to print them together.

    Note: If there are text or field placeholders that have not been replaced, you get a warning once you select Print.

The financial statement is converted to a PDF file that displays on a new browser tab.

Was this helpful?

Yes
No
This content is exclusively related to Rct,se,pcr and has been filtered out. Select the PRODUCTS dropdown in the top navigation to modify your filter settings.

Stay Connected

Subscribe to receive updates on the latest articles and news for CaseWare products.

Your download will start immediately after you subscribe.

Please enter a valid email.
No thanks, I just want the file.