---
title: "Financial Statements Python Script | MCC"
description: "A Python script that turns a trial balance CSV into monthly P&L, balance sheet, indirect cash flow, ratios and variance flags. Runs on your computer."
url: "https://mcc-solutionsnj.com/bookkeeping/financial-statements-python-script"
---

Paid script

# Financial Statements Builder Python script

Give it a monthly trial balance and get a profit and loss, a balance sheet, an indirect cash flow statement that reconciles to your cash, ratios, and a list of what moved.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Paid script

## Financial Statements Builder Python script

Buy this script on its own for $19, one time. No membership needed. It runs on your own computer and nothing you enter leaves it. Read how it works and the questions below first.

The [Financial Suite](/bookkeeping/financial-suite) includes this and 9 more tools for $49. Members get this included. [See the membership](/membership) or [sign in](/membership/login). Already bought it? Email me my access link.

How it works

## How it works

The script checks first that **assets equal liabilities plus equity plus cumulative net income** in every month and warns you plainly if they do not. Then it builds the monthly P&L with margins, the balance sheet, an **indirect-method cash flow** that must reconcile to the actual change in cash, working-capital and margin ratios, and month-over-month flags for accounts that jumped by more than the percent and dollar amounts you set. Pure Python with no installs.

FAQ

## About this calculator

**What does the input file look like?**

A CSV with period, account, type and amount. Types are cash, ar, inventory, fixed_asset, accum_depr, ap, long_term_debt, equity, revenue, cogs, expense and a few more, all explained in the script. A demo shows an example.

**What if my trial balance does not balance?**

The report starts with a warning showing the gap for each month. It is better to find the problem than to build statements on it.

**Is this a substitute for my accountant's statements?**

No. It is a tool for building working statements from your own numbers. Have a professional review anything you give to a lender, investor or tax authority.

**Is anything saved?**

No. The math runs in your browser and nothing you enter is sent to us.

**Is this tax or financial advice?**

No. It is a calculator for general information. Check the numbers against your own records, and ask an accountant before you act on them.

Related: [dupont analysis calculator](/bookkeeping/dupont-analysis-calculator), [operating cash flow ratio calculator](/bookkeeping/operating-cash-flow-ratio-calculator). See [all free tools](/free-tools). More free tools: [Cash conversion cycle calculator](/bookkeeping/cash-conversion-cycle-calculator), [Contribution margin calculator](/bookkeeping/contribution-margin-calculator), [Retained earnings calculator](/bookkeeping/retained-earnings-calculator), or [see all free tools](/free-tools).

Free

### Month-End Close Checklist (PDF)

The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.

General information, not tax or legal advice. [How we write and check our tools](/editorial-standards).

Python scripts

### Bookkeeper's Python Starter Scripts

Three small, readable Python scripts that do chores bookkeepers repeat by hand, with sample files so you can see each one work before using your own data.

[See what is inside ($39)](/toolkits/bookkeeper-python-scripts)

## Want your books and numbers handled?

[Free health check](/bookkeeping/health-check)[Call (908) 444-6373](tel:+19084446373)