
Open
Posted
•
Ends in 6 days
Paid on delivery
My list takes the place of the bank statement import in my recommendations, as it already says which invoices each transfer pays: - we upload Customer’s list (Excel, or the PDF). Each line finds its invoice, and the system makes one receipt per transfer with those invoices ticked. You type what the bank actually credited; the difference (the USD 7) is booked as bank charges, and the exchange difference as well. 1. We should have the issued invoice to the Customer 2. PO Number should match with the PO number from the PDF/Excel 3. Total amount of the P/Ns should match with the total amount received - From the same list, the system proposes the supplier invoices behind those sales invoices for payment, one payment per supplier, so paying them the same week takes a few clicks. - The payments received so far, loaded from Customer’s lists in one go. - As recommended: Customer’s payment terms on every invoice, so the due dates and Overdue are right, and the month-end revaluation of the USD and CNY balances.
Project ID: 40803885
90 proposals
Open for bidding
Remote project
Active 37 mins ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
90 freelancers are bidding on average $1,035 HKD for this job

Hi, I am Elias from the sunny state of Florida. I see you're looking to automate customer payments and supplier settlements, which is essential for streamlining your financial processes. The goal is to enhance efficiency while ensuring accuracy. What usually matters most here is integrating your existing data sources seamlessly. A common issue in systems like this is managing various payment methods and aligning them with supplier requirements. The tricky part is ensuring that the automation logic effectively handles exceptions, as manual interventions can disrupt workflows. My approach would involve setting up a robust data integration layer that connects your payment systems with your accounting tools. This ensures real-time updates and provides a clear audit trail. I focus on building a system that's stable and maintainable, allowing for easy adjustments as your needs evolve. In previous projects, I’ve implemented similar automation solutions that improved transaction accuracy and reduced processing times. A few questions to better understand the scope: Q1 – What specific payment methods and platforms are you currently using? Q2 – Are there particular reporting features you require for supplier settlements? Q3 – How do you envision handling exceptions or discrepancies in payments? Happy to discuss the details and suggest the best technical approach. Looking forward to hearing from you.
$1,200 HKD in 6 days
7.4
7.4

Hi there, I have reviewed your project and understand you need your customer payment list to replace the bank statement import, matching each line to its invoice and posting one receipt per transfer, with bank charges and exchange differences booked. I am confident I can build it so a transfer posts only when invoice, PO number and total all match. My approach is to first read your Excel and PDF formats and chart of accounts. Next, I will match each line to its issued invoice, check the PO number and that the P/N total equals the amount received, sending failures to an exceptions list. I will then create one receipt per transfer with those invoices ticked, enter the amount the bank credited, and book the difference as bank charges and the currency difference as exchange gain or loss. From the same list, I will propose supplier payments, one per supplier. I will also load past payments with duplicate checks, apply customer payment terms to every invoice, and add month-end USD and CNY revaluation. Finally, I will test on a full month and reconcile totals. You will receive the working import and matching, receipts and supplier payments, revaluation setup and a user guide. Which accounting system is this built in, and what does P/N stand for on your list? Send me one sample list with its invoices and I will map out the matching rules right away. Let’s chat about scope in detail. Warm Regards, Aneesa.
$800 HKD in 1 day
7.1
7.1

I can extract tables from PDFs into clean Excel, like the Customer's list or invoices. For example, I can help with extracting PO numbers and total amounts from PDFs. I offer a free sample before payment. Can you provide a sample PDF for extraction?
$485 HKD in 3 days
6.5
6.5

Automating customer payment matching and supplier settlements requires strong Excel handling and careful financial reconciliation—skills I offer through Excel, automation, and financial analysis. I can work with customer lists in Excel or PDF, accurately capture invoice and PO details, and reconcile the total P/N amounts against the amount actually received. My experience with Excel functions, formulas, formatting, pivot tables, and data entry supports reliable processing of payment lists, invoice references, bank charges, and exchange differences. I can also help structure the information so customer payment terms, due dates, overdue balances, USD/CNY balances, and month-end revaluation are clearly maintained. I am committed to fast, accurate, and well-organised work, with strong attention to financial data and document consistency. Choose me to support this payment automation and reconciliation project with dependable Excel-based execution.
$500 HKD in 1 day
6.5
6.5

Hi, I can implement this workflow in your accounting system with a strong focus on accuracy, automation, and complete transaction traceability. Let's review your sample Excel/PDF list and accounting setup. I can demonstrate how I would structure the workflow and ensure the first reconciliation is accurate before proceeding with the full implementation. Best, Faizan.
$1,000 HKD in 7 days
6.4
6.4

Hello, I went through your project description and understand you need an automated accounting workflow that will process customer payment lists, match receipts against issued invoices, reconcile bank differences, and prepare supplier payments with accurate multi-currency accounting. I will develop this using Python, Excel/PDF processing, and an accounting integration layer. The system will extract PO numbers, invoice references, and payment amounts, validate each entry against issued invoices, and generate one receipt per transfer with the corresponding invoices allocated. You will enter the actual bank credit, while the system will automatically post bank charges and exchange differences separately. I will also implement supplier invoice matching, consolidated supplier payments, customer payment terms, automated due-date tracking, overdue reporting, and month-end USD/CNY revaluation. Validation checks will flag mismatched PO numbers and discrepancies between invoice totals and received amounts before posting. Within 24–48 hours of award, I will share a project blueprint. Which accounting software are you currently using, and will you expect the workflow to post transactions directly into it? Let's discuss the implementation and build a reliable, streamlined process for your accounting team. Best regards, Imran
$710 HKD in 1 day
6.0
6.0

Your customer’s payment list can drive receipts and supplier-payment proposals, but the key is to make every match auditable before anything is posted. I’ll map the Excel and PDF fields to issued invoices, check PO numbers and totals, and flag missing invoices, duplicate transfers, or mismatches for review. For each confirmed transfer, the workflow will create one receipt against the listed invoices, use the actual bank credit you enter, and record bank charges and exchange differences separately. I’ll also build a bulk import for payments already received, with duplicate protection. On the payable side, I’ll use the links between sales and supplier invoices to propose payments grouped by supplier, leaving final approval with you. I’ll check customer payment terms and due dates, then configure month-end USD and CNY revaluation using the accounting system’s supported process. I’m comfortable building import and reconciliation workflows where traceability and safe posting matter as much as speed. Which accounting system do you use, and are supplier invoices already linked to the corresponding sales invoices?
$500 HKD in 10 days
5.6
5.6

Reconciling supplier settlements against bank statements manually is where most of these setups fall apart, especially once volume picks up. I can build an automated matching script in Python that pulls your statement data and flags mismatches before payment, with Excel exports for your records. Start today, working version in 4 days. These numbers are based on the post as written, we will nail down specifics once you share a sample file. Want me to send a quick scope doc?
$1,200 HKD in 10 days
4.7
4.7

Hi, The real bottleneck here is matching: a transfer on the customer list has to find the right invoice, and that invoice has to pull the supplier invoices behind it, all before you can create the receipt and the payment proposal. If the PO number or total amount mismatches, the whole chain breaks. I'd build this as a web app where you upload the customer list (Excel or PDF), and the system matches each transfer to invoices by PO number and amount, flagging mismatches so you fix them first. Once matched, it auto-creates one receipt per transfer with those invoices ticked, and you enter the bank credit and any charges. From the same receipt, it pulls the supplier invoices linked to those sales invoices and groups them by supplier for one payment per supplier. The app stores all uploaded lists so you can load prior payments in bulk, and it calculates due dates and overdue status from the customer payment terms on each invoice, plus month-end revaluation of USD and CNY balances. I'd start with the upload and matching logic, so you can see which transfers find invoices cleanly and which need manual fixes. Send a sample customer list, a sample invoice (to show the PO and supplier link), and the current payment terms structure, and I'll build the first version. Denis
$240 HKD in 30 days
4.6
4.6

Hello, I’m Karthik, a financial systems expert with over 15 years of experience in developing automated solutions for invoice and payment processing. I understand your requirement for a streamlined system that enhances accuracy and efficiency in managing customer and supplier transactions. Project Overview: - Customer List Upload: I will develop a feature to upload customer lists in Excel or PDF format. The system will match each line to corresponding invoices, generating receipts for each transfer with the relevant invoices automatically ticked. - Bank Reconciliation: Users can input the actual bank credited amount, with any discrepancies (like bank charges) automatically categorized, ensuring accurate financial reporting. - Invoice Verification: The solution will ensure that issued invoices match the PO numbers from the uploaded documents and that the total amounts align with received payments. - Supplier Payment Integration: The system will propose supplier invoices related to sales for efficient payment processing, enabling quick payment actions within the same week. - Comprehensive Payment Tracking: All payments received will be consolidated from customer lists for easy tracking and reporting. - Payment Terms Management: We will incorporate payment terms on each invoice for accurate due dates and overdue tracking, along with month-end currency revaluation for USD and CNY. Best regards, Karthik
$2,220 HKD in 7 days
5.1
5.1

I can develop a reliable payment-automation workflow that turns customer Excel or PDF remittance lists into accurate receipts and settlement proposals. The solution can validate issued invoices, PO numbers, received totals, and payment allocations, while automatically recording bank charges and exchange differences. It can also trace related supplier invoices behind each sale, consolidate payments by supplier, and support one-click weekly settlement preparation. I will structure the import process with clear validation, exception handling, duplicate prevention, and an audit trail so every receipt and payment remains transparent. I can also implement payment terms, accurate due-date and overdue calculations, and month-end revaluation for USD and CNY balances. The result will be a streamlined accounting workflow that reduces manual entry, improves reconciliation accuracy, and makes imported customer payment data immediately actionable.
$1,245 HKD in 2 days
4.3
4.3

Automating customer receipts and supplier settlements requires strong accounting control, not just data entry. My experience in bookkeeping, bank reconciliation, AR/AP management, Excel automation, and payment processing directly matches your workflow. I can support a reliable process for importing customer Excel or PDF lists, matching invoices and PO numbers, checking that P/N totals agree with amounts received, and recording bank charges and exchange differences accurately. My expertise with QuickBooks, Xero, SAP, Odoo, and Advanced Excel also aligns with loading historical payments, applying customer payment terms, identifying overdue balances, proposing supplier payments, and supporting month-end USD and CNY revaluation. FinTax Global Solutions LLC applies a Big4-trained mindset to accurate, compliant financial operations for businesses worldwide. I am ready to help turn this payment information into a controlled, efficient accounting process.
$1,300 HKD in 7 days
3.9
3.9

I can expertly automate your multi-currency payment reconciliation workflow, ensuring your customer lists seamlessly map to invoices, strictly match PO numbers, and accurately book bank charges and FX differences. I have uploaded samples similar to this project completed by me earlier in my profile. As a Chartered Accountant (ICAI) and CPA with 10+ years of professional experience, I specialize in designing advanced ERP workflows and executing complex financial reconciliations. This elite-level accounting background ensures I can perfectly configure your system to ingest Excel and PDF lists, automatically tick matched sales invoices, and route the exact USD and CNY exchange differences and bank fees to the correct ledgers. Furthermore, I will actively streamline your payables by linking your supplier invoices to these exact sales receipts for rapid, one-click payment runs, while ensuring your payment terms and month-end multi-currency revaluations are strictly compliant and flawlessly automated. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion of milestone ✅ Regular updates related to the project ✅ Timely delivery ✅ 100% commitment to project completion Which accounting software (like Xero or QuickBooks) are you currently using to manage these multi-currency transactions and supplier payments? Looking forward to completely automating and streamlining your entire reconciliation process.
$1,000 HKD in 1 day
4.1
4.1

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, Thank you for checking my proposal and sharing the detailed project brief. I can build your invoice management system using Python and React with a scalable and user-friendly design. I will deliver: • Seamless upload of customer lists (Excel/PDF) with automatic invoice matching • Generation of receipts per transfer, including bank charges and exchange differences • Integration of issued invoices with matching PO numbers • Automated payment proposals for supplier invoices based on sales invoices • Bulk loading of payments received from customer lists • Implementation of customer payment terms for accurate due dates and month-end revaluation You will also receive comprehensive documentation and ongoing support throughout the project. I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
$1,000 HKD in 14 days
3.8
3.8

A transfer that pays several invoices, less a USD 7 bank fee and an exchange gap, is where these receipt matches usually break, so I would build that part first from your customer lists. The hard part is the PO match: when the PDF and Excel PO numbers differ by a prefix or a space, the line should stop and show you, not match the wrong invoice. The Card statement CSV to accounting item on my profile is the closest sample. Here is the order I would work in: 1. Match one customer's Excel and PDF by PO number and total, mismatches first. 2. Write one receipt per transfer, with the USD 7 fee and exchange gap as their own lines. 3. Build the supplier payment list, one line per supplier, from the same invoices. - 250 HKD for steps 1 and 2, once you can see the receipts for one of your customer files. - 650 HKD for step 3, when the whole job is done. Check one customer's receipts against your bank before you pay for the rest. The month-end revaluation, the batch load and the payment terms would be quoted after. Which accounting system holds your invoices today?
$900 HKD in 3 days
3.4
3.4

Your customer's remittance list is a better source than the bank statement because it already names the invoices each transfer pays. That makes the importer the core of this job. For each line in the Excel or PDF, I'd find the issued invoice, check that the PO number matches, and check that the P/N totals add up to the amount received. Each transfer then becomes one receipt with those invoices ticked. You enter the amount the bank actually credited, and the system books the shortfall (like the USD 7) as bank charges and posts the exchange difference. I'd parse the PDF and Excel into one clean structure first, then post through the accounting system's API so mismatches get flagged instead of guessed. I've built Excel Power Query restructuring and structured extraction pipelines before. This bid covers that customer receipt import. Supplier payment proposals, the historical load, payment terms and month-end USD/CNY revaluation would be quoted as a later phase. Which accounting system and version are you on, and can I get API or custom module access?
$761 HKD in 1 day
2.9
2.9

Hi, Automating the reconciliation of customer payments and supplier settlements to eliminate the time-consuming and error-prone manual process. How do you currently manage discrepancies if payments do not match the expected amounts? Here's how I'd do it: - Build a data parsing solution to extract line items from uploaded Excel/PDF files. - Implement logic to match invoices, generating receipts, bank charges, and handling exchange differences automatically. - Make sure you have a dashboard showing reconciliation status, discrepancies, and scheduled supplier payments. I can have a working version of the core piece ready on a test link within a day. What's your preferred platform for this automation? Toqeer S
$600 HKD in 5 days
2.5
2.5

I can automate your Customer’s list upload from Excel or PDF, creating one receipt per transfer and preparing supplier settlements with the right checks. I’d align the flow with your accounting logic: PO Number matching, P/N totals matching the credited amount, and the USD 7 difference posted as bank charges with clear exchange differences. Supplier invoices can then be proposed from the customer payment list, grouped one payment per supplier for same-week payment. - Parse Excel/PDF lines and match issued Customer invoices. - Create receipts per transfer with bank charges and FX differences. - Propose supplier invoices and month-end USD/CNY revaluation entries. I have 14+ years in web development, including Node.js, TypeScript, REST APIs, MySQL/PostgreSQL, PDF/data workflows, and 130+ client reviews on Freelancer.com. Should the system read Customer payment terms from existing invoices, or will those terms come from the uploaded list? HKD 1,099 covers receipts per transfer, proposed supplier invoices, and month-end revaluation of USD and CNY balances. Delivery in 14 days. Rajavel
$1,099 HKD in 14 days
2.6
2.6

One honest note first: I'm early on this platform and pricing low to earn reviews, so the number is real. Your brief reads like requirements from the middle of a conversation, so let me prove I understood the accounting before anything else. The customer's remittance list stands in for the bank statement: each line matched to its invoice by PO number, with the totals agreeing, and one receipt per transfer with those invoices ticked. The bank's actual credit gets typed in, and the gaps book themselves correctly, short payments as bank charges, rate movement as exchange difference, so the ledger stays honest without manual patching. The same list then drives the money going out: the supplier invoices behind those sales, proposed as one payment per supplier, payable the same week in a few clicks. Payment terms on every invoice so due dates and overdue are real, and the month-end revaluation of the USD and CNY balances so nothing pretends exchange rates stand still. What the brief doesn't say is where all this lives. If there's an existing system to extend, this is a focused build against it, matching engine, receipt logic, settlement proposals, done in days. If this is the first brick of something new, that's a bigger conversation and I'd tell you so plainly before starting, not discover it with you mid-project. So the plan once the shape is clear: day one, the matching engine, list lines to invoices by PO number and totals, with the exceptions surfaced rather than silently forced; day two, receipts with the bank-charge and exchange-difference booking, plus the settlement proposals, one payment per supplier; day three, payment terms and due dates, the revaluation entries, and a walkthrough with your real files. One question, and it's the one I'd start with: does a system already exist for this to extend, or is this greenfield?
$393 HKD in 3 days
1.4
1.4

Hi, I can help you streamline this process by matching customer payment lists with issued sales invoices, recording receipts against the correct invoices, and reconciling differences such as bank charges and exchange gains or losses. I can also match supplier invoices with the related sales, prepare supplier payments, and ensure payment terms, due dates, and month-end USD/CNY revaluations are properly maintained. I have two years of accounting and bookkeeping experience, including invoice management, bank reconciliations, and multi-currency transactions. I’d be happy to review your current records and help put this workflow in place. Thank you.
$750 HKD in 7 days
1.7
1.7

Hong Kong, Hong Kong
Payment method verified
Member since Jul 9, 2026
$240-2000 HKD
$30-250 USD
$250-750 USD
$240-2000 HKD
$240-2000 HKD
$8-15 USD / hour
$15-25 USD / hour
$30-250 USD
$250-750 USD
₹12500-37500 INR
$10-30 USD
$30-250 USD
₹750-1250 INR / hour
₹12500-37500 INR
$2-8 USD / hour
₹12500-37500 INR
₹150000-250000 INR
$2000-6000 HKD
₹12500-37500 INR
$80-95 USD / hour
$30-250 USD
$10-30 USD
$25-50 USD / hour
$25-50 USD / hour
$10-30 USD