To create a unified cashflow base I needed to integrate several systems: two invoicing SaaS and parsing of specific XML bank exports.
- Invoices table unified data from mulitiple different invoicing services
- Transactions table had unified data from multiple different banks in different currencies
Transactions were matched to invoices, tracking payment status and information from all invoices were summarized in Airtable interfaces. This allowed custom automations based on invoice payment status as well as building custom dashboards via Airtable interfaces which showed up to date status of cashflow from multiple bank accounts at the same place.
Airtable formula was able to convert all values to EUR and so revenue was easy to track month to month.
Having financial data in Airtable might be useful if you need to set up automations on top of your financial data:
- Custom invoice workflows: payment reminders, notifications, issuing new invoices
- Connecting revenue to your existing data: see revenue of each product, company or user right in the Airtable base
- Custom alerts: identify drops or increases in revenue in specific areas
