Total Revenueℹ

Total invoiced amount
SUM of extended_price from all line items in the selected period. Includes fuel, taxes, freight, and all charges.

—

Total Gallonsℹ

Volume of product shipped
SUM of quantity_shipped for non-tax line items. Excludes MF Tax and Charge lines which mirror fuel quantities for tax purposes.

—

Net gallons shipped

Gross Marginℹ

Revenue minus cost of goods
SUM of (price_unit − actual_cost_unit) × quantity_shipped. Represents the profit before operating expenses.

—

Ordersℹ

Distinct invoice count
COUNT of unique order numbers in the period. One delivery may have multiple line items but counts as one order.

—

Open ARℹ

Accounts receivable balance
SUM of open_amount from unpaid invoices (status not Cancelled/Voided). This is the total amount owed by customers.

—

Total outstanding

Avg $/Gallonℹ

Revenue per gallon
Total Revenue ÷ Total Gallons. Higher values indicate premium product mix or pricing power.

—

Revenue per gallon

12-Month Revenueℹ

Rolling annual revenue
Total revenue for the trailing 12 months from today. Not affected by the period selector.

—

Rolling 12 months

12-Month Gallonsℹ

Rolling annual volume
Total gallons shipped in the trailing 12 months from today.

—

Rolling 12 months

12-Month Marginℹ

Rolling annual profit
Total gross margin for the trailing 12 months. The percentage shows margin as a percent of revenue.

—

Revenue Run Rateℹ

Annualized projection
Current period revenue extrapolated to a full year. Based on the daily average × 365.

—

Annualized projection

Revenue & Margin Trend

Top Customers

Customer	Revenue	Open AR

Revenue by Location

Revenue by Product

Warehouse Performance

⌕

Warehouse ↕	Orders ↕	Qty/Gal ↕	Revenue ↕	Margin ↕	Margin % ↕	$/Gal ↕

Sales Representatives

⌕

Rep ↕	Code ↕	Orders ↕	Customers ↕	Qty/Gal ↕	Revenue ↕	Margin ↕	Margin % ↕	$/Gal ↕

Products

⌕

Product ↕	Line ↕	Orders ↕	Qty/Gal ↕	Revenue ↕	Avg $/Gal ↕	Margin ↕	Margin % ↕

LTM Gallonsℹ

Last twelve months volume
Total gallons for the rolling 12-month period.

—

Rolling 12 months

MTD Gallonsℹ

Month-to-date volume
Gallons shipped from the 1st of the current month through today.

—

QTD Gallonsℹ

Quarter-to-date volume
Gallons shipped from the start of the current quarter through today.

—

YTD Gallonsℹ

Year-to-date volume
Gallons shipped from January 1 through today.

—

Gallons by Month — 3-Year Comparison

Gallons by Product Line

Gallons by Warehouse

LTM Gross Profitℹ

Last twelve months margin
Total gross margin for the rolling 12-month period.

—

MTD Gross Profitℹ

Month-to-date margin
Gross margin from the 1st of the current month through today.

—

QTD Gross Profitℹ

Quarter-to-date margin
Gross margin from the start of the current quarter through today.

—

GP Per Gallonℹ

Margin efficiency metric
Gross Margin ÷ Total Gallons. Shows how much profit is earned per gallon sold. Key metric for fuel distributors.

—

Period average

Gross Profit by Month — 3-Year Comparison

GP by Product Line

GP by Warehouse

Current GP/Galℹ

Period GP per gallon
Gross margin per gallon for the selected date range.

—

Period average

MTD GP/Gal

—

QTD GP/Gal

—

YTD GP/Gal

—

GP Per Gallon by Month — 3-Year Comparison

GP/Gal by Product Line

Product Line	Qty/Gal	Margin	GP/Gal

GP/Gal by Warehouse

Warehouse	Qty/Gal	Margin	GP/Gal

Customer Analysis

⌕

Customer ↕	Orders ↕	Revenue ↕	Qty/Gal ↕	Margin ↕	Margin % ↕	GP/Gal ↕	Open AR ↕	Last Order ↕

Order Lookup

⌕

Invoice ↕	Date ↕	Customer ↕	Warehouse ↕	Product ↕	Line ↕	Qty ↕	Qty/Gal ↕	Price ↕	Cost ↕	Revenue ↕	Margin ↕	Rep ↕

Gross Profit by Brand

Gallons by Brand

Rebates by Month — Current Year

Rebates by Month

Rebates by Product Line

Rebates by Warehouse

Total Open AR

—

All outstanding

Current

—

Not yet due

Past Due

—

Open Invoices

—

Outstanding

Customers w/ Balance

—

Active accounts

Avg Invoice Age

—

Days outstanding

1–30 Days

—

Past due

31–60 Days

—

Overdue

61–90 Days

—

Critical

90+ Days

—

Seriously past due

Collections Activity (Last 30 Days)

Invoices Paid

—

Amount Collected

—

Top Past-Due Customers

Customer	Open Balance	Max Days Past Due	Invoices

Current

—

Not yet due

1–30 Days

—

Past due

31–60 Days

—

Overdue

61–90 Days

—

Critical

90+ Days

—

Seriously past due

All Open Invoices

⌕

Invoice # ↕	Customer ↕	Location ↕	Rep ↕	Amount ↕	Open ↕	Invoice Date ↕	Due Date ↕	Days Past Due ↕	Bucket ↕

Customers

⌕

Customer ↕	Location ↕	Rep ↕	Orders ↕	Revenue ↕	Qty/Gal ↕	Margin ↕	Margin % ↕	Open AR ↕	Last Order ↕

Revenue

—

Gallons

—

Weighted Margin

—

Weighted Margin %

—

Weighted GP / Gal

—

⚖ Sales Performance View — Margin uses weighted cost for sales reporting and hiring/firing decisions. The main Overview uses actual cost for accounting/financials.

Top Customers — Ranked by Weighted Margin

⌕

Customer ↕	Orders ↕	Revenue ↕	Gallons ↕	Weighted Margin ↕	Weighted Margin % ↕	Weighted GP/Gal ↕	Actual Margin ↕
Loading…

By Salesman — Ranked by Weighted Margin

Salesman ↕	Customers ↕	Orders ↕	Revenue ↕	Gallons ↕	Weighted Margin ↕	Weighted Margin % ↕	Weighted GP/Gal ↕
Loading…

Top Products — Ranked by Weighted Margin

⌕

Product ↕	Line ↕	Orders ↕	Revenue ↕	Gallons ↕	Weighted Margin ↕	Weighted Margin % ↕	Weighted GP/Gal ↕
Loading…

Strategy:

Classifies by fixed days since last order: At Risk 30–60d, Stale 61–90d, Inactive 91+d

At Risk

—

Stale

—

Inactive

—

Total At-Risk Revenue

—

— customers · click for all

At-Risk Margin (Actual)

—

All At-Risk Customers

⌕

Customer ↕	Rep ↕	Location ↕	Last Order ↕	Days Since ↕	Avg Cadence ↕	Orders 12M ↕	Revenue 12M ↕	Margin 12M ↕	Tier ↕	Contact

Open Invoices

Invoice	Date	Due Date	Amount	Open	Status

Product Mix

Product	Qty/Gal	Avg Price

Order History

⌕

Invoice	Date	Location	Qty/Gal	Amount	Open	Status

👋

Welcome!

Your account has been created but hasn't been assigned access yet.

Next Steps

Please contact your manager or IT department to request dashboard access. They will assign the appropriate role for your position.

Logged in as:

Account status: Pending Approval

PDF Reports

Formatted reports for executives and staff. Uses the current time period and location filter.

Total Open

—

0–30 Days

—

Current

31–60 Days

—

Aging

61–90 Days

—

Overdue

91–120 Days

—

Critical

121+ Days

—

Seriously past due

AR Aging Report

⌕

Customer ID	Company	P	Type	Invoice #	Trx Date	Due Date	Open Amt	0–30	31–60	61–90	91–120	121+	Unapplied
Loading…
TOTALS

Total Value

—

Total Items

—

SKUs in stock

Total QOH

—

Adj gallons

Product Lines

—

Categories

Inventory Valuation

⌕

Description	Part Number	Product Line	Vendor	Warehouse	QOH	Unit Cost	Total Value	Repackaged	Adj Gal
Loading…
TOTALS

Total Revenue

—

Total Gallons

—

Card lock dispensed

Gross Margin

—

Transactions

—

Customers

—

Avg $/Gal

—

Card lock price

Top Customers

⌕

Customer ↕	Transactions ↕	Cards ↕	Gallons ↕	Revenue ↕	Margin ↕	$/Gal ↕

By Product

Product ↕	Transactions ↕	Gallons ↕	Revenue ↕	Avg $/Gal ↕	Avg Cost ↕

By Card Lock Location

Location ↕	Transactions ↕	Cards ↕	Gallons ↕	Revenue ↕	Avg $/Gal ↕

Recent Transactions

⌕

Date	Card #	Customer	Location	Product	Gallons	$/Gal	Amount	Invoice

Tank Levels by Customer

⌕

Needs Delivery Only

Customer ↕	Location ↕	Product ↕	Tank # ↕	Capacity ↕	On Hand ↕	% Full ↕	Daily Use ↕	Days Supply ↕	Next Delivery ↕	Status

Stock on Hand

⌕

Active only

Dispatch

⌕

Truck Inventory

⌕

Branding & Identity

⛽

Company Name

Product Name

Primary Color

Secondary Color

Logo: PNG, JPG, or SVG · max 500KB. Colors apply to accent elements and sidebar.

Appearance

Theme

Switch between dark and light interface

Database Connection

Configure the ODBC connection to the VS Petroleum SQL Anywhere database. All queries are read-only.

ODBC DSN

Server Name

Database Name

Username

Password

Not tested

General

Session Timeout (min)

Brand/Vendor Column

Used for Brand Breakdown and Rebate Splits pages

Authentication

Auth Mode

AD Server

Domain

Base DN

Default Role for New AD Users

Uses LDAP port 389 with SIMPLE bind (user@domain). New AD users get auto-created on first login with the default role above. Requires pip install ldap3 on the server.

Two-Factor Authentication (MFA)

Require MFA for All Users

When enabled, users without MFA will be prompted to set it up on their next login

Authenticator App Issuer Name

Displayed in authenticator apps (Google Authenticator, Microsoft Authenticator, Authy)

Login Security

Account Lockout & IP Rate Limiting

Lock accounts after repeated failed sign-ins and throttle abusive IPs. Strongly recommended for internet-facing deployments.

Per-Account Lockout

Max Failed Attempts

Fails before lock

Window (Minutes)

Rolling window

Lock Duration (Min)

How long locked

Per-IP Rate Limit (across all usernames)

Max Failed Attempts

Fails per IP

Window (Minutes)

Rolling window

Lock Duration (Min)

How long blocked

Tip: When IIS or another reverse proxy fronts this app, the per-IP limiter reads the client address from X-Forwarded-For. Make sure the proxy strips any inbound XFF header from untrusted clients before forwarding. Locked users can be cleared from Users via the Unlock button.

Cookie & Session Security

Behind Reverse Proxy (IIS / nginx)

Enable when IIS or another reverse proxy sits in front of Flask. Tells the app to trust X-Forwarded-For and X-Forwarded-Proto for client IP and HTTPS detection. Leave OFF for direct localhost development.

Secure Cookies (HTTPS only)

Enable once SSL/HTTPS is in place. The session cookie will only be sent over HTTPS. If you enable this on plain http://, you will be unable to log in.

SameSite Policy

Lax allows top-level navigation; Strict blocks all cross-site sends.

Session Timeout (Minutes)

Idle session expires after this many minutes.

Default to "Remember Me" on Login

When OFF, sessions end when the browser closes. Recommended OFF for internet-facing portals.

Note: The HttpOnly cookie flag is always on (cannot be disabled). Some changes (e.g. ProxyFix, SameSite) take effect on the next request, but a service restart is recommended after changing these settings to fully apply.

Audit Log Retention

Auto-Purge Old Audit Entries

Automatically delete audit log entries older than the configured retention window. Runs lazily when the app handles requests.

Retention (Days)

Entries older than this are deleted.

Check Frequency (Hours)

How often to run the purge check.

View / manage: The full audit log is at Admin → Audit Log, where you can filter, export to CSV, and trigger a manual purge.

Email & Alerts

Email Notifications

Enable email to send scheduled reports and AR alerts

Email Provider

SMTP Host

Port

Username

Password

From Address

To (comma-separated)

AR Aging Alerts

AR Alerts Enabled

Email when invoices hit 30, 60, or 90 days past due

30-day alert 60-day alert 90-day alert

Windows Service

Run as a Windows Service for automatic startup, background operation, and crash recovery.

Checking…

Requires Administrator privileges and pywin32 installed.

About

ApplicationFuel Intelligence v1.0

DatabaseSQL Anywhere via ODBC

Port5200

Built by Paradigm Technologies

Unsaved changes · click Save All to apply

Portal Settings

Configure your branding, customer experience, and user defaults. Changes apply immediately across the app.

Brand

Your company identity. Used throughout the app, the customer portal, and on reports.

Auto-detect from your website

Enter your homepage URL and we'll detect your company name, theme color, and logo. You can edit the results before saving.

Company name

Primary color

Buttons, links, and accents

Secondary color

Charts and secondary UI

Logo

PNG, JPG, or SVG. Up to 500KB. Shown in the sidebar, login pages, and emails.

Customer login page

A public-facing login at /portal. Link to this from your main website.

Headline

Subtitle

Support text

Shown below the sign-in card. Line breaks supported.

Self-service options

"Forgot password" link Sends a request to your admin email "Request portal access" link Sends a request to your admin email

Admin notification email

Password reset and access requests are delivered here for manual review. Falls back to your SMTP "To" address if blank.

Sign-out redirect (customers)

Where customer users land when they sign out. Leave blank to return them to the customer login page. Typically your main company website.

Background image

Optional. Shown behind the login card with a light overlay. Use a photo from your website — a truck, refinery, or branded image works well. JPG or PNG. Up to 2MB.

Customer portal (after login)

What customers see on their My Account page after signing in.

Welcome banner

Optional greeting at the top of My Account.

Headline

Accent color

Subtitle

Sales rep contact card

Rep is pulled from the user record matching the customer's salesman code. Configure a fallback for customers with no assigned rep.

Show sales rep card on the customer portal

Fallback name

Fallback phone

Fallback email

Quick links

Tiles shown to customers above their KPIs.

Icon	Label	Type	Target

Announcement banner

A dismissable message shown at the top of the app. Users see it until they dismiss. Clearing the message hides the banner.

Message

Style

Audience

Default landing pages

Where each role lands after signing in. Individual users can override this from their user menu.

User Management

Username	Full Name	Role	Rep Code	MFA	Status	Last Login

Audit Log

Security & activity events. Used for incident review and compliance.

Total Entries

—

Showing

—

Oldest Entry

—

Retention

—

Filter Limit

Timestamp	User	Action	Detail	IP
Loading…