FW

Filter Water Business System

SQLite-powered single-file system for sales, stock, shifts, and daily closing.

Default manager PIN: 1234. Change it from Settings after login.
FW

Filter Water ERP

Daily closing, shifts, stock, cash

Main
Operations
Finance & Reports
Database Engine
SQLite (browser local file)
Deploy as single index.html on Cloudflare Pages.

Dashboard

Today’s business summary and operational controls.

Today Sales

0
All paid sales for today

Today Purchases

0
Stock received today

Today Expenses

0
All expense entries for today

Estimated Cash In Hand

0
Sales - expenses - deposits

Open Shift Sessions

No open sessions

Today by Station

No data yet

Low Stock Alert

No low stock items

Quick Actions

Best practice: each station should always have one active session only. At end of shift, close it and hand over exact cash and stock details.

Create Sale

Live Sale Summary

Selected session employee—
Product stock0
Line total0
Payment typeCash
Sale is allowed only when there is an open session for that station and enough stock is available.

Recent Sales

Invoice Date/Time Station Employee Product Qty Total Payment Notes

Close Shift Session

Session Closing Preview

Choose a session to see summary

Closed Sessions

Session Station Employee Opened Closed Expected Cash Counted Cash Difference Status

Daily Closing Summary

Day Financial Summary

Generate report first

By Station

Generate report first

Stock Movement

Generate report first

Saved Daily Closings

Date Sales Expenses Purchases Expected Closing Cash Saved At Notes

Add Station / Base

Tips

Create one record for each sale point/base and one record for the main storage if you want day-end stock visibility by location.

Stations

NameCodeTypeStatusNotes

Add Employee

Employees

NamePhoneRoleStatusNotes

Open New Shift Session

Open Sessions

SessionStationEmployeeStartedOpening CashOpening StockStatus

Add Product

Products

NameCodeUnitPriceLow StockStatus

Record Purchase / Stock In

Recent Purchases

SupplierDateStationProductQtyUnit CostTotalNotes

Add Expense

Expenses

DateStationTitleAmountNotes

Current Stock by Station & Product

StationProductIn QtyOut QtyBalanceLow Stock

Stock Card

DateTypeReferenceInOutBalanceNote

Add Customer

Customers

NamePhoneTypeCredit Limit

Sales Summary

Range Totals

Choose dates and generate report

Top Station/Product

Choose dates and generate report

Detailed Report

DateStationEmployeeProductQtyAmountPayment

Export Full SQLite Backup

Download the full database as filter-water.sqlite.

Import Backup

Restore a previously downloaded SQLite file.

Manager PIN

System Tools

Factory reset removes all local data from this browser after confirmation.