FEER Profit & Loss Report
1. Overview
This FEER Profit and Loss Report is designed to provide a comprehensive summary of foreign currency transactions handled by the hotel, including opening balances, purchases, deposits, and resulting profit/loss per currency.
2. Report Columns Definition (Based on Attached Image)
| Column | Description | Data Type | Remarks |
|---|---|---|---|
| S.No | Serial number | Integer | Auto-generated |
| Currency | Currency code (e.g., USD, EUR) | String | Pulled from predefined currency list |
| Opening Balance - Cash | Foreign currency opening balance (cash) | Decimal | Balance carried from previous day |
| Opening Balance - Eq. NPR | NPR equivalent of opening balance | Decimal | Calculated using the opening exchange rate |
| Total NPR | Total NPR value of opening balance | Decimal | Sum of NPR equivalents for reference |
| Purchase - Cash | Foreign currency amount purchased | Decimal | Sum of purchase entries |
| Purchase - Eq. NPR | NPR equivalent of purchased currency | Decimal | Calculated using daily rate at time of purchase |
| Deposit (Cash) - Cash | Foreign currency deposited to cash | Decimal | Movement from cash to hotel cash account |
| Deposit (Cash) - Eq. NPR | NPR equivalent of cash deposit | Decimal | Calculated using deposit transaction rate |
| Deposit (Bank) - Cash | Foreign currency deposited to bank | Decimal | Movement from cash to hotel bank account |
| Deposit (Bank) - Eq. NPR | NPR equivalent of bank deposit | Decimal | Calculated using bank deposit rate |
| Total NPR | Sum of NPR from purchase and deposits | Decimal | Reflects total local currency inflow |
| Profit/Loss | Profit or loss from the exchange | Decimal | Formula: (Total NPR from deposits - Total NPR of purchases) |
3. Calculation Logic
-
Opening Balance (Eq. NPR) =
Opening Balance (Cash) × Opening Rate -
Purchase (Eq. NPR) =
Purchase Amount × Purchase Rate -
Deposit (Cash Eq. NPR) =
Cash Deposit × Deposit Rate -
Deposit (Bank Eq. NPR) =
Bank Deposit × Deposit Rate -
Total NPR = Sum of all NPR equivalents
-
Profit/Loss =
(Deposit NPR + Bank NPR) – Purchase NPR
4. Report Features
-
Date Range Filter: Allows viewing for a selected day, week, or month.
-
Currency Filter: Filter by specific foreign currencies.
-
Export Options: Excel / PDF download
-
Auto-calculation: Real-time calculations of totals and profit/loss based on entries.
-
Summary Footer: Aggregate totals of each column (especially profit/loss) for all currencies.
5. Use Case
This report is critical for:
-
Daily reconciliation of foreign currency operations.
-
Ensuring compliance with NRB reporting.
-
Tracking exchange profitability.
-
Enabling auditable financial records for internal and external review.