Tutorials / Application

Currency in the App

Currencies in YayPay 

In YayPay the following currency levels are used: 

  • Business-level – Main currency configured for the given YayPay instance in Settings | Business.
  • Customer-level – Currency that is set for a specific customer.
  • Document-level – Currency used in a specific document, such as an invoice.


To set your business-level currency in YayPay:
  1. Go to Settings | Business | General Information panel.

  2. On this panel, scroll down to the Currency field and type in your required currency abbreviation, e.g. USD,GBP,EUR, etc.

  3. Click SAVE CHANGES at the bottom of this panel to confirm your settings.

Currencies in Aging report 

You can view information on the Aging Report page in the following currencies:
  • business-level currency
  • customer-level currency


Business-Level Currency

The TOTAL DUE and balances for each customer on the Aging Report page are displayed in the set business-level currency:


Customer-Level Currency

The customer-level currency in the Aging Report is hidden by default. To view it:
  1. Click Select Columns.

  2. Select the Currency and/or Customer's currency balance options.

  3. Click Apply changes


Delete

Note

  • The Customer's currency balance column shows the amount/value from your ERP system in the original customer's currency.
  • The Balance due column shows the balance in the main currency configured for the given YayPay instance (SettingsBusiness).
    Its value depends on the Use Calculated Customer Balance setting in Settings | Business:

    • If checked, the Balance due value is calculated within YayPay and it is based on all open documents obtained from the ERP, i.e. open invoices, credits, transactions, etc.

    • If unchecked and the customer's currency is the same as the main business-level currency, the Balance due value is taken from your ERP system as is.


Alternatively, you can filter customers by their respective customer-level currencies. To do so:
  1. Click the Filtersbutton in the top-left corner of the page:

  2. Select Customer Currencyand the required currency from the list.


  3. As a result, only customers with a selected currency will be displayed.

Currencies on the Statement page 

You can view information on the Statement page in the following currencies:
  • customer-level currency
  • document-level currency

Customer-Level Currency

The TOTAL DUE on Statement page is by default displayed in the customer-level currency:

 

To view the TOTAL DUE calculated in business-level currency, go to Settings | Business and check Use calculated Customer balance in the General information panel.

 

As a result, the business-level currency will be used instead.

 

Note 

For the customer-level currency on the Statement page, the following also applies:
  • When Use calculated Customer balance is checked, the system recalculates the Statement page balance not only by simply applying the respective exchange rate but also by incorporating payments and adjustments.

  • To display the TOTAL DUE amount in the customer's invoice currencies, check Statement - Show Total Due by the invoice currency and Use calculated Customer balance in SettingsBusiness.

  • If your YayPay business utilizes both a primary and secondary payment provider and you want to link each saved payment account with a payment provider that can process transactions in the customer's currency, then follow the steps described in Configuring Payment Providers for Saved Payment Accounts.


Document-Level Currency

The document-level currency (invoice currency) on the Statement page is hidden by default. To view it:
  1. Click Select Columns.

  2. Select the Currency option.

  3. Click Apply Changes.

  4. As result, the Currencycolumn is added and displays currencies of the individual invoices:


Alternatively, you can filter the invoices by their currencies. To do this, click the funnel icon in the Currency column and choose the currency you wish to be displayed:
 

Note

For the document-level currency (invoice currency) on the Statement page, the following also applies:

  • The TOTAL DUE on Statement page is by default displayed in the customer-level currency.
    However, when you download a Statement page as a PDF file, the TOTAL DUE in the PDF file will be displayed in the business-level currency.


  • When you send email reminders that include the Statement Balance dynamic tag, the customer's statement balance amount can be displayed in different currencies.

    By default, the statement balance amount will be displayed in the customer's own currency (customer-level currency).

    To display it in your business-level currency, check Use calculated Customer balance in Settings | Business.

    To display it in invoice currencies, check Customer Portal - Send StatementBalance tag by the invoice currency in Settings | Business.




Use Business Currency for Recurring/On Account payments

To configure the currency when making recurring/on account payments, go to Settings | Business |Use Business currency for Recurring/ On Account payments.

By default, this is checked and the business-level currency is used.

If unchecked, the customer-level currency is used instead.

Frequently Asked Questions 

What currencies will be displayed on the Customer Portal? Why? 

The TOTAL DUE on the Customer Portal is displayed in the customer-level currency (unless Use calculated Customer balance is enabled in Settings). 

 

Alternatively, you can view TOTAL DUE on the Customer Portal in all currencies of the customer’s open invoices: go to Settings | Business and enable the following checkbox on the General information panel:  


Additionally, the TOTAL DUE on Customer Portal can be displayed grouped by transactions (payments, adjustments, credit memos) currencies: go to  Settings | Business and enable Show Total Due grouped by transaction currencies on the General information panel: 

 

 

What currencies are used in the rules engine, e. g. in Conditions? 

When creating rules for invoice events and specifying CUSTOM CONDITIONS options related to invoice amount, the values you enter in the Value field are expected to be in the currency of the document (invoice currency).

 

Delete

Note

If you create a customer level custom condition (by selecting Customer from the Type combo box), then the customer-level currency will be utilized.

If you want to use the business-level currency instead, check Use Business currency for custom conditions in the Workflow Settings dialog. As a result, the amounts will be converted to the amount in the business-level currency. If unchecked, amounts will be in the customer-level / invoice-level currency (depending on the option selected from the Type combo box).

Additionally, if Switch to multicurrency daily exchange rates is checked in Settings | Business, then the balances of the multicurrency documents will be calculated using daily-updated exchange rates pulled from the service called OANDA (online broker service). If unchecked, document-level exchange rates pulled from your ERP system will be used instead.


What currencies are used in the e-mail templates? Can it be changed? 

When sending an e-mail reminder to a customer from the Aging report (Customer Email) or the form Statement page (Invoice Email), you can use a dynamic tag StatementBalance in the letter body. 

The amount under StatementBalance will be displayed in customer-level currency (unless the checkbox Use calculated Customer balance is enabled in Settings: if enabled, the amount will be calculated to business-level currency). 

For the StatementBalance tag to display the amounts in currencies grouped by invoice currencies, enable the Send StatementBalance tag by the invoice currency in the Settings:

 

Delete

Note

  • Send StatementBalance tag by the invoice currency should be enabled simultaneously with Show Total Due by the invoice currency:
  • StatementBalance and StatementBalance Multicurrency dynamic tags are modified when Show Total Due grouped by transaction currencies is enabled. In this case, Send StatementBalance tag by the invoice currency and Show Total Due by the invoice currency can be disabled. 

Alternatively, a StatementBalance Multicurrency dynamic tag can be used, which incorporates amounts in all the currencies grouped by invoices. 

Can I Upload My Exchange Rates?

Answer: Yes.

The exchangeRate field is required in the invoice.csv file that is uploaded to the system. This field indicates the rate at which the invoice-level currency is converted to the business-level currency. If both currencies are the same, the exchange rate is 1.

However, entering 0 in the exchangeRate field in the CSV file will cause the system to fail in calculating bucket balances in the business-level currency on the Aging Report page. This will also impact the Total Due on the Statement page if Use calculated Customer balance is checked in Settings | Business.

Exchange rates can also be pulled from ERP (see the information in the respective articles in the Integrations and ERP Custom Fields Reference Guide).

Example

Invoice amount (in invoice-level currency) * Invoice exchange rate = Amount in business-level currency.

Examples

 

Invoice-level currency

Business-level1 currency

Invoice exchange rate

The calculation of the amount in business-level currency

1

CAD

CAD

1.000000 CAD to CAD

100.00 CAD * 1.000000 = 100.00 CAD

2

USD

CAD

1.358600 USD to CAD

100.00 USD * 1.358600 = 135.86 CAD

3

CAD

USD

0.736100 CAD to USD

100.00 CAD * 0.7361 = 73.61 USD

1 The business-level currency is your Company’s main currency.

How Often Are OANDA Rates Updated?

YayPay is updated with the exchange rates from OANDA (online broker service) on a daily basis. To be more specific, one daily candle for a currency pair is retrieved. 

To use the OANDA rates, ensure the option under your Business Settings page, called Switch to multicurrency daily exchange rates is enabled.

 


Can't find what you need?

Contact our support team support@yaypay.com for help.