Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Import Excel into pastel Cash book

  1. #1
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Red face Import Excel into pastel Cash book

    Hi :-)

    I would like to find out whether it is perhaps possible to type out the entries for the cashbook into excel, and then import them into Pastel?
    I am using PastelStartup V12.

    Thank you

    Regards

  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
    Yes, it is possible, but you will need to save the Excel file in CSV format and the data must be arranged in a particular format.

    I have attached the format requirements.

    To import the CSV file, open a blank cashbook journal. Then click on the Batch button, and then the Import option. You can then browse for the CSV file.
    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 (28-Feb-13), ultramel123 (28-Feb-13)

  4. #3
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thank you very much Neville. This is going to make my life sooooooo much simpler,as I have tons of months to still capture.

  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
    Have you considered getting the Bank Manager module? Makes life even easier!
    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
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I have heard about it... would you perhaps know roughly what the cost is?

  7. #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
    There is an initial cost of R2,550.00 incl VAT, and thereafter an annual Cover fee of R2,059.00 incl VAT.

    I can supply you with the module if you are interested.
    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)

  8. #7
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts
    let me discuss it with my client, and I will get back to you :-) Thank you very much.
    That would really make life easer :-)

  9. #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
    Bear in mind that the quote I gave you is based on the assumption that you are using Xpress V12 Xpress Startup (single-user, single-company).
    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)

  10. #9
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts
    ok great. thank you. I will hear what the "boss" says :-)

    One more thing - if you wouldn't mind assisting please

    when importing the csv into the cash book - (payments) - must I include the "tax" amount in the column, or leave that column blank for pastel to calculate?

  11. #10
    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 always included the VAT amount in the "Tax" column, but I think Pastel will automatically calculate it by virtue of the Tax Code that you will have in the CSV file.

    Perhaps do a test import without the VAT amount and see what happens.
    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)

  12. Thanks given for this post:

    ultramel123 (28-Feb-13)

Page 1 of 3 123 LastLast

Similar Threads

  1. [Question] CSV Template to Upload in Pastel Xpress Cash Book
    By StuMurless in forum Accounting Forum
    Replies: 4
    Last Post: 22-Mar-18, 05:21 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. Different Cash Book balances
    By gmawoyo in forum Accounting Forum
    Replies: 1
    Last Post: 03-Oct-12, 11:22 AM
  4. [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
  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
  •