Aantar

Aantar Books

Balances in other currencies

See what a US-dollar customer or vendor owes in their own currency, read the Foreign balance column on the aging and balance reports, and keep a bank account in US dollars with its register in US dollars.

Where: Customers ▸ Customer Centre · Vendors ▸ Vendor Centre · Banking ▸ Use Register · Lists ▸ Chart of Accounts

Your books are always kept in your home currency (such as CAD). A customer or vendor kept in another currency, and a bank account kept in another currency, also show their figures in their own currency, beside the home figures. Nothing here changes an amount in your books: the home figures are exactly what they were.

Customers and vendors

A customer or vendor is kept in one currency (see Add or edit a customer). For a name kept in a foreign currency:

  • Customer Centre and Vendor Centre. Once anybody on the list owes in another currency, the list gains a Foreign balance column, such as USD 500.00, beside Balance. Balance is the home figure your Accounts Receivable or Accounts Payable carries: each document at the rate it was entered at.
  • The ledger. Opening the customer or vendor shows two more columns, Amount (USD) and Balance (USD): each invoice, bill, payment and credit in US dollars, and the running balance in US dollars. The box at the top says what they still owe In USD.
    • A payment shows the US-dollar amount recorded with it. An older payment saved without one is worked out at the invoice's rate and marked ≈.
    • An Exchange difference line moves the home balance only; nothing changes in US dollars.
    • A document saved in the home currency has no US-dollar amount and moves the home balance only.

Reports

A/R Aging Summary, A/P Aging Summary, Customer Balance Summary and Vendor Balance Summary gain two columns when any open document is in another currency:

Column Meaning
Currency The name's currency. A home-currency name shows the home currency.
Foreign balance What the name owes in their currency. Blank for a home-currency name.

The Total USD line under the names gives the US-dollar total and its home value. The aging buckets and TOTAL stay in the home currency, so they still agree with the control account.

A bank account in US dollars

  1. Turn the currency on in the Currency List.
  2. Open Lists ▸ Chart of Accounts and choose New account (or edit an account that has no entries yet).
  3. Choose a bank, credit card or other asset or liability type, then choose the Currency, such as USD.
  4. Choose Create or Save.

The account's currency cannot change once the account has entries. The message says This account already has entries in USD. Its currency cannot change once it is used — make a new account in CAD instead.

The register in US dollars

Banking ▸ Use Register on a US-dollar account shows Debit (USD), Credit (USD) and Balance (USD), and beside them Amount (CAD) and Balance (CAD). The heading gives the balance in both.

Each line's US-dollar amount comes from, in order:

  1. the amount recorded on the line when it was saved;
  2. the payment's US-dollar amount, or the US-dollar journal entry it came from;
  3. the rate of the invoice or bill behind it;
  4. the rate for the line's date in the Currency List — marked ≈, and counted in the heading as at the rate for the day.

A line with no rate at all shows ?. Enter a rate for that day in the Currency List.

The account page, the journal and the ledger reports

The same figures appear wherever the account is read:

  • The account page (opened from the Chart of Accounts or a report line) shows Debit (USD), Credit (USD) and Balance (USD) beside Debit (CAD), Credit (CAD) and Balance (CAD), with the opening and closing in both.
  • A journal entry shows, on a line of that account, the Account currency and the amount In the account's currency beside its CAD debit or credit.
  • General Ledger and Transaction Detail by Account add Debit (USD), Credit (USD) and Balance (USD) for that account (and a Currency column when accounts are kept in more than one currency).

Each has a Basis column: ≈ day rate for a figure read at the rate for its day, ? no rate for a line with no rate, blank for a figure the entry kept itself. In Excel the figures stay numbers, so they add up; the basis is a column of its own.

Common problems

  • No Currency box on the account. Only a balance-sheet account can have one, and only once a second currency is on in the Currency List.
  • "USD is not turned on in the Currency List." Turn it on there first.
  • A US-dollar figure marked ≈. Nothing recorded the US-dollar amount, so the rate for that day was used. Your accountant can ask Aantar Books support to record the figures on older lines.

Note: each customer and vendor has one currency, the Currency and Foreign Balance columns show in the Centres and on the aging and balance reports, and an account's register is in the account's currency. Revalue open balances with Home Currency Adjustment.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.