Revaluate accounts

The purpose of this procedure is to revaluate/revalue the accounts receivable and the accounts payable in connection with monthly statement or annual financial statement for invoices issued in foreign currency (that is, a currency other than the company currency). The procedure compares the exchange rate for a selected date with the rate from the time of the registration. Then a voucher is created for the rate change and this is called to make a currency adjustment or to revaluate the accounts receivable/accounts payable. The invoices that will be adjusted are the preliminary recorded invoices (accounts payable) and unpaid invoices (accounts receivable and accounts payable) for a certain date. You can also choose to automatically create reversal vouchers using accrual accounting.

In the Standard accounts procedure there are separate standard accounts for recording of the adjustment amount.

It is important that the exchange rates in the Currencies procedure are up-to-date before you perform the revaluation. Please note! The AFS rate must be updated manually.

Accounts receivable ledger – Detailed

In the list you see Account, Accounts receivable, Invoice number, Customer, Invoice date, Book amount, Amount Current exchange rate*, Booked exchange rate, Current exchange rate*, and Adjustment amount. The total amounts are shown at the bottom of the list. It is not possible to update any information in this list.

Accounts payable ledger – Detailed

In the list you see Account, Accounts payable, Consecutive number, Supplier, Voucher date, Book amount, Amount Current exchange rate*, Booked exchange rate, Current exchange rate*, and Adjustment amount. The total amounts are shown at the bottom of the list. It is not possible to update any information in this list.

* The name of these columns depends on what you have named the AFS rate in the Currencies procedure.

The presentations determine how the selected list should be displayed/presented. For example if it should be presented as grouped or as total. There are some standard presentations included in the program.

In most procedures where you can load lists, it is possible to create your own presentations. This is done under Presentations in the backstage of the procedure in question. If you create your own presentation you can for example choose if it should have a drilldown function and a drilldown filterering.

You can select which columns the list should consist of, and for each of the columns you can configure grouping, sorting, aggregation, and if the column should be shown in chart form and if it should be printed. Additionally you can also make printout settings, chart settings, and settings regarding extra aggregation.

Read more about this in Presentations.

In a list procedure there is always a tab called Selection where you can select data records in different intervals from the database. The data records are then loaded by using the Load button in the toolbar of the procedure.

Under Selection rows in the backstage of the procedure, you can choose which selection rows that each list type should have, under the Selection tab in the procedure. In the List type field you select for which list type you want to customize the selection rows.

One table shows selection rows possible to select and one one table shows the selected selection rows. You can add, delete, or move selection rows by dragging and dropping the selection rows with your mouse pointer.

Using the Save button you save the selected selection rows.

Read more about this in the Selection topic.