Excel download overview
Download the Lending API reports to Excel
Our Excel download reports will show you what data is available from our API without you writing any code upfront. You can use this to inform testing within your credit models.
Our Excel download feature consists of the following component reports:
Data export provides an output of data from our accounting data sources.
Enhanced financial statements provide an output of the categorized profit and loss and balance sheet statements.
Enhanced cash flows provides an output of the categorized bank transactions.
Enhanced invoices provides an output of reconciled invoices.
We've also created a metrics template Excel file. You can paste data into this file from the Enhanced financial statements Excel report to calculate key financial metrics and ratios.
Excel download via API
The process to download an Excel report via the API is as follows:
- Request an Excel report for download.
- Check the progress status of the latest report requested (optional).
- Download the latest Excel report.
Only one request will be processed at a time per SMB company and per report type. The generated report is kept in blob storage and gets replaced when a new one is generated.
Excel download via Portal
You can also generate and download a report in an Excel format via the Portal:
Navigate to Companies and select a company you wish to download a report for.
In the side navigation, choose Lending > Reports. This page lists the names of reports available for generation and their descriptions.
Click the Generate report button next to the desired report to produce a new report. The Last generated field will be updated to the date and time you initiated the generation. It will keep this timestamp until the next time you generate the report.
When the report successfully generates, the report name (which is also the file name) with the file size and latest timestamp will be available for download. Click the Download button to save the Excel report to your local machine.
You can also generate and download the data export report by clicking the Export data button on any of the Lending screens of the Portal.