Importing account numbers from a chart

wed · January 7, 2020, 11:09pm

Hello!

I’d like to taylor my Dolibarr to Swedish conditions. Is it possible to import a fixed set of account numbers from a chart, like an xls-file?

Here are the sets that are valid in these parts: https://www.bas.se/kontoplaner/

This is in English: https://www.bas.se/wp-content/uploads/2017/06/English-Chart-of-Accounts-19_0-Table-and-list-november2019.xlsx

dev · July 22, 2024, 8:47pm

Hi,

We also operate a Swedish business and are in the process of implementing Dolibarr for our Swedish branch. Unfortunately, it is not possible to import a fixed set of account numbers directly from an Excel file via the accounting module. Additionally, Dolibarr currently only supports the K1 chart of accounts, which is not suitable for mid-size companies.

We are interested in collaborating with other developers or like-minded individuals to develop and stabilize modules tailored to Swedish standards. Our focus includes accounting, salary and expense reimbursements, Swedish bank connections, Bolagsverket, and skatteverket connections. We aim to support K2 and K3 reporting standards to better serve mid-size companies.

If anyone is interested in collaborating on this project, please feel free to reach out.

Thanks & Regards,
Dev

jonbendtsen · July 22, 2024, 9:42pm

@dev I added some DK business types in this pull request Adding foreninger as DK business entity types by JonBendtsen · Pull Request #25666 · Dolibarr/dolibarr · GitHub

I think that the DK tax departments standard accounting plan was already inside Dolibarr, and I just looked for a Swedish one and found The Swedish mini chart of accounts

If that is not good enough, perhaps add the K2 and K3 char of accounts to these 2 files:

github.com

Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/data/llx_accounting_abc.sql

-- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
-- Copyright (C) 2003      Jean-Louis Bergamo   <jlb@j1b.org>
-- Copyright (C) 2004-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
-- Copyright (C) 2004      Benoit Mortier       <benoit.mortier@opensides.be>
-- Copyright (C) 2004      Guillaume Delecourt  <guillaume.delecourt@opensides.be>
-- Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
-- Copyright (C) 2007      Patrick Raguin       <patrick.raguin@gmail.com>
-- Copyright (C) 2011-2022 Alexandre Spangaro   <aspangaro@open-dsi.fr>
-- Copyright (C) 2015-2017 Juanjo Menent        <jmenent@2byte.es>
-- Copyright (C) 2018      Abbes bahfir         <dolipar@dolipar.org>
-- Copyright (C) 2020      Udo Tamm             <dev@dolibit.de>
-- Copyright (C) 2023      Nick Fragoulis
-- Copyright (C) 2023      Santiago Payà        <santiagopim@gmail.com>
--
--
--------------------------------------------------------------------------------------
-- License
-- #######
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by

This file has been truncated. show original

github.com

Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/data/llx_accounting_account_se.sql

-- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
-- Copyright (C) 2003      Jean-Louis Bergamo   <jlb@j1b.org>
-- Copyright (C) 2004-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
-- Copyright (C) 2004      Benoit Mortier       <benoit.mortier@opensides.be>
-- Copyright (C) 2004      Guillaume Delecourt  <guillaume.delecourt@opensides.be>
-- Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
-- Copyright (C) 2007 	   Patrick Raguin       <patrick.raguin@gmail.com>
-- Copyright (C) 2011-2017 Alexandre Spangaro   <aspangaro@open-dsi.fr>
-- Copyright (C) 2019      swedebugia	        <swedebugia@riseup.net>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--

This file has been truncated. show original

dev · July 24, 2024, 4:49pm

Hi JonBendtsen,

Thank you for your contributions and the pull request regarding the addition of DK business entity types.

Regarding the Swedish Chart of Accounts, you’re correct that Dolibarr already includes the K1 mini chart. However, adding the K2 and K3 charts isn’t as straightforward as importing a .csv file due to several errors encountered during the process. Our team managed to manually integrate the BAS Kontoplan for K3, but this required creating custom groups to meet our specific requirements.

We’re currently testing the implementation with our accountant and developer to ensure it functions correctly within our system. We’ll provide further updates once we have more comprehensive results from our testing phase.

Best regards,
Dev.