Quote:
Currently the accounts receivable dept manually matches up the invoice number and amount in our accounting system to the invoice number and dollar amount on the statement that is sent with the check.
She has a printed .pdf that she goes line by line comparing the invoice the chain paid for then finds it in our accounting system to mark as paid.
That part can be automated
Quote:
One thought is to scan the pdf to convert to an excel file. Then see if I can get help to create an excel VB script that will compare the invoice number and dollar amount form the statement showing what it is paying to an excel file that has my invoices information then have it mark off any invoice numbers and dollar amount that match then flag any that do not match.
That is the best you will be able to do with Excel. Using a good relational Data Base will provide a littler better solution, but no truly complete automated solution is possible with so many people/depts/time involved