Suoritettu

Excel Script / Program to Audit, Compare CSV files

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.

Taidot: tietojenkäsittely, Excel, PHP, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: program compare csv files windows, compare csv files gui, windows compare csv files, compare csv files excel, python compare xls files, pandas compare excel files, compare two csv files for differences in python, python excel diff, macro to compare two csv files, compare two csv files for differences, compare two excel files, sample vbscript compare csv files, compare csv files differences, visual basic compare csv files, compare csv files vbscript, compare csv files windows, compare csv files using excel, vb6 compare csv files, compare csv files sql, compare csv files vba

Tietoa työnantajasta:
( 37 arvostelua ) Concord, United States

Projektin tunnus: #16554474

Myönnetty käyttäjälle:

periyannas

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 päivässä
(27 Arvostelua)
4.6

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$200 USD 2 päivässä
(253 arvostelua)
7.4
$111 USD 4 päivässä
(1 arvostelu)
2.4
Nicecreator

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 Con Lisää

$40 USD 1 päivässä
(7 arvostelua)
2.2