ALTRK – The extension to SAP Business One which allows electronic book keeping of bank statements and considerably facilitates the registration of classical – the manual ones.

• Work directly from the SAP Business One menu;
• Automatic booking of payments incoming and outgoing in PLN and foreign currencies from a bank statement;
• Automatic compensation of the foreign exchange rate for amounts due and remaining operations on the accounts of the main book.

Program uruchamiany jest bezpośrednio z menu SAP Business One.

Add-On allows to automatically book the payments incoming and outgoing in local currency (the systemic one) and in foreign currencies at the purchase/sale of the currency of the bank.

The basic step is to load a bank statement in an electronic form by pressing the Import button. The program automatically loads the file and will save it in proper tables of the database – thanks to that the data from the statement will be retained and the booking of a given bank statement can be performed at any given moment.

The statement for a given account includes the following:

• Date of the statement;
• Number of the statement;
• Number of the account;
• Currency of the account and the rate;
• Initial, final and available balance

Zaczytany plik może dotyczyć więcej niż jednego rachunku bankowego – np w dwóch walutach PLN oraz EUR.

Every statement also has items which include:

• Name of the commercial partner from the statement;
• Revenue/expense – meaning the proper amount to be paid for the receivables/liabilities;
• Type of currency in which the payment is booked;
• Currency exchange rate;
• Title of the transfer (Details);
• Additionally: after the payment has been made the transaction number of this payment in SAP and the status „Closed” confirming the completion of booking the payment in SAP.

Pozycje wyświetlane są poprzez dwukrotne kliknięcie w pierwszą kolumnę danego wyciągu i rachunku bankowego.

Booking of payments from a bank statement

Process of booking of the payments incoming and outgoing looks the same.

1. A code for the commercial partner is chosen (the first column)
2. After double clicking of a proper item of a bank statement in the first column a window will open „Incoming payments” (for the repayment of receivables) or „Outgoing payments” (for repayment of  liabilities). We select a proper of document (according to what is displayed in “Details” in the item of the bank statement). The field of comments in the payments window is filled with the automatic item „Details” from the bank statement. The field “Reference” is also filled – with the number of the bank statement.
3. After pressing „Add” button the payment in an easy way is automatically entered into the books.

Currency exchange netting

The program, apart from the basic functionality i.e. booking of the payments from a bank statement, is also able to automatically calculate the exchange rate differences for the settlements and operations made in the accounts. This functionality is particularly useful during the evaluation of financial resources and liabilities expressed in a foreign currency on the balance sheet date according to the average exchange rate of the National Bank of Poland.

Kryterium wyboru może być klient lub konto KG, waluta oraz zakres dat

The settlement of the exchange rate differences occurs automatically by choosing a proper document and pressing “Book”. Earlier it is necessary to give the date of booking, the exchange rate of the settlement (e.g. the rate of the purchase of a foreign currency from a bank or the average exchange rate of the National Bank of Poland), the difference account for positive differences (the revenue account) and negative ones (the expense account). Moreover, you can also choose a proper code of the profit/expense centre.

Zawartość tego dokumentu możemy sprawdzić klikając strzałkę przy „Nr transakcji”