Firstly you will need to Export the Template and work from there.
- Log onto readysell
- 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
- Click on Financials from the navigation panel
- Select Financials
- Select Journals
- Insert a Journal with the correct date , description and 1 general ledger account , nothing in the debit and credit values for this line.
- Click on SAVE and note down the Journal Number.
Select Import/Export from the navigation panel
- Search and highlight the Import in question. In this case we are looking at Journal LInes which resides in the Category of Financials
Click on Export Template Action button in the top ribbon
- Save the template to your desktop or to a folder
- Open up the Journal Lines Template that you just saved
- In the Transaction number paste in the Journal number that you created and copy it throughout the entire spreadsheet
- 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.
- Enter the General Ledger Accounts, Narrative, Debit and Credit Values for the accounts that make up the journal entry.
- Save the spreadsheet once completed.
- Go back to Import/Export Module
- Still highlighted on Journal Lines
Click on Import Data Action button in the top ribbon
- Find the spreadsheet and click on Open
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
- Go back to the journal that was just imported
- Check it, remove the initial dissection if you like that has no value.
- Enter a Manual Value
- Click on Finalise.