Results 1 to 5 of 5

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
    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 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 - 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. 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
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 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 - 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)

  6. #5
    New Member
    Join Date
    Jun 2016
    Location
    Zimbabwe
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to ipmort a payments batch from excel to my cashbook debit side, i am failing, may you please help help me.

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. Different Cash Book balances
    By gmawoyo in forum Accounting Forum
    Replies: 1
    Last Post: 03-Oct-12, 11:22 AM
  3. [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
  4. cash sale in pastel xpress ver11
    By Naseema in forum Accounting Forum
    Replies: 2
    Last Post: 12-Jun-12, 04:30 PM
  5. Making a quotation template in Pastel
    By Martinco in forum Accounting Forum
    Replies: 11
    Last Post: 17-Apr-12, 09:06 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
  •