Reply
This thread is now archived and closed to new comments.
If you have a question please post a new topic.
User
xdankex
Posts: 1
Registered: ‎10-01-2012
Australia
0 Kudos
Accepted Solution

Solved! Import Data - General Journal Entries

[ Edited ]

Does anyone know if there is a "General Journal Entries" template available? 

 

MYOB Technical Support recommends exporting an existing journal entry and using the format for future journal entries to be imported.  The experience in our office is that it can be difficult to wirtualne biuro get the format right and importing fails more often than not - they have given up and type general journal entries directly into MYOB.

 

It would be great if there was a user friendly template available!

Please use plain text.
MYOB Staff Post
Michael_P
Posts: 128
Registered: ‎04-01-2012
New Zealand
0 Kudos

Re: Solved! Import Data - General Journal Entries

Hi,

 

Welcome to MYOB Community Forum.

To get the best out of this community, we suggest familiarising yourself with the ‘Welcome to New Users’ section at http://community.myob.com/t5/Welcome-to-the-Community/Getting-started-in-the-MYOB-Community-Forums/t... Here you’ll find out where to post your questions, how to give kudos to the people who help and for forum guidelines.

For more for information on how and where to post your questions, I suggest having a look at the following video: http://community.myob.com/t5/Welcome-to-the-Community/Posting-Your-Message-to-the-Community-Forum/td...

We hope you enjoy your interactions in the Community Forum.

In regards to your question re an import template; we do not have a template available for the general journals. To ensure the formatting is correct I would recommend do an export of general journal entries from the MYOB software as this will give you a txt file with the correct formatting and headings so you can add or copy your data to this and then import it back in with your information. Full information on importing/exporting data can be found at either of the below links.

 

AccountRight 2011: http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_faqid=33521

Any earlier version: http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_faqid=9072

Regards,

Michael
MYOB Client Support

Accept as SolutionGot an answer that solves your issue?
Mark it as an Accepted Solution

Please use plain text.
Experienced Cover User
Scout
Posts: 13
Registered: ‎20-02-2012
Australia
0 Kudos

Re: Solved! Import Data - General Journal Entries

Hello

 

I am very interested in this topic and I'm wondering if anyone can help further. 

 

We use a separate payroll package to process our payroll. 

 

I can export the journal from the payroll package to excel and would like to be able to upload it into a general journal into MYOB.

 

I am very familiar with how to do this, having imported into another Accounting package in a previous job - it can work and can save lots of time. 

 

I'm struggling with MYOB though as follows -

 

I have tried exporting a general journal from MYOB to get the required field information.  However the export file contains a fields called "isCredit" and "Amount", whereas when I import I am required to provide four fields of information relating to the amounts in the journal which are "Debit Ex-Tax Amount", "Debit Inc-Tax Amount", "Credit Ex-Tax Amount" and "Credit Inc-Tax Amount".

 

I have tried importing a 2 line journal a number of times but keep getting errors regarding the amount.  It generally says each line must have only a debit or credit but not both.

 

Can someone from MYOB please advise what the contents of these 4 import fields should be if I want to record a journal, say, for 100.00 DR and 100.00 CR and the journal has no GST (ie N-T)?

 

Many thanks if you can help.


Sarah

Please use plain text.
Ultimate Partner
Mike_James
Posts: 2,435
Registered: ‎08-05-2007
New Zealand
0 Kudos

Re: Solved! Import Data - General Journal Entries

I've attached a couple of sample files, one is for import of general journals, and the other for import of transaction journals, which is a simpler format.

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Multi-user cross-platform sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Please use plain text.
Valued Partner
Paul_Coffey
Posts: 168
Registered: ‎11-01-2007
Australia
0 Kudos

Re: Solved! Import Data - General Journal Entries

Hi Scout

 

A much simpler alternative to formatting & importing Payroll Journals would be to set up your payroll In MYOB to reflect the Payroll Categories, Deductions and Superannuation etc. that you are using in your other package. Then create in MYOB an Employee Card called "Weekly Wages" and process ONE pay for each weekly/fortnightly wage total using the totals from other package. You could then take up all ordinary hours, overtime hours, leave hours as well as values.

 

The advantage of doing it this way is that you will then have a payroll activity summary in MYOB, as well as correct total Leave accruals for the business.

 

I do this with several of my clients who have large payrolls and who use a separate Wages file.

 

I hope this coment is useful

Cheers

Paul :smileyhappy:

Paul Coffey
MYOB Certified Consultant, Member Institute of Certified Bookkeepers
Corporate Computer Consultants, Gold Coast QLD
pcoffey@ozemail.com.au
Ph: 07 5265 5255
Please use plain text.
Experienced Cover User
Scout
Posts: 13
Registered: ‎20-02-2012
Australia
0 Kudos

Re: Solved! Import Data - General Journal Entries

Hi Paul


Thanks so much for the time you've spent in answering my query.

 

I'm really looking forward to giving your suggestion with the upload a go...just been a bit snowed under so haven't been able to look at it again.

 

I also like your idea with the payroll.  I'm actually going to investigate further using MYOB to do our payroll.....but need to learn more about this because main payroll is for temps that we charge out to clients.  Our current system integrates payroll and client invoicing.

 

Anyway I'll get back to you to let you know how I go.

 

Cheers


Scout (Sarah)

Please use plain text.
Experienced Cover User
Scout
Posts: 13
Registered: ‎20-02-2012
Australia
0 Kudos

Re: Solved! Import Data - General Journal Entries

Hi Paul

 

I saved your sample journal file and then opened in Excel.  I removed all lines except the headers and the first journal.

 

I then changed the date and account numbers but left everything else.


I then attempted to upload into MYOB and it didn't work.  Same error as I was having - unbalanced transaction.  I've attached the import log and the text file.  I appreciate any guidance you can give.

 

Quick question...have you tested these in Account Right 2011?  That is the version I'm using.


Kind regards


Sarah

 

 

Please use plain text.
Ultimate Partner
Mike_James
Posts: 2,435
Registered: ‎08-05-2007
New Zealand
0 Kudos

Re: Solved! Import Data - General Journal Entries

The examples I posted were for version 19.x, not 2011.

 

I haven't opened your file to compare.

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Multi-user cross-platform sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Please use plain text.
Experienced Cover User
Scout
Posts: 13
Registered: ‎20-02-2012
Australia
0 Kudos

Re: Solved! Import Data - General Journal Entries

[ Edited ]

 

Hi Paul

 

I've solved it!

 

Basically do what the original reply to someone's request for help on this - Export out a journal and the create your import journal with same fields - it didn't work at first, which is why I wrote my original message, but now works perfectly!

 

The fields are different in AccountRight 2011....

 

Thanks for your time.

 

Sarah

Please use plain text.