Difference between revisions of "How do I reconcile foreign currency accounts?"

From Catalyst
Jump to: navigation, search
(Viewing, Amending and Reconciling)
 
(5 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
Where you deal with customers or suppliers in a foreign currency, or have a bank account in a foreign currency, it is important to be able to see both the value in your home currency and in the foreign currency, however all the accounting in Platinum is done is your home currency. Reconciling the accounts is very difficult if you cannot see the details in the applicable foreign currency.
 
Where you deal with customers or suppliers in a foreign currency, or have a bank account in a foreign currency, it is important to be able to see both the value in your home currency and in the foreign currency, however all the accounting in Platinum is done is your home currency. Reconciling the accounts is very difficult if you cannot see the details in the applicable foreign currency.
  
Platinum allows you to translate between currencies easily using {{KeyPress|A-E}}. Click [[How do I set up currency translation?|here]] to set up and maintain the currency rates, and [[How do I Add a New Currency?|here]] to add a new currency.  
+
Platinum allows you to translate between currencies easily using {{KeyPress|A-E}}. Click [[How do I set up currency translation?|here]] to set up and maintain the currency rates, and [[How do I add a new currency?|here]] to add a new currency.
  
 
Both the home and foreign currency values are stored for any account or centre flagged with a foreign currency code, with the currency values being calculated from the exchange rate set for the currency at the time of posting.
 
Both the home and foreign currency values are stored for any account or centre flagged with a foreign currency code, with the currency values being calculated from the exchange rate set for the currency at the time of posting.
Line 13: Line 13:
 
* At the bottom of the window, you will see the account or centre shown.
 
* At the bottom of the window, you will see the account or centre shown.
 
* Click twice on the account or centre.
 
* Click twice on the account or centre.
* Transactions for the past 12 months are displayed in both your home and foreign currencies.  
+
* Transactions for the past 12 months are displayed in both your home and foreign currencies.
 +
 
 +
{{Tip|text=To view older transactions press {{KeyPress|F5}}.}}
 +
 
 
* Check the foreign currency amounts at this point against the original documents, statements or bank information, or any other documentation that you have available.
 
* Check the foreign currency amounts at this point against the original documents, statements or bank information, or any other documentation that you have available.
 
* Amend the values if necessary.
 
* Amend the values if necessary.
Line 24: Line 27:
 
== See also ==
 
== See also ==
 
* [[How do I set up currency translation?]]
 
* [[How do I set up currency translation?]]
* [[Dealing with Currency Accounting in Platinum?]]
+
* [[Dealing with currency accounting in Platinum?]]
* [[How do I View an Amount in a Different Currency?]]
+
* [[How do I view an amount in a different currency?]]
* [[How do I Add a New Currency?]]
+
* [[How do I add a new currency?]]
* [[How to Deal with Sales to EU Countries and V.A.T. Reporting]]
+
* [[How to deal with sales to EU countries and V.A.T. reporting]]
* [[How do I Deal with Purchases from EU Countries and V.A.T. Reporting?]]
+
* [[How do I deal with purchases from EU countries and V.A.T. reporting?]]
  
 
{{KB_Tags|reconcile, reconciling, currency, sterling, euro, dollar, yen}}
 
{{KB_Tags|reconcile, reconciling, currency, sterling, euro, dollar, yen}}
{{KB_SL}}{{KB_PL}}{{KB_NL}}{{ZN_Admin}} {{Hint}} {{ZN_Accounts}}
+
{{How}}{{Hint}}{{KB_NL}}{{KB_PL}}{{KB_SL}}{{ZN_Accounts}}{{ZN_Admin}}

Latest revision as of 12:04, 4 February 2020

Summary

This article explains how to reconcile any Sales Ledger or Purchase Ledger account, or Nominal Ledger centre where they need to be held in a foreign currency.

More Information

Where you deal with customers or suppliers in a foreign currency, or have a bank account in a foreign currency, it is important to be able to see both the value in your home currency and in the foreign currency, however all the accounting in Platinum is done is your home currency. Reconciling the accounts is very difficult if you cannot see the details in the applicable foreign currency.

Platinum allows you to translate between currencies easily using <Alt+E>. Click here to set up and maintain the currency rates, and here to add a new currency.

Both the home and foreign currency values are stored for any account or centre flagged with a foreign currency code, with the currency values being calculated from the exchange rate set for the currency at the time of posting.

Viewing, Amending and Reconciling

  • From anywhere that you have the relevant account or centre on the screen, press <Alt+E> to pull up the Currency Exchange option.
  • At the bottom of the window, you will see the account or centre shown.
  • Click twice on the account or centre.
  • Transactions for the past 12 months are displayed in both your home and foreign currencies.
To view older transactions press <F5>.
  • Check the foreign currency amounts at this point against the original documents, statements or bank information, or any other documentation that you have available.
  • Amend the values if necessary.
  • Click the [Value Correct/Unverified] button to mark the 'Amount' as checked and verified.
  • Click the [Balance Correct/Unverified] button to mark the 'Balance' as checked and verified.
Both the 'Amount' and the 'Balance' figures need to be verified as correct. If you mark an item as checked and verified when it isn't, you can simply press the relevant button again to reverse the process.
  • If you want to mark more than one 'Amount' as correct and verified, press <Shift+F3> and all the items prior to the one you have selected will be marked as correct and verified. You can then mark the 'Balance' as correct against the last item of your selection.
Note: This should be a regular process that you carry out on your currency accounts to keep them accurate.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
reconcile, reconciling, currency, sterling, euro, dollar, yen