Excel sheet: 2 hours manual mapping work (for analytical minds)

Exercise 1:
Hereby the file

1. Worksheet "Plak Proef en Saldi balans": this is a download from out of our bookkeeping system until Column Q
From column S till U are formulas
= it's a balance sheet and a profit and loss account that is according our bookkeeping system
BUT the government wants us to report according to other accounting system
This information you find in worksheet "Jaarrekening VMSW" = official model
Worksheet "jaarrekening VMSW" = official template from the government
What needs to be done is the mapping for the 6 and 7 accounts (=profit and loss)
You need to do it in the worksheet "VERTAALSLAG"
How can you do it?
For example

In the worksheet " Jaarrekening VMSW" under account 16800 a passive amount of EUR 464.459,32 is reported
Where he finds those information?
Well go to sheet "plak proef en saldi balans" and you see that it is a sum of


so you do the mapping in "VERTAALSLAG"
168010 16800
168020 16800
168021 16800
168022 16800
168023 16800
168024 16800
168025 16800
168026 16800
168027 16800
168028 16800
168030 16800
168031 16800
168032 16800
168033 16800
168034 16800
168035 16800
168036 16800
168037 16800
168040 16800
168041 16800
168042 16800
168043 16800
168044 16800

the left side is the account of the bookkeeping system
the right side is the official governmental account
Be aware; balance sheet is already ready