Automation

Accounting automation

Python accounting automation script: reads cash register or sales Excel exports, transforms and cleans data, generates the import file in the format expected by the accounting software (FEC, normalized CSV). Process hundreds of lines in seconds.

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

Main interface — source file selection and target format

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

Preview — preview of transformed data before 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

Mapping rules — column correspondence configuration

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

Processing log — detailed log of operations and detected errors

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

Result file — export ready to import into accounting software

Ce type de projet vous intéresse ?

Démarrer un projet similaire