Reporting

Gain financial clarity with automated insights and real-time data tracking.

Please note that this article uses sample data from the company International Business Machines (IBM) as an example to display company profile information, as well as financial statement information.


a. Viewing a Company.

1

Opening a Company record:

Open the Scopacasa application, then travel to the Home page. In the top section of the page is a tabs bar that has Managed Packages selected by default. Click on the Custom Objects tab (identified in red). Once the Custom Objects tab has opened, click on the Companies icon (identified in green).

Once you are viewing a list view of Company records, identify and click on the record you would like to view. In the example below, we are travelling to the International Business Machines record (identified in red).

2

Viewing the Record Details:

Once you have arrived in a Company record, you will find the record’s fields on the left side of the page. Below is a screenshot of the Details section, containing the core data of the company itself. In the example below, we are viewing the record for IBM.

Just below, is the Reporting section. This displays some details specific to the reporting requirements of the company.

b. Viewing a Financial Statement.

1

Opening a Financial Statement:

Just right of the details specific to the Company, there is a section with related records to the Company. In the screenshot below, we can see the Financial Reports have a separate related list for Annual and Quarterly. The Name field of a Financial Statements record is structured by the following code block if the Reporting Period field is assigned Annual. The code block is structured as if the Company and Financial Statement records are dictionaries in Python:

company[“ticker_symbol”] + “: ” + financial_statement[“year”] + “ (Annual)”

So if we were viewing the 2023 annual report for IBM, it would be named:

IBM: 2023 (Annual)

If the Reporting Period is assigned as Quarterly, the following format is used:

company[“ticker_symbol”] + “: ” + financial_statement[“year”] + (financial_statement["quarter"])

So if we were opening a 2021 quarter 2 report for IBM, it would be called:

IBM: 2021 (Q2)

In the screenshot below, we are clicking on the annual report for 2023.

2

Viewing the Record details:

We are first going to look at the left side of the record page, containing the core details of the Financial Statement record. The Statement Details section contains a lookup field to the Company record that it belongs to, as well as information about the reporting period.

Just below in the Report Management section, we are able to view information about internal management of the Financial Statement record within the company. This allows staff to track the type of statement, whether or not the report is approved, audited and the version of the document.

On the right, is a section with four tabs. There is the Income Statement, Balance Sheet and Cash Flow Statement, containing fields and their values specific to that report type. There is also the Fundamental Analysis tab, with formula fields containing fields from the three report types mentioned earlier.

Below is a screenshot of when the Fundamental Analysis tab is selected, although not completely showing its section. The other three report types have displays that are the same in structure.

Fields within the three report types are able to have their values added, edited and removed. The formula fields in the Fundamental Analysis section are unable to have a value manually assigned to them, as they are calculated depending on the other fields in their formulas.

c. Express Printing a Report.

1

Opening the Printable View:

When a Financial Statement record is open, travel to the top right of the page and select the Printable View button.

2

Viewing the Report:

If your browser settings allow, Salesforce should open the printable view of the record in a new tab.

Please note that this is an express solution to printing the Financial Statement report, as it will not be in a traditional and most suitable form for use with shareholders + stakeholders.

The development team is currently constructing a solution to merge specific record values with a custom designed Financial Statement report template. This will enable users to simply click a button and have a suitable report emailed or downloaded to select recipients.

The screenshot above contains the top of the report, where the Statement Details, Report Management and part of the Balance Sheet sections are present. Each sub-section of the report types in the page layout of the record are grouped the same in this printable version, although only the report type names (not the sub-section headers) are included.

Further down the page, the rest of the Balance Sheet section is included, along with the Income Statement, Cash Flow Statement and Fundamental Analysis sections.

d. Using the Analytics Tools.

1

Travelling to the Analytics Tools:

Once on the Home page of the Scopacasa application, click on the Reporting icon under the Managed Packages tab in the top section of the page.

2

Fundamental Analysis:

Once arriving in the Reporting page, the main section should have the Fundamental Analysis tab open by default. The page contains each of the sub-sections from the page layout of the Financial Statement record, but will instead show them as multiple records in graph and table form.

You are able to select whether you would like to view records where the value of Reporting Period is either Annual or Quarterly. The select-box to change this is identified in the screenshot below.

Each of the Fundamental Analysis sub-sections have their own area of an accordion component. Clicking on one of the components will open its section, where each Fundamental Analysis item will have its own horizontal bar chart.

Once all of the Fundamental Analysis items within the section have been displayed through their respective bar charts, a table will appear at the bottom of the dashboard.

This table displays each Financial Statement record as a row, where each column is a Fundamental Analysis item of the section you are currently in.

The above two screenshots are viewing the Fundamental Analysis items within the Cash Flow Metrics section.

3

Report Management:

Coming soon…

Updated on