Showing results for 
Search instead for 
Did you mean: 

How to Choose the Control Account When Creating Journal Entries by Using Import from Excel feature?

0 Kudos

Hi experts,

Is it possible to select the control account we are posting when using Import from Excel? We currently use DTW in order to achieve this, but some users are struggling to handle DTW and its technical approach, so importing from Excel seems more adequate and user-friendly, let's say.

I have tried couple different Excel templates but none of them are getting the desired outcome. The result is always booking the GL set up in the Business Partner, but sometimes we have to book a different one and this process doesn't seem to offer this possibility, unless we are missing something here.

Any thoughts?

Thanks in advance!




View Entire Topic
Active Contributor


To my understanding you would have to set the 'Account Type' column to 'GL', and set the desired control account in the 'Account Code/BP Code' column:




0 Kudos

Hi Johan,

Thanks for your suggestion.

As long as you are posting to a Control Account, you must pass the BP code to the system. If you are informing a BP code, you have to set the account type as BP, then, in the Account Code/BP Code field is expected you inform the BP code. The way you suggested, the system will always return an error message, as you are setting the type as GL. I think it is a three-way match here: Type = BP, the BP Code and the Control Account (pass the GL). The latter is missing here I suppose and I couldn't find it available in the template. Hope it makes sense.


Active Contributor
0 Kudos

I must admit that I do not know enough about accounting to understand what it is you are trying to achieve, and how it should be done. So I will just think some thoughts out loud.

  • The journal entry that you are trying to create would look something this(?):
    In the template there is the 'Record Type' column. Your import file would have 2 or more rows, with 'Record Type' L. The first row with the BP code and 'Account Type' BP, and other rows with Account Type GL and the desired accounts, that just happen to be control accounts.


0 Kudos


When using the SAP client or even DTW, we are able to choose the Control Account where the BP will be booked.


See in the screenshot above. Once you select the BP Code, SAP retrieves the default Control Account set up in the BP Master Data on "Accounts Receivable". On the JE second row, we are crediting the same BP, but using a different control account instead. This is widely used when transferring balances between two control accounts. Another business case is when your accounting has different control accounts to accommodate different transactions, so your Loan postings will be booked in a different account than your Receivables, even when the BP is the same. So the same Business Partner may hold different balances, for different purposes.



Basically, the issue is that Import from Excel feature doesn't seem to give the option of changing the control account to be posted, as I've demonstrated above from the GUI.

I hope it makes sense.