Statement of Foreign Currency
Statement of Foreign Currency will give the report based on From and To Date and the selected Currency. Terminology;
Opening: Opening Balance of each currency based on selected From Date. Need to evaluate this as Initial Balance + Receipt till From Date-1 - Deposit till From Date -1 + Withdrawn till From Date -1
Add Purchase: Total Receipt within the selected From and To Date
Total: Opening + Receipt
Less Deposit: Total Deposit within the selected From and To Date
Closing: Opening + Purchase - Less Deposit
Filter
- From Date
- To Date
- Currency: All/Multi Select/ Default - All
- Type=Cash
- Group By: None/
Day/Date/Default-DayDate
Group By Date
{Property Name}
{Country}, {State}, {City}, {Street}, {Tel1}
Statement of Foreign Currency Purchase for the Period of {From Date} to {To Date}
| Date |
Amount Purchased |
Amount Deposited |
||||
| Receipt No. | Currency | Amount | Particulars | Currency | Amount | |
| 01/01/2023 | 8081-1 to 8081-15 | |||||
| USD | 200.00 | |||||
| AUD | 20.00 | |||||
| GBP | 200.00 | |||||
| 02/01/2023 | 8081-1 to 8081-3 |
Himalayan Bank | USD | 100.00 | ||
| AUD | 10.00 | |||||
| JPY | 10000.00 | |||||
| Particular | USD | AUD | JYP | CAD | GBP |
| Opening | 0.00 | 0.00 | 10000.00 | 0.00 | 0.00 |
| Add Purchase | 200.00 | 20.00 | 0.00 | 0.00 | 200.00 |
| Total | 200.00 | 20.00 | 10000.00 | 0.00 | 200.00 |
| Less Deposit | 100.00 | 10.00 | 10000.00 | 0.00 | 0.00 |
| Closing | 100.00 | 10.00 | 0.00 | 0.00 | 200.00 |
Name: {Property Name}
Signature:
Stamp:
Date:
Group By None
{Property Name}
{Country}, {State}, {City}, {Street}, {Tel1}
Statement of Foreign Currency Purchase for the Period of {From Date} to {To Date}
| Date |
Amount Purchased |
Amount Deposited |
||||
| Receipt No. | Currency | Amount | Particulars | Currency | Amount | |
| 01/01/2023 | 8081-1 | USD | 200.00 | |||
| 01/01/2023 | 8081-2 | AUD | 20.00 | |||
| 01/01/2023 | 8081-3 | GBP | 200.00 | |||
| 02/01/2023 | 8081-1 | Himalayan Bank | USD | 100.00 | ||
| 02/01/2023 | 8081-2 | Himalayan Bank | AUD | 10.00 | ||
| 02/01/2023 | 8081-3 | Himalayan Bank | JPY | 10000.00 | ||
| Particular | USD | AUD | JYP | CAD | GBP |
| Opening | 0.00 | 0.00 | 10000.00 | 0.00 | 0.00 |
| Add Purchase | 200.00 | 20.00 | 0.00 | 0.00 | 200.00 |
| Total | 200.00 | 20.00 | 10000.00 | 0.00 | 200.00 |
| Less Deposit | 100.00 | 10.00 | 10000.00 | 0.00 | 0.00 |
| Closing | 100.00 | 10.00 | 0.00 | 0.00 | 200.00 |
Name: {Property Name}
Signature:
Stamp:
Date: