Results 1 to 4 of 4

Thread: CSV Template to Upload in Pastel Xpress Cash Book

  1. #1
    New Member
    Join Date
    Jan 2013
    Location
    Umhlanga
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    CSV Template to Upload in Pastel Xpress Cash Book

    Does anyone have a CSV template to upload bank transactions into Pastel Xpress Cash Book.

    I am looking to do what Pastel Bank Manager achieves without the add on.

    I want a template so that I can download my bank statement in CSV format and then transfer the data into the template and upload it into Pastel thus cutting out the manual data entry.

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    I have attached a PDF document that describes the CSV layout requirements, as well as a sample cashbook payments journal, in CSV format.
    Attached Files Attached Files
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

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

  3. Thank given for this post:

    Dave A (02-Jan-13), KimH (22-Aug-13), StuMurless (02-Jan-13)

  4. #3
    New Member
    Join Date
    Jan 2013
    Location
    Umhlanga
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Neville. Do you use Pastel Bank Manager and if so would you recommend it. From what I understand you would have to pay for Pastel Cover every year as well as the once off purchase of Bank Manager.

  5. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Yes, I do use Bank Manager and I can highly recommend it, as rules can be set for the automatic account allocation (including VAT or not) of transactions with certain strings of characters in the reference.

    You are quite correct regarding the requirement of Pastel Cover (for your entire Pastel setup, not only the Bank Manager module). I personally have an issue with this policy, but that's the way it is, I'm afraid.

    Let me know if you would like me to send you a quote.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

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

Similar Threads

  1. Different Cash Book balances
    By gmawoyo in forum Accounting Forum
    Replies: 1
    Last Post: 03-Oct-12, 11:22 AM
  2. [Question] How to correct a double entry in my cash book
    By AntoinetteReed in forum Accounting Forum
    Replies: 4
    Last Post: 13-Sep-12, 07:32 PM
  3. cash sale in pastel xpress ver11
    By Naseema in forum Accounting Forum
    Replies: 2
    Last Post: 12-Jun-12, 04:30 PM
  4. Making a quotation template in Pastel
    By Martinco in forum Accounting Forum
    Replies: 11
    Last Post: 17-Apr-12, 09:06 AM
  5. Replies: 2
    Last Post: 14-Apr-11, 11:22 AM

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
  •