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_DAYS in 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