Windows App: Single User Billing App with Wallet Management

Final Draft for Freelancer: Offline Billing and Wallet Management Application Project Overview We are looking to build a simple offline billing application for Windows OS. The app will be used on a laptop/desktop and will operate offline with no need for an internet connection. The user will log in with a unique ID and password, and the system will allow the creation of invoices, customer management, wallet management, and reporting functionalities. The application can be built either as a web app running on a local server or as a native desktop application, depending on cost and feasibility. Key Features User Authentication Single user with a unique ID and password. Secure login page for user authentication. Welcome Page (Dashboard) After login, the user will be directed to a welcome page with the following options: Create New Bill View Reports Manual Wallet Adjustment Billing and Invoice Creation Create New Bill: The user will input the customer mobile number: If the customer exists, an invoice will be created for that customer. If not, the customer will be registered in the system with the mobile number and the invoice will be created. Invoice Number: Generated as a combination of the current date and daily invoice count (e.g., 01082024/5 for the 5th invoice on August 1st, 2024). Product Details: For each product, the user will input the following fields: MRP (Maximum Retail Price) MCode (Product Code) Quantity Amount Payable per Product Reward Points Earned for the Product Auto Calculations: Total Rewards Earned Total Amount Before Discount Total Amount Payable Customer Total Savings (with and without rewards) Cost Price per Product Profit per Product Total Profit Draft Invoice Review: After entering all the products, the user can review the draft, edit or delete items if necessary. Wallet Deduction: The user can choose to subtract an amount from the customer’s wallet, ensuring the amount does not exceed the wallet balance (validation check). Final Invoice: The user confirms and submits the invoice for printing on an Epson TM-T82 thermal printer. Manual Wallet Adjustment The user can credit or debit a customer's wallet manually, entering the following: Customer Mobile Number Transaction Type (Credit/Debit) Amount Reason for the adjustment A validation check ensures that the debit amount does not exceed the customer’s wallet balance. Reports and Analytics The user will have access to various reports, with filters and export options (PDF, CSV, Excel). The available reports are: Daily Sales Report: View daily sales, total sales amount, rewards issued, wallet deductions, and profit. Invoice Report: Detailed view of all invoices created within a selected time range, with fields like Invoice Number, Date, Customer Mobile, and Total Amount Payable. Customer Transaction History: View all transactions for a specific customer, including rewards earned, wallet deductions, and balance. Profit Report: Tracks profits made over a period, with product-level details. Product-wise Sales Report: Shows sales and profits for each product. Customer Reward Points Report: Shows the total rewards earned by customers and their current wallet balance. Wallet Usage Report: Tracks wallet usage across invoices, showing how much customers deducted from their wallet balances. Pages Required Login Page User authentication with ID and password. Welcome Page (Dashboard) Provides access to "Create New Bill," "View Reports," and "Manual Wallet Adjustment." Create New Bill Page Enter customer mobile number (validate for new/existing customer). Enter product details and calculate totals (MRP, Quantity, Amount Payable, Rewards, etc.). Show draft invoice for review and edit. Wallet deduction feature. Submit and print invoice. Customer Wallet Adjustment Page Enter customer mobile number, select Credit/Debit, enter amount, and provide a reason for the adjustment. Reports Page Provides a list of reports available for selection (Sales, Invoices, Profit, Customer Rewards, etc.). Individual Report Pages For each report type, a page to display the report with filters (date range, product, customer, etc.) and export options. Invoice Print Page Display the finalized invoice with options to print on the thermal printer. Error/Validation Pages Display error messages or success confirmations (invalid login, wallet validation, successful transaction, etc.). Optional Add-ons Settings Page: For future configuration options. Customer Management Page: To view and manage customer data manually. Technical Considerations The app should work offline on a Windows-based machine. Local Storage: Use either local storage (for web apps) or a local database (for desktop apps) to store customer and invoice data. Epson TM-T82 Printer Integration: The app must support printing via this thermal printer. Deliverables Fully functional offline billing and wallet management application with the ability to print invoices. Access to multiple reports with filtering and export options. Clear documentation on how to install and use the application.