Results 1 to 3 of 3

Thread: Exporting from Pastel V12 to excel

  1. #1
    Full Member
    Join Date
    Jan 2014
    Location
    Harare
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting from Pastel V12 to excel

    Hie,

    Please assist me on how to export reports (balance sheet, income statement, etc) and save them in excel format so as to edit and put reference notes. Or is it possible to put reference notes to reports on pastel if so how do I go about?

    Thank you.

  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
    There's a rough and ready method and a more sophisticated method.

    The rough and ready method is to simply select the Excel option when printing one of the standard reports and then edit the Excel file. The problem with this method is that you will need to repeat the editing process everytime you run the reports.

    The more sophisticated method is to use the Business Intelligence Centre (BIC) module, which will allow you to custom design report templates that refresh dynamically from your Pastel database whenever you run them.

    The BIC module is an add-on module that can be purchased.

    If you are interested to know more about it, please send me your Pastel base serial number and I will send you a quote and a PDF brochure.
    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
    Full Member
    Join Date
    Jan 2014
    Location
    Harare
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dear Neville,

    Thanks for the options, we recently started using pastel 12, can you highlight the differences and pros and cons of the two options. We were given a thirty day trial of BIC so how do I make use of it. We need to consider all these before we can add on the BIC module.

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. Pastel - Excel compatability in invoicing
    By Miro Bagrov in forum Accounting Forum
    Replies: 8
    Last Post: 22-Nov-12, 12:56 PM
  3. [Question] exporting data in pastel to excel
    By bernardshap in forum Accounting Forum
    Replies: 5
    Last Post: 28-Aug-12, 01:19 PM
  4. Pastel statements - Excel
    By KimH in forum Accounting Forum
    Replies: 7
    Last Post: 27-Sep-11, 12:12 PM

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
  •