Retail Business Management System

Job ID: 39506018

Budget: $250 – $750 AUD

Core Features Summary
Admin Panel
Create and manage shops.

Create and assign investors to shops (%-based profit).

Create vendors and assign them to categories.

Add products with purchase price and optional barcode.

View all sales, vendor dues, profit reports (shop-wise and consolidated).

Receive cash from shopkeepers and log it (deduct from profit/cash in hand).

Add expenses to any shop (visible to investors, affects profit).

Upload PDF receipts for bank transfers to investors.

Shops
Each shop has:

Sales by category (handled via sheets).

Vendor tracking (dues, paid).

Profit tracking.

Cash & bank separation.

Expense tracking.

Investor Panel
View shops assigned with % share.

See their share of sales and profits.

When admin pays profit: update wallet, upload PDF, reduce profit share.

Categories (Sheets)
Each category functions differently:

1. Transaction-Based Category
Shopkeeper enters:

Transaction amount

Rate

Charges

Vendor side:

Auto-applies same transaction with vendor rate

Auto-calculate:

Per transaction profit: ((sales rate - vendor rate) * quantity) + charges

Vendor due

Reports:

Daily sales, vendor dues, total profit

2. Wallet-Based Category
Admin/shopkeeper funds the wallet (becomes vendor due).

Product list has purchase price.

On sale:

Shopkeeper enters sales price

Purchase price deducted from wallet

Profit = Sale price – Purchase price

Wallet balance affects vendor due

3. Fixed Product Category
Predefined products with purchase price.

Shopkeeper enters sales price only.

Profit = Sale price – Purchase price

Vendor due shows accordingly

4. Service/Open Category
Shopkeeper adds service with/without purchase price.

If no p.price → 100% profit

If p.price → Vendor due shows

Open/free format

Sales Management
Entry types: Cash or Bank

Bank entries auto-add to wallet (in wallet-based categories)

End-of-day sheet:

Total sales

Vendor dues

Profit

Cash in hand

Admin received cash from shopkeeper: logs and deducts from cash/profit

Reports Needed
Summary & Detail reports:

Sales (all categories, date-wise)

Vendor due (total and paid)

Profit (shop-wise, investor-wise)

Cash in hand (after vendor payments and cash received by admin)

Expense reports (visible to admin and investor)

Minimal Interface (Simple Sheet-Like Format)
List view per category

Daily entry format

Filters: Shop, Date, Category, Vendor, Investor
Related categories: PHP Website Design Software Architecture MySQL HTML