This article will show you: How to export my accounting from Magicline
Click on the main menu Finance
Go to Tax consultant > Tax consultant portal
Specify the accounting period to be exported.
Click on Export
How to export your accounting ?
Each month, you will export your accounting from Magicline to your accountant.
To do this, simply go to Finance > Tax consultant > Tax consultant portal.
Here, you will initially have an overview of your cash flows and results by account group for a given period.
You can change the period by clicking on the month displayed.
To export your accounting, you just have to click on the Export button in the upper right corner.
Here, under File Format, click on the Excel format.
Under Period, you can specify the accounting period to be exported.
The box "Individual entries by entry account" is the only one you can now check.
Check the box and click on Export.
The Excel file will download to your computer. You can send this file as is to your accountant.
Understanding the accounting export
The Excel file you have just downloaded has different columns.
The columns date, amounts exclusive of tax, including tax and VAT are important for your accountant.
On the other hand, those directly linked to your accounting are the columns :
Counter account" (H)
These are the debit and credit accounts.
To modify the accounts and accounting rules, consult this article in our help centre (link).
Line number 2 = is a monthly subscription payment with a due date for the 01.09.2022.
Thus, Magicline generates an accounting line dated 01.09.2022. This line represents the accounting transaction from the member account (member number BF-18) to the account 7060, with VAT at 20%.
A second line is generated at the payment date of this receivable. At the time of payment, the member's accounting account will be balanced. Here on 19.09.202.
This line records the debit transaction by bank account 5120 to the member account (member number BF-18). Note that VAT is recorded at the time of the due date, therefore the payment line does not include VAT.
Note 1: When you are in your global view of the tax advice portal, Magicline distinguishes between account groups and cash flows. Account groups are all accounting transactions. In our example, the transaction where the claim arises and the transaction where it is paid. The cash flows represent only the payments.
If member BF-18 settles his claim from 01.09.22 on 10.10.22, this is what you will find in the table:
in September :
EUR 59.90 in account group 7060
no entry in the cash flow
in October :
59.50 in cash flow.
Note 2: The turnover that appears in the dashboard menu corresponds to all the sales of the month – and this is independent of the receipts.
What makes up your turnover is all transactions with a due date in the current month.
In other words, all the monthly payments of members whose due date is on the 1st of the month (for example) are therefore included in the turnover of the current month.
Still in the example of my member BF-18. Every 1st of the month, she adds the amount of her subscription to my turnover.