Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

 

 

  1. Log onto readysell
  2. Before you export the template add anything to the template, you will need to create a Manual General Ledger Journal with a one Line General Ledger Account but no value in the debit or credit
  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. Select Import/Export from the navigation panel

    Expand
    titleShow Me

  9. Search and highlight the Import in question. In this case we are looking at Journal LInes which resides in the Category of Financials
  10. Click on Export Template Action button in the top ribbon

    Expand
    titleShow Me

  11. Save the template to your desktop or to a folder 
  12. Open up the Journal Lines Template that you just saved
  13. In the Transaction number paste in the Journal number that you created and copy it throughout the entire spreadsheet
  14. 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.
  15. Enter the General Ledger Accounts, Narrative, Debit and Credit Values for the accounts that make up the journal entry.
  16. Save the spreadsheet once completed.
  17. Go back to Import/Export Module
  18. Still highlighted on Journal Lines
  19. Click on Import Data Action button in the top ribbon

    Expand
    titleShow Me

  20. Find the spreadsheet and click on Open
  21. 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

    Expand
    titleShow Me

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

...