automation scripts — Python: invoices, contacts, bank and files

Five Python automation scripts for the files freelancers and small sellers handle every week.

automation scripts — Python: invoices, contacts, bank and files
Example of the result this page gives you

Try it freeFull version · $29 once →

How it works
  1. Put your own numbers into the free version below — no sign-up.
  2. Your result shows up right here, as you type.
  3. Want to keep it, print it or do it again next time? That is what the full version adds — see "What you get".

What you get: Saved setups : keep a setup per client or per bank and open it with one click next time. · Weekly schedule : the exact Windows Task Scheduler command and the Mac or Linux cron line for your paths, plus a double-click launcher. · Undo for files : the rename script writes an undo log; one command puts every file back.

Published 2026-11-18 · ReadyStack

Try it freeFull version →

Made-up example, already run below: a freelance designer's invoices.csv with 12 invoices, checked on Nov 18, 2026. The overdue invoices script finds $4,910.00 unpaid past the due date on 6 invoices, $1,900.00 of it more than 60 days late, and drafts one reminder email per client. INV-1038 turns 31 days late on Nov 22, 2026. Another 3 invoices, $2,975.50, are not due yet.

Five Python automation scripts for the files freelancers and small sellers handle every week. Pick a script, drop in your own CSV or files, and see exactly what it will do before anything runs on your computer. Same rules every run, no AI guessing, nothing uploaded: the preview runs in this browser.

Free: any of the five scripts on your own file, every row, the whole result on screen. Pro: the Python script with your settings written in, the result files, saved setups and a weekly schedule. $29 once or $6.99 per month.

Your file and settings

Using the made-up example file.

Pro: take the script home and let it run every week

Pro: $29 once, or $6.99 per month. All five scripts.

Get Pro for $29 once Get Pro monthly · $6.99 / month

How the scripts decide

Overdue invoices: an invoice is open while the paid-on cell is empty (or, if your file has an amount-paid column, while amount minus paid is above zero). Days late = the check date minus the due date. Buckets 1-30, 31-60, 61-90 and 91+ days; "enters next bucket" is the date it moves up. One reminder per client lists all of that client's late invoices; past 30 days the wording is firmer, past 60 it is a final reminder. The script writes the drafts; it does not send email.

Duplicate contacts: emails are compared without spaces and capitals. The first row is kept and empty cells in it are filled from its duplicates. Rows without an email can be matched on the last 10 digits of the phone number.

Bank categories: the first rule whose words appear in the description wins. Money in without a rule is "Income (no rule)", money out without a rule is "Uncategorized", so you see exactly which rules to add.

Rename and sort files: names that would collide get -2, -3. The script shows the plan and changes nothing until you add --go; then it writes an undo log.

Split CSV: one file per value of the column you pick, with the same columns as the original, largest group first.

Amounts like $1,250.00, 1.250,00 € and (59.99) are read; dates as 2026-11-18, 11/18/2026 or 18.11.2026. The page and the Python file use the same rules; both were run on the same test files and gave the same answers.

This tool is 1 of 333 paid tools in English. All 333 with one key: Freelancer & Small Business Pass — $9.99/month · $79/year · Deadline reminders by email (free)

Email me this result
A copy of what you see above, in your inbox — the tool stays free, nothing here is locked.

More tools for the same work

automation scripts — Python: invoices, contacts, bank and filesStarter Vault for ObsidianYour weekly review, written from your notesFree versionautomation scripts — Python: invoices, contacts, bank and filesLinkedIn outreach toolsNote + 2 follow-ups, then dated remindersFree versionautomation scripts — Python: invoices, contacts, bank and filesAI Automation Workflows for Small BusinessFree versionautomation scripts — Python: invoices, contacts, bank and filesMonth-End Back Office for US Freelancers - Schedule C, 1040-ES, remindYour January 15 payment, with its IRS formFree version
People like you also use
Everything for Invoices and small business → · Video Summary & Notes · Client portal and CRM for freelancers · Email Marketing and Newsletters · ReadyStack Pass — every tool in one subscription · All tools →

Questions and answers

What does this page do?

Python automation scripts for freelancers and small sellers: overdue invoices with reminder drafts, duplicate contacts, bank transactions by category, rename and sort files, split a CSV per client.

Is it free?

Yes. The free version on this page works without an account. The full version ($29 once) adds: Saved setups : keep a setup per client or per bank and open it with one click next time. · Weekly schedule : the exact Windows Task Scheduler command and the Mac or Linux cron line for your paths, plus a double-click launcher. · Undo for files : the rename script writes an undo log; one command puts every file back.

How do I use it?

1. Put your own numbers into the free version below — no sign-up. 2. Your result shows up right here, as you type. 3. Want to keep it, print it or do it again next time? That is what the full version adds — see "What you get".

Ask about this tool

One question, answered by the person who built it. Your email only if you want the answer sent.

Privacy: your e-mail is used only to send you the answer. A question appears on this page only after it is answered, without your e-mail.

For a team or company: for an invoice with your company details, a quote or several licences, write to support@getreadystack.com.

Who is behind this page

ReadyStack is a small team. We build each tool for one job people keep asking about, from the rules and sources named on the page, and we run it on the worked example you see here before it goes live.

How we check our pages: each rule names its source and the day we read it.

Something looks wrong, or you are stuck? Write to support@getreadystack.com or use the contact form. It goes to our own inbox, not to a bot.

About ReadyStack

Your next step

More in Small business & payroll See all →