Configure accounting export files

Accounting export files are formatted files that can be seamlessly imported into your accounting software. To generate these files, you need first to populate your accounting codes.

In 'Settings/Users/Access management' enable the right 'Activate accounting codes'.


1/ Default accounting codes

in 'Accounting/Settings', you can enter the default accounting codes for:
– products: code used if your product or product category is not linked to a code,
– discounts: code used for a sale-wide discount if you have not assigned a product to your discounts,
– credit note: code used for a credit note created after a return/exchange,
– customers: code used if the customer is not linked to a code,
– bank: code used to record bank movements,
– till: code used to record cash movements,
– Discrepancy: code used to record cash discrepancies.


2/ Products mapping

In 'Products/Product settings/Categories', you can assign an accounting account to each category/sub-category when you click on the magnifying glass icon.
The accounting account will apply to all products linked to the category, except if the product itself has a different accounting account.
To assign a specific accounting account to a product, go to its product form in the 'Description' section and fulfill the 'Accounting account' field.
You cannot assign a different accounting account for export sales. Nevertheless, if an account is linked to different tax rates, it will be splitted into different lines in the accounting export file.


3/ Payment types mapping

In 'Settings/General settings/Payment types', you can assign an accounting account to your different payment methods.
You don’t need to add an accounting account to the DIV payment method, as payments are then splitted into others payment types.


4/ Sales taxes mapping

In 'Settings/General settings/Sales taxes', you can assign an accounting account to your different taxes.


5/ Customers mapping

To assign a specific accounting account to a customer, go to the customer form in the 'Customer details'.


6/ Generate export accounting files

In 'Accounting/Export files' select a point of sale and a month.
Accounting export files are automatically generated for different accounting solutions (Sage, EBP, Cegid, Ciel, Intuit, Banana…).

Export files are .CSV files encoded in UTF-8.
Sometimes, you just need to rename the extension (.xls or .txt) before importing the file into your accounting solution.

Export files generated by Hiboutik are your sales data available under the accounting structures Sales/Payments or Sales/Customers.

In 'Accounting/Cash book', you can generate an accounting export file of your cash movements.
In 'Accounting/Store credit' you can generate an accounting export file of your customer credit deposits.