0

Implementation of Multicurrency in Surf Accounts Reports

Overview

In a global economy, the ability to trade with foreign companies in their native currency is becoming ever more important.  So we have introduced the facility to deal with customers, suppliers and banks in different currencies to your business's main accounting currency ('Base Currency').

You may choose to specify your own customised conversion rates, or use the daily rates provided to Surf Accounts by Yahoo Finance.

Foreign currency transactions will be automatically converted to your base currency, keeping your core accounts correct while dealing with your global partners. 

Implementation of Multicurrency in Surf Accounts Reports

In the new version of Surf Accounts multicurrency features will appear in the following reports.

Customer Reports

» Sales Invoice/Credit Note Report

» Customer Invoice Details Report

» Customer Invoice Margin Report

» Recurring Template Report

» Recurring Sales Invoice Report

» Customer Recurring Invoice Details Report

»Customer Receipts Report

» Aged Customer Balances Report

» Customer Statement Report

»Customer Account Card Report             

»Sales Quotes/Orders Report

»Product Price Report

»Price History Report

»Customer Batch Invoice

In the above mentioned ‘Customer’s Report’ we have introduced the following columns:

Currency Code

In the currency code column the currency of the customer will appear. For e.g. if the customer currency is GBP and your business currency is Euro; GBP will be shown under ‘Currency Code’. 

Exchange Rate

The exchange rate will appear under the exchange rate. Please note if the customer currency and the business currency is same a ‘-‘symbol will appear under the exchange rate. Now if the customer currency is GBP and business currency EURO then the conversion rate will appear under the exchange rate column. As per the settings of the exchange rate will appear under the column.

Currency Net

The net amount in the invoice is displayed under the currency net. For e.g. if the customer’s currency is GBP and the net invoice amount is 50, the currency net column will show 50. However under the net column the multiplied value of currency net and the exchange rate will appear.

Currency VAT

The currency VAT amount of the invoice will appear in the column. For e.g. if the currency net is 50, the currency VAT will be 11.50 applying a VAT of 23%.

Currency Gross

The currency gross value will be the summation of currency net and currency VAT. For e.g. if the currency net is 50 and VAT is 11.50 the currency gross will be 61.50. Please note here the currency of the customer is different compare to your business currency.

For illustration see the below mentioned figures:

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_Image_I.jpg

In the Customer Invoice Sales / Credit Note Report you can sort the report by using the ‘Currency’ drop down.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_Image_II.jpg

In ‘Customer Invoice Margin Report’ you can sort the report by currency as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_Image_III.jpg

In ‘Recurring Template Report’ you can sort the report by using ‘Currency’ drop down.

 

In ‘Recurring Sales Invoice Report’ you can sort the report by using ‘Currency’ drop down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_V.jpg

In ‘Customer Receipts Report’ you can sort the report by using ‘Currency’ drop down as show below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-_Customer_Receipt_Report.jpg

In ‘Aged Customer Balance Report’ you can sort the report by using ‘Currency’ drop down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Aged_Customer_Balance_Report.jpg

In ‘Customer Statement’ you can sort the report by using ‘Currency’ drop down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Customer_Statement_Report.jpg

In “Customer Account Card’ Report you can sort the report by using the ‘Currency’ drop down as shown below.  

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Customer_Account_Card_Report.jpg

In ‘Sales Quotes/ Orders Report’ you can sort the report by using the ‘Currency’ drops down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-_Sales_Orders_Report.jpg

In ‘Product Price Report’ you can sort the report by using the ‘Currency’ drop down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_Product_Price_Report.jpg

In ‘Price History Report’ you can sort the report by using the ‘Currency ‘drop down as shown below.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_-_Price_History_Report.jpg

In ‘Customer Batch Invoice’ you can sort the report by using the ‘Currency’ dropdown as shown below. 

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_-_Customer_Batch_Invoice_Report.jpg

Supplier Reports

»In ‘Purchase Invoice/Credit Note Report’ you can sort the report by using the ‘currency’ drop down as shown below.   

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-_Purchase_Invoice_Credit_Note_Report.jpg

In sort the Supplier Invoice Details Report select the ‘currency’ from the drop down.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Supplier_Invoice_Report.jpg

»Supplier Payments Report

To sort currency wise you can use the ‘Currency’ dropdown in Supplier Payments Report

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-_Supplier_Payments_Reports.jpg

»Aged Supplier Balances Report

To sort the ‘Aged Supplier Balance Report’ by currency select the currency by using the drop down.

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Aged_Supplier_Balance_Report.jpg

»Supplier/ Statement Report

To sort the report currency wise in ‘Supplier Statement Report’ select the currency by using the drop down as shown below.  

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Supplier_Statement_Report.jpg

»Supplier Account Card Report 

To sort the ‘Supplier Account Card’ currency wise select the ‘Currency’ from the drop down as shown below. 

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Supplier_Account_Card_Report.jpg

»Purchase Order Report 

To sort the ‘Purchase Order Report’ currency wise select the ‘Currency’ from the drop down as shown below. 

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-_Purchase_Order_Report.jpg

»Price History Report

To sort the ‘Price History Report’ currency wise select the ‘Currency’ from the drop down as shown below. 

Implementation_of_Multicurrency_in_Surf_Accounts_Reports_-_Price_History_Report.jpg

»Supplier Batch Invoice 

To sort the ‘Supplier Batch Invoice’ report currency wise select the ‘Currency’ from the drop down as shown below. 

Implementation_of_Multicurrency_in_Surf_Accounts_Reports-Supplier_Batch_Invoice.jpg

0 comments

Please sign in to leave a comment.