Mobile Power — Expense Analytic Shortcuts Walkthrough

Version: 1.0 Date: March 2026 Prepared by: Advance Insight Client: Mobile Power Flow: Analytic Shortcuts on Advances & Expense Reports


Expense Analytic Shortcuts Walkthrough

Expense reports (both Advances and Expense Clearing reports) include a set of analytic shortcut fields in the header. These let you tag the entire report with analytic dimensions — Hub(s), Department, Activity, Product Type, and Week — in one place, rather than setting them line by line.

When an Expense (Clearing) report is submitted, Odoo automatically copies these header values into the Analytic Distribution field on every expense line. This saves time and ensures consistent analytics across all lines in the report.

Field Type Analytic Plan Purpose
Hubs Multi-select Hub Which hub(s) the expense relates to
Department Single Department/Function The department incurring the cost
Activity Single Activity The activity or project category
Product Type Single Product Type The type of product being procured
Week Single Weeks The reporting week (for cashflow tagging)
Note: For Advance reports, the analytic fields are visible and editable — but analytic distribution is not applied to lines on advance submit. Analytics are applied when the linked Clearing report is submitted.

1Open the Advance or Expense Report

Navigate to Expenses → Expense Reports and open a report, or create a new one.

Expense reports list

2Fill in the Analytic Shortcut Fields

The analytic shortcut fields appear in the header section, just below the Advance residual amount line. Fill in as many or as few as needed:

All fields are editable while the report is in Draft state. Once submitted, they become read-only.

Advance report showing analytic shortcut fields

The example below shows an advance with two hubs (Afikpo 1 Ebonyi and Agbado Ekiti), Department set to Operations, Activity to Hub Management, Product Type to MOPO50, and Week to W11 2026.

Analytic fields filled in on the advance report

3Open the Linked Clearing Report

When clearing an advance, open the Expense (Clearing) report linked to the original advance. The analytic shortcut fields are pre-populated from the advance. You can adjust them before submission if needed — for example, if the actual expenses relate to a different hub than originally planned.

Clearing report with analytic fields pre-populated

4Review Expense Lines Before Submission

Before submitting, the individual expense lines do not yet have analytic distribution applied. The Analytic D... column is empty on each line.

Expense lines with no analytic distribution before submission

5Submit the Clearing Report

Click Submit to Manager to submit the clearing report.

Clearing report with Submit to Manager button

At this point Odoo applies the analytic distribution logic:

  1. Reads the header analytic fields (Hubs, Department, Activity, Product Type)
  2. Splits 100% equally across the selected hubs (the last hub absorbs any rounding remainder)
  3. Combines each hub share with the other analytic accounts into a composite key
  4. Writes the resulting distribution to every expense line on the report
Note: The Week field is stored on the report for reporting purposes but is not included in the analytic distribution written to expense lines.

6Verify the Analytic Distribution on Expense Lines

After submission, the Analytic D... column on each expense line now shows the full distribution — all selected analytic dimensions are visible as tags on every line.

Expense report after submission showing analytics applied to each line

With two hubs selected, each line shows a 50/50 split across both hubs, combined with the Department, Activity, and Product Type.

Expense lines showing the 50/50 hub split distribution applied

Distribution Examples

1 hub selected:

Analytic Key %
Dept + Hub A + Activity + Product Type 100%

2 hubs selected:

Analytic Key %
Dept + Hub A + Activity + Product Type 50%
Dept + Hub B + Activity + Product Type 50%

3 hubs selected:

Analytic Key %
Dept + Hub A + Activity + Product Type 33.33%
Dept + Hub B + Activity + Product Type 33.33%
Dept + Hub C + Activity + Product Type 33.34%

Rules Summary

Scenario Result
Analytics set on Advance report Stored for reference — distribution not applied on advance submit
Analytics set on Clearing report, no hubs 100% to single combination of Dept + Activity + Product Type
Analytics set on Clearing report, 1 hub 100% to Dept + Hub + Activity + Product Type
Analytics set on Clearing report, N hubs Split equally (100/N) across N hub combinations
No analytics set on clearing report Lines left unchanged