Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Import Excel into pastel Cash book

  1. #1
    Junior Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    22
    Thanks
    8
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "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
    Junior Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    22
    Thanks
    8
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Have you considered getting the Bank Manager module? Makes life even easier!
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  6. #5
    Junior Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    22
    Thanks
    8
    Thanked 0 Times in 0 Posts
    I have heard about it... would you perhaps know roughly what the cost is?

  7. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  8. #7
    Junior Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    22
    Thanks
    8
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  10. #9
    Junior Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    22
    Thanks
    8
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "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 2 12 LastLast

Similar Threads

  1. [Question] CSV Template to Upload in Pastel Xpress Cash Book
    By StuMurless in forum Accounting Forum
    Replies: 3
    Last Post: 02-Jan-13, 01:38 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
  •