Back office with spreadsheets
Stock, income, customers and documents in one trusted place — no expensive software
Lessons (in order)
- 01Designing spreadsheets that don't break Separate input and summary sheets, one row per event, never type over formulasBasics · 6 min
- 02Stock that updates itself and warns before running out Product table + movement log + reorder point = know what to order before it's goneHands-on · 7 min
- 03Income and expenses in 5 minutes a day Log little but completely: date, type, category, channel, amount — let formulas summarizeBasics · 5 min
- 04A small customer database you will actually use Keep only what you need, track the next follow-up, respect personal dataHands-on · 6 min
- 05Sales documents: quotation, invoice, receipt When each document is used, what it must state, and how a tax invoice differs from a receiptHands-on · 6 min
Free tools to use alongside
Hands-on
Ask and share in this path's community room
Go to the room →Go further when ready
Related templates
- Stock sheet with low-stock alerts · Excel / Google SheetsAwaiting real-use test
- Small-shop income & expense ledger · Excel / Google SheetsAwaiting real-use test
- Quotation + invoice (VAT / withholding) · ExcelAwaiting real-use test
- Small CRM in Notion · Notion (CSV import)Awaiting real-use test
- Sales dashboard (Looker Studio) · Looker Studio template + source sheetOutlined
E-book
Back Office with Spreadsheets
Stock, books, customers and documents you can set up in a week
Outlined
Course
A Back-Office System in Google Sheets
Build your own working stock, books, customer and document system
Outlined