Results 1 to 6 of 6

Thread: Import excel into Pastel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member
    Join Date
    Jan 2015
    Location
    namibia
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import excel into Pastel

    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! 

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    New Member
    Join Date
    Jan 2015
    Location
    namibia
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville! Will surely try this.

  4. #4
    New Member morrisedwards's Avatar
    Join Date
    Apr 2017
    Location
    Singapore
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  5. #5
    New Member
    Join Date
    Jul 2017
    Location
    Lusaka Zambia
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by morrisedwards View Post
    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

  6. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by kalumbah View Post
    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.

    Quote Originally Posted by kalumbah View Post
    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.

    Quote Originally Posted by kalumbah View Post
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Similar Threads

  1. Import Excel into pastel Cash book
    By ultramel123 in forum Accounting Forum
    Replies: 20
    Last Post: 20-Jun-19, 12:20 PM
  2. Exporting from Pastel V12 to excel
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Feb-14, 08:26 AM
  3. Import excel into xpress 2009
    By RCerva in forum Accounting Forum
    Replies: 0
    Last Post: 12-Jul-13, 02:27 PM
  4. Excel spreadsheet - to convert to CSV for Easyfile import
    By Christel in forum Technology Forum
    Replies: 5
    Last Post: 16-Apr-13, 01:08 PM
  5. Pastel statements - Excel
    By KimH in forum Accounting Forum
    Replies: 7
    Last Post: 27-Sep-11, 12:12 PM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •