Taulia experience center

Article Number: 000010684

Taulia Analytics dashboards aggregate and analyze millions of supplier transactions, from more than 600,000 suppliers, conducted on the Taulia portal since 2009. The dashboards provide immediate usable data to customers, without having to go through data mapping and cleansing. Taulia Analytics dashboards leverage buyer-provided network data and combine it with third-party data providing firmographics and other information. The dashboards leverage AI-powered prediction models which can accurately predict supplier behavior. 

The analytics dashboards provide customers with business trends while helping companies set goals, compare themselves to industry averages, and streamline their supply chains. The dashboards enable businesses to monitor performance and explore the implications of strategic working capital decisions by leveraging historical, industry, and real-time data. Artificial Intelligence (AI) gives buyers a far more detailed understanding of the potential benefits of working capital strategies, and of how different techniques can be deployed to achieve the company’s goals. 

The flexible Taulia Analytics dashboards let customers examine their entire supply chains, groups of suppliers, or a single supplier, and help customers:

• Make data-driven decisions with predictive insights - Optimize your working capital and play out different scenarios without the risks involved with actually performing the changes. Predict which invoices suppliers will choose to accelerate under a range of different conditions or extend the cash forecasting process all the way down to the purchase order level, providing a clearer view of supplier health and the impact that different actions could have on the company’s supply chain.
• Evolve your working capital program and meet objectives with clear next steps - Gain a holistic view of your working capital program to be proactive in improvement with actionable insights.
• Benchmark against peers in order to be a business supplier wants to sell to - Become more profitable by better understanding suppliers and larger industry trends with the most comprehensive look available at payment trends across numerous industries. Make actionable decisions on how to strengthen supply chains and increase efficiency.
• Meet company cash-related objectives, goals, and targets - Realize cash opportunities to optimize working capital, generate yields and ensure supply chain strength.
• Track and monitor program performance - Track statistics on supplier data and transactions and understand dynamics in real-time. 
• Filter across business units and drill down to specifics - Monitor payables across business units to optimize cash outflows and discount yield.

Taulia Analytics Process



Contents
Buyer Landing Page: Financial
Payables Measure

Buyer Landing Page: Financial
High-level program insights for buyers focused on supplier onboarding.
To access the page log into the Taulia Network UI and navigate to Home. On this page, you will find high-level program insights for buyers focused on supplier onboarding.
 
- Total spend - Display the sum of paid invoices for all suppliers (including suppliers not yet invited) where the invoice was paid for the period selected
- Supply Chain benefit - Collective working capital improvement forecast based on the period selected for suppliers participating in the Early Payment program. Illustrates the benefit realized by suppliers
- Discounts Earned - Sum of discount amounts deducted from paid invoices where the invoice was paid for the period selected. The gross amount does not include discounts on 3rd party funded early payments (SCF)
- Supplier Count - Count of supplier connections
- Spend Funnel - Total spend (sum of paid invoices) for the period selected by the following key stages. Percentages shown in the labels are based on the prior stage. 

• Total: Spend for which supplier master data has been transferred to Taulia
• Currently Invited: Spend of all invited suppliers (invited as of today)
• Currently Enrolled: Spend of all enrolled suppliers (enrolled as of today)
• Offered for Early Payment: Spend offered for early payment (to suppliers who were enrolled before or on the day of payment)
• Paid Early: Spend accelerated (by suppliers enrolled and offered for early payment)
• Paid via Cashflow: Spend accelerated automatically via Taulia’s Cashflow functionality

- Monthly Spend Breakdown - Paid invoices for suppliers grouped by the date the invoice was paid. Each group is mutually exclusive

• Initialized: Monthly spend of suppliers for which supplier master data has been transferred to Taulia, but haven’t been invited as of the payment d
• Invited: Monthly spend of suppliers who were invited before or on the day of payment, but haven’t been enrolled as of the payment date
• Enrolled: Monthly spend of suppliers who were enrolled before or on the day of payment, where the invoice was not offered for early payment
• Offered: Monthly spend of suppliers who were enrolled before or on the day of payment, where the invoice was offered for early payment but was not accelerated
• Accelerated: Monthly spend of suppliers who were enrolled before or on the day of payment, where the invoice was offered for early payment and accelerated

If you click on Filters you will have more options to adjust your report request.  



Below you will find a list with a description of all filters:

• Reporting Currency: Invoice currency Default value: “USD”. Used in adjusting the aggregate and document-level currency reporting amounts (with the exception of columns specifically denoting "local currency amount")
• Other Currencies: Invoice currency (additional options) Default value: “AED”. Applied if “Other” is selected in Reporting Currency filter
• Payment Currency: Supplier payment currency
• Buyer Company Name: Buyer company name
• Buyer Business Unit: Buyer business unit name (and number)
• Supplier Segment Name: Supplier segment name
• Current Supplier Status: Supplier engagement state as of today
• Supplier Industry: Supplier Industry
• Supplier Payment Date: Supplier Payment Date Default value: “Is in the last 12 complete months”.

Note: Data includes paid invoices from the last 3 years based on a supplier payment date.

Key Definitions and Calculations
- Total Spend, Total in Spend Funnel, and the sum of all elements in the Monthly Spend Breakdown are all aligned for the same selected period.
- Offered for Early Payment in Spend Funnel and the sum of Offered and Accelerated in Monthly Spend Breakdown are aligned for the same selected period.
- Paid Early in Spend Funnel and the sum of Accelerated in Monthly Spend Breakdown are aligned for the same selected period.
- Supply Chain Benefit: Sum product of invoice amount and Early Payment Tenor divided by selected period length.

Payables Measure
A provocative dashboard that gives users a unique view of payables working capital impacts from changes in payment terms and spending volume.
To access the page log into the Taulia Network UI and click on Cash > Measure.



Quantify the impact changes in spend, supplier payment terms, and payment issuance are having on your working capital.

On this page, you will find the below information boxes: 

• Beginning payable - Total Payable on the first day of the filtered range. Includes invoices that were approved before the first day of the filtered range but haven’t yet been paid as of the first day of the filtered range (based on buyer payment date)
• Invoices Confirmed - Invoice total for all approved invoices (whether open or paid). Includes all invoices that were approved within the filtered range
• Invoices Paid - Sum of paid invoices where due. Includes invoices that were approved before or on the last day of the filtered range and were paid within the filtered range (based on buyer payment date)
• Ending Payable - Total Payable on the final day of the filtered range. Includes invoices that were approved before or on the last day of the filtered range but haven’t yet been paid as of the last day of the filtered range (based on buyer payment date)
• Payables Trend - Accumulative change to working capital in the filtered range. Contributions grouped by changes in invoice terms and spend
• Indicative Monthly DPO - Calculated by averaging the open payables at the beginning of the month and the open payables at the end of the month, multiplied by 30 days, divided by monthly spending. COGS is estimated as the spend invoiced during the period (assuming the beginning and ending inventory remains unchanged).
• Payables Impact by Supplier - A list of all suppliers with spend within the filtered range. Provides beginning and ending spend, terms, outstanding payables, and the change in payables over the filtered range for each supplier, calculated based on the invoice date and due date. Can be used to understand the suppliers with the largest impact on working capital over a period of time.
• Payables Impact by Document - List of invoices paid before or after the invoice due date by the buyer. This report can be used to understand the impact on working capital resulting from actual payment behavior. Invoices paid early as a result of traditional discount terms or dynamic discounting are included.

Note: Accelerated SCF invoices are not included because third-party funding has no impact on the buyer’s working capital. Report includes details at the invoice level, for invoices paid (based on buyer payment date) within the filtered range. Excludes documents paid on the due date because they have no impact on the balance sheet.

If you click on Filters you will have more options to adjust your report request. 



Below you will find a list with a description of all filters:

• Reporting Currency: Invoice currency Default value: “USD”
• Other Currencies: Invoice currency (additional options) Default value: “AED”. Applied if “Other” is selected in Reporting Currency filter
• Payment Currency: Supplier payment currency
• Buyer Company Name: Buyer company name
• Buyer Business Unit: Buyer business unit
• Supplier Name: Supplier name
• Supplier Segment Name: Supplier segment name
• Supplier Industry: Supplier Industry
• Supplier Country: Supplier Country
• Supplier Vendor Number: Supplier Vendor Number
• Filter Date: Period selection Default value: “Is in the last 12 complete months”
• SCF Program Participants: Limits results to invoices for suppliers after they have enrolled and had at least one invoice eligible for SCF. This only applies to the following charts: Beginning Payable, Invoices Confirmed, Invoices Paid, Ending Payable

Note: Data includes approved invoices after the year 2011 (based on invoice date) for which the due date is not missing

Key Definitions and Calculations
- Beginning Open Payables: For a selected period (month), the sum of invoices of which invoice date is before the beginning of the selected period and the due date is on or after the beginning of the selected period
- Ending Open Payables: For a selected period (month), the sum of invoices of which invoice date is on or before the end of the selected period and the due date is after the end of the selected period
- DPO:

- COGS: Beginning Inventory + Purchases - Ending Inventory (in this analysis, it is assumed that beginning and ending inventory remains unchanged and COGS is estimated as the spend invoiced during the period)
- Change in Payables from Spend
- Change in Payables from Terms
- Beginning Spend: Sum of invoices in the first month of the filtered range (based on invoice date)
- Ending Spend: Sum of invoices in the last month of the filtered range (based on invoice date)
- Beginning Average Term: For the first month of the filtered range

- Ending Average Term: For the last month of the filtered range

- Delta Payable: Difference between the Ending Open Payables of the last month of the filtered range and the Beginning Open Payables of the first month of the filtered range.
- Payables Impact: Equals invoice amount for the “Late Payment” payment category and (-1 Invoice Amount) for all other payment categories.

Related Articles:
The Accounts Payables Turnover Ratio
Accounts Payable Metrics and KPIs Worth Tracking
Guide to Accounts Payable Outstanding