Financial Results

In \Automation\Reports\, Prelude Desktop can maintain a CSV file named FINANCIALRESULTS.CSV.
Production of FINANCIALRESULTS.CSV is controlled by the following DIAMOND.INI item:
AUTOMATIONFINANCIALRESULTS =Y/N.
Each record in the file will consist of the following fields:
CODE – Char(2) – The Prelude Desktop Company number
Stock – Number – FIFO stock valuation
TM0 – Number – T/O this month (so far)
PM0 – Number – Net Profit this month (so far)
FM0 – Number – Franchisor Revenue this month (so far)
TM1 – Number – T/O Month-1 (i.e. last calendar month)
PM1 – Number – Nett Profit Month-1
FM1 – Number – Franchisor Revenue Month-1
TMx – Number – T/O Month-x (i.e. last 12 months)
PMx – Number – Nett Profit Month-x
FMx – Number – Franchisor Revenue Month-x
TY1 – Number – T/O Year-1 (i.e. last year)
PY1 – Number – Nett Profit Year-1
FY1 – Number – Franchisor Revenue Year-1
TY2 – Number T/O Year-2
PY2 – Number Nett Profit Year-2
FY2 – Number Franchisor Revenue Year-2
TY3 – Number T/O Year-3
PY3 – Number Nett Profit Year-3
FY3 – Number Franchisor Revenue Year-3

TMn is sum of all sales invoices to franchisor in the franchisee company
PMn is net profit in the franchisee company (i.e. Prelude @PROFIT amount)
FMn is sum of all franchisor purchase invoices in the franchisee company – these will be product sales invoices and management & service invoices
Missing data (e.g. franchisee relatively recent) show zero
The Profit data will only be available for franchisees where the franchisor is providing their bookkeeping service. Flightdeck will have a flag indicating this.
All costs will be submitted via expenses – payroll, bills, van rental payments (non DD), etc.
This will be updated periodically (probably overnight)
It will be used to drive the franchise management screen which is a key component of the MyFlightdeck display.