FFA

Accounts Department Dashboard

This dashboard loads when a user with ‘accounts’ authority logs in. This typically refers to finance staff responsible for invoicing, payment tracking, and revenue analysis.
Each user will see all financial data (not restricted to their own entries).
The general filters defined in section 1 above apply.
The default time span selected will be ‘this month’.
Apply predictive analysis where applicable – normally this applies to charts (e.g., revenue trend forecast).

This would be a bit the same as the existing report we already have for Invoice and Payment.

 All reports should be able to filter by the following where applicable:

• Transport Mode: Ocean / Air (multi-select)
• Shipment Type: Import / Export (multi-select)
• Client(s) (multi-select search)
• Vessel (search)
• Custom Date Range (ETA)
• Custom Date Range (ETD)

Note: Default filter selection = Current Month (based on ETA).

Income / Revenue¶

KPIs (Import vs Export split)

• Total Revenue (MUR).
• Revenue Growth % - (MoM (Month-over-Month) and YoY (Year-over-Year) change in revenue.
• Total Invoices Issued (#) – Import vs Export split.
• Total Payments Received (MUR)—Import vs. Export Split.
• Total Outstanding (MUR)—Import vs. Export Split.
• Provision for Bad Debt Amount (Invoices >120 days overdue)

Charts:

• Line Chart: Revenue trend over selected period —you should be able to filter by shipment type.
• Forecast Line: Predictive revenue for the upcoming period.  (Merge the revenue trend with the predictive revenue in one single chart.)
• Bar Chart: Revenue by Client.
• Stacked Bar Chart: Revenue by Service (Freight, Clearing, etc.)
• Stacked Donut Chart/Pie Chart - Invoices by Payment Status (Paid / Partial / Unpaid)
• Column Chart: Number of invoices by service—you should be able to filter by Shipment Type.

Income Table:

• Total Income
• Income per Client
• Income per Shipment Type
• Income per Service
• Period-over-Period Comparison (MoM, YoY)

Invoice Table:

• Invoice Ref
• Invoice Date
• Service – freight, clearing, transport, etc.
• Shipment Type (Import/Export)
• Client Name
• File Ref
• HBL Ref
• Amount (MUR)
• Amount (FCY)
• Exchange Rate
• Paid Status – Paid/unpaid/partially
• Due Date
• Total Paid (MUR)
• Total Due (MUR)
• Days Overdue

Payment Table:

• Payment Ref
• Invoice Ref
• Last Payment Date
• Client Name
• Transaction Type – Cash, Cheque, etc...
• Paid Status
• Amount Received
• Currency
• Outstanding Amount
• Associated Invoice(s)
• Due Date
• Paid Date
• Days overdue for Outstanding payment