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

Customize the financial statements content

This feature is only available with products on the CaseWare Cloud Engagements platform.

As a member of the engagement team, you can modify the financial statements document for your engagement file. Once you've made your changes, your reviewer can look at the document and verify that it is ready to be finalized to the client.

You can customize your financial statements content to meet internal requirements or specific client requirements and prepare your financial statement for printing and archiving.

To start customizing the content, open your engagement file and select Documents from the top menu. Select the desired financial statement to open it.

Note: If you want to customize the financial statements content in the firm template, you must have the Settings Admin role or similar to access the firm template. See Manage the firm template for information on how to open and edit the firm template.

Add content areas

Areas help organize your financial statement content by grouping similar or related information.

To add an area to the financial statement:

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

  2. Choose New Area.

    The new area is appended to the document map and displays on the page with a default title New Area. You can select the default title to change it.

    Note: If there are no notes in the financial statement, the option Note Area is also available. Choose Note Area to include a notes section in the document and start adding notes.

  3. Start adding content to the new area by selecting it to display the Add icon ().

To add content to the new area, select Add (), then choose one of the following content types:

  • Text Section

  • Dynamic Table

  • Page Break

You can add more than one content type in an area. You can also drag and drop the new area to change its location in the document, see Rearrange document areas.

Customize text

Financial statements can include text sections in various areas and notes. You can edit and customize the formatting of the text sections in your financial statement.

To customize a text section:

Select the text section to start editing the text as desired.

The formatting toolbar displays at the top of the text section. You can use the formatting toolbar to make the following changes:

Toolbar icon

Description

Apply a style to selected text or paragraph.

Bold, italicize or underline selected text.

Change the color of a selected text or a paragraph or highlight selected text or paragraph.

Add a bullet or number list

Add visibility conditions to lists.

Indent selected text or paragraph.

Align selected text or paragraph.

Add a horizontal line

Add an image

Add a table

Add a special character in the text section.

Add field placeholders.

Field placeholders are drop-down lists for selecting a staff member or a client contact from Cloud, or a date.

Add text placeholders.

Add or remove a link.

Add data links.

Remove all formatting for a selected text or a paragraph and revert to the default.

Add or remove a link in text sections

You can add links to a URL, an email or a phone number.

To add a link in a text section:

Select Add link () and enter the following information in the Link Info tab:

  • Display Text - the selected text is the default Display text for the link. If you haven’t selected text, enter the Display Text in this field.

  • Link Type - select a type from the drop-down list. Based on your selection, the dialog displays different sets of fields that you need to specify:

    Link type

    Fields

    URL

    Protocol - select the link protocol (http, https, ftp, news or other)

    URL - enter the URL

    Link to anchor in the text

    This feature is currently not functional

    Email

    E-mail address - enter the email address

    Message Subject - enter a subject for the email message

    Message Body - enter the email message body

    Phone

    Phone number - enter the phone number

In the Target tab, select where you want the link target to open. The default is in a new browser window.

You can also enter more information in the Advanced tab. Note that if you add a link to a file download, you can select the Force Download check box in this tab so the file download starts once the user selects the link.

Once you’re done, select OK.

To remove a link in a text section, select the link text then select Remove Link ().

Add or remove placeholders in text sections

You can add placeholders for text and fields to prompt users to insert specific information related to the engagement, organization or client. For example, you can add a date placeholder to prompt accountants to add today’s date as part of the content.

To add a text placeholder:

  1. Go to where you want to add the placeholder, then select Add Text Placeholder ().

  2. In the Text Placeholder dialog:

    • Enter a label describing the information that users need to add in the placeholder in the Label field.

    • You can optionally enter content as a suggestion for the users in the Suggested Text field. A reduced version of the formatting toolbar displays so you can customize the format.

  3. Select Save.

  4. The text placeholder displays in the text section marked with a blue color.

Note: If you enter suggested text, it displays in the text section. Otherwise, the label text displays. The label text also shows as a tooltip for the engagement team members.

To add a client contact placeholder:

Go to where you want to add the placeholder, then select Add Contact Placeholder () from the formatting toolbar.

A drop-down list is inserted in the text section. The engagement team members can then select a client contact from the list while working on the engagement.

The default label for the contact placeholder is Select Contact. To change the default label, select the field, then enter a custom label in the displayed dialog box. To apply your change, select the arrow () next to the label field.

To add a staff placeholder:

Go to where you want to add the placeholder, then select Add Staff Placeholder () from the formatting toolbar.

A drop-down list is inserted in the text section. the engagement team members can then select a staff contact from the list while working on the engagement.

The default label for the staff placeholder is Select Staff. To change the default label, select the field, then enter a custom label in the displayed dialog box. To apply your change, select the arrow () next to the label field.

To add a date placeholder:

Go to where you want to add the placeholder, then select Add Date Placeholder () from the formatting toolbar.

A drop-down is inserted in the text section. The engagement team members can then specify a date using the calendar that displays once they select the drop-down.

The default label for the date placeholder is Select Date. To change the default label, select the field, then enter a custom label in the displayed date picker. To apply your change, select the arrow () next to the label field.

To add a logo placeholder:

Go to where you want to add the placeholder, then select Add Logo Placeholder () from the formatting toolbar.

If the firm author uploads a logo, the placeholder is automatically replaced with the uploaded image. Otherwise, a link to Cloud displays.

Tip: To remove a placeholder, highlight it and select Delete or Backspace.

Add or remove data links in text sections

Data links () allow you to have existing information in the engagement or in Cloud automatically retrieved and inserted in text fields.

The following data links are available:

Engagement properties

(from Cloud)

Engagement properties as defined in Cloud, such as:

  • Operating name
  • Legal name
  • Year end date
  • Year start date
  • Current Year
  • Website
  • Prior Year
  • Entity address

Trial balance

(from the engagement)

Items in the trial balance such as, account name, grouping name, or values from the current or prior year.

Firm properties

(from Cloud)

Firm name

Firm address

Responses

(from the engagement)

Responses to procedures from checklists. Once you select a checklist document from the list, select the response you want to retrieve and insert in the text section.

Materiality

(from the engagement)

Defined values in the Materiality document.

Dynamic text

Dynamic text is conditional text. It’s a field where different text displays based on a condition or a set of conditions.

See Add dynamic text.

Forms Value

Insert the value of a specific form field. Once you select a form and a field, the value of the selected field is inserted in the text field.

Note: This option is only available in the Data Link dialog if custom forms are available in your product, such as Tax forms.

To add dynamic text:

Note: You can only add dynamic text if you are customizing the firm template. To access the firm template, you must have the Settings Adminrole or similar. See Manage the firm template for information on how to open and edit the firm template.

  1. Go to where you want to add a formula in the text.

  2. Select Add Data Link () from the toolbar.

  3. At the Dynamic Text tab, select the Add Condition drop-down list.

  4. Different setup details display in the Data Link dialog based on the condition you choose:

Condition type

Condition setup

Response

Document - select the source document for the response

Procedure -  select the procedure for which the response is provided

Condition - select the value of the response

Output - select the text to be displayed when the condition is met

Trial balance

Financial Group - select the trial balance account or account group

Condition - select how the name of the Income Statement displays based on the value of Net Income in the trial balance

  • Consistent → name displays as "Statement of Income"
  • Contrary → name displays as "Statement of Loss"
  • Inconsistent → name displays as "Statement of Income (Loss)"

Output - select the text to be displayed when the condition is met

Consolidation

Condition - select the consolidation situation (Consolidated, Non-consolidated)

Output - select the text to be displayed when the condition is met

Reporting period

Condition - select the value of the reporting period (Monthly, Quarterly, Semi-Annual, Annual)

Output - select the text to be displayed when the condition is met

Organization type

Condition - select a country

Output - select the text to be displayed when the condition is met

Group of conditions

Select this option if you want to add a group of conditions, where the text output is based on how the conditions in the group are collectively evaluated

Group Condition - select one of the following values:

When all conditions below are met -> all conditions must be true for the Group Condition to be met

When any condition below is met -> any condition must be true for the Group Condition to be met

Output - select the text to be displayed when the Group Condition is met

Form Value Condition - select a form and a field in the selected form

Output - select the text to be displayed when the condition is met

Note: This condition is only functional if custom forms are available in your product, such as Tax forms.

    You can add more than one condition type to trigger additional text outputs. To add another condition, select Add Condition.

    You can also optionally specify an alternate output for the text if no conditions are met.

  1. Once you’re done, select Save.

  2. If a condition (or conditions) is met, the corresponding output text you specified for that condition displays.

    If no condition is met, the alternate text output (the one you specified for when none of the conditions are met) displays. Otherwise, #ValueEmpty# displays.

Tip: To remove a Data Link (), highlight it and select Delete or Backspace.

Edit notes

You can edit the dynamic table or the text section in a note. To edit a text section in a note, see Customize text .

To edit or copy a dynamic table in a note, refer to the dynamic table customization topics in this article.

You can delete an entire note or note content that’s no longer needed in the document.

Select More actions () | Delete to delete content or headings in a note. For example, to delete a note heading in a note, select the note heading then select More actions () | Delete.

To delete a note:

  1. Go to the Document Map then, select Notes to the Financial Statements.

  2. Select the note that you want to delete, then select More actions () | Delete Note at the top-right corner of the page.

  3. All headings and content within this note is also deleted.

Note: You can’t delete notes that are part of the default content that comes with your product. However, you can exclude them from the document.

Customize the title of the notes section

You can change the title of the notes section in the financial statements document.

Note: You can only change the title of the notes section in the firm template. To access the firm template, you must have the Settings Admin role or similar. See Manage the firm template for information on how to open and edit the firm template.

To change the title of the notes section:

  1. In the Document Map, select the title of the notes section.

  2. The title now displays in the note area.

  3. In the note area, select the title to change it.

  4. You can also include a data link or a special character in the title by selecting the formula icon () and the special character icon ().

Customize the title of the financial statements notes section

Edit table descriptions

You can customize the row and column descriptions in the financial statements tables.

To edit row descriptions:

  1. Select the table.

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

  3. The table opens in edit mode.

  4. Select the row that you want to edit.

  5. Edit the row description as desired.

  6. To include dynamic text, select the Data Link icon ().

    Note: If the row description is sourced from the trial balance data, the Revert icon () displays next to a modified description. Select Revert () to revert back to the trial balance description.

  7. Select DONE.

  8. Select SAVE or SAVE & CLOSE.

To edit column descriptions:

  1. Select the table.

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

  3. The table opens in edit mode.

  4. Select the column that you want to edit.

  5. Select the Heading field.

  6. The Data Link dialog displays.

  7. In the Output field, edit the name as desired.

  8. You can also select the Data Link () icon to have the table description include dynamic text.

  9. Select DONE.

  10. Select SAVE or SAVE & CLOSE.

Expand or collapse account group rows in a table

If a dynamic table has trial balance data, you can expand or collapse account group rows. When you expand an account group, you view the information and figures for each account in the group. When you collapse an account group, you view the total amount for the accounts in the 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.

You can also expand or collapse the groups while editing the table.

To change group settings:

  1. Select the table.

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

    The table opens in edit mode.

  1. Select More actions (), then choose Collapse to hide all accounts in a group.

    To show all accounts in the account group, select Expand ().

  2. Select More actions (), then choose Do not indent detail rows to display the accounts in the group without indentation.

Edit table columns

You can enrich the dynamic table data by adding columns. You can also view and modify the settings for the existing columns.

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.

Edit table rows

You can remove any existing rows in a dynamic table or rearrange them. You can also add rows to include more information or to add white space between rows to improve readability.

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.

To delete a row:

  1. Select the table.

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

    The table opens in edit mode.

  1. Select the check box at the right border of the row you want to delete.

  2. Select Delete () .

To hide a trial balance row:

Note: You can only hide rows whose data source are trial balance groups, not accounts. The Hide / Show icons (/) are only visible for trial balance group rows.

  1. Select the table.

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

    The table opens in edit mode.

  1. Select the check box at the right border of the trial balance row you want to delete.

  2. Select Hide () .

    To make the row visible again, select Show ().

Copy a table

You can copy an existing dynamic table in the financial statement and paste it anywhere in the financial statement. Once you copy a table, it stays in the clipboard and you can paste it as many times as you want until you copy a different table to clipboard.

To copy a dynamic table:

  1. Select the dynamic table that you want to copy.

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

  3. Select where you want to add the copied table, then select Add | Paste Copied Dynamic Table.

Delete content

You can only delete content that you've added in the document. Although you can't delete the default content that comes with your product, you can exclude it.

To delete 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 delete is located.

  2. Select the content you want to delete.

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

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

To delete a note:

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

  2. Select More actions (), then choose Delete Note from the list.

  3. The note is deleted from the financial statement and is no longer available on the Document Map.

To delete an area from the financial statement:

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

  2. Select More actions (), then choose Delete Area from the list.

  3. The area is removed from the financial statement and is no longer available on the Document Map.

View hidden rows and columns in a table

You can view the hidden rows or columns in a dynamic table.

To view hidden content in a table:

  1. Select the table.

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

    The table opens in edit mode.

  1. Select General Settings () at the top of the page, then select Show hidden items.

You can also set the table to autosave changes. To enable autosave, select General Settings () | Enable autosave.

Was this helpful?

Yes
No
This content is exclusively related to Rct,pcr,se 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.