Full-Stack Developer for Accounts Payable "Three-Way Match" AppFreelanceJobs • Canada
This job offer is no longer available
Full-Stack Developer for Accounts Payable "Three-Way Match" App
FreelanceJobs
- Canada
- Canada
About
Your job is to build the logic engine that matches the data, flags discrepancies, and manages the "remaining unmatched" inventory.
The Core Challenge
The system must match invoices against Received quantities only (not just what was ordered). You will need to build logic that tracks which specific received items have already been "consumed" by previous invoices to prevent double-billing.
Key Responsibilities
Reconciliation Engine: Build an aggregate matching logic (Total Qty + Price) as the primary workflow, with a granular "Line-Item" fallback mode.
State Management: Track quantities across partial shipments and multiple invoices.
Currency & FX: Handle non-USD invoices with automated/manual exchange rates and tolerance thresholds (e.g., auto-accept 1% variance).
Smart Suggestions: Develop a "Best Fit" algorithm to suggest which received items match an invoice based on price/quantity combinations.
ERP Integration: Build a search/sync feature to fetch PO and Receiving data via API and store it locally for reconciliation.
Technical Stack
Frontend: , React, Tailwind CSS, ShadCN/UI (Focus on speed and density).
Backend/Database: Supabase (PostgreSQL), Cloudflare Workers, or Vercel.
Complex Logic: Experience with relational database design and "Knapsack-style" matching algorithms.
Our Ideal Candidate
You understand Accounting/FinTech logic. You know why an invoice might not match a PO exactly and how to handle those edge cases.
You have experience building Internal Tools (Retool-style density but with custom flexibility).
You write clean, documented code—especially regarding the reconciliation math.
To Apply
Briefly explain how you would structure the database to ensure a "Received Item" isn't matched to two different invoices.
Mention the word "UNMATCHED" in your first sentence.
Link to a project where you handled complex data relationships or financial reconciliation.
Contract duration of 1 to 3 months. with 30 hours per week.
Mandatory skills: Web Development, Inventory Management, Accounting Systems, , React, API Integration
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.