I will reconcile excel sap bank and invoice data
Excel, Web Scraping, Accounting, Finance, Data Analysis, Data Entry
About this Gig
I will compare and reconcile two Excel, CSV, SAP export, bank, sales, or invoice files and identify the differences clearly.
The order includes:
* Two input files
* Up to 1,000 rows in each file
* Up to three matching fields
* Matched records report
* Unmatched records report
* Difference report
* Basic reconciliation summary
* One revision
Analysis type:
Quantitative Analysis
•
Qualitative Analysis
Expertise:
Web analytics
•
Business Insights
•
Algorithms
•
Statistics
Technology:
Excel
Programming language:
Python
•
DAX
My Portfolio
FAQ
Can you reconcile SAP data with a bank statement?
Yes. Please provide an Excel or CSV export from SAP and the bank statement in a readable spreadsheet format.
Can you find invoices missing from one file?
Yes. The final report will clearly show records found in only one file.
Can you detect duplicate transactions?
Yes. Duplicate detection can be included using the selected invoice, reference, amount, or date fields.
Will you modify the original files?
No. I will work on copies and deliver a separate reconciliation report.

