Convert a CAMT CSV file into a normal CSV file that can be used for importing Bank Transactions into ERPNext.
Project description
This CLI can convert a CAMT CSV file (provided by your bank) into a normal CSV file that can be used for importing Bank Transactions into ERPNext.
Installation
It is easiest to install camt-to-erpnext
with pipx
, a tool to "install and run python applications in isolated environments":
pipx install camt-to-erpnext
Usage
camt-to-erpnext convert INPUT_PATH OUTPUT_PATH
Input format
- Delimiter:
;
- Quoting: all columns quoted
- Date Format:
28.02.99
- Number Format:
-1234,56
- Encoding:
cp1252
- Columns:
- Auftragskonto
- Buchungstag
- Valutadatum
- Buchungstext
- Verwendungszweck
- Glaeubiger ID
- Mandatsreferenz
- Kundenreferenz (End-to-End)
- Sammlerreferenz
- Lastschrift Ursprungsbetrag
- Auslagenersatz Ruecklastschrift
- Beguenstigter/Zahlungspflichtiger
- Kontonummer/IBAN
- BIC (SWIFT-Code)
- Betrag
- Waehrung
- Info
Output format:
- Delimiter:
,
- Quoting: where necessary
- Date Format:
1999-02-28
- Number Format:
1234.56
- Encoding:
utf-8
- Columns:
-
Date
"Buchungstag" of the input file, converted to ISO-format
-
Deposit
"Betrag" of the input file (if > 0)
-
Withdrawal
Absolute "Betrag" of the input file (if < 0)
-
Description
The following columns of the input file: "Beguenstigter/Zahlungspflichtiger", "Verwendungszweck", "Kontonummer/IBAN", "BIC (SWIFT-Code)", "Glaeubiger ID", "Mandatsreferenz", "Kundenreferenz (End-to-End)", "Valutadatum"
-
Reference Number
Hash of the following columns of the input file "Buchungstag", "Betrag", "Verwendungszweck", "Kontonummer/IBAN", "BIC (SWIFT-Code)".
-
Bank Account
"Auftragskonto" of the input file
-
Currency
"Waehrung" of the input file
-
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for camt_to_erpnext-0.2.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c2945d820427cba083c9a11494676324c05ed5d5b6e857b2cdcd652256d24663 |
|
MD5 | 2ef99c11e51728ab47b70757437bbb50 |
|
BLAKE2b-256 | 8c1d9718c7c3493a7ce0a3789b157f55a605c1a043072068b222e918ca047039 |