Lendly

    NS File Daily Processing & Gross Calculation Automation – Lendly

    A fully automated daily financial tracking and invoice preparation system built on Airtable + n8n.

    Problem Statement

    Lendly relied heavily on manual workflows for their daily financial operations. Each NS file had to be handled by the team manually — downloading files, checking filenames, fixing formatting, calculating Gross values, updating Airtable, and linking files to invoice periods. Because everything depended on humans, files were misplaced, dates were mismatched, and month-end reconciliation took hours. Lendly needed a system that would eliminate manual work, prevent errors, and maintain 100% financial accuracy — daily.

    The Solution

    Automation Overview

    We built a complete automation system that processes every incoming NS file, validates dates, calculates Gross values, fills missing entries, detects gaps, and updates Airtable automatically. The workflow also handles monthly totals and links NS files to the correct Tax Invoice using date-range matching. Everything now runs without any manual work.

    Automated NS File Intake & Processing

    The workflow picks up incoming NS files the moment they arrive. It automatically reads CSV data, cleans fields, extracts numbers, calculates Gross values using business logic, reformats dates, and stores everything cleanly in Airtable.

    Smart Date Identification via Airtable

    Instead of relying on inconsistent filenames, the workflow uses the official Date field stored inside Airtable. This solves problems with duplicate uploads, wrong filenames, and manual placeholder entries.

    Intelligent Error-Proof Validation System

    To keep financial data clean, the system checks if entries already exist, if months have missing dates, if records are placeholders, and if Gross values need recalculation. It stops safely if anything looks incorrect.

    Seamless Daily Entry & Gross Filling

    Whenever a new NS file arrives, it assigns the correct date, fills the Gross value if missing (leaving it untouched if accurate), and updates only what needs updating.

    Monthly Gross Total Calculation

    The automation handles month-end logic: groups NS files by month, checks for incomplete days, calculates final monthly Gross, and updates the Tax Invoice table automatically.

    Clean, Actionable Error Messages

    If something is genuinely missing, the workflow sends a clear message about which dates are missing and what must be added. No noise, just actionable insight.

    NS File → Tax Invoice Auto-Linking

    A second automation layer intelligently links daily NS files to their respective Tax Invoices by comparing dates and matching them to invoice windows, allowing Airtable rollups to recalculate monthly totals automatically.

    Integrations & Connected Systems

    Airtable – Daily records, Tax Invoices, rollups; n8n – File processing, validation, calculation, logic; CSV processing tools; Internal date logic system.

    Smart Logic & Reliability

    • Duplicate protection
    • Missing-day detection
    • Placeholder handling
    • Safe exits for invalid files
    • Correct date resolution every single day
    • Rollup recalculation always accurate
    • End-to-end traceability

    Before

    Manual downloading, messy calculations, broken filenames, inconsistent entries, errors, and slow month-end reconciliation.

    After

    NS files are processed automatically every day. Gross values are calculated perfectly. Missing dates are detected instantly. Monthly totals are accurate by design.

    Tools Used

    n8n
    Airtable
    CSV Parsing
    Automated rollups
    Date-validation logic

    Our Process

    1

    Discover

    Analyzed Lendly’s entire financial workflow.

    2

    Design

    Architected a two-layer system for daily and monthly tasks.

    3

    Build

    Automated file reading, calculations, validations, and totals.

    4

    Integrate

    Connected Airtable with dynamic logic and rollups.

    5

    Deploy

    Ensured error-free processing and strong reliability.

    Business Impact

    Zero manual handling of NS files

    No date errors or misaligned records

    Automatic Gross calculations with perfect consistency

    Daily updates without opening Excel

    Monthly summaries generated automatically

    Clean linking between NS Files and Tax Invoices

    Clear notifications for missing days

    A reliable financial automation system running 24/7

    "This workflow turned Lendly’s financial tracking into a completely automated system. From daily NS file processing to monthly invoice summaries, the platform now operates with perfect accuracy, zero manual effort, and full clarity — giving Lendly a system they can trust every day."

    Want a system like this for your business?

    Let’s build it.