How to incorporate your custom financial ratios into TradeTapp (General contractors)

As a general contractor using TradeTapp, if you have a set of in-house financial ratios that are not captured in the default financial formulas available, we have a tool to incorporate your custom ratios so that they are also auto-calculated into the analysis performed in TradeTapp.

See How to view and adjust financial metrics and category weightings in TradeTapp to learn about the default financial ratios that can be calculated in the platform.

Important: To start, contact your Account Executive or Customer Success Manager. They will connect you with the appropriate resource to discuss your import needs and next steps.

After you speak with our team, if you need to assistance with the template, use the following article for instructions and tips.

• Fill out the Custom Calculations Worksheet
• What will occur with benchmarking calculations when custom financial ratios are added?
   

Fill out the Custom Calculations Worksheet

1. Download the "TradeTapp Custom Calculations Worksheet" XLSX file at the bottom of this article.
2. Follow the steps in the “Custom Financial Ratios” tab to complete it.
   
   Requirements to Note: 
   • Ratios must fall into one of the following categories: Liquidity, Turnover, Debt, Profitability
   • Equations can include inputs from the TradeTapp Financial Input (financial statements) and monetary questions from the TradeTapp default questionnaire (submitted by the vendor). Custom financial inputs are not supported at this time.
   • There’s no limit on the number of ratios that can be added.

What will occur with benchmarking calculations when custom financial ratios are added?

• Results will be displayed in the ‘Financial Metrics’ section of the vendor’s profile along with the default TradeTapp financial metrics. 
• On the 1st day a new custom ratio is created, the results for the new ratio will all appear green until the nightly benchmarking calculations are run.
• When the nightly benchmarking calculations are performed, the custom ratio results will be benchmarked against all vendors and the metrics will be updated to reflect their score (red/orange/yellow/green).