Loading
Uniconta
Search
Generic filters
Get Uniconta
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
  • Search
  • Uniconta
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Dashboard
    • Company
    • Adaptability
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
  • Resellers
    • Find a reseller
    • Become a reseller
    • Become an integration partner
    • Partner Portal Login
    • Partner Portal sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Downloads
    • Samples
    • Support
  • Accountants
    • Become a Univisor
  • News
  • About us
    • About us
    • Management
    • Contact

Unipedia

  • Introduction
    • Get started with Uniconta
    • Which browser are you using?
    • Get started with an existing set of accounts
  • Converting to Uniconta
    • Conversion tool
    • What can be converted to Uniconta?
    • Converting from NAV to Uniconta
    • Converting from e-conomic to Uniconta
    • Converting from C5 to Uniconta
    • Converting from eCtrl to Uniconta
    • Checking your accounts after conversion
  • General Ledger
    • How to split voucher PDF
    • Chart of Accounts
      • Chart of Accounts
      • Account types
      • System Accounts
      • Import a Chart of Accounts
    • General journals
      • Journal Entries
      • Import from a file
      • Import Bank statement
        • Automatic account selection
      • Posting in foreign currency
      • Posting customer payments
      • How to manage voucher number series
      • Setting up Journals
      • Cancel voucher/delete journal/delete record
    • Bank Reconciliation
      • Bank Management / Bank reconciliation
      • Automatic account selection
    • Budget
      • Budget
    • Reports
      • Account statements
      • Transactions
      • Financial Statement
      • Physical Vouchers
      • Posted Journals
    • VAT reporting
      • VAT reporting – Denmark
      • VAT specification – Denmark
      • EU sales
      • Intrastat
      • EU sales list
    • Pivot table
    • Maintenance
      • Dimensions
      • – Join two dimensions
      • – Reverse charged VAT – Denmark
      • Voucher number series
      • – Automatic allocation of number series
      • Terms of payment
      • – Managing cash discounts
      • Accounting year
      • – Year end closing/opening balances
      • Join two accounts
    • Audit activities
      • Company accounts templates
      • Export transactions
  • Customer
    • Customer
      • Customer
      • – Reconciling Customer Accounts
    • Quick invoice
      • Quick invoice
    • Sales
      • Sales orders
      • – Create purchase/sales order
      • Quotations
      • Mass update
      • – Generate UBL
      • – Purchases and sales without VAT
      • Order journal
    • Reports
      • Statement
      • Transactions
      • Open transactions
      • Payment proposals (SEPA)
      • Ageing report
      • Interest and collection letter
        • – Collection letter messages
      • Invoices
      • Delivery note
      • Stock transactions
      • Order lines
      • Customer statistics
      • Pivot table
    • Maintenance
      • Customer groups
      • Order groups
      • Shipments
      • Terms of delivery
      • Layout groups
      • Number sequences
        • – Error messages
      • Invoice layout
        • – Creating watermarks
      • E-mail setup
        • – Setting up SMTP
        • – Mail server set up
        • – Forwarding e-mails to Uniconta
      • Document messages
      • SEPA set up
      • Mandates (SEPA)
      • Customer Direct Debit
      • Join
        • Join two accounts
        • Join two sales orders
        • Join many
  • CRM
    • – Introduction to CRM
    • Prospects
      • – Creating an quotation for a prospect
      • – Create follow-up
    • Customers & Prospects
    • Follow-up activities
    • Create e-mail list
    • Campaign
    • Maintenance
      • Interests
      • Products
      • CRM groups
      • Follow-up groups
      • Campaign groups
  • Vendor
    • Mass update
    • – Purchases and sales without VAT
    • Reports
      • Statement
      • Merge payments
      • Ageing report
      • Pivot table
    • Maintenance
      • Vendor groups
      • Purchase order groups
      • Vendor layout groups
      • Number sequences
      • File formats for methods of payment
        • – Setting up messages for vendor payments
        • – Setting up bank days
      • Join
      • – Join two accounts
      • – Join two purchase orders
      • – Join many
  • Inventory
    • Items
    • Stock Journal
    • – Posting in the stock journals
    • – BOMs in Uniconta
    • – Handling packaging fees
    • Reports
      • Inventory account statement
      • Inventory transactions
      • Item stock status
      • On-hand
      • Re-order list
      • Pivot table
    • Maintenance
      • – Purchasing number series items
      • Join two items
      • Variants
        • – Default variants
        • – Importing old inventory transactions
  • Project
    • Get started with Project and Time
    • Invoicing in the project module
    • Project Categories
    • Pivot table
    • Project groups
  • Company
    • Company information
    • View a demonstration company
    • User rights
      • Manage users
      • Requests for company access
      • Request company access
    • Maintenance
      • Configure application functionality
      • Preferences
      • Subscription (Administrators)
      • – Create subscription (Administrators)
      • – Create subscription (Client)
      • – From trial period to subscription
      • – Counting financial items
      • Modification URL
      • Create a new company
    • Contacts
  • Administrator
    • Distributor Administration
    • User Login History
    • Partner Plugin
  • Tools
    • Main Menu
    • Save layout as a menu item
    • User Plugin
      • How to change Uniconta’s default plugin path
    • Report Generator
      • Report Generator
        • Acccount statement
        • Collection letter documents
        • Company accounts cover page
        • Picking list
        • Purchase documents
        • Sales documents
      • Create a report to be viewed externally
      • Expression binding for Reports
    • Additional setup
      • Local backup
      • Import e-conomic
  • Data Access
    • Transfer data from Uniconta to Excel
    • OData filter function
  • General
    • User Interface
      • User Profile
      • Shortcut Keys in Uniconta
      • Layout
      • Templates
      • How to search in Uniconta
      • Filter/Clear Filter
      • General tips
    • General Functions
      • Attachments
      • Copy and paste in Uniconta
      • Export data and reports to file format
      • Send documents and data by e-mail
      • Print reports and list forms
      • National company number lookup
      • Excel, export and import
    • Security
      • Who has access to my accounts?
      • Forgot Password
      • Backup
      • Uniconta Security
    • Installation
      • Installation on RDS – Remote Desktop Server
      • Optimal internet access for Uniconta
      • Install Uniconta in Windows 7
      • Uniconta in the Microsoft App-Store
      • Uniconta for Mac

Posting in foreign currency

580 views 18 July 2017 27 February 2018
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
February 27th, 2018
Posting in foreign currency

It is possible to post in foreign currency in Uniconta. If a foreign currency code is used for the account, then the amount MUST be entered in a foreign currency column, otherwise an error will occur upon posting. 

 

There are four currency columns/fields: 

‘Currency’: indicates the currency code on the account.

‘Debit(Currency)’: for making a debit entry in the foreign currency.

‘Credit(Currency)’: for making a credit entry in the foreign currency. 

‘Amount currency’: for making a credit (-) or debit entry in the foreign currency.

 

(Click on screenshot to enlarge).

 

If these column headings are not visible, they can be added by right clicking in any heading and clicking on ‘Select fields’. Read more about Layouts here.

 

When posting in foreign currency, amounts are EITHER entered in the ‘Amount Currency’ field OR they are entered in the ‘Debit (Currency)’ and Credit (Currency) fields’ It is not required to enter a value in all three fields as the ‘Amount Currency’ field and Debit/Credit fields are filled automatically when data is entered in either of them. 

 

The user can choose to just enter a value in the ‘Amount Currency’ field, prefixing a minus sign if it is a credit. The ‘Credit (Currency) field will then be filled automatically. If an amount with no sign is entered in the ‘Amount Currency’ field, this indicates that it is a debit, so the ‘Debit (Currency)’ field will be filled automatically.

 

No sign is required if entering directly in either the ‘Debit (Currency)’ or the ‘Credit (Currency)’ fields. Likewise, if data is entered in either the ‘Debit (Currency)’ or the ‘Credit (Currency)’, then that value is automatically represented, with the correct sign, in the ‘Amount Currency’ field.

 

A simple example is given below.

 

Amount Currency             Debit (Currency)               Credit (Currency)

          20                                        20

         -15                                                                                      15

 

The amount in the foreign currency is automatically converted to the default currency using exchange rate on the relevant date.  Any exchange rate differences to amounts shown on the bank statement will automatically be posted to the ‘Exchange rate difference’ System account. Read more about System accounts here. 

 

Once posted, currency and the default currency are also displayed, as shown in the screenshot below.

 

(Click on screenshot to enlarge).

 

TIP!

If the company has a bank account in a foreign currency, it is advisable to set up a special journal for posting to this account, which includes the ‘Debit(Currency)’,  ‘Credit(Currency)’ and ‘Amount Currency’ fields.  

 

Alternatively, a new layout can be created, called Currency, for example, in a daily journal, which includes the currency fields. Read about layouts here.

 

  • Was this Helpful ?
  • YesNo
Categories: General Ledger, Unipedia

Get in touch with us

Uniconta

  • Uniconta
  • Subscription Terms
  • System Status

PARTNER

  • Resellers
  • Get Uniconta
  • Documentation

INFO

  • News
  • Video
  • Security

Support

  • Unipedia
  • API Support
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
Uniconta
© Copyright 2019 | All rights reserved | info@uniconta.com | Terms & Conditions
Facebook Twitter LinkedIn Youtube