Firstly you will need to Export the Template and work from there.
- Log onto readysell
- Before you export the template or add anything to the template, you will need to create 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.
- 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.
- Or just sort the Transaction number and note down the next Journal Number
Select Import/Export from the navigation panel
Expand title Show Me - 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
Expand title Show Me - 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 either noted down or manually 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
Expand title Show Me - 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
Expand title Show Me - 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.
...