Import Journal template

Question

Hi all,&nbsp;Im a new MYOB user trying to transition a general ledger from an existing accounting system. I require assistance for a general ledger transaction import. I have pulled together the attached transaction journal import and Im getting the below errors. My system is not allowing me to access the sample company template. Any assistance would be greatly appreciated and save me a lot of time.&nbsp;Error -12: Transactions dated before your conversion date may not be imported. This is one I can fixError -15: Account number not found in list of postable accounts. Potentially format related in excelError -19: Unbalanced transaction. TBC. Accounts are grouped per GL extract.&nbsp;&nbsp;Thanks in advance.

gavin12345 · Answer

Hi&nbsp;sc_spl&nbsp;&nbsp;Yes if you want MYOB to use the next number in the order, leave this blank. If you want MYOB to use a specific reference as the ID you can eneter your own ID.&nbsp;RegardsGavin

sc_spl · Answer

Hi gavin12345&nbsp;,&nbsp;Is there limit on journal line entries in the GJ import? We tried to import around 550 lines.&nbsp;How do we know which line we have format error? i have attached screenshot of error log.&nbsp;&nbsp;Appreciate your help on this.&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;RFD&nbsp;&nbsp;Many importing issues can be resolved by first manually entering several GJ's of the type you want to import. Export these. Then use the export template as a guide for your import file. MYOB can be finicky&nbsp;so follow export as closely as possible.&nbsp;RegardsGavin

sc_spl · Answer

Hi Gavin,&nbsp;I am trying to create a GJ import template using the export of similar journal already recorded as per your advice. Looks like the GJ number field is a system controlled, should i leave this field &nbsp;blank as this is a new GJ?

jcarrier · Answer

Hi&nbsp;gavin12345&nbsp;, I am having the same issue with journal import. Could you please advise? Thanks.&nbsp;

Forum Discussion

Import Journal template - MYOB premier

Looking for something else?

Related content

Payslip template

Invoice Template

Premier V9.5

Timesheet Template

AccountRight Premier v19.16

bulk upload journal template

Journal Entry