If your accounting software isn't connected to Legalsense, you can still avoid entering your invoices twice. Legalsense can export your finalized invoices to a file that you import into your accounting software yourself. This article explains how the export works, how to download it, and how to configure it.
In this article
Export or integration?
Legalsense offers two ways to get invoice data into your accounting software:
If your firm uses an integration, see the article ↪ Managing the integration with accounting software instead.
Note: Some accounting packages, such as Exact Online, are available both as an export format and as an integration. If you see Export Exact Online under Reports, your environment uses the export, not the integration.
Before you start
- Legalsense sets up one export format for your environment. If you don't see an Export item under Reports, or you want to switch to a different format, contact Legalsense support.
- You need access to reports to download the export.
- Some export formats need to know your ledger accounts first. To configure them, you also need the
manage_accountingpermission. See the article ↪ Permission groups.
What the export contains
The export contains the finalized invoices with an invoice date in the period you choose, including credit invoices. Draft invoices are never included. Depending on the format, the export also contains the debtors that were changed in that period, so you can create or update them in your accounting software.
The file type depends on the format, for example a CSV file, an Excel file, or a text file. Ask your accountant or the supplier of your accounting software how to import it.
Important: Legalsense doesn't keep track of which invoices you've already exported. If you choose a period that overlaps with a previous export, the same invoices are exported again. Make sure you don't import them twice.
Download an export
- Go to Reports → Export [format], for example Reports → Export SnelStart.
Export page under Reports, showing the period of the previous download, the From date and to fields, and the Download button.
- Check the period in the From date and to fields. Legalsense shows the period of your previous download, and suggests a new period that starts the day after it and ends yesterday, so you can continue where you left off.
- Click Download. Legalsense prepares the file in the background and shows the message Your download of [format] is being prepared. We will notify you when it's ready.
- When the file is ready, Legalsense sends you a notification. Open the notification to download the file.
Legalsense notification saying that the export file is ready for download.
- Import the file into your accounting software.
Note: You can leave From date or to empty to export without a start or end date. Use this with care, because it can export invoices you've already imported.
Configure the export
Some export formats need information about your administration before you can download anything: your ledger accounts, VAT codes, and journals. If your format needs this, the export page shows [format] is not set up yet the first time you open it.
- Go to Reports → Export [format] and click Configure [format].
Export page showing the message that the export is not set up yet and the Configure button.
- For each row, enter the code of the matching journal, ledger account, VAT code, or cost center in your accounting software. The rows are grouped into Journals, Ledger accounts, Ledger accounts for custom invoice lines, Office expenses, VAT, Cost centers, and Other.
Export configuration page showing the Journals and Ledger accounts sections.
- Click Next. Legalsense then shows the revenue accounts per user, where you can book revenue for each timekeeper to a different ledger account or cost center. Click Save when you're done.
We advise filling in this information together with your bookkeeper or accountant. The rows have the same meaning as for the integrations. See the article ↪ Managing the integration with accounting software for a description of each section.
To change the configuration later, click Configure [format] on the export page.
Troubleshooting
I don't see an Export item under Reports.
No export format has been set up for your environment, or you don't have access to reports. Contact Legalsense support, or ask your administrator.
I see the message The accounting export can’t be used: …
The export set up for your environment can't be loaded, so Legalsense also hides the Export item under Reports. Contact Legalsense support and include the full message.
The export is missing an invoice.
Check that the invoice is finalized, and that its invoice date falls within the period you exported. The export uses the invoice date, not the date you finalized it.
I get the notification Something went wrong during the download of the accounting report.
Legalsense couldn't create the file. Try again with a shorter period. If the problem continues, contact Legalsense support and tell them the period you tried to export.
My accounting software rejects the file.
Check that the codes on the configuration page match your accounting software exactly. If the format has no configuration page, or the codes are correct, contact Legalsense support.
Comments
0 comments
Please sign in to leave a comment.