Process foreign currency transactions
Description

Multi-currency is only available in Sage 50cloud Pastel Partner.

Cause
Resolution

Customer transactions

You’ll use Invoices and Receipts.

Customer Invoice

  1. Select Process > Customer > Tax Invoice.
  2. Select the foreign Customer.
  3. Enter the date.
  4. Enter the exchange rate for the date of sale.
  5. Process the invoice as normal and update it when complete.

Cash Book Receipt

When recording a receipt:

  • Enter the amount shown on your bank statement (home currency) in the Bank Amount column.
  • Enter the foreign currency amount in the Foreign Customer column.
  • The system calculates the transaction’s exchange rate automatically.

NOTE:

The exchange rate at the time of purchase will likely differ from the rate at the time of receipt due to fluctuations.

 


Supplier transactions

You’ll use Supplier Invoices and Payments.

Supplier Invoice

  1. Select Process > Supplier > Supplier Invoice.
  2. Select the foreign Supplier.
  3. Enter the date.
  4. Enter the exchange rate (use the rate from the shipping invoice if applicable).
  5. Process the supplier invoice as normal and update it when complete.

Cash Book Payment

When paying a supplier:

  • Enter the bank statement amount (home currency) in the Bank Amount column.
  • Enter the foreign currency amount in the Foreign Supplier column.
  • The system calculates the transaction exchange rate automatically.

Match open items

After processing a receipt or payment, the Match Open Item screen displays:

  • Match the payment or receipt processed to the related invoice.
  • Expect differences:
    • Foreign currency value will clear (zero balance).
    • Home currency will show a balance due to exchange rate differences.

Exchange rate impact:

  • If the foreign currency strengthened against your home currency → you record a loss.
  • If the home currency strengthened →, you record a profit.

Foreign cash book processing

To process transactions in a foreign cash book:

  1. Select Process > Cash Book > Process Cash Books.
  2. From the Cash Book dropdown, select the foreign bank account.
  3. Process transactions as normal (similar to a home currency cash book).

 

Steps to duplicate
Related Solutions