Client desk: (908) 444-6373 · Text us · booking@mcc-solutionsnj.com Online 7AM–9PM ET daily · Mobile Mon–Sat · ← MCC Solutions home
MCCMCC Solutions Account Bookkeeping

Paid script

Books Audit Python script

One file you run on your own computer. Feed it a ledger CSV (and a bank CSV if you have one) and get a plain-English report of what deserves a second look.

Intuit ProAdvisor Gold tier badgeGold tier in Intuit's ProAdvisor program. See my Intuit listing

Paid script

Books Audit 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.

Prices plus sales tax where applicable, calculated at checkout from your billing address.

The Financial Suite includes this and 9 more tools for $49. Members get this included. See the membership or sign in. Already bought it? Email me my access link.

How it works

How it works

The script is pure Python with no installs. It runs eight checks: possible duplicates, a Benford first-digit test with a chi-square p-value, robust outliers by vendor using the median and MAD, amounts just under an approval limit, weekend and month-end timing, vendor names that look like the same vendor, bank-to-ledger reconciliation including split deposits, and a Monte Carlo cash runway that resamples your own past months. It reads CSV exports from any accounting system, and a built-in --demo shows the report on sample data first. Flags are reasons to look, never proof of a problem.

FAQ

About this calculator

What do I need to run it?

Python 3.9 or newer. There is nothing else to install, and the data never leaves your computer.

What file format does it read?

CSV exports with a header row: a date, a description or payee, and either one amount column or debit and credit columns. Common column names are recognized automatically.

Is a flag proof of fraud or an error?

No. These are statistical screens. A flag means look at the transaction, and most have ordinary explanations.

Is this audit or accounting advice?

No. It is a general-information tool. It does not replace a bookkeeper, accountant or auditor.

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: npv irr payback calculator, altman z score calculator. See all free tools. More free tools: Economic order quantity (EOQ) calculator, Rental yield and gross rent multiplier calculator, Mortgage payment calculator, or see all 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.

New Jersey deadlines and rule changes, by email

A short email when a deadline is coming up, a rule changes or we add a free tool. A few a month at most, and you can unsubscribe any time.

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)

Want your books and numbers handled?

Free health checkCall (908) 444-6373

Rather talk first? Leave your number and we'll call you.

CallTextFree health check