Automated bank statement parsing, GL classification, and journal entry generation.
import csv, json
BANK_CSV = "bank_statement.csv"
GL_MAP = {"payment": "7001", "transfer": "1002", "deposit": "1001"}
def parse_bank_csv(file):
with open(file) as f:
return list(csv.DictReader(f))
def classify_entry(desc):
desc = desc.lower()
if "payment" in desc or "pay" in desc: return "Purchase", GL_MAP["payment"]
if "transfer" in desc: return "Transfer", GL_MAP["transfer"]
return "Sales", GL_MAP["deposit"]
def generate_journal(entries):
lines = []
for e in entries:
cat, gl = classify_entry(e["desc"])
lines.append({"date": e["date"], "category": cat, "gl": gl})
return lines
entries = generate_journal(parse_bank_csv(BANK_CSV))
print(json.dumps(entries, indent=2))
Basic Package
Special SME traction programme by AINNA.
Limited starter website offer. AI usage, hosting, maintenance and custom integrations depend on the confirmed scope.
View SME Offer โ
Ask about AINNA pages, services and articles.
AINNA sources only ยท up to 5 lines ยท 20 questions/hour
No section data available yet.
Sites with documented sections will appear here.
We value your privacy
We use browser storage to remember your choice. Optional analytics runs only after you allow it; your choice is recorded with an anonymous ID. Privacy Policy