Skip to main content

Foreign Exchange Entry

1. Overview

This section defines the Foreign Exchange Entry form used for recording foreign exchange transactions in a hotel’s Property Management System (PMS). The form captures seller (guest) information and transaction details to ensure compliance with NRB policies.

2. Foreign Exchange Entry Form

2.1 Seller Information (Guest Details)
  1. Transaction Date:

    • Description: The date when the transaction occurs.
    • Validations: Required field, date format (YYYY-MM-DD), must not be a future date.
  2. Full Name (Name of Guest):

    • Description: Full name of the guest conducting the transaction.
    • Validations: Required field, alphabetic, 2-100 characters.
  3. Local Address:

    • Description: Address of the hotel where the guest is staying.
    • Validations: Required field, alphanumeric, 5-200 characters.
    • Copy Hotel Address Feature: Button to auto-fill the hotel's address.
  4. Home Address:

    • Description: Permanent address of the guest.
    • Validations: Required field, alphanumeric, 5-200 characters.
  5. Nationality:

    • Description: Nationality of the guest.
    • Validations: Required field, alphabetic, 2-50 characters.
  6. Passport Number:

    • Description: Passport number of the guest.
    • Validations: Required field, alphanumeric, 5-20 characters.
2.2 Exchange Entry Details
  1. Type:

    • Description: Type of transaction (Cash/Card/TC).
    • Validations: Required field, dropdown list (Cash, Card, TC).
  2. Currency:

    • Description: Currency being exchanged.
    • Validations: Required field, dropdown list populated with predefined currencies.
  3. Rate:

    • Description: Exchange rate of the respective currency.
    • Validations: Required field, numeric, must be greater than 0, precision up to 4 decimal places.
  4. Bill (Applicable for Type=Cash):

    • Description: Denomination of the bill.
    • Validations: Required field for Cash type, numeric, positive integer.
  5. Quantity (Applicable for Type=Cash):

    • Description: Quantity of the bills.
    • Validations: Required field for Cash type, numeric, positive integer.
  6. Amount (Block Field for Type=Cash; Open for Type=Card/TC):

    • Description: Amount in the respective currency.
    • Validations: Required field, numeric, must be greater than 0.
  7. Local Amount:

    • Description: Amount in local currency (NPR).
    • Validations: Required field, numeric, calculated as (Amount * Rate), must be greater than 0.
2.3 List Section
  • Columns:
    1. S.No: Serial number of the transaction entry.
    2. Type: Type of transaction (Cash/Card/TC).
    3. Amount: Amount in foreign currency.
    4. Local Amount: Equivalent amount in local currency (NPR).
2.4 Summary Section
  1. Total Amount:

    • Description: Total amount in foreign currency.
    • Validations: Calculated field, sum of all Amount values.
  2. Total Local Amount:

    • Description: Total amount in local currency.
    • Validations: Calculated field, sum of all Local Amount values.
  3. Amount in Words for Local Amount:

    • Description: Total local amount expressed in words.
    • Validations: Required field, auto-generated from Total Local Amount.

3. Validation Details

3.1 General Validation Rules
  • Required Fields: Ensure all mandatory fields are filled before submission.
  • Date Validation: Prevent future dates for transaction date.
  • Numeric Validation: Ensure numeric fields contain valid numbers.
  • Positive Values: Ensure all amounts and rates are positive numbers.
3.2 Specific Validation Scenarios
  • Conditional Fields: Ensure Bill and Quantity fields are only required for Cash type transactions.
  • Amount Calculation: Automatically calculate and validate the Local Amount based on the exchange rate and foreign amount.

4. User Interface Design

4.1 Foreign Exchange Entry Form
  • Layout:
    • Seller Information section at the top.
    • Exchange Entry Details in the middle with split view for entry and list.
    • Summary Section at the bottom.
  • Error Messages: Inline error messages for invalid entries.
  • Submit and Reset Buttons: Options to submit the form or reset all fields.
  • Design Considerations: Ensure the form is intuitive, mobile-friendly, and accessible.

This Foreign Exchange Entry form setup provides a comprehensive method for capturing all necessary details for foreign exchange transactions in a hotel setting. The detailed form fields and validation rules ensure accuracy, compliance with NRB policies, and ease of use for hotel staff.