The firm calculates sales from Amazon market place based on VAT (value added tax) region and currency segments.
Program takes an export text file from Amazon and prepares a flexible Accounting Report in xlsx format.
Project is heavily based on previous work.
- Not uploading source files, or databases due to sensitivity of personal information;
- No Excel side (VBA) implementation is uploaded;
- Filters out:
- today's orders (assumes incomplete date);
- orders alreadt processed before (present in database)
- Logs, backups database;
- Automatic database self-flushing of records as defined by
ORDERS_ARCHIVE_DAYSin orders_db.py; - Creates a Excel report with:
- Datasheets for each present segments in loaded raw text file with selected data for each order;
- Summary sheet
Example of report summary sheet:
Example of report data sheet for specific segment:
Python 3.7+
Most requirements are for compiling python executable for Windows. openpyxl is the only third-party library used.
pip install requirements.txt