iWRS

The Problem

My family runs a small business, and for years, everything was tracked on paper. Every order was handwritten in notebooks. When it came time to check who hadn't paid, someone had to manually flip through pages of scribbled orders, cross-reference payment records, and hope nothing was missed.

I got tired of seeing our employees waste hours on something a database could handle in seconds. So I built a system to fix it. (Read the story about moving from notebooks to databases)

What I Built

I started by digitizing everything into Excel, then migrated to a MySQL database with a Laravel web app to manage the full order lifecycle: order intake, statement generation, payment tracking, and reporting. (Excel to MySQL insight post soon.)

The invoice module lets you pick any date range and instantly see all orders (paid and unpaid) for that period, with calculated remaining balances. No more manual arithmetic or hunting through old notebooks. Just select your dates, and the system does the rest.

What It Does

• Order Management — Track every order from creation to fulfillment, with full audit trails
• Custom Invoice Generation — Pick a date range and generate statements showing all orders with payment status and remaining balances
• Payment Tracking — See outstanding balances and payment history at a glance
• Performance Dashboard — Visualize revenue trends, order volume, and team metrics in real-time

The Result

What used to take hours now takes seconds. The business has a single source of truth for orders and payments. No more lost orders, no more missed invoices. And the business can finally focus on actual operations instead of drowning in paperwork.

More screenshots soon.