Skip to main content
Try for free

How to Add Foreign Currency

Add a currency in Data Maintenance so you can quote, invoice and take payments in it, and set where its payments post and what its invoices print.

Updated Nov 9 2026

How to Add Foreign Currency

Allow external media cookies to watch this video.

Before you start

  • Data Maintenance is under Admin > Maintenance and shows for users with the Admin role. Editing a table needs the Can Edit Maintenance function (Admin or Maintenance role by default), or the table assigned to one of your roles.
  • Currency and CurrencyRate only appear in Data Maintenance if your site lists them in the table_maint_classes or extra_table_maint_classes config.
  • Have the IDs ready: the Account ID of the cash and undeposited funds ledger accounts (Accounting > Chart/Ledger > Account List: click Submit, then Show All Sub Accounts, and read the Account ID column, not the Account # beside it; the standard chart names them Cash and Undeposited Cash), and the Id of the location customers should remit to (Data Maintenance, LNAME (Locations) table).
  1. Open the currency table

    1. Go to Admin > Maintenance > Data Maintenance.
    2. Click the filter search bar (Filter or search…) above the list, choose Data Type, and type currency (it matches any part of the name).
    3. Click Apply (1). The filter shows as a chip in the search bar; click the chip's remove button to drop it.
    4. Click Currency in the Data Type column (or the Edit icon at the right of the row, shown when you point at it). A page headed Data Maintenance, with Currency and its description under it, opens.
  2. Add the currency

    The table can be empty while you only use your home currency; add a row for each other currency you trade in.

    1. On Admin > Maintenance > Data Maintenance > Currency, click Add Record. Cetec saves a new empty row straight away (along with any changes you haven't saved) and shows Rows created: 1 deleted: 0 updated: 0.
    2. Fill in the new row (point at the Sign, Remit Address Id or Banking Instructions heading to see its help):
      • Abbrev – the currency code, such as EUR, GBP, CAD, JPY or CNY. Each code can be added once.
      • Sign – the help says signs are not used: USD shows $, and every other currency shows its three-letter code after the amount.
      • Description – such as Euro or Japanese Yen.
      • Active – leave on Active.
      • Default Cash Account Id and Default Undeposited Funds Account Id – the ledger Account IDs that customer payments in this currency post to.
      • Remit Address Id – the Id of the location (LNAME table) customers should send payments in this currency to. Its address prints in Remit To on the invoice PDF.
      • Banking Instructions – text printed under Payment Instructions on invoice PDFs in this currency.
    3. Click Save Changes. Cetec shows Saved - 0 created, 1 updated, 0 deleted. Turn on Changed only before you save to see just the rows you edited.
  3. Check the exchange rates

    Cetec's currency script looks up each active currency's rate against your home currency (the default_currency_code config, USD unless changed) and saves a rate row in both directions. You don't need to enter a starting rate.

    1. Go to Admin > Maintenance > Data Maintenance, filter Data Type on currency, and click CurrencyRate. This table opens the classic editor, headed Data Maintenance For CurrencyRate, with Add Record and Submit above and below the table.
    2. Each row has Rate, From Currency Abbrev, To Currency Abbrev, Active Date and Active. Cetec uses the active row with the latest Active Date on or before the transaction date.
    3. To set a rate yourself, click Add Record, fill in Rate, From Currency Abbrev, From Currency Id, To Currency Abbrev, To Currency Id and Active Date, and click Submit. The currency ids are in the Id column of the Currency table.