bulk upload journal template
I tried to follow the online instruction, it said Go to Setup > Import Customised Forms. but we got nothings. we never have any form before. So how to I create a format myself to make sure the file ...
Forum Discussion
Hi SherryltqWahl,
Thank you for your post. I'm sorry for the delay in getting back to you.
Welcome to the Community forum!
From what I understand, you're looking to create an import template for journal entries that you can upload to your file. If that's the case, you would first need to export the file, make the necessary edits, and then import it back as a template. Whenever you need to import journal entries, you can simply open this template, adjust the values as needed, and upload it to AccountRight.
I hope I've understood your situation correctly. If not, please don't hesitate to correct me and provide more details about what you're trying to achieve. I'm here to help.
Cheers,
Princess
Hi Princess,
Thank you for the reply.
I tried to export the file as what you suggested below. however, It will only give me the text file.
When i opened it in excel then it will show me the right column.
if I use my excel as a template, do I save it back to text file? or I save it as CSV or any other particular format will make this work?
When the excel file is ready, you need to save it as a tab delimited file (.txt) or a Comma Separated Values (CSV) file. Provided you map the fields correctly, it should then import into MYOB via the Import/Export Assistant.
The example you have provided is not yet ready. You need to change the display format for amounts so that they show as 3645.00 instead of $3,654.00. The comma here will cause import problems.
Regards
Gavin
Thannk you so much for two of you. I really appreciate.
Just the last part to clarify this template.
I downloaded my existing journal abviously I have got the journal number which was allocated by the system after I put through.
-If I am using this as a template, Do I leave column A empty, MYOB will generate the number for me after I imported? or I have to give a number before I import?
- Also the date format, when I open the existing file, it automatically went to the format MM/DD/YYYY even we used DD/MM/YYYY in the previous manual journal transactions, then does that mean I have to put the same format to be MM/DD/YYYY for MYOB to accept it?
- Our manual journal has the option for tax code but when I download the exsiting jornal entry it will not give me the column for tax code, does that make sense? how to fix the tax code and add the extra column?
-Also If I upload the multiple journals, I think I just leave a empty line in the csv file which I figured out but the tax part really worried me and I am not sure how you guys fix that.
I did a screenshot for the same journal I manually created and the csv version as attached.
Hi SherryltqWahl,
You're welcome! I appreciate your inquiries.
To address your queries:
- There's no need to fill in column A, as the system will automatically generate journal numbers. However, if you prefer specific journal numbers, feel free to input them.
- For the date format, ensure that the format matches the one set up on your PC, as the system follows your default time and date settings.
- The tax code field should have been selected during the export process. If it wasn't, you can manually add it, ensuring to use the correct codes. You may want to consult with your accountant about this.
- For multiple journals, an empty line is required between transactions to indicate that they are separate.
I hope this answers your concerns. Please let me know if you need further assistance.
If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.
Cheers,
Princess
Hi SherryltqWahl,
Thank you for your response.
Once you've checked the format and made the necessary changes, save the file as a tab-delimited (TXT) file. Then import it via the import/export assistant. I'd also like to thank you, gavin12345, for your prompt reply in providing information about importing data. Our Help article, Importing and Exporting Data: Importing and Exporting Tips, has information to assist with this.
If you encounter any issues, please feel free to reach out for further assistance.
If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.
Cheers,
Princess
