I will build a google sheets sales and inventory dashboard


Level 2
About this gig
I will build a Google Sheets sales and inventory dashboard that helps you see orders, stock, revenue, and agreed business KPIs in one workbook.
For small businesses, equipment sellers, contractors, and agencies, I can organize clean source data, create formulas, dropdowns, filters, conditional formatting, charts, and clear summary tabs. Standard and Premium add inventory tracking; Premium can include product revenue and gross profit calculations based on the costs you supply.
We will agree on the source columns and KPI definitions, build on a copy with sample data, check the calculations, and provide a short update guide. Package limits cover one workbook and the stated tabs, rows, KPIs, and charts.
Please share an anonymized sample and your desired output before ordering. No passwords or unnecessary personal data. External app connections, Apps Script, macros, large data cleanup, accounting advice, and guaranteed business results are excluded. One revision covers adjustments to the agreed workbook; new features require a separate scope.
Message me on Fiverr to confirm the best package.
Get to know Sidra H
All Rounder Virtual Assistant
Level 2
- FromPakistan
- Member sinceMar 2024
- Avg. response time1 hour
- Last delivery1 month
Languages
English
FAQ
What files and access do you need?
Please send an anonymized sample, source column names, row count, desired KPIs, and expected output. Work is done on a copy. You can provide a shared working sheet through authorized access; never send passwords or unnecessary customer data.
Do dashboards update automatically or connect to other apps?
Formulas and charts recalculate when properly structured data changes. External integrations, scheduled imports, Apps Script, and macros are excluded. Google account access and any subscriptions remain your responsibility.
Can you improve an existing sheet and what is a revision?
Send a sanitized sample before ordering so cleanup or repair can be scoped. One revision adjusts the agreed workbook. New tabs, KPIs, source files, or features may need a separate offer. Figures depend on supplied data; financial accuracy and business results are not guaranteed.
