Lending reports in Excel

Describes the process required to generate and download lending reports in Excel format

The Excel reports endpoints are used to produce and download Excel reports. For more information on available reports, see the report types section. These reports can be generated via the Portal or the APIAPI A set of rules and protocols that allows different software applications to communicate with each other. Codat provides APIs for accessing financial data from accounting, banking, and commerce platforms..

The process to download an Excel report via the APIAPI A set of rules and protocols that allows different software applications to communicate with each other. Codat provides APIs for accessing financial data from accounting, banking, and commerce platforms. is:

1. Request an Excel report for download.
2. Check the progress status of the latest report requested (optional).
3. Download the latest Excel report.

Only one request will be processed at a time per SMBSMB The primary customer segment that Codat helps businesses serve, typically companies with annual revenues under $500 million. companyCompany In Codat, a company represents your customer's business entity. Companies can have multiple connections to different data sources. and per report type. The generated report is kept in blob storage and gets replaced when a new one is generated. These reports will show you what data is available from our APIAPI A set of rules and protocols that allows different software applications to communicate with each other. Codat provides APIs for accessing financial data from accounting, banking, and commerce platforms. without writing any code upfront and how this data can be used to automatically generate your key financial metrics.

Available report types

• Audit report (reportType=audit) identifies indicators of inaccurate or out-of-date accounts, helping you to make decisions with confidence.
• Enhanced Cash Flow report (reportType=enhancedCashFlow) contains enhanced cash flow data.
• Enhanced Financials report (reportType=enhancedFinancials) contains enhanced profit and loss and balance sheet data, allowing you to calculate key metrics.
• Enhanced Invoices report (reportType=enhancedInvoices) contains enhanced invoices that are linked to payments.

Using the Enhanced Financials report?

Refer to the Metrics Template which demonstrates how we can use the data within the Enhanced Financials Report to calculate financial metrics.