10-01-2012 08:27 PM - edited 28-01-2012 04:26 AM
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!
Solved! Go to Solution.
13-01-2012 07:36 AM
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-Commun
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-Commun
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.
17-04-2012 11:03 AM
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.
17-04-2012 01:08 PM
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.
17-04-2012 07:44 PM
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
23-04-2012 02:44 PM
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.
27-04-2012 12:31 PM
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.
27-04-2012 12:45 PM
The examples I posted were for version 19.x, not 2011.
I haven't opened your file to compare.
27-04-2012 02:26 PM - edited 27-04-2012 02:27 PM
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.
Need help with your MYOB product or service?Find out more
News, views and ideas for your businessFind out more
Courses and materials
designed to help you make
the most of your software.