### Client Overview
Our client is a leading fintech company from the Czech Republic, specializing in providing loans secured by real estate. The company has a growing portfolio and needed a more efficient way to handle its various processes, from risk assessment to contract management, to support its expansion.
### Challenges
1. **Complex Risk Assessment:** Manually assessing the risk of each loan based on real estate value was time-consuming and prone to errors.
2. **Integration Gaps:** The lack of integration with real estate appraisers, cadastres, and financial institutions led to fragmented data and inefficiencies.
3. **Contract Management:** Creating and managing contracts manually was labor-intensive and prone to errors.
4. **Transaction Control:** Tracking government payments and transactions manually was inefficient and risked compliance issues.
5. **Investor Integration:** Coordinating with investors without an automated system created delays and miscommunications.
6. **Document Tracking:** Monitoring post letters and other documentation required a streamlined tracking system.
7. **Task Management:** Ensuring efficient collaboration and task management among team members was challenging without a robust project management tool.
### Solution Provided by Value Added Tech
To address these challenges, we developed a comprehensive Airtable database with interfaces and automations tailored to the client’s needs. Key components of the solution included:
1. **Risk Assessment Interface:** A dedicated interface to streamline the risk assessment process by integrating data from various sources.
2. **Integration with Real Estate Services:** Seamless integration with real estate appraisers, real estate cadastres, and Google Photos to gather and validate property data.
3. **Contract Automation:** Automated creation of PDF contracts with all necessary details, including real estate photos, using make.com.
4. **Transaction Control and Accounting:** Automated tracking of transactions and government payments, ensuring accurate and timely accounting.
5. **Bank Account Integration:** Direct integration with the client’s bank account for seamless financial transactions.
6. **Post Letters Documentation Tracking:** A system to monitor and track all post letters and important documentation.
7. **Investor Integration:** Automated updates and communication with investors regarding loan statuses and financial transactions.
8. **Asana Integration:** Integration with Asana to enhance task management, enabling efficient collaboration and tracking of project progress.
## Results
The implementation of the Airtable solution yielded significant improvements in efficiency and accuracy:
- **Monthly Real Estate Processing:** Increased to **$7 million**, demonstrating a substantial capacity enhancement.
- **Automation Workflows:** 50 automation workflows were created to handle various processes seamlessly.
- **Database Tables:** 24 tables were designed to organize and manage the client’s data effectively.
- **Interfaces:** 33 interfaces were developed to provide intuitive and user-friendly access to data and processes.
- **Cost-Effectiveness:** The solution reduced operational costs by **40%**, primarily by minimizing manual labor and streamlining processes.
- **Return on Investment (ROI):** The client achieved an **ROI of 150%** within the first six months of implementation due to increased processing capacity and efficiency.
- **Manual Work Reduction:** Manual work was reduced by **70%**, freeing up valuable human resources for more strategic tasks.
- **Efficiency Improvement:** Overall operational efficiency improved **by 60%**, leading to faster loan processing times and improved customer satisfaction.
- **Task Management Enhancement:** Integration with Asana improved task tracking and collaboration, ensuring timely completion of projects and tasks.
### Conclusion
The integration of Airtable with various real estate and financial services, combined with advanced automation and Asana integration, transformed the client’s loan processing operations. The new system reduced manual efforts, minimized errors, and enhanced overall efficiency. By processing real estate loans worth **$7 million monthly and leveraging 50 automation workflows**, the fintech company is now well-positioned to scale its operations and meet growing demand. The comprehensive solution provided by Value Added Tech has not only met the client’s current needs but also established a robust foundation for future growth. The significant cost savings, impressive ROI, and substantial reduction in manual work underscore the value and effectiveness of the implemented solution, while Asana integration has ensured efficient task management and collaboration among team members.
#### Contact us to explore how we can tailor our solutions to streamline your operations and drive your business forward: sales@vatech.io
Inside the Airtable Architecture
The headline numbers — 24 tables, 33 interfaces, 50 automation workflows — don't convey what the system actually does. Here's the structure that made it work.
The Core Data Model
The database was organized around three primary record types: Loan Applications, Properties, and Investors. Every other table was either a junction table linking these three or a supporting reference table (vendor lists, document templates, government fee schedules).
The Loan Application table was the operational center. Each record tracked:
- Applicant identity and contact details
- Property being used as collateral (linked to the Properties table)
- Loan amount requested and approved
- Risk assessment score (calculated field pulling from the property valuation and LTV ratio)
- Current stage in the pipeline (12 stages from "Application Received" to "Loan Closed")
- Linked investor (from the Investors table) once funding was confirmed
- All associated documents (contracts, appraisal reports, cadastre extracts, bank statements)
The 12-stage pipeline was the backbone of the workflow automation. Every stage transition triggered a different set of actions.
The Risk Assessment Interface
Manual risk assessment was the biggest time sink before the implementation. An analyst would gather property data from the cadastre, request an appraisal, wait for the report, then manually calculate the loan-to-value ratio and cross-reference it against the company's risk thresholds.
The Airtable interface we built automated the data gathering:
- The analyst enters the property cadastre number into the interface
- A Make.com scenario calls the Czech cadastre API, retrieves the property record (ownership history, encumbrances, area, zoning), and writes the data to the Properties table
- The interface displays the retrieved data alongside the loan application details
- The analyst selects an approved appraiser from a dropdown (linked to the vendor table) and triggers an automated email requesting the appraisal
- When the appraisal PDF arrives by email, a Make.com scenario parses the appraised value from the document and writes it to the Properties table
- The LTV ratio calculates automatically:
Loan Amount / Appraised Value × 100 - A color-coded risk indicator (green/yellow/red) appears based on the company's LTV thresholds
What previously took 2–3 days of back-and-forth now completes in under 4 hours for standard properties.
Contract Automation with Make.com
Contract generation was the most technically complex piece. Czech real estate loan contracts require specific legal language, property descriptions pulled from the cadastre, appraised value figures, repayment schedules, and real estate photos — all assembled into a single PDF.
The Make.com scenario for contract generation:
- Triggered when a loan application moves to "Contract Ready" stage in Airtable
- Pulls all required data fields from the Loan Application, Properties, and Investors tables via Airtable API
- Retrieves property photos from Google Photos (linked to the property record) via Google Photos API
- Populates a contract template stored in Google Docs using the Docs API (find-and-replace for each variable field)
- Converts the populated Google Doc to PDF via the Drive API
- Attaches the PDF to the Airtable record and sends it to the applicant via email
- Creates a task for the legal reviewer with a link to the contract
The entire process runs in under 3 minutes. Previously, a paralegal spent 45–60 minutes assembling each contract manually.
Bank Account Integration and Transaction Tracking
The client's bank (a Czech commercial bank) provided an API for account transaction data. Make.com polled this API every 2 hours and matched incoming transactions against open loan records by reference number.
When a loan repayment was detected:
- The payment was recorded against the correct loan record in Airtable
- The outstanding balance field updated automatically
- If the payment was late (past the due date), a flag was set and a task was created for the collections team
- The investor linked to that loan received an automated email confirming the repayment
This replaced a daily manual reconciliation process that had been taking 2–3 hours per day.
Investor Communication Automation
The company had 40+ active investors, each with a portfolio of funded loans. Investors previously received monthly PDF reports compiled manually. The automated system replaced this with:
- Real-time loan status updates: When a loan moves to a new stage, the linked investor receives an automated email notification
- Monthly portfolio summary: A Make.com scenario runs on the 1st of each month, aggregates all loans linked to each investor, calculates total outstanding principal and interest earned, and sends a formatted summary email
- Repayment confirmations: Sent automatically when each repayment is processed (as described above)
Investor satisfaction improved measurably — the company reported fewer inbound inquiries asking for status updates, which had previously consumed significant staff time.
Why Airtable Over a Custom Database
The client considered a custom-built system but chose Airtable for two reasons: speed of implementation and internal maintainability. A custom system would have taken 4–6 months to build and required ongoing developer support for any changes. Airtable let us build the initial system in 6 weeks and gave the client's operations team the ability to modify interfaces, add fields, and adjust automations without developer involvement.
The tradeoff is performance at scale. At $7M monthly processing volume with 40+ investors and hundreds of active loans, Airtable handles the load comfortably. If the company scales to $50M+ monthly, they'll likely need to migrate the core data model to a more performant database — but that's a problem for a different stage of growth.
