เทมเพลต Excel / Google Sheets

Stock & Sales Template

Product list with auto stock on hand
Low-stock alerts in red
Stock-in and sales log with daily profit
Sales dashboard with best sellers and charts

฿99Lifetime

About this template

A stock and sales tracker for online sellers. Log sales from Shopee, Lazada, TikTok, Facebook and LINE in one place; the file deducts stock, works out profit per sale and flags items that are running low.

Screenshots from the real file

Who it is for

Online sellers on several marketplaces
Small shops still counting stock by hand
Anyone who wants the real profit of each product

What you get out of it

Know the stock of every item without counting
See real profit per sale and per channel
Never miss a reorder: low stock turns red
Know which products sell best

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean

DashboardTotal sales, total profit, units sold, low-stock items, best sellers and sales by channel

ProductsCode, name, category, cost, price, opening stock and reorder point; remaining stock, status and margin % are calculated

SalesPick product code, channel, quantity and discount; name, price, sales and profit fill in

Stock inRecord incoming stock; remaining stock updates at once

SettingsEdit product categories and sales channels

How to use it

In "Settings", edit categories and sales channels
In "Products", enter code, name, cost, price and opening stock
Log every sale in "Sales" and new stock in "Stock in"
Check profit and best sellers in "Dashboard"

What you receive

Excel file (.xlsx), 57 KB, ready to download right after payment
A Google Sheets link that makes your own copy in Google Drive, usable on mobile
Sample data on every tab so you can see how to fill it in, then replace it with yours
Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is Stock & Sales Template for?

Online sellers on several marketplaces; Small shops still counting stock by hand; Anyone who wants the real profit of each product

What's inside the file?

5 tabs: Dashboard, Products, Sales, Stock in, Settings, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet