Foreign Exchange Transaction

Foreign Exchange Transaction report in TallyPrime displays all the vouchers with multi currency.

This report will help the user to check if the proper rate of exchanges are entered and other guidelines regarding the Forex are followed during the transactions.

Foreign Exchange Transaction Report in TallyPrime

In this section

1) View the Forex Transactions report

2) Button options in Forex Transaction screen

A..  View the Foreign Exchange Transaction report

Gateway of Tally > Display More Reports > Analysis & Verification > Voucher Verification > Forex Transactions. Alternatively, press Alt+G (Go To) > type or select Voucher Verification > and press Enter.

Note : The Foreign Exchange Transaction report in TallyPrime displays the Name of the Voucher Type, Type of Voucher, Total Vouchers for each Voucher Type, Forex Vouchers for each Voucher Type and count for Verified Vouchers. The user can press Enter in the Forex Vouchers column to display the Forex Vouchers report for the selected Voucher Type.

Button options in Foreign Exchange Transaction screen

1) Press F4 (Voucher Type) to filter and view the Foreign Exchange Transactions for the selected Voucher Type.

2) Press F9 (Analysis & Ver Reports) > type or select Movement Analysis > press Enter.

3) You can follow this step to open any of the Accounting, Inventory, and Verification reports from the list. Press Alt+F12 (Range) to use the Range Filter option to search the specific vouchers from the list of Vouchers under each Voucher Type.

4) Press Ctrl+F12 (Value) to use the Value Filter option to search the specific vouchers as per the specified user defined criteria.

How to upload bank statement in Tally Prime?

By following these simple steps any bank Statement can be uploaded / imported in Tally Prime through Bank Reconciliation process:- ∙

The bank statement can be imported for bank reconciliation. Depending on the bank that is selected, the supported formats will appear, for example, Excel, MT940 and .CSV.

Step 1 : Gateway of Tally > Banking > Bank Reconciliation > and press Enter.

Step 2 : Alternatively, Alt+G (Go To) > type or select Bank Reconciliation > and press Enter.

Step 3 : Select the required bank.

Step 4 : Press Alt+O (Import) > and select Bank Statement. The Select File screen appears, as shown: The Select File screen displays the Directory which is specified as the Location of new bank statement files in F12 (Configuration) > Banking Configuration.

Step 5 : Select the required file format in File Type field. Based on the format selected the bank statements are displayed under List of Files.

Step 6 : Select the file to be viewed.

Step 7 : Press Alt+B (With View). The Bank Statement appears as shown below:

Step 8 : Press Esc if you do not intend to import the bank statement.

Step 9 : Press Alt+H (Import) to import the bank statement. The import progress bar is displayed followed by the Success message with count of Total Entries in Bank Statement, Reconciled transactions and Additional Bank Entries. The Bank Statement appears as shown below:

Step 10 : Press any key. After importing the bank statement, the bank dates are filled in the Bank Date column automatically in the Bank Reconciliation screen.

Step 11 : Press F12 (Configure) from the Bank Reconciliation screen. Set Show Difference in Bank Balance to Yes.

Step 12 : Accept the Configuration screen. The Bank Reconciliation screen with imported bank statement details appears as shown

There may be transactions which have been executed at the bank’s end (for example, bank charges, interest credit, and so on) but not yet reflected in the books of accounts. The details of such transactions will appear under the Amount Not Reflected in Company Books in Bank Reconciliation screen. You can reconcile them with existing transactions or create new vouchers.

Note: To avoid errors, save the Bank Reconciliation before reconciling the unlinked transactions.

Video : 

Update to Tally Prime 2.1 Release

You may be using Tally ERP 9 or an older TallyPrime release and you want to update the release to the latest release of TallyPrime 

There can be four cases associated with updating an older release to the latest one.

You are using a :

Tally ERP 9 application and want to update to the latest TallyPrime release.

To update an application:

1) Double-click setup.exe.

2) Select the to be updated and press Enter.

  The TallyPrime Setup Manager screen appears as show below:

  Updating Tally.ERP 9 to TallyPrime’s latest release:

3) Press C (Configure) to configure Application Path and other settings, if needed.

4) Press I (Update).