crdb-fee-calculator 1.0.1

A command line tool for calculating fees and VAT from CRDB account statements in Excel format

CRDB Fee Calculator

A command line tool for calculating fees and VAT from CRDB account statements in Excel format.

Features

• 🚀 Simple command line interface
• 📊 Automatic detection of fees/charges
• 🏛️ VAT calculation
• 💱 Automatic currency detection (USD/TZS)
• 💰 Support for different currencies
• 🎨 Beautiful, formatted output
• 📁 Supports .xlsx and .xls files

Installation

From PyPI (Recommended)

pip install crdb-fee-calculator

From Source

Requirements

• Linux system (Ubuntu 22.04+ recommended)
• Python 3.7 or higher
• python3-venv (will be installed automatically)

Quick Installation

1. Clone or download repository
2. Make installation script executable:

   chmod +x install.sh
   

3. Run installation:

   ./install.sh
   

The tool will be automatically installed in /usr/local/bin and will be available from anywhere.

Note: This installation method is for development/testing. For production use, install from PyPI.

Manual Installation

1. Create virtual environment:

   python3 -m venv venv
   source venv/bin/activate
   

2. Install dependencies:

   pip install -r requirements.txt
   

3. Make script executable and copy to PATH:

   chmod +x crdbfee.py
   sudo cp crdbfee.py /usr/local/bin/crdbfee
   

Note: The automated installation script is recommended as it handles virtual environment setup automatically.

Usage

Basic Usage

crdbfee statement.xlsx

Show Help

crdbfee --help

Show Version

crdbfee --version

Example Output

USD Output

╔══════════════════════════════════════════════════════════════╗
║                    CRDB Fee Calculator                      ║
╠══════════════════════════════════════════════════════════════╣
║  📊  Fees/Charges:          125.50 USD                     ║
║  🏛️   VAT Total:             25.10 USD                     ║
╠══════════════════════════════════════════════════════════════╣
║  💰  Total Amount:          150.60 USD                     ║
╚══════════════════════════════════════════════════════════════╝
💱 Detected currency: USD

TZS Output

╔══════════════════════════════════════════════════════════════╗
║                    CRDB Fee Calculator                      ║
╠══════════════════════════════════════════════════════════════╣
║  📊  Fees/Charges:        25000.00 TZS                     ║
║  🏛️   VAT Total:           5000.00 TZS                     ║
╠══════════════════════════════════════════════════════════════╣
║  💰  Total Amount:        30000.00 TZS                     ║
╚══════════════════════════════════════════════════════════════╝
💱 Detected currency: TZS

Uninstallation

chmod +x uninstall.sh
./uninstall.sh

Supported File Formats

• Excel (.xlsx)
• Excel (.xls)

Detection of Fees and VAT

The tool automatically detects:

Fees/Charges:

• charge
• commission
• fee
• levy
• fund transfer

VAT:

• All entries with "vat" in the description text

Currency Detection

The tool automatically detects the currency from:

• Column names (e.g., "Balance USD", "Amount TZS")
• Description texts (e.g., "Bank Fee USD", "Commission TZS")
• Currency symbols ($, TSH, TZS)
• Fallback: USD (default)

Supported Currencies:

• USD: US Dollar
• TZS: Tanzania Shilling

Troubleshooting

"File does not exist"

• Check the file path
• Make sure the file is in the current directory

"Not an Excel file"

• Use only .xlsx or .xls files
• Make sure the file is not corrupted

"Python not found"

• Install Python 3.7 or higher
• Make sure python3 is available in PATH

"externally-managed-environment" Error (Ubuntu 22.04+)

• This error occurs because Ubuntu prevents system-wide pip installations
• The installation script automatically creates a virtual environment to solve this
• If you encounter this error, use the provided install.sh script instead of manual pip installation

License

See LICENSE file for details.

Support

For problems or questions, please create an issue in the repository.