Import GL Transactions

Hello @shmaryarichler,

Have you tried using the sample scenario from demo “ACU Import GL Transactions” as reference?

You can find the import scenario attached to this comment.
If you still run into any issues please share your scenario mapping and if possible the exported scenario to XML.

Hope this helps!

Thanks for the quick response.

How do I import the XML file into my environment. Also, how do I export my scenario as an XML file?

Hi @shmaryarichler 

You can Import and Export the scenarios using the clipboard options under Import Scenarios screen:
 

Attached is a copy of my scenario. 

I can use the import function on the Journal Entry form but that only allows for one JE per financial period. I would like to upload 6 periods in one import. Using the JE import would mean doing the import 6 times. I know it’s not a big deal but I have 8 bank accounts so that would mean uploading 48 separate files. If I can’t get the scenario working then I’ll do it that way but I’m looking for a quicker method.

Hi,

I created a new scenario using your xml file and successfully imported 2 journal entries. Thanks.

This is an Easy Fix for the Import out of balance.  Make sure that you do not have Blanks in any of the debit or credit fields...just put in Zeros.

for example in Line 1   put 100.00  (debit column)   0.00 in credit column.

I did have blanks and it worked properly:

@shmaryarichler , I just want to confirm, that you were able to properly import, correct?

Yes, I was able to import properly. Here is a screen shot showing one of the JE’s. It created to because I had one entry for February and one for March.