How to track daily sales without a POS system
New cafe and restaurant owners often try to manage daily sales manually using spreadsheets to avoid buying a POS system right away. Without a proper setup, it becomes confusing to keep track of daily figures and handle inventory reordering effectively.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
- 1Using Excel
- 2Using Google Sheets
- 3Using other tracking tools
- 4Keeping records manually
- 5Using Excel or Google Sheets
- 6Keeping sales tracking manual
- 7Using cheap plug-in card readers like SumUp to track sales and cash
- 8Relying on employees to manually report what materials they use
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“One thing I’m particularly confused about is keeping track of daily sales. I don’t wanna get a POS right away, so for those of you who already run cafes/restaurants, how do you manage this?”source ↗
“I have hundreds of small fittings that I need to keep track of for reordering purposes. I am currently using the inventory program through QBO but would like to start scanning a bar code to help keep a better eye on things as employees aren't very good at telling me what they use.”source ↗
“I'm not interested in buying a whole new inventory program, so I need something that will work with QBO.”source ↗
“One thing I’m particularly confused about is keeping track of daily sales. I don’t wanna get a POS right away, so for those of you who already run cafes/restaurants, how do you manage this?”source ↗
Where this came up
People with this problem also raised
- 7Simple offline accounting software without monthly subscriptions
- 2Simple expense tracker with no extra features
- 5Tracking business and personal finances without full accounting software
- 3How to get new sales when referral networks dry up
- 4Taking over bookkeeping with no records or account logins
- 2How to track historical data in CRM without a data warehouse