Assess in the Portal

🚧

Assess - Beta testing

Please note, this feature is in beta testing. We encourage you to provide any feedback you have on the product by selecting Submit idea here on our roadmap.

Assess in the Portal leverages Codat APIs to produce features that serve data on the health of a business and provide insights required for making informed lending decisions.

To benefit from all of the features of Assess, a company should be linked to accounting, banking and commerce data sources. Explore our How to get started guide.

The categorized Profit and Loss, and Balance Sheet showcase the power of the Categories feature which standardizes bespoke data across SMEs. After the data is standardized, meaningful insights and measurements are produced for financial performance.

Assess consists of three sections: Profit and Loss, Balance Sheet and Commerce. Profit and Loss, and Balance Sheet sections allow you to select a start date, period length and periods to compare (see image below). The Commerce section allows you to select a date range which represents one period.

The system will prefill the Period start date with the latest available dates. If you select a date that’s out of range, the system will notify you of the latest available date for that company.

Data match

The Data match percentage is located in the top right corner of every Assess page (see image above) which leverages the Data Integrity feature. The match percentage is pre-calculated using the Data Integrity summaries endpoint.

It takes the match percentage from the summaries endpoint for both banking-transactions and accountTransactions to calculate an overall match percentage, and it accounts for all dates, not just the optimal date range.

The information icon reveals further detail about the data match. The right arrow takes you to the Data Integrity page which provides detailed information about matches. Explore Data Integrity.

Profit and Loss

The Profit and Loss page is the landing page when accessing Assess. The page consists of the graph displaying selections for the categorized financial statement, and ratios.

Mapping to a common statement outline

On load, we will automatically categorise the lines on the business's profit and loss statement. The results will be presented in a modal for you to review. When you are finished reviewing each group, press Next. In some cases, we may not be able to automatically map every statement line - these will highlight in red and you will be required to select the relevant category from the list. Once complete, press Save to view the final statement.

Statement

The categorized profit and loss statement is obtained from the Enhanced Profit and Loss endpoint. It provides the fully categorized statement over a specified period(s) of time, for a specific company’s accounting connection.

The following information is displayed:

  • Income
  • Expense
  • Gross profit
  • Net operating profit
  • Net profit

The Statement table renders the Enhanced Profit and Loss endpoint response data to give a clear visual of the company’s performance over the specified periods. The green and red arrowheads alongside the numbers indicate an increase or decrease respectively compared to the previous period.

Rows can be expanded or collapsed to show more or less information. A maximum of 5 checkboxes can be checked, like Income above, to display the selection on the graph. Hovering over the graph displays a tooltip which contains information about all of the points plotted for that date.

Ratios

Ratios are produced from the Financial Metrics endpoint. It provides a set of pre-calculated ratios and metrics used to assess a company’s financial performance. The Financial Metrics feature performs complex calculations on fully standardized financial statements to produce the following financial metrics and ratios (see formulas):

Gross Profit Margin

  • EBITDA
  • Debt Service Coverage Ratio
  • Current Ratio
  • Quick Ratio
  • Free Cash Flow
  • Working Capital
  • Fixed-charge Coverage Ratio

The Ratios table is displayed below the Statement table. Each metric/ratio can be expanded to show the inputs and values used to calculate the metric (see extract of the Ratios table below).

Balance Sheet

The Balance Sheet page consists of a graph displaying selections for the categorized balance sheet, and ratios.

Statement

The balance sheet statement is produced from the Enhanced Balance Sheet endpoint. It provides the fully categorized statement over a specified period(s) of time, for a specific company’s accounting connection. The following information is displayed:

  • Asset
  • Liability
  • Equity
  • Net Assets

The Statement table renders the Enhanced Balance Sheet endpoint response data to give a clear visual of the company’s performance over the specified periods. The green and red arrowheads alongside the numbers indicate an increase or decrease respectively compared to the previous period.

Rows can be expanded or collapsed to show more or less information. A maximum of 5 checkboxes can be checked, like non-current assets above, to display the selection on the graph. Hovering over the graph displays a tooltip which contains information about all of the points plotted for that date.

Ratios

Ratios are produced from the Financial Metrics endpoint. It provides a set of pre-calculated ratios and metrics used to assess a company's financial performance. The Financial Metrics feature performs complex calculations on fully standardized financial statements to produce the following financial metrics and ratios (see formulas):

  • Current Ratio
  • Debt Service Coverage Ratio
  • Free Cash Flow
  • Quick Ratio
  • Working Capital

The Ratios table is displayed below the Statement table. Each metric/ratio can be expanded to show the inputs and values used to calculate the metric (see extract of the Ratios table below).

Commerce

The Commerce page consists of the sales analysis and key indicators of merchant health. The Commerce Metrics endpoints are used to generate the graphs and metrics displayed on this page.

Sales

The Sales section provides a revenue graph generated from the Revenue endpoint, and displays the average order value for the date range selected. The dropdown to the right of the graph gives you the option to map Revenue (represented as a currency) or Revenue growth (represented as a percent). Hovering over the graph displays a tooltip that contains information about the point plotted for that date.

Merchant Health

The Merchant Health section displays customer information. You can select graphs for New vs. existing customers or Orders vs. refunds. Hovering over the graph displays the value for each of these at that point in time.

The following metrics are displayed as follows:

Marketing Metrics

The Marketing page displays graphs for the Marketing to revenue and Marketing to expense metrics, and a table of the percentages and metric inputs. These marketing metrics are calculated from accounting data. It is generated from data available on the customer's profit and loss statement (see formulas).

The dismissible banner displayed at the top of the Marketing page invites you to our product roadmap to let us know which platforms and insights you would be interested in.

The Marketing Metrics endpoint is used to generate the graphs and metrics displayed on this page. The green and red arrowheads alongside the numbers indicate an increase or decrease respectively compared to the previous period.

Rows can be expanded or collapsed to show more or less information. Hovering over the graph displays a tooltip which contains information about the points plotted for that date.


Did this page help you?