Contact person: Simple Accountancy Web Software (Laravel)

Phone:Show

Email:Show

Location: Berlin, Germany

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Goal:
We currently manage all ticket sales, dues tracking, and reporting in Google Sheets. We want to migrate this into a secure, web-based Laravel application where the input fields match our existing sheet columns exactly.
Before starting, please review the provided Google Sheet (attached).

Sheet Structure Overview
Sells report DTT – Ticket sales from vendor DTT.


Columns: Date, Invoice No., HC No., Cash/Bank, Filekey, Passenger Name, Airline, Qty, Buying Price, Selling Price, Profit, Ticket By Office, W Done (staff).


Sells report OTH – Ticket sales from vendor OTH.


Columns: Date, Filekey, Hallo Cash No., Cash/Bank, Passenger Name, Airline, Qty, Buying Price, Selling Price, Profit, W Done (staff).


All Client DUES – Tracks outstanding dues for clients and agents.


Columns: Ref No., Filekey, Client Name, Selling Price, Paid Amount, Due Amount, Date, Remarks, Payment Method.


Agent-specific sheets (e.g., Grace Travels, AG S&A Shop, Khan Travels, etc.).


Contain filtered sales records for each agent.



Business Rules
Vendors: DTT and OTH – we buy tickets from them.


We sell to normal clients and agents with full payment and with due payment


Dashboard profit = selling price − buying price.



User Roles
Admin


Full system access.


Manage users, settings, and data.


Create Staff id edit report


Staff


Enter sales and payments.


View dashboard.


Send manual reminders.


Manage dues list.



Main Features
Sales Entry


Add tickets with fields matching the Google Sheet columns.


Profit auto-calculated from selling price − buying price.


Dues Tracking


Due = total sales − total payments.


Central dues list showing all outstanding amounts.


Payment entry: party, date, amount, method, reference.


Dashboard


Shows current month profit.


Total agent dues & total client dues.


Top overdue agents/clients.


Recent payments list.


Date range/month filter.


Quick stats: total tickets sold, total sales amount, overdue accounts count.
.



Export & Filters


Filter data by date, party, type, etc.


Export filtered results to:


PDF


Googesheet,Excel/CSV

Agent Profile Page (Admin/Staff only)
Visit any Agent profile to see:


Current due (computed from sales/payments).


Sales list and Payments list (filterable).


Actions on Agent profile:


Send current due by email to Admin (single-click; include summary & PDF attachment).


Download Agent Due PDF (summary + itemized list for the selected filter/date range).


Export filtered lists to PDF/CSV/XLS.




Other Requirements
Laravel 11, MySQL or PostgreSQL.


Secure login system.


Daily scheduled reminder job.



Deliverables
Full source code.


Database migrations & seed data.


Installation instructions.


One round of bug fixes post-handover." (client-provided description)