I propose that in the P&L budget plan, you should use the template with macro has been sent by me to you.
For some of the columns. I have more details as follows.
1. Cost center: The cost center to plan budget cost.
2. Source CCA : Sender Cost center from allocation and used in Internal order(IO by department) Plan.
In template, please revise Account code /Commitment Item and add formula in sum total. then send to your staff use it.
In the next step, I can run macros from this template to create text file for upload.