Use the Forex Daily Summary report to see how much of each foreign currency your property held at the start and end of a day, and how much it bought from guests that day.
What does the Forex Daily Summary report show?
The Forex Daily Summary report is a one-day summary of the foreign currency your property holds, with one row for each currency set up under Foreign Exchange Rates. For each currency it shows the balance at the start of the day, the foreign currency bought from guests that day, and the balance at the end of the day. The heading on the report reads Daily Summary Of Foreign Currency.
Foreign currency reaches the report through encashments, which you record on the Encashment tab of a reservation (booking) when a guest hands over foreign currency. Forex is short for foreign exchange. The report keeps each amount in its own currency and does not convert it into your property's currency.
The Forex Daily Summary report is for front office and accounts staff at properties that exchange foreign currency for guests. Before you start, make sure that:
- Foreign Exchange Rates are set up for each currency you accept.
- The Encashment tab is switched on: Show Encashment Tab is selected under Setup > Property Options > General Information > Reservation Defaults.
- Your Security Profile allows Daily Summary under Report Screens > Forex Reports.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
When to use the Forex Daily Summary report
The Forex Daily Summary report suits properties that take foreign currency from guests at the front desk. Run it at the end of each day, or for an earlier day when you need to check a balance.
- Closing off the day - the night auditor compares each currency's Closing Balance with the foreign currency held at the front desk.
- Checking a shift - a supervisor selects Time Created Between to see the foreign currency bought from guests during one shift.
- Following up a balance - the accounts team runs the report for an earlier day to see the balances on that day.
How to access the Forex Daily Summary report
In the side menu of RMS, go to Reports > Forex > Daily Summary.
Choose the Forex Daily Summary report options
The Forex Daily Summary report options below set the day the report covers and, if you need one, a time window within that day. The Report Options panel has no More Options section.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Date | Single date | Today |
Sets the day the report covers. Options:
|
| Time Created Between | Checkbox and two times | Not selected, 12:00 PM And 12:00 PM | Limits the report to encashments saved between the two times on the Date. You can change the times once the checkbox is selected. |
| Property | Multi-select | All Selected | Limits the report to the selected properties. Only shown on databases with more than one property. |
Tip! Select the star beside Add Report to Favourites Menu to add the Forex Daily Summary report to your Favourites.
What the Forex Daily Summary column headers show
The Forex Daily Summary report shows one row for each Foreign Exchange Rate, including currencies with no activity, which show 0.00. The table below lists the columns from left to right. Where a value follows a wider rule, the Source / Calculation column points to How the Forex Daily Summary report calculates its figures.
| Column | Description | Source / Calculation |
|---|---|---|
| Currency | The currency's symbol, such as $ or £. | The Symbol on the currency's Foreign Exchange Rate. See How rows are sorted and labelled. |
| Opening Balance | Foreign currency on hand at the start of the day. | Counted encashments before the day, less deposits before it. See How the balances carry forward. |
| Purchase From The Public | Foreign currency bought from guests on the Date. | Counted encashments on the Date. See Which encashments the report counts. |
| Refund | Always blank. | Not filled in by the report. |
| Total | Foreign currency held during the day. | Opening Balance plus Purchase From The Public. |
| Deposited with Authorised Dealer | Foreign currency recorded as deposited with an authorised dealer on the Date. | Forex Entry records. See How the balances carry forward. |
| Closing Balance | Foreign currency on hand at the end of the day. | Total minus Deposited with Authorised Dealer. |
How the Forex Daily Summary report calculates its figures
The Forex Daily Summary report works out its figures from the encashments recorded on reservations. Each concept below governs more than one column.
Which encashments does the report count?
The Forex Daily Summary report counts an encashment in Purchase From The Public, Opening Balance and Closing Balance when both of these are true:
- It was saved with the Apply To Account option, which posts the amount to the reservation's account as a Forex Cash receipt. Encashments saved with the Currency Exchange option are not counted.
- It has not been reversed. Reversing an encashment removes it from the report.
Only the first currency line of an encashment is counted. An encashment can hold up to six lines, each in its own currency, but the report leaves out the amounts on lines 2 to 6.
For example, on 19 November these encashments were saved in US dollars (USD) and pounds sterling (GBP): USD 100.40 with Apply To Account, two of USD 50.00 with Currency Exchange, and one, saved with Apply To Account, with GBP 20.00 on line 1 and USD 30.00 on line 2. The report showed 100.00 in Purchase From The Public for US dollars and 20.00 for pounds sterling.
How the opening and closing balances carry forward
The Opening Balance of a currency is the total of every counted encashment saved before the day, less any deposits with an authorised dealer recorded before the day. It is never reset, so the Closing Balance of one day is the Opening Balance of the next. For example, a US$ Closing Balance of 400.00 on 19 November showed as the Opening Balance on 20 November.
Deposited with Authorised Dealer comes from Forex Entry records, and RMS has no screen for recording them. This column therefore normally shows 0.00, and the balances keep growing.
How Time Created Between changes the figures
When you select Time Created Between, the report covers only the encashments saved between the two times on the Date. The report adds encashments saved earlier on the same day to the Opening Balance instead. The heading on the report shows the Date only, not the times.
For example, with the times set to 2:56 AM And 11:00 PM, a USD 100.40 encashment saved at 2:53 AM moved from Purchase From The Public into the Opening Balance.
How the report rounds amounts
The report rounds each currency's amounts to whole units, then shows them with two decimal places. For example, USD 100.40 shows as 100.00, and USD 100.40 plus USD 10.00 shows as 110.00.
How rows are sorted and labelled
The report shows one row for each Foreign Exchange Rate, sorted by property and then by symbol. The rows show the symbol, not the currency code, so two currencies with the same symbol, such as Australian dollars and US dollars, appear as two rows that look the same.
Tip! To tell currencies apart on the report, give each Foreign Exchange Rate its own Symbol, for example US$ for US dollars. To change a Symbol, go to Setup > Accounting > Foreign Exchange Rates and double-click the currency. A Symbol can be up to five characters long.
Please Note! When the report covers more than one property, the heading shows your enterprise name and the rows do not say which property each one belongs to. To see the figures for one property, select only that property in the Property option.
Related Reports
The other reports in the Forex menu are:
- Register Of Purchase (Reports > Forex > Register Of Purchase)
- Statement (Reports > Forex > Statement)
Related Articles
Comments
0 comments
Please sign in to leave a comment.