Exporting accounting records

To export accounting records from Opter, use the Müügiraamatu eksport tool. You can create a sales ledger export once, but export it on multiple occasions.

If you do not want to export accounting data but just want to see information about invoices, payments and supplier bills, you can use the Müügireskontra tool, which contains information on invoices, payments and supplier bills. In the sales ledger it is possible to export snapshots of information to Excel, such as order-level account coding and unpaid invoices.

Create an accounts receivable export

When you create a sales ledger export, it will include all the account coding not previously exported, up to and including the date you select. This means that you can never create an export of the same information twice.

To create a sales ledger export, which can then be exported to different formats, proceed as follows:

1. Click on Majandus > Müügireskontra eksport. A list of previous exports is displayed in the window.

2. Click on Fail > Loo eksport.

3. Select the date up to which the export should apply and the information you want to include.

4. Click on Loo.

Your export has now been created and is at the top of the list of exports in the sales ledger export.

Exporting the sales ledger

How to export the sales ledger:

1. Select the sales ledger export you want to export by clicking on it in the list.

2. Click on Eksport > Ekspordi, or double-click on the sales ledger export. One of the transaction list types in the menu can also be selected to export directly to Excel. For information about the different transaction list types, see Majandus > Müügireskontra.

3. Choose the format and how you want to group the information.

   More about grouping

   • The Tehing grouping option is suitable for most cases. It allows you to see each payment, invoice and credit separately.

   • The Kokkuvõte kuus grouping option provides one account coding per month and is appropriate if the export contains only invoices and credits.

   • The Kokkuvõte päevas grouping option provides one account coding per day, for the days for which account coding information is available, and is appropriate if you have included payments in the export as it helps you monitor the current account on a daily basis.

4. Click on Ekspordi.