Excel Script / Program to Audit, Compare CSV files
$30-250 USD
Ολοκληρώθηκε
Αναρτήθηκε περίπου 6 χρόνια πριν
$30-250 USD
Πληρωμή κατά την παράδοση
I need an Excel program that will compare two CSV files and return the results.
Our bank receives about 150 checks per day. The bank captures all the information on the checks (the check #, the check amount, the remittance information) and supplies us with a CSV of that data.
We then take that CSV and upload it to our accounting system. The accounting system automatically receives and applies the checks that it is able to match based on the CSV.
On every import, there are some failures / exceptions, for various reasons. We would like to create an Excel tool that will take the Bank CSV and the Accounting system CSV and compare the two and display a sheet that shows the exceptions.
The full description of who this will work, as well as an example of the output are attached to this project.
If you're awarded the project I will provide the real CSVs described for development and testing.
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days.
Willing to take up your project. Thank you, Regards.
$155 USD σε 3 ημέρες
5,0 (27 αξιολογήσεις)
4,6
4,6
4 freelancers δίνουν μια μέση προσφορά $127 USD για αυτή τη δουλειά
Hi there,
i understand your requirement and if you need a sample work,can provide within one hour.
if you have any questions please let me know,
can start now your project according to the your guide line with Confirmation.