From ContaAzul to Excel: managed, scheduled, no code.
Creating a pipeline that sends data from ContaAzul to Excel spreadsheets takes only a few minutes with Kondado. And the whole integration from ContaAzul to Excel is managed and executed by our platform. With Kondado, you can focus on extracting value from ContaAzul data and combining it with other data in your Excel spreadsheet
Connecting your ContaAzul account to Excel allows you to automate financial reporting and analysis workflows with consistent, up-to-date data. With Kondado, you select ContaAzul as your data source and Excel as your destination, then choose which data pipelines to replicate based on your specific reporting requirements and business intelligence needs. The platform handles all technical complexity behind the scenes, delivering your accounting data directly to spreadsheets on a schedule you configure, whether that means updates every 5 minutes, hourly, or daily, ensuring your financial models always reflect current business conditions.
Kondado provides automated replication of ContaAzul financial data to Excel, including accounts payable, accounts receivable, sales transactions, and customer records drawn from thirteen available pipelines, updated on a configurable schedule to keep your workbooks current without manual intervention.
Once your data flows into Excel, you can combine Accounts Payable and Accounts Receivable pipelines to build dynamic cash flow forecasts and aging analysis reports using familiar formulas and pivot tables. The Sales and Sales Details pipelines enable deep dive analysis into transaction patterns, product performance, and revenue trends, allowing you to create sophisticated financial models that update automatically as new data arrives from your ContaAzul account. With People Registration data, you can segment customers by location or business type to identify your most valuable accounts and optimize collection strategies directly within your spreadsheets.
Try out all the features for free for 14 days
Replicated to Excel
ContaAzul data available for Excel
Tables Kondado writes into your Excel, on a schedule you control.
13
available pipelines
571
extractable fields
Excel
Destination
Available integrations
People Registration: Details
Includes fields such as uuid, name, and email, along with information on active status and person type, either INDIVIDUAL or LEGAL.
People Registration
Contains data such as document, phone, and address, including details like neighborhood, city, and state, along with active status.
Accounts Payable
Presents information on financial obligations, including id, expected payment date, and reconciliation status.
Accounts Payable: Categories
Includes financial categories with fields such as id, name, and type, along with information on whether they should be considered as cost in the DRE.
Accounts Payable: Cost Centers
Provides data on cost centers, including id, name, and active status, along with a custom code for internal organization.
Accounts Receivable
Contains information on amounts receivable, including id, due date, and collection status, along with financial details.
Accounts Receivable: Categories
Includes accounts receivable categories with fields such as id, name, and type, along with information on whether they are considered revenue.
Accounts Receivable: Cost Centers
Provides data on cost centers related to accounts receivable, including id and name, along with active status.
Accounts Receivable: Collections
Includes information on collections, with fields such as id, status, and due date, along with relevant financial details.
Contracts
Contains data on contracts, including id, contracting party name, and status, along with associated financial information.
Sales
Data on sales transactions, including fields such as id, sale date, and total amount.
Sales Details
Detailed information on each sale, such as sale id, product, quantity, and unit price.
Sales Items
List of sold items, including fields such as item id, description, quantity, and value.
Sync data automatically — no code, no manual exports.
1
Connect Your ContaAzul Account
Log into Kondado and add ContaAzul as a new data source by entering your API credentials to establish the initial connection.
2
Set Up Excel Destination
Choose Excel as your destination and specify the workbook location where you want your financial data to be delivered automatically.
3
Select Pipelines and Schedule
Choose which data pipelines to replicate from the thirteen available options, then configure your update frequency from 5-minute intervals to daily updates.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending ContaAzul data to Excel automatically
How do I automatically export ContaAzul data to Excel without manual CSV downloads?▼
Kondado creates a direct connection between your ContaAzul account and Excel, eliminating the need for manual exports. You select which data pipelines to replicate, configure your update schedule, and the platform delivers fresh data directly to your workbooks automatically.
What ContaAzul financial data can I replicate to Excel using Kondado?▼
You can access thirteen distinct pipelines including Accounts Payable, Accounts Receivable, Sales transactions, Sales Details, Contracts, and People Registration. Each pipeline contains specific financial fields such as payment dates, reconciliation status, customer details, and transaction amounts that arrive in structured Excel format.
How often does ContaAzul data update in my Excel spreadsheets?▼
Kondado updates your Excel workbooks on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This ensures your financial reports reflect recent business activity without requiring manual refresh or data entry.
Can I combine ContaAzul data with information from other platforms in the same Excel file?▼
Yes, Kondado allows you to replicate data from multiple sources into the same Excel destination alongside your ContaAzul information. You can blend accounting data with metrics from BigQuery, PostgreSQL, or other business tools to create unified financial dashboards.
Does Kondado offer ready-made dashboards for ContaAzul data?▼
Yes, Kondado provides pre-built report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report. While these templates work with Looker Studio and Power BI, you can also export the underlying data structure to Excel for custom spreadsheet analysis.
What format does ContaAzul data take when it arrives in Excel?▼
Data arrives in structured spreadsheet format with preserved field relationships, making it immediately usable for pivot tables and formula calculations. Each pipeline populates distinct sheets within your workbook, maintaining data integrity for complex financial modeling.
Can I replicate data from multiple ContaAzul companies to separate Excel workbooks?▼
Yes, you can configure separate pipelines for each ContaAzul company or account, directing them to different Excel destinations or separate sheets within the same workbook. This setup works well for agencies managing multiple client accounts or businesses with several legal entities.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
