GL Journal import scenario

Hello,

Your Import Scenario should list Account, Subaccount, Reference number, Quantity, and Transaction Description only once.

Each line of your Excel may have either a Debit Amount or a Credit Amount, not both.  Here is an example of a correct GL Import Scenario:

Here is an example of a correct Excel file to go along with the above Import Scenario:

I attached the Import Scenario for you.

Laura

Hi Laura, 

thanks for your answer but I need an import scenario to work with the format I uploaded, there are literally like thousands of lines and they can’t be split in one line for debit , one line for credit. I have both debits and credits in one line. 
thanks 

I’m wondering if you might be best off doing the following:

1. On the GL Preferences Screen, make sure hold batches on entry is selected so that you can save out of balance entries.
2. Disable the lines on your import scenario for your Credit transactions (account, subaccount, amount)
3. Load everything for the debit side of the transaction
4. On the Import Scenario, disable the Debit side items and enable all the Credit side items.
5. Load everything for the credit side of the transaction.
6. Take the batches off of hold and release.

Also - When importing to the GL Transactions, make sure that the order of the steps in your import scenario matches the order of the columns on your GL Journal Entries page.  I also think you have too many <Line Number> rows.  You should just need one <Line Number> =-1 per row that you’re trying to add.  You also cannot manually assign line numbers.  The system will do that for you.

Thank you for sharing your solution with the community @GhazalSh!