AT Truong Dinh Anh Tu

Home / Python Automation / FP&A Demo

Featured runnable demo · Synthetic evidence

One Python run turns raw FP&A data into a management-ready monthly pack.

Watch the end-to-end workflow, inspect each generated file, then download the runnable package to reproduce it. The example uses fictional June 2026 data and keeps reconciliation controls visible throughout.

Download runnable package Watch the workflow
360

synthetic rows processed

3

management outputs created

4/4

automated controls passed

0

company records exposed

Video walkthrough

See the raw file become a finance review pack.

End-to-end screen recording
Public-safe demo

Raw Excel input → Python validation and calculations → Excel analysis and Word report.

Decision first

The automation shortens preparation while keeping the management question visible.

Decision supported

Where did performance move, why did profit conversion change, and who owns the next action?

The generated pack organizes actual-versus-budget performance by region and highlights revenue, gross margin, OPEX, and EBITDA signals for finance review.

Synthetic June result

Revenue +7.8% vs budget, but gross margin -1.3pp.

That combination directs the conversation toward pricing, freight, and product mix rather than treating topline growth alone as success. The figures are illustrative, not measured business impact.

01Read

Load 360 synthetic transaction rows from Excel.

02Validate

Check required fields, dates, regions, and product mappings.

03Transform

Standardize fields and calculate FP&A measures.

04Analyze

Build regional variance tables, chart, and tie-outs.

05Report

Draft an executive readout with actions and owners.

Inspect the evidence

Download the input, then generate each output locally.

Input ships · Output stays local

sample_data/data-raw.xlsx

Unformatted input with 360 fictional transaction rows.

Download input

output/clean-data.xlsx

Standardized dimensions and calculated FP&A measures.

Generated on run

output/variance-analysis.xlsx

Regional bridge, visual summary, and four PASS controls.

Generated on run

output/monthly-report.docx

Management summary, risks, actions, owners, and timing.

Generated on run

Run it yourself

The package is arranged for a repeatable local run.

Python 3.10+

Control and review

Automation handles preparation; finance retains accountability.

Source-to-output tie-out

Row counts plus actual and budget revenue totals reconcile back to the raw workbook.

Mapping exceptions

Unexpected regions, dates, and product codes stop the workflow instead of passing silently.

Human approval

A finance owner reviews unusual drivers, recommendations, and distribution before release.