We want a macro in excel to perform reconciliation of our company travel, and create a batch input file for our finance system. The two files are a Travel Agency Invoice in Excel And an excel statement of charges by the Travel Agency to the company account for the same period. The macro must 1, Import both documents 2, Reconcile them both by invoice number, and then charge amount (charge amount must be within 5%) 3, Move all transactions in the Statement of charges into three documents. Document 1: Matched transactions (a batch input file) Document 2: Unmatched items, or missing mandatory information (for return to the travel agency for completion stating the reasons "incorrect cost", "no matching invoice" or 'Missing mandatory information" next to each line) - when new information comes back and is entered on this page, the corresponding line must be reconciled against the travel agency statement again and automatically moved into the batch input file in a different color. Document 3: Carry over transactions (travel agency invoice lines that have not yet been billed to the company account) - there must be a way of adding the carry over from the previous month to the current month's reconciliation file moving forward (user form "Import previous Travel Agency Invoices? Yes/No" After each reconciliation, a pop-up will show the report, indicating % match rate success, % carried over and % returned to Travel agency The reconciled page must be logged, and added to with further monthly reconciliations.
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."