---
title: "A/R Aging and Collections Letters (Python Script) | MCC"
description: "Aging report, weekly follow-up list and mail-merged friendly, firm and final reminder letters from an open-invoices CSV. Includes an NJ court reference."
url: "https://mcc-solutionsnj.com/bookkeeping/accounts-receivable-collections-python-script"
---

Paid script

# Accounts Receivable Collections Manager

Turn an open-invoices list into an aging report, a short weekly to-do list and ready-to-edit reminder letters, without sending anything automatically.

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

## Collections Manager

Buy this script on its own for $39, 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 [Automation Suite](/bookkeeping/automation-suite) includes this and 10 more tools for $99. 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

Export open invoices (customer, invoice, date, due date, amount, paid, email) to CSV. The script builds an **aging report** (current, 1-30, 31-60, 61-90, 90+), then a **weekly action list** following a friendly (about 7 days late), firm (about 30) and final-notice (about 60) sequence, skipping letters you have already logged as sent. It writes one **letter per customer** as text and printable HTML from templates you can edit. Letters stay factual and never threaten. The report also has a **New Jersey court reference**: Small Claims up to $5,000 and Special Civil Part up to $20,000 with the published filing fees, plus a warning when an invoice nears the 6-year contract statute of limitations.

FAQ

## About this calculator

**What do I need to run it?**

Python 3.9 or newer and a CSV of open invoices from QuickBooks, Xero, Wave or a spreadsheet. It runs on your computer and never sends email.

**Can I change the letters?**

Yes. Run it with --write-templates to get the friendly, firm and final templates as text files, edit them, and point the script at your folder.

**Are the court fees current?**

They come from the NJ Courts small claims and Special Civil Part guides revised July 2022. Confirm current fees with the court clerk before filing.

**Is this legal advice?**

No. It organizes your receivables and drafts factual reminders. Consumer debts have stricter collection rules; consult an attorney before escalating any balance.

See [all free tools](/free-tools). More free tools: [Weighted average calculator](/bookkeeping/weighted-average-calculator), [Vacation accrual calculator](/bookkeeping/vacation-accrual-calculator), [Leads needed calculator](/bookkeeping/leads-needed-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).

## Want your books and numbers handled?

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