Import excel into Pastel

[nikkidv]

I have Pastel Partner 2009 and would like to know if I can export Debtors/Creditors Journals to excel so I can have someone else fill them in daily. And then import the excel sheet back into Pastel? This would saves me loads of time and effort! Any tips/advise would be highly appreciated! 

[Neville Bailey]

The best option would be to process the initial structure of the journal in Pastel and then export the batch, using the file extension CSV (so that the exported file can be opened in Excel).

You can then modify the values and/or add line items to the CSV file, but you need to take care not to change the layout of the file or change the format of the cells.

You can then save the file as a CSV file and then import it into a blank journal.

[nikkidv]

Thanks Neville! Will surely try this.

[morrisedwards]

Thanks Nikkidv for raising this topic and giving us such an appreciable suggestion. And thanks to you also Neville Bailey for your tips. I will surely try this.

[kalumbah]

Thanks Nikkidv for raising this topic and giving us such an appreciable suggestion. And thanks to you also Neville Bailey for your tips. I will surely try this.

Hello Neville
I have the following questions

1)I am using pastel version 17.When a cashbook entry has been consolidated,where can I view its exact makeup?
2)if I want to import a dr/cr journal from excel to pastel.How should the layout be and how do I go about it?Kindly illustrate in journal format.I noted a similar question but I couldn't see debit and credit columns
3)How can I close the prior period to avoid erroneous postings to those periods?
Hillary

[Neville Bailey]

1)I am using pastel version 17.When a cashbook entry has been consolidated,where can I view its exact makeup?

Go to View...General Ledger...Transactions...Entry Type Details.

Select the Entry Type range pertaining to the cashbook journal, and make sure the option "Show Generated Entries" is ticked.

2)if I want to import a dr/cr journal from excel to pastel.How should the layout be and how do I go about it?Kindly illustrate in journal format.I noted a similar question but I couldn't see debit and credit columns

Please refer to post #2 above for my suggestion.

3)How can I close the prior period to avoid erroneous postings to those periods?

You can restrict access to periods other than the nominated period, for each user, by going to Setup...Users/Passwords...Users, and then click on Process Options.

Untick the "Multi Period Processing" option in the General Ledger section.

To select the period in which processing is allowed, go to Setup...Periods and then type in the nominated period in the "Current Period" option on the left.