Importing General Ledger Journal Lines Using Import/Export Module

Owned by Diane Partridge
Last updated: Nov 03, 2015
2 min read

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.