Ledgers and recordsFree tool
Free Excel templates: credit ledger, cash book, stock, customer list
Formatted Excel templates with summary boards and formulas for a credit ledger, cash book, stock, customers and a price list.
Stock and credit tracking for grocery shops
In a small grocery, corner shop or greengrocer the daily work is usually three things: knowing what is left, not forgetting who owes how much, and getting the day’s cash to add up. This page gathers the free tools on this site for those jobs and says plainly what they do and what they do not.
In short
- They do: look up price and stock by barcode from your own product list, keep customer credit per customer, print the day’s income and expenses, and print shelf labels.
- They do not: issue fiscal receipts; they are not a barcode checkout, a cash register, a scale link or an e-invoicing link.
- No account is needed; the data does not go to a server, it stays in the browser of the device you use (take backups).
Five tools for the job
All are free and need no account. The credit ledger, the cash book and the barcode tool install on a phone or a computer like an app.
Ledgers and recordsFree toolInstalls as an app
Barcode scanner and stock lookup (with your phone camera)
Load your product list; scan a barcode and the price and stock appear.
Ledgers and recordsFree toolInstalls as an app
Digital credit ledger: track debts and payments
Write customer debts, see balances, remind on WhatsApp and back everything up.
Ledgers and recordsFree toolInstalls as an app
Daily cash book: income, expense and end-of-day cash
Enter the day’s income and expense; see carried-over, end-of-day cash and the monthly difference.
Posters and labelsFree tool
Shelf price label template: 12 or 24 labels per A4
Type products and prices, print cut-out price labels on A4.
A day’s routine
- Morning: load the stock template or your product list into the barcode tool; scan a product with the camera to see its price and stock.
- During the day: update the stock with “− 1” as you sell and “+ 1” as goods arrive; write a customer who takes credit into the credit ledger.
- Evening: for a customer who owes, open a ready message with “Remind on WhatsApp” (you press send); write the day’s income and expenses into the cash book and see the closing cash.
- When needed: print shelf labels on A4 when prices change; work out a new product’s price with the margin calculator.
Limits to know about
- They issue no fiscal receipts: you need the device or system that documents your sales for tax purposes (a cash register, e-invoicing); these tools do not replace it.
- The data sits on one device: if you clear the browser data or change phones, the records are gone. Move them to another device with the backup file; there is no live sync.
- No several users, no several branches, and stock does not drop by itself at a sale; the barcode tool is a lookup and simple stock counting.
- No scale link and no barcode label printing; the shelf-label template has no barcode for now.
- The cash book is a personal tracking book, not an accounting record, an invoice or a tax return. A customer’s name and phone in the credit ledger are personal data and keeping them safe is your responsibility.
Frequently asked questions
Do I need to install something or open an account?
No. The tools open in the browser. The credit ledger, the cash book and the barcode tool can also be added to a phone’s home screen and used like an app.
Can I use these instead of my cash register?
No. They are for stock, credit and closing-cash tracking; to document your sales you keep using your own cash register or whatever system the regulations require.
Is my data sent anywhere?
No. Records stay in your device’s browser, which is why regular backups matter. In the credit ledger the backup file contains customer names and phones, so keep it safe too.
How do I prepare my product list?
Fill in the stock template among the free Excel templates; its “Export to the barcode tool” sheet puts the list into the form the barcode tool accepts.
My business grew and I need more?
If you need several users, several branches or a flow of your own, we can look at it as custom software. I do not have a ready-made grocery software; we settle the need in a conversation.
Need more than this?
I can visit clients at their workplace in Bursa for in-person requirements discussions. We first identify existing records and workflows, then agree on scope and delivery.
All free tools · Custom software: web and desktop tools
Describe your requirements