I will create a google sheets inventory, budget or client tracker for you
Shopify, Excel and Python Automation Specialist
About this Gig
Need an inventory list, a budget, or a client and job tracker that actually gets used? I build it in Google Sheets: clean tabs, drop-down menus, totals that add themselves and a one-page dashboard you can read at a glance.
BUILT FOR
Landlords: rent roll, lease alerts, expenses, category totals
Turo and car-sharing hosts: profit per car, service due dates, mileage
Service crews (cleaning, lawn, mobile repair): jobs, customers, invoices
Small shops: inventory, sales, reorder flags
PROOF
My Rental Property Tracker (see the gallery) has a dashboard, a rent roll that flags expiring leases, an expense log and category totals. I also ran my own 5-car rental fleet, so maintenance and fleet logs are second nature.
HOW IT WORKS
1) Show me what you track now: an old sheet, a notebook photo or a list.
2) I confirm the layout with you, then build it.
3) You get a Google Sheets copy link, an .xlsx file and a how-to tab.
Formulas are locked so nothing breaks by accident. No add-ons or monthly fees. Not tax advice; your preparer decides how to file.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Python
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Macros
•
Dashboard
My Portfolio
FAQ
Google Sheets or Excel?
It's built in Google Sheets, and you also get an .xlsx copy. Apps Script automations (emails, forms, schedules) only run in Google Sheets.
Can you fix my existing sheet instead?
Yes. Quick Tracker covers fixing broken formulas and cleaning up one tab. Bigger rebuilds are Standard.
Do I have to share private data?
No. Send your column headings and a few made-up rows, and fill in the real numbers after delivery.
Will it work on my phone?
Yes, in the Google Sheets app, for entering data. Dashboards read best on a computer or tablet.
Is this tax or legal advice?
No. Tax-category totals make tax time easier, but your preparer decides how to file.

