A Python script that turns your bank's CSV statement into the import format your accounting program expects

Example result

python merge_sales.py --month 2026-10

2026-11-02 09:14:03 INFO  Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO  shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO  shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN  shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO  Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
    """Reads one shop's file and gives it the report's column names."""
    table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
    renamed = {}
    for name, variants in columns.items():
        found = next((c for c in table.columns if c.strip() in variants), None)
        if found is None:
            raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
        renamed[found] = name
    table = table.rename(columns=renamed)[list(columns)]
    table["shop"] = path.stem
    return table

About this service

Banks export statements in their own CSV layout, and accounting programs want theirs: other column names, dates as DD.MM.YYYY or YYYY-MM-DD, one amount with a minus sign or separate debit and credit, a particular encoding. This Python script converts the statement you download from your online bank into your program's import file, by the template or sample file that program gives. From Standard it can also put each line into a category by your rules, such as payments mentioning Rent go to Rent. It runs on your computer and never connects to your bank or accounting program; you download the statement and import the result yourself. It changes only the layout, not the figures, and gives no accounting or tax advice. Check the totals after the first import.

What is included

• What you getA ZIP archive with the Python script, a README with step-by-step instructions and, from Standard, a settings file with columns and category rules; the code is also shown on the order page.
• Your program's formatBy its import template or a sample file
• Dates and amounts rightFormats, signs and decimal separators converted
• Categories by your rulesFrom Standard, keywords you set
• Stays on your computerNo connection to the bank or anywhere else
• Readable codeWith comments, easy to add a rule later

How it works

1. 1
   SamplesYou send made-up lines in your bank's layout and your program's template
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou convert one statement, import it into a test company or period and check totals
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The header row and 10-20 lines of your bank's CSV with made-up amounts, names and account numbers but the same layout, the name of your accounting program and its import template, documentation page or a sample file it accepts. For Standard, your category rules (which words go to which category). For Premium, a sample from each bank or account. Never send real statements, account numbers or bank logins.

We will ask you:

• Which bank export do you have?
• Which accounting program, and its import format?
• Do you need categories?
• How many banks or accounts?

Compare packages

Questions and answers

Did not find your answer? Ask us