I will provide a ready to use english sales tracker in google sheets


About this gig
Get organized with a ready-to-use Google Sheets Sales Tracker, designed for small businesses that want to manage sales, customers, payments, and products in one place.
WHAT'S INCLUDED:
- 12 monthly sales tabs (JanuaryDecember 2027)
- 5 customizable categories and 100 product slots per month
- Customer registration and dropdown selections
- Purchase costs, selling prices, payments, and inventory cost tracking
- Interactive dashboard with customizable period filters
- 5 key performance indicators and 2 Top 20 customer rankings
- English SETUP and USER GUIDE tabs
- Step-by-step PDF user manual
MADE FOR US USERS:
- English interface
- US Dollar ($) currency
- MM/DD/YYYY date format
Dashboard results and rankings update automatically after you enable the included Apps Script automations. Product statuses and inventory transfers are managed manually.
IMPORTANT:
This is a prebuilt template, not a custom spreadsheet service. Google may display an unverified-app warning when you activate the automations. Review the requested permissions before authorizing.
You will receive access to the template to make your own editable copy, along with the PDF manual.
Get to know Deiviin
Excel Spreadsheets and Dashboards
- FromBrazil
- Member sinceJun 2024
Languages
Portuguese, English
FAQ
Is this template in English?
Yes. The spreadsheet, dashboard, setup instructions, and PDF manual are provided in English, with USD currency and US date formatting.
Does the dashboard update automatically?
Yes. After enabling the included Apps Script automations, the dashboard and customer rankings update when you edit sales data or change the period filters. Copy Q&A
Do I need Microsoft Excel?
No. This template is designed specifically for Google Sheets. You only need a Google account to create and use your own copy.
Can I customize the template?
You can rename product categories, enter your own customers and products, and adjust monthly records. Custom development or personalized modifications are not included. Copy Q&A
Does it automatically manage inventory?
No. Inventory transfers and product statuses are managed manually. The dashboard automatically calculates sales indicators and customer rankings after activation.
How will I receive my template?
You will receive view-only access to the Google Sheets template and an English PDF manual through your Fiverr order. You can then create your own editable copy. Copy Q&A
Why might Google show an unverified-app warning?
The spreadsheet uses Google Apps Script for automation. Google may display an unverified-app warning during setup. Review the code and requested permissions before deciding whether to authorize it.

