FEC package for French Auditing
Project description
Package for automating the generation of the French auditing file FEC with an excel file output. Uses Gooey for a user-friendly interface, translates to French and maps accounts/suppliers/journalcodes
REQUIREMENTS:
Change your columns to the exact name columns considering lower/upper cases and spaces to the French FEC standards (ex: JournalCode) Use Debits and Credits format (with column names: Debit and Credit)
Please be aware you need to create master files for your specific:
- Account Numbers corresponding to PCG French accounts (name the file mapping-accounts.xlsx) a) Name the Columns: G/L Account # (for the company's account numbers) b) FrMap (for the corresponding French standard) c) FEC Compliant (for the corresponding French Account Name)
- Vendor numbers to vendor names (name the file Vendors.xlsx) a) Name the Columns: No (Vendor Number) b) Name (Vendor Name)
- Journal Codes to Journal Names in French (name the file mapping-journal.xlsx) a) JournalCode (for the journals codes) b) JournalLib (for the corresponding names in French)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
FEC-brunnatorino-0.0.1.tar.gz
(1.5 kB
view hashes)
Built Distribution
Close
Hashes for FEC_brunnatorino-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 823cfd3c48f99d9acf3a98eb2c714e412fd30a8fc4d5dc6098ff9720cc29b3f5 |
|
MD5 | 66f8f56b8fef93118d24473c05cc987e |
|
BLAKE2b-256 | 7c67f39d38007e534ccd7c7a68af35b7bbcb338f1345e699808e0ba2dabf2db0 |