Importing General Ledger Journal Lines Using Import/Export Module

Firstly you will need to Export the Template and work from there.

1. Log onto readysell
2. Before you export the template or add anything to the template, you will need to either Create a Manual General Ledger Journal with a one Line General Ledger Account but no value in the debit or credit OR note down the next Journal Number.
3. Click on Financials from the navigation panel
4. Select Financials
5. Select Journals 
6. Insert a Journal with the correct date , description and 1 general ledger account , nothing in the debit and credit values for this line.
7. Click on SAVE and note down the Journal Number.
8. Or just sort the Transaction number and note down the next Journal Number

9. Select Import/Export from the navigation panel

    Show Me

   

10. Search and highlight the Import in question. In this case we are looking at Journal LInes which resides in the Category of Financials

11. Click on Export Template Action button in the top ribbon

     Show Me

    

12. Save the template to your desktop or to a folder 
13. Open up the Journal Lines Template that you just saved
14. In the Transaction number paste in the Journal number that you either noted down or manually created and copy it throughout the entire spreadsheet
15. For the Line number field, Enter number 2 on the first line and on the second line enter number 3, then highlight both lines and double click. This will create a consecutive number all the way down the page.
16. Enter the General Ledger Accounts, Narrative, Debit and Credit Values for the accounts that make up the journal entry.
17. Save the spreadsheet once completed.
18. Go back to Import/Export Module
19. Still highlighted on Journal Lines

20. Click on Import Data Action button in the top ribbon

     Show Me

    

21. Find the spreadsheet and click on Open

22. Once the import is complete you will get a pop up box of the import being successfull and the number of records updated. Click on OK

     Show Me

    

23. Go back to the journal that was just imported
24. Check it, remove the initial dissection if you like that has no value.
25. Enter a Manual Value
26. Click on Finalise.