Invoice Data Extraction Automation CSV/Excel Expert Needed
Budget: $30 – $250 USD
I am looking for a freelancer to analyze 11 Excel/CSV invoice files from a fulfillment/logistics provider.
The task is to create a clear monthly overview of all services that were billed.
What I need, per month:
* A list of all different services that were charged
* How many times each service was charged (quantity)
* The price per service
* The total amount per service
* The grand total of all services combined for that month
This must be based strictly on the invoice data. No assumptions or interpretation.
Additional details:
* There are 11 Excel/CSV files in total
* Service names must be exactly as written in the invoices
* Some services appear many times within the same month
* Accuracy is more important than speed
* The output must be a clean, well-structured Excel file
Deliverable:
* One Excel file showing a clear monthly breakdown of services and totals
When applying, please include:
* Relevant experience with invoice or financial data analysis
* Estimated time to complete the task
* Your fixed price for the full job
The task is to create a clear monthly overview of all services that were billed.
What I need, per month:
* A list of all different services that were charged
* How many times each service was charged (quantity)
* The price per service
* The total amount per service
* The grand total of all services combined for that month
This must be based strictly on the invoice data. No assumptions or interpretation.
Additional details:
* There are 11 Excel/CSV files in total
* Service names must be exactly as written in the invoices
* Some services appear many times within the same month
* Accuracy is more important than speed
* The output must be a clean, well-structured Excel file
Deliverable:
* One Excel file showing a clear monthly breakdown of services and totals
When applying, please include:
* Relevant experience with invoice or financial data analysis
* Estimated time to complete the task
* Your fixed price for the full job
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Financial Analysis
Data Visualization
Data Analysis
Data Management