Excel to Universal Payment file format
Budget: $30 – $250 USD
Every month I export roughly 150 payment-voucher rows from QuickBooks Desktop into a single Excel sheet. Instead of keying each voucher into Maybank 2E by hand, I need a small utility that reads that Excel file and turns just the payment-voucher lines into a Universal Payment XML file ready for upload to the bank portal.
Core workflow
1. I drop the fresh Excel export into a chosen folder.
2. Your program parses it, pulls out the relevant payment-voucher data, checks for duplicate entries, then produces the correctly structured XML file.
3. If the converter finds an issue at any row, it should immediately show a clear on-screen error message identifying the problem so I can fix the source file and rerun.
Key points to keep in mind
• Input: QuickBooks Desktop-generated Excel file (column layout is fixed; I’ll supply a sample).
• Output: Bank-accepted Universal Payment XML compatible with Maybank 2E upload.
• Validation: flag duplicate voucher numbers before the XML is produced.
• Usability: simple desktop executable or script I can run locally—no cloud components required.
Deliverables
• The compiled utility (and source code for future tweaks).
• A short README explaining setup, required libraries (if any), and step-by-step usage.
• Sample output XML generated from the sample Excel so I can test upload straight away.
Core workflow
1. I drop the fresh Excel export into a chosen folder.
2. Your program parses it, pulls out the relevant payment-voucher data, checks for duplicate entries, then produces the correctly structured XML file.
3. If the converter finds an issue at any row, it should immediately show a clear on-screen error message identifying the problem so I can fix the source file and rerun.
Key points to keep in mind
• Input: QuickBooks Desktop-generated Excel file (column layout is fixed; I’ll supply a sample).
• Output: Bank-accepted Universal Payment XML compatible with Maybank 2E upload.
• Validation: flag duplicate voucher numbers before the XML is produced.
• Usability: simple desktop executable or script I can run locally—no cloud components required.
Deliverables
• The compiled utility (and source code for future tweaks).
• A short README explaining setup, required libraries (if any), and step-by-step usage.
• Sample output XML generated from the sample Excel so I can test upload straight away.