Valid from: 2020.06.00 and later

Exporting accounting records

To export accounting records from Opter, use the Sales ledger export 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 Sales ledger 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.

Creating a sales ledger 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 Economy > Sales ledger export. A list of previous exports is displayed in the window.
2. Click on File > Create export.
3. Select the date up to which the export should apply and the information you want to include.
4. Click on Create.

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

Exporting a sales ledger export

How to export sales ledger export:

1. Select the sales ledger export you want to export by clicking on it in the list.
2. Click on Exports > Export, 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 Economy > Sales ledger.

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

   More about grouping

   • The Transaction grouping option is suitable for most cases. It allows you to see each payment, invoice and credit separately.
   • The Summary per month grouping option provides one account coding per month and is appropriate if the export contains only invoices and credits.
   • The Summary per day 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 Export.

---