Custom Invoice Reconciliation Application

Posted last month

Worldwide

Summary

I am looking to have a custom application developed for my steel distribution business. The goal of the application is to track customer invoices, supplier invoices, freight invoices, profitability, and payment status in one centralized system. Core requirements: Customer Invoice Entry Create a new Company invoice record. Enter invoice number, customer name, invoice date, due date, and invoice amount. New invoices should automatically be marked as "Red" (incomplete). Status Workflow Red = Customer invoice entered, but vendor costs and/or freight costs have not been assigned. Green = Vendor and freight costs have been assigned, profitability can be calculated, but customer payment has not been received. White = Customer payment has been received and the order is fully reconciled. Cost Allocation Ability to assign one or multiple vendor invoices to a customer invoice. Ability to assign one or multiple freight invoices to a customer invoice. Calculate gross profit automatically. Document Storage Upload and store PDF copies of: Customer invoices Vendor invoices Freight invoices Purchase orders Mill certificates Other supporting documents Documents should remain attached to the related job/order. Dashboard List all Red invoices (missing costs). List all Green invoices (awaiting payment). List all White invoices (completed). Search by invoice number, customer, vendor, or date. Payment Tracking Ability to mark invoices as paid. Record payment date and amount. View outstanding receivables. Database All data should be stored in a database and backed up automatically. I would like the ability to export data to Excel. Future Enhancements (Optional) OCR reading of uploaded vendor invoices. Automatic extraction of invoice number, vendor name, and invoice amount from PDFs. Basic profit and loss reporting. GST/HST reporting. Please provide: Estimated development cost. Estimated timeline. Recommended technology platform. Ongoing maintenance costs (if any). Examples of similar applications you have built. Thank you and I look forward to hearing from you.

  • Less than 30 hrs/week
    Hourly
  • 1-3 months
    Duration
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Accounting
Database Design
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:4 weeks ago
  • Interviewing:
    5
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Jun 11, 2026
  • Canada
    7:59 PM

Explore similar jobs on Upwork

Tally Prime 7 Invoice CustomizationHourly‐ Posted 3 weeks ago
PHP
Windows Administration
MySQL
Microsoft Windows PowerShell
Accounting
Financial Accounting
Bookkeeping
Accounts Payable Management

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo