ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Mapping Tab
2
Why mapping?
3
1. Mapping tab is due to Odoo provide the standard chart of accounts and links to some backend standard behavior.
Archiving all the Odoo exisiting CoA is not recommended.
4
Mapping process
5
2. Prepare Company Client account list to client account tab and Odoo account list (by export) to Odoo account tab.
6
3.First map client account 'type' with odoo account type. We can't create 'new account type', it's also a very rare request. It will be a development if you need a new account type as it impacts the accounting report.
7
8
4. Create three new tabs: Mapping, Import exist and Import new.
This template is based in Canada.
9
5. At the mapping tab, copy Odoo account. Change original Name column to 'Old names', Code to 'Old code. Add two extra columns called: Name and Code. Then add an empty column. Copy Client account to the right.
10
6. In the Client Account tab, group by account type.
Case A: Client account (per type) is less than Odoo account (same type)
I.e: Bank and cash. If client has 2 bank accounts but Odoo account tab shows 3 bank and cash account, randomly pick 2 out of 3 bank and cash account from Odoo. In the mapping tab, Odoo account type column, group by 'bank and cash'. Color coded 'green' on the 2 selected account. Then color code the right side client account for the bank and cash type account name.
Case B: Client account (per type) is more than Odoo account (same type)
I.e: Current asset type. If client has 8 bank accounts but Odoo account tab shows 12 accounts. However, only 4 accounts can be changed. The other 8 accounts has to keep as it is. This means we are mapping 8 accounts to 4 accounts.
Green code: In the mapping tab, randomly pick client 4 out of 8 accounts. Change Odoo these 4 accounts name and code to client accounts and copy to 'Import exist tab' include Odoo account 'external ID'. Color coded green these 4 accounts for borth client account and Odoo account.
Red code: Mark Odoo 8 accounts to red. If Odoo 8 accounts (pre-programmed ones) needs to change the 'code', please include in the import exsit tab. Otherwise, we can skip it.
Purple code: Mark 4 new client acocunt to purple and copy to 'Import new' tab.
11
7. At the Import exisit tab, keep the column A (external_id) as it is. If you decide to move around the rows, make sure you move the entire row with column A id.
12
13
Forum post: https://www.odoo.com/forum/help-1/how-to-import-chart-of-accounts-map-chart-of-accounts-228281
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100