Results 1 to 8 of 8

Thread: Pastel statements - Excel

  1. #1
    Email problem KimH's Avatar
    Join Date
    Jul 2010
    Location
    Cape Town
    Posts
    362
    Thanks
    167
    Thanked 63 Times in 52 Posts

    Pastel statements - Excel

    Hopefully someone can help urgently on this.

    I have recently taken on a new client who insists on having his pastel debtor statements in excel format. When I run statements to excel it does not look the same as a Pastel statement which is what the client wants.

    I am running Pastel Xpress 11, the previous accountant was using Partner - is this a limitation on Xpress or am I missing a setting somewhere that I need to change.
    "If at first you don't succeed, do it like your mother told you."

  2. #2
    Silver Member geraldenek's Avatar
    Join Date
    Jul 2008
    Location
    Somerset West
    Posts
    229
    Thanks
    19
    Thanked 112 Times in 80 Posts
    Hello Kim

    Had a look now - not just a xpress thing - same happening in partner also

    I can remember doing this a long long time ago.... but can't seem to find anything now.... will keep looking and let you know when i do find something

    did he provide you with an example of how it should look?
    Geraldene Kapp
    Professional Tax Help
    www.mytaxhelp.co.za

  3. #3
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    I suggest that you purchase Pastel's Business Intelligence Centre (BIC) module, which will allow you to custom-design any report, in Excel format, including customer statements.

    I have created customer statements for one of my clients, using BIC, who sell to the Shoprite-Checkers group. Shoprite-Checkers will only accept statements in a certain Excel layout (CSV to be exact), so that they can import them into their system.

    Drop me a line if you would like to discuss this further.
    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)

  4. #4
    Email problem KimH's Avatar
    Join Date
    Jul 2010
    Location
    Cape Town
    Posts
    362
    Thanks
    167
    Thanked 63 Times in 52 Posts
    Thanks guys.

    Geraldine - it should look exactly like a statement when you print one directly to screen or .pdf format.
    "If at first you don't succeed, do it like your mother told you."

  5. #5
    Silver Member geraldenek's Avatar
    Join Date
    Jul 2008
    Location
    Somerset West
    Posts
    229
    Thanks
    19
    Thanked 112 Times in 80 Posts
    Quote Originally Posted by KimH View Post
    Geraldine - it should look exactly like a statement when you print one directly to screen or .pdf format.
    Just making sure, cause some people think the html printing looks like excel. I see Neville gave the answer to the problem.
    Geraldene Kapp
    Professional Tax Help
    www.mytaxhelp.co.za

  6. #6
    Email problem KimH's Avatar
    Join Date
    Jul 2010
    Location
    Cape Town
    Posts
    362
    Thanks
    167
    Thanked 63 Times in 52 Posts
    Hey Neville,

    The previous accountant was doing the statements manually onto excel -have the template and have now managed to finalise these. Odd way of doing things if you ask me, but hey the client gets what the client wants.
    For 17 statements every second month it would take far too long to recoup the cost of the additional software. Thanks though.
    "If at first you don't succeed, do it like your mother told you."

  7. #7
    Email problem KimH's Avatar
    Join Date
    Jul 2010
    Location
    Cape Town
    Posts
    362
    Thanks
    167
    Thanked 63 Times in 52 Posts
    Neville, could you possibly send me a quote on that module anyways?
    "If at first you don't succeed, do it like your mother told you."

  8. #8
    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 KimH View Post
    Neville, could you possibly send me a quote on that module anyways?
    Kim, the BIC Standard module costs R2,299.00 incl VAT, plus optional annual Cover of R910.00 incl VAT.
    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)

  9. Thanks given for this post:

    KimH (27-Sep-11)

Similar Threads

  1. [Question] Excel Help please
    By greghsa in forum Technology Forum
    Replies: 16
    Last Post: 04-Aug-14, 02:24 PM
  2. [Question] Pastel Partner - Runtime Error 9 when running customer statements
    By J7J in forum Accounting Forum
    Replies: 0
    Last Post: 15-Aug-11, 09:45 PM
  3. [Question] Help Re: Pastel Customer Statements & incorrect opening balances.
    By Vinruby in forum Accounting Forum
    Replies: 3
    Last Post: 03-Aug-11, 11:28 AM
  4. Pastel Partner to Excel Auto mapping
    By tyrone k in forum Technology Forum
    Replies: 2
    Last Post: 11-May-09, 04:59 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
  •