Welcome to the release of Version 1 of our all-in-one Inventory & Invoicing System built using Google Sheets and Google Apps Script. This tool is 100% free, runs online, and requires no external hosting — making it ideal for small businesses and shop owners.
🎥 Watch the Demo Video
🌟 Why Use This System?
- Track inventory in real time
- Create and print invoices with your logo
- Secure login and forgot password feature
- Generate sales, profit, and inventory reports
- Easy to deploy and customize
💼 Who Is It For?
- Small shops and retailers
- Freelancers and local service providers
- Startups and home-based businesses
🚀 Features Overview
📊 Dashboard
See key metrics like sales, purchases, profit, and top-selling items with visual charts.
🧾 Invoicing
- Create new sales & purchase invoices
- Edit item quantities and prices
- Print invoices directly from the app
📦 Inventory Management
- Add/edit/delete items
- Set stock limits for low-stock notifications
- Upload product images
🔐 User Access
- Email-based login
- Forgot password feature with email reset link
📁 Reporting Tools
- Sales, profit & inventory reports
- Graphical insights and item breakdown
- Export to CSV for Excel or Google Sheets
⚙️ Custom Settings
- Set company name, logo, currency, and address
- Custom details appear on invoice printouts
📥 How to Get It
- Click the button below to access the download page
- Enter your email and choose any amount (free or donate)
- Follow the instructions provided with the file
- Deploy using Google Apps Script — no hosting required
📌 Updates & Support
We are working on Version 2 with more features including:
- Mobile optimization
- Multi-user support
- Enhanced analytics
For help and tutorials, watch our YouTube video or leave a comment on the channel.
🙏 Support the Developer
This system is free to use, but if it saves your time and helps your business, please consider supporting by donating any amount. Your support encourages us to keep building helpful tools for small business owners like you.
Made with ❤️ by Rony
Enter Code to Copy the Sheet
🚀 Don’t want to wait? Get instant access via Gumroad
How to add options to print invoice in excel or pdf
For pdf just save as pdf instead of print. For Excel we have to do little bit update in the existing coding.
Can You create a complete EMPLOYEE BASIC SYSTEM
1. Delegation
2. Checklist
3.Help ticket
4. Leave system
5. Attendance
In one web app
Yes , But in google sheet using app script it will get slow for large number of employee. If employee is large then we have to go for other platform.
maybe cashier can’t delete only the admin can do that, and much better there is a timestamp history changes of the user.
I ready Subscribe . Please send code please
Code already shared .
Watch the video you will get the code in the video.
Thanks very much.
Much love sir.
Thank You.
Code copy to sheet not working please help me
It should work. If not Please share the sheet.