Data Import

SUGGESTED

Uploading journals using the Audit Trail Transaction template to Sage 50cloud and looking to understand the Exchange Rate column.

Just want to check whether this understanding is correct as the comments on the Template aren't very explanatory and I can't find anything on the help files (although  I might be looking in the wrong place).  i'm always accustomed to journals taking up two or more lines, with separate lines for each nominal account reference, so I am puzzled about the instructions which require both an Account Reference and a Nominal Account Reference on each line.  The description "The nominal code originally associated with this transaction" for the Nominal A/c ref column is also puzzling me since, before the entry for the transaction is uploaded there is nothing originally associated with the transaction as it doesn't exist!  There is also no clue as to which way the currency transaction goes: is it NetAmount*ExchangeRate or NetAnount/ExchangeRate.

My guess is this (am I right? and if not, how are they done)?

Let us say I have a bank payment of 10,000 GBP from a GBP bank account (say a/c 1200) which is a transfer to a USD bank account (a/c 1210) and the exchange rate is 1 GBP = 1.25 USD
would the (partial) entry be:
Type BP
Account Reference 1210
Nominal A/C Reference 1200
Net 10000,00
Exchange Rate 1.25

(and would the corresponding entry in a/c 1210 automatically show the type as BR)

If I then paid a bill of of 5,000 USD to a supplier whose account was set up in USD,  would I record
Type BP
Account Reference SUPP001
Nominal A/C Reference 1210
Net 5000,00
Exchange Rate 1

Finally, if I paid from the same account a bill of 3,000 USD to a supplier whose account was set up in GBP, would I record
Type BP
Account Reference SUPP002
Nominal A/C Reference 1210
Net 3000,00
Exchange Rate 0.80     (i.e the inverse rate USD-> GBP)

Any help (or a pointer to a set of instructions which explains the template) gratefully received.

Malcolm

  • 0
    SUGGESTED

    Hi Malcolm,

    Thanks for using Sage City.

    To import transactions in a foreign currency, you must use the foreign currency value and enter the exchange rate for the transaction in the Exchange Rate field.

    You can import the following types of transactions in a foreign currency:

    • Sales invoice (SI)
    • Sales credit (SC)
    • Purchase invoice (PI)
    • Purchase credit (PC)

    If importing Base currency transactions, you should enter 1 in the Exchange Rate field.

    If this has answered your question please click More > Verify Answer.

    Regards,

    Paul

    Sage UKI

  • 0 in reply to Paul Morgan

    So you can't enter BP or BR in foreign currency via the Journal Template.

    I've already found out that you can't sent up foreign currency nominal ledger accounts to cover foreign currency investments and loans.  The foreign currency part of Sage apparently only deals with Bank accounts, customer ledger and purchase ledger.   Now, as I understand it you can't even import nominal ledger entries from our foreign currency bank accounts into Sage by way of journal but have to type them in entry by entry.

    Am I really correct about this?   I thought Sage did multi-currency accounting.  It appears if this is true that it is a very limited form of multicurrency accounting.  

    Can I not get foreign currency statements into Sage (bank payments and bank receipts), without typing each entry in separately?

    Malcolm

  • 0 in reply to MalcolmB

    Thanks correct Malcolm, you can only import the above types of transactions in a foreign currency.

    You can access our guide to Sage Accounts Foreign Trader for full details on how Sage 50 / 50cloud Accounts deals with foreign transactions.

    Regards,

    Paul

    Sage UKI