Excel Cost Tracker Automation
Budget: $30 – $250 USD
I'm seeking an Excel expert to streamline our project cost tracking. Currently, we use a cost estimate to create a cost tracker, which is updated daily. Invoices come via email as PDF attachments, and I manually input data into the tracker and generate payment certificates.
The main issues are:
- Inefficient data organization: All data for the same item is in one row, making it hard to track multiple invoices per day.
- Manual input errors: I make many mistakes entering data by hand.
I need a solution to automate:
- Data entry from PDF invoices
- Generating payment certificates
Ideal Skills and Experience:
- Proficiency in Excel
- Experience with PDF data extraction tools
- Ability to create automated workflows in Excel or using VBA
- Strong attention to detail to minimize errors
Looking forward to your proposals!
The main issues are:
- Inefficient data organization: All data for the same item is in one row, making it hard to track multiple invoices per day.
- Manual input errors: I make many mistakes entering data by hand.
I need a solution to automate:
- Data entry from PDF invoices
- Generating payment certificates
Ideal Skills and Experience:
- Proficiency in Excel
- Experience with PDF data extraction tools
- Ability to create automated workflows in Excel or using VBA
- Strong attention to detail to minimize errors
Looking forward to your proposals!