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 Now

Apply Now