Skip to main content

Review spend analysis and insights

Learn how to review the spend and supplier information from your customer and associated insights

Prerequisites

Before you can review spend data and associated insights, you need to request access to it. We cover this in detail in our Onboard customer guide.

In this guide, we will cover how you can view the insights generated from your customer's business data using the Codat Portal.

Check data status

Once you onboard the customer, check that their insights reports are ready. In the Codat Portal, navigate to the Spend Insights tab and locate the customer's company.

You may see one of the following statuses next to the company name:

StatusAction
AvailableCodat successfully generated the spend report for this customer, and it's ready to download.
GeneratingCodat is currently generating the spend report for this customer. Check back later.
UnavailableReport wasn't generated due to an error. Contact support to resolve the issue.
Request informationCodat hasn't yet received data from this customer. Onboard the customer first.

An image of the Portal user interface on the Spend Insights tab with four companies listed and their statuses highlighted.

Download reports

To download the available reports, click the Download button next to the company name. In the dropdown, choose the type of report you wish to download and click the corresponding line. This downloads of the Excel reports to your default download folder.

Codat offers the following report options:

  • Spend summary provides a one-page summary view of top supplier opportunities for the customer.
  • Spend analysis covers the summary and detaileds of the customer's spend and suppliers in an Excel format.

An image of the Portal user interface with the download dropdown displayed and download button highlighted for an example company

Spend analysis report

This Excel report offers a detailed look into your customer's spend data, providing an overview of their spending and suppliers by payment method and detailed supplier analysis. It also contains the source bills, bill payments, and direct costs that inform the report.

Customer tab

The Customer tab provides an at-a-glance view of the company you're reviewing, including their administrative details, and the parameters of the generated report.

Spend Analysis tab

The Spend Analysis tab analyses the performance of various payment methods utilized by your customer and looks at the quantities and amounts of suppliers, bills, payments, and direct costs associated with these payment methods.

This tab uses the same parameters as the Supplier Analysis tab, but breaks the data down by payment method instead of supplier. We will review each parameter in detail when covering the Supplier Analysis tab.

A section of the Spend Analysis tab from the Excel report that displays the payment method breakdown of the data.

Supplier Analysis tab

Let's now focus on the Supplier Analysis tab, where you will find sections covering supplier details, payment methods, amounts, and terms. You can distinguish between the sections by using their colors. We will go through the columns of this tab and explain how to read their details and data.

Suppliers

This section covers the supplier's name, the most common method used to pay them, and their imported date.

  • Supplier Name - supplier's name as recorded in your customer's accounting system.
  • Most Common Payment Method - an aggregate value reflecting the most common method your customer used to pay the supplier.
  • Imported Date - the date this supplier first appeared in the Spend Analysis file. This becomes significant when reviewing files on an ongoing basis.

Bills

This section goes into the details of bills incurred by your customer, highlighting the amounts and quantities the supplier has raised with the business.

  • # of Bills - the total number of bills raised by the supplier.
  • # of Bills Outstanding - the total number of bills that haven't been paid yet.
  • Bills Amount - the total amount the supplier raised bills for.
  • Bills Outstanding Amount - the total raised amount of bills that haven't been paid yet.
  • % of Bills Outstanding (by amount) - the outstanding bills amount expressed as a percentage of the total billed amount.
  • Most Recent Bill - the date when the supplier's most recent bill was raised.

Payments

This section goes into the details of payments your customer has made to their suppliers.

  • # of Payments - the total number of payments the business made to the supplier.
  • # of Late Payments - the total number of payments made to the supplier that were past their due date.
  • Payments Amount - the total amount of payments the business made to the supplier.
  • Late Payments Amount - the total amount of payments that were past their due date.
  • % Late Payments (by amount) - the amount of payments past due date expressed as a percentage of the total payments amount.
  • Average Payment Amount - the average payment size for this supplier based on the number of payments made to them.

Payment terms and settlements

This section covers the customer's average payment terms and settlements.

  • Average Payment Terms shows how many days on average it takes for the customer business to pay this supplier. This is weighted by payment amount.
  • Common Payment Terms Days represents the number of days that you are likely to see from this supplier as the payment terms.
  • Average Settlement Period shows how many days the payment actually takes to settle and process on the supplier's side.

Direct costs

This section covers the customer's direct costs associated with the suppliers. Direct costs are money that leave the business without impacting Accounts Payable, and refunds associated with such transactions.

  • # Of Direct Costs - the total number of direct costs associated with this supplier.
  • Direct Costs Amt - the total amount of direct costs associated with this supplier.
  • Most Recent Direct Cost - the date when the supplier's most recent direct cost was incurred.

Supplier details

The final section of this tab provides administrative details of each supplier, such as their ID in the customer's software, their contact details, and tax information.

Other tabs

The Bills, Bill Payments, and Direct Costs tabs contain the source spend data that Codat used to generate the report.

Spend Insights Chat

Codat has enhanced the Spend Insights solution capability with an AI agent that will use the spend data provided by your customer to respond to the queries asked in natural language. It can help you create spend summaries, prepare collateral, and draft communication materials for your customers.

If your organization has opted to use this feature, you will see a Lightbulb icon next to your customer's name on the Spend Insights tab of the Codat Portal. Simply click on the button to be directed to Codat's Spend Insights Chat.

An image of three companies on the Spend Insights tab. A lightbulb icon is visible and highlighted next to aevery company entry.

The Spend Insights Chat provides three key interaction areas:

  • Use the Spend Analysis report section to download the Excel file generated by Spend Insights or access the overview of the company's data.
  • Navigate previous conversations with the Spend Insights agent or start new ones via the Conversations section.
  • Carry the current conversation with the agent in the Main section of the screen, using prompts or writing out the questions.

An image of three companies on the Spend Insights tab. A lightbulb icon is visible and highlighted next to aevery company entry.


Was this page useful?
👏
👍
🤔
👎
😭