Automatisierung

Buchhaltungsautomatisierung

Python-Buchhaltungsautomatisierungsskript: liest Kassen- oder Verkaufs-Excel-Exporte, transformiert und bereinigt Daten, erstellt die Importdatei im vom Buchhaltungsprogramm erwarteten Format.

PythonPandasFECCSV
Accounting automation · Settings
File selection
Source file
📊 sales_november_2024.xlsx
Source format
Cash register (Excel)
Target format
FEC (accounting entries file)
Period
November 2024
Journal code
SAL / PUR / BNK
▶ Run processing
Advanced settings
01

Hauptschnittstelle — Quelldateiauswahl und Zielformat

Preview · Transformed data
Source (raw Excel)
DateSale no.LabelAmount
11-28SAL-1042Country bread saleCHF 12.50
11-28SAL-1043Pastries saleCHF 28.30
11-27PUR-0312Flour supplierCHF -245.00
11-27SAL-1041Cakes saleCHF 67.80
→
Generated FEC
AccountLabelDateDebit
411000Moreau Bakery11-28CHF 12.50
706000Country bread sale11-28CHF -12.50
401000Flour supplier11-27CHF -245.00
607000Raw material purchases11-27CHF 245.00
02

Vorschau — Vorschau transformierter Daten vor Export

Mapping rules · Column settings
Source columns → FEC fields
Source column (Excel)FEC fieldTransformation
Transaction date→EcritureDatedd/mm/yyyy → yyyymmdd
Sale number→EcritureNumAuto sequence
Description→EcritureLibTrim + upper
Amount incl. VAT→Debit / CreditSign → debit/credit
Category→CompteNumChart of accounts mapping
Register code→JournalCodeSAL / PUR / BNK
03

Zuordnungsregeln — Spaltenzuordnungskonfiguration

Processing log · 28/11/2024 14:32
Execution log
14:32:00▶ Processing started — sales_november_2024.xlsx
14:32:00✓ File read: 156 rows detected
14:32:01✓ Column check: 6/6 columns mapped
14:32:01✓ Cleaning: 3 duplicates removed → 153 rows
14:32:01⚠ Row 47: empty category → filed as "MISC"
14:32:01⚠ Row 89: empty category → filed as "MISC"
14:32:02✓ Accounting entries generated: 306 FEC rows
14:32:02✓ Debit/credit balance check: OK
14:32:02✓ Export: FEC_november_2024.txt (47.2 KB)
14:32:03✓ Archived: /exports/2024/11/
14:32:03■ Processing complete — 3.2 seconds — 0 errors
04

Verarbeitungsprotokoll — detailliertes Log der Operationen

Output file · FEC_november_2024.txt
FEC preview — 306 entries · Ready to import
✓ Balanced✓ Valid formatFEC 2024
JournalNo.DateLabelDebitCredit
SAL00120241128Country bread sale12.50
SAL00220241128Pastries sale28.30
PUR00320241127Flour supplier245.00
PUR00420241127Raw material purchases245.00
BNK00520241126Customer payment340.50
.........— 301 more entries —
05

Ergebnisdatei — exportfertig für den Import ins Buchhaltungsprogramm

Ce type de projet vous intéresse ?

Démarrer un projet similaire