---
title: "Automated Checkbook Register | MCC"
description: "A Python script that turns bank CSV exports into a categorized checkbook register with running balance, statement reconciliation, budget check and bill…"
url: "https://mcc-solutionsnj.com/bookkeeping/checkbook-register-python-script"
---

Paid script

# Automated checkbook register (Python script)

Import your bank export and let the script keep the register: new lines only, categorized, with a running balance. Then reconcile to your statement, check the budget and see which bills are coming.

[![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

## Automated Checkbook Register 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. The [Personal Finance Suite](/bookkeeping/personal-finance-suite) includes this and 3 more tools for $29. 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

Importing the same export twice adds nothing, so you can re-run it any time. Lines are categorized by your own rules first, then built-in ones, and check numbers are kept. **Reconcile** compares the register to your statement and, if they differ, searches for the exact set of outstanding checks or deposits in transit that explains the gap. **Summary** compares each category to a budget file. **Recurring** finds bills and paychecks that repeat and predicts the next date, and **forecast** projects your balance and warns before it drops below an amount you set. Your register is a plain CSV file you own. Pure Python, no installs, and nothing leaves your computer.

FAQ

## About this calculator

**Does it connect to my bank?**

No. You download a CSV export from your bank's website and the script reads it from your computer. That is the point: your login and data never go anywhere.

**What bank formats work?**

Any CSV with a date, a description and either one amount column or separate debit and credit columns. Common column names are recognized automatically.

**Is the forecast reliable?**

It is an estimate built from your own repeating bills and paychecks. It cannot know about one-off spending, so treat it as an early warning, not a guarantee.

**Is this financial advice?**

No. It is a record-keeping tool for general information.

**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: [compound interest calculator](/bookkeeping/compound-interest-calculator), [simple interest calculator](/bookkeeping/simple-interest-calculator). See [all free tools](/free-tools). More free tools: [MCC Financial Suite](/bookkeeping/financial-suite), [Retirement Monte Carlo Python script](/bookkeeping/retirement-monte-carlo-python-script), [MCC Automation Suite](/bookkeeping/automation-suite), 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)