Workiva Support Center

From Corporate Regulatory Reporting, you can prepare reports to submit to governmental regulatory agencies, such as:

• Federal Financial Report (FFR) SF-425 for United States federal agencies such as Small Business Administration (SBA), Department of Commerce (DOC), or Environmental Protection Agency (EPA)
• Bureau of Economic Analysis (BEA) surveys, such as Annual Survey of US Direct Investment Abroad
• Country-by-country reporting (CbCR) with the Australian Taxation Office (ATO) or European Commission (EC) 

To ensure accurate filings, a Workspace Owner can set up Corporate Regulatory Reporting to best meet your company's reporting needs.

To manage these details from Corporate Regulatory Reporting, click Settings.

Set up primary entity

To set up how agencies identify your company in its reports:

1. From Settings, select Primary entity.
   
2. In Primary entity info, enter your company's name and address.

3. To enter your company's identification (ID) number with a specific agency, click Add add in Agency identification number, then select the agency, and enter your ID number.

   Tip: To remove an unnecessary or inaccurate ID number, click Delete delete_outline

4. Click Save.

Tip: To provide details about subsidiaries or foreign affiliates included in reports, add them as entities.

Set up entities

For each subsidiary or foreign affiliate your company includes in reports, add it as an entity. You can add each entity separately, or import multiple entities in bulk.

After you set up an entity, you can manage it from Entities in Settings:

• To no longer include an entity in reports, turn off Active in Status.
• To edit an entity's details, such as its name or BEA ID number, select Edit from its menu.

Map source data for automated data collection

To help automate data collection, you can import source data, such as from your Enterprise Resource Planning (ERP) system. To enable this import, first set up the data imported from source systems and how it maps to your reports' forms.

1. From Settings, select Source data mappings.
   

   Tip: To update the details or columns of a file type, select Edit from its menu.

2. Click Add mapping.
   
3. In Info, enter a unique name to help identify the source data, such as based on its source system, data type, and file format.
4. In Source names, enter where the data will come from — such as ERP UAE entity trial balance extract for BE-11 — to help identify its applicable source data.
5. In Contact person, select the workspace member responsible for the source system or its data.
6. If the mapping applies to only a specific entity's reports, select it in Entity.

7. Click Next, then define the mapping's columns and their corresponding form fields. 
   
   To define columns, automatically extract them from a sample import file — a Workiva Spreadsheet, Wdata Query, or comma-separated values (CSV) file — or manually add them as necessary.

   Tip: To define a mapping's columns, you can both add and extract them, including from multiple import files.

   • Spreadsheet
   • Query
   • CSV
   • Add column

   To extract columns from a Spreadsheet in your workspace, such as one that collects source data from an integration through Chains or Automations:

   1. Select Workiva sheet.
   2. Click Browse, then search for or select the Spreadsheet, and click Select.
   3. Select which sheet of the Spreadsheet to extract columns from.
   4. In Master field, select the corresponding form field of the report for each column of the sheet.

   To extract columns from a Query in your workspace, such as one that collects source data from an integration through Chains or Automations:

   1. Select Workiva query.
   2. Search for or select the Query, then click Import.
   3. In Master field, select the corresponding form field of the report for each column of the sheet.

   To extract columns from a CSV file, such as one that exported from the source system:

   1. Select Upload CSV.
   2. Drag and drop the file from your desktop or network or click Browse files to browse to and select it, then click Confirm selection.
   3. In Master field, select the corresponding form field of the report for each column of the file.

   To manually add columns to the mapping:

   1. Click Add column.
   2. In Column, enter the column's header name from the source data.
   3. In Master field, select the form field of the report that the column maps to.

   Tip: If your workspace has Workiva AI enabled, click AI recommendations for AI-suggested mappings. You can view each suggested mapping's confidence level in Confidence %.

   Tip: To view only fields for a specific report, select its form — such as BE-11A — in Filter by form class. 

8. After you map all columns, click Save.

Assign source data mappings to form classes

To specify the source data required when creating each entity's reports, assign source data mappings to their respective form classes: 

1. From Settings, select Form class assignments.
   
2. For the form class, click Add add_to_photos.
   
3. Select the source data mappings to use with the form, and click Done.

Tip: You can assign a source data mapping to multiple form classes. To remove a mapping from a form class, click Delete delete.

Set up report types

For each report, set up its details, such as its frequency, agency, and form. When you add a report type, you also automatically create a Process to help automate its data collection.

Step 1. Add report type

1. From Settings, select Report types, then click Add report type.
2. Enter a unique name to identify the report type, such as based on its agency and form.
   

3. Select the report's agency and form class.

   Agency	Form class
   Australian Taxation Office (ATO)	ATO public Country-by-Country Reporting (CbCR)
   Bureau of Economic Analysis (BEA)	BE-11: Annual Survey of US Direct Investment Abroad BE-125: Quarterly Survey of Transactions in Selected Services and Intellectual Property with Foreign Persons BE-577: Quarterly Survey of US Direct Investment Abroad
   US General Services Administration (GSA) agency, such as: US Department of Agriculture (USDA) Department of Justice (DOJ) National Endowment of the Arts (NEA)	SF-425: Federal Finance Report (FFR)
   European Commission (EC)	European Union (EU) public CbCR

4. To help enable manual data collection, select the workspace member to own the Process created for the report.
5. To use the report type for current reports, turn on Active.
6. Click Save.

Step 2. Set up reports

After you add a report type, set up its reports based on the applicable reporting periods.

1. From Settings, select Report types, then expand the report type.
2. Click Create report.
   
3. In Instance name, enter a name to help identify the report, such as based on its reporting year and period.
4. In Year and Frequency, select the applicable reporting period. For example, for a quarterly report, select its year and respective quarter — Q1, Q2, Q3, or Q4. 
5. To assign a different Process owner than the report type, select the applicable workspace member.
6. Select the start and due dates for the reporting period.

7. In Data collection due date, select the final due date for manual data collection.

   Note: Select a Data collection due date between the Start date and Due date.

8. To use the period for current reports, turn on Active.
9. Click Save.

After you set up a report type or its report, you can manage it from Report types in Settings:

• To retain a report type but no longer create its reports, turn off Active.

• To edit the details of a report type or report, select Edit from its menu.

  Note: If you edit the Process Owner of a report type or report, also edit the Process file's permissions accordingly.

• To retain a report but no longer create it, select Archive from its menu. 
• If you no longer need a report type or report, select Delete from its menu.

Tip: To archive or delete multiple reports of the same type — but not the report type itself — select the reports within the type, then click Archive or Delete.

Set up groups and assignees for manual data collection

To help ease manual data collection, set up groups to assign a default workspace member to multiple fields of an entity's reports once.

Tip: To avoid gaps in data collection, use groups to assign default members to at least all required fields.

Note: Before you create a group, a Workspace Owner or Org Workspace Admin must first add its assignees to the workspace. To learn more, view Add users to a workspace.

1. From Settings, click Groups & assignees.
   
2. Click Create group and assignee, then enter a unique name and description to help identify the group.
   
3. In Entity, select which entity's reports the group's assignee supports.
4. In Assignee, select the member to prepare the fields' data by default.
5. To enable the entity to use the group for its reports, turn on Active.

6. Click Next, then select the fields to assign to the member.
   

   Tip: To view only fields for a specific report, select the applicable form — such as BE-11A — in Filter by form class.

7. Click Next, review the selected fields, then click Save.

   Note: When you include a field in a group, it no longer appears in any previously assigned group to ensure only one default assignee.

After you add a group, you can manage it from Groups & assignees in Settings:

• To no longer use a group with an entity's report, turn off Active.
• To edit a group's details, such as its assignee or fields, select Edit from its menu.