Initial Setup and Branch Data Management
📌 The initial step involves enabling Macros in Excel by navigating to File > Options > Trust Center > Trust Center Settings > Macro Settings and selecting "Enable all macros".
👤 Accessing the application requires entering the employee name and password, with an option to show the password for verification.
🔄 Upon logging in, the first action is to update branch data, including the region, branch name, employee name, branch code, file number, and security PIN.

Balance Updates and Point of Sale (POS) Management
💰 Branch balances (cash, stamps, professional fees, etc.) must be updated according to the physical inventory, with the ability to add or update these balances.
🖥️ The system allows for the addition or cancellation of POS machines (or sales points) by entering their serial numbers.
🗑️ A dedicated function exists for deleting stored data based on a specified date range, with options to delete operations, ATM data, or statistics.

Transaction Value Setting and Daily Operations (1MT System)
🎯 Users must update transaction values (targets) under "Update Transaction Values," such as setting the value for a specific deposit account (e.g., Account 7 set to 1 EGP).
📅 The 1MT system distinguishes between 1MT Region (data across all branches) and 1MT Branch (specific branch data) to streamline account selection for daily operations.
📈 Daily entries require selecting the region/branch context, then specifying the account type, account name, transaction count, and value, which automatically updates the branch's standing balance and target achievement.

Reporting and Statistics (1MT, ATM Statistics, and Feed)
📊 The reporting section offers detailed (daily/specific date) and summary (cumulative/period-based) reports for the 1MT system, which require reconciled "Receipts and Payments" before printing.
📊 The Statistics (Ahsa) module allows users to add, delete, and modify account types (e.g., adding a new "Real Estate Financing" account to Receipts) and track daily or period statistics against defined targets.
🏧 The ATM module handles daily ATM feeds, customer deposits, disbursements, and returns; reports can be generated as detailed (daily) or summary (cumulative), reflecting feed counts and values from specific dates or the entire month.

Key Points & Insights
➡️ Data Integrity is paramount: The system enforces checks, such as preventing duplicate entry of an account on the same day or blocking printing if the receipts/payments balance (Mizan) does not match.
➡️ Efficient Reporting: The structured reporting for 1MT allows immediate generation of specific account-type reports (e.g., Account 7 history) for auditing and management requests.
➡️ Streamlined ATM Reconciliation: The ATM feed process requires meticulous entry of denominations, which are then sorted automatically; printing the ATM report ensures the documented counts match the physical count for easy reconciliation.

📸 Video summarized with SummaryTube.com on Dec 31, 2025, 20:43 UTC