This article will show you: how to export your accounting from the software
Quick guide:
-
Finance / Tax consultant / Export lists
-
Select "Create export list"
-
Choose the export type and specify the period
-
Confirm with "Create", then download the generated list
How to export your accounting ?
Each month, you will export your accounting from the software to your accountant.
In the Tax consultant portal you 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 the data, go to Finance / Tax consultant / Export lists.
To export your accounting, open Finance / Tax consultant / Export lists and select "Create export list".
-
Under "Type", choose the export you need. For your tax consultant these are the accounting exports (for example "Accounting export (Infor)", "Accounting export (JIMS)" or "SAP export"). Other types such as "Invoice list", "Account sheet" or "Booking entries" are also available.
-
Under "Period", specify the accounting period to be exported. Depending on the selected type, additional fields (such as an account or a description) can be set.
-
Confirm with "Create".
The new entry appears in the export list with its status. Once it is ready, you can download it and send the file to your accountant.
Understanding the accounting export
The exported 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 :
-
Account (G)
-
Counter account" (H)
These are the debit and credit accounts.
To modify the accounts and booking rules, consult the Managing booking rules article in our help centre.
Example:
Line number 2 = is a monthly subscription payment with a due date for the 01.09.2022.
Thus, the software 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, the software 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.