Google Sheets Dashboard for Purchase Invoices -- 2
Budget: ₹1,500 – ₹12,500 INR
I'm seeking an experienced freelancer to design a Google Sheets dashboard that consolidates my purchase invoice data through a RESTful API. The goal is to streamline the reporting process by automating data updates, categorizing multiple TranZact purchase invoices under one vendor Invoice ID, and incorporating easy-to-use filters.
Key tasks will include:
- Visualizing data in tables and lists within Google Sheets.
- Adding essential data fields: Total amount, Vendor name, Purchase date, Invoice ID, Purchase Order ID.
- Creating filters for efficient reporting, particularly focusing on the Invoice number.
Ideal candidates should have:
- Strong proficiency in Google Sheets.
- Proven experience with RESTful APIs.
- Excellent data visualization skills.
- Understanding of invoice data and vendor management.
Please note, while I skipped a few questions, I primarily need the filter for the Invoice number and would appreciate the data being refreshed automatically on a daily basis.
Key tasks will include:
- Visualizing data in tables and lists within Google Sheets.
- Adding essential data fields: Total amount, Vendor name, Purchase date, Invoice ID, Purchase Order ID.
- Creating filters for efficient reporting, particularly focusing on the Invoice number.
Ideal candidates should have:
- Strong proficiency in Google Sheets.
- Proven experience with RESTful APIs.
- Excellent data visualization skills.
- Understanding of invoice data and vendor management.
Please note, while I skipped a few questions, I primarily need the filter for the Invoice number and would appreciate the data being refreshed automatically on a daily basis.