Python Developer Needed to Build Bank Statement Scraper (MCA Detection + Excel Output)
Description:
We’re Tribeca Funding, a business lending company, looking for a Python developer to build a custom tool that parses PDF bank statements and extracts key financial data into structured Excel sheets.
Our top priority is detecting daily and weekly MCA (merchant cash advance) payments from statements, but the tool must also pull full cash flow data for underwriting.
Project Scope:
✅ Input: PDF bank statements (some native, some scanned)
✅ Output: Clean Excel sheets with the following fields:
Bank Name
Account Number
Routing Number
Business Name & DBA
Total Revenue (excluding transfers)
Deposits (excluding internal transfers/Zelle)
Daily Balances
Average Daily Balance
MCA Payments Summary (see below)
NSF/Returned Payments
of Deposits
Large One-Time Deposits
Flagged Transfers
Critical Requirement: MCA Payment Detection
We need the script to:
Identify recurring ACH debits from known MCA companies (Kapitus, Bitty, Forward, OnDeck, etc.)
Group them by frequency (daily, weekly)
Flag stacking (multiple MCA pulls per day)
Identify and count returned or failed ACH payments
Summarize activity in a dedicated section:
Example:
bash
Copy
Edit
| Company | Frequency | Avg Daily Payment | Total Paid | # of Debits | Returned? |
|--------------|-----------|-------------------|------------|-------------|-----------|
| Kapitus | Daily | $237.44 | $4,511.36 | 19 | Yes (2) |
Tech Requirements:
Python (required)
PDF parsing: pdfplumber, PyMuPDF, or pdfminer.six
OCR: Tesseract (for scanned statements)
Excel generation: pandas, openpyxl
Regex / logic for identifying recurring payments and transfers
Familiarity with financial docs (bank statements, ACH, NSF, etc.)
Use Case:
This will be used by our internal underwriting team to evaluate business cash flow and funding activity.
To Apply:
Please include:
Samples of similar PDF-to-Excel data extraction work
Your approach to identifying recurring payments (especially MCA-related)
Your estimated timeline and proposed budget or hourly rate
We’re ready to hire immediately.
If you can build a clean, repeatable, scalable script — we want to work with you.
Apply Job!
Apply to this Job