Results 1 to 9 of 9

Thread: Pastel - Excel compatability in invoicing

  1. #1
    Bronze Member Miro Bagrov's Avatar
    Join Date
    Dec 2011
    Location
    Pretoria, South Africa
    Posts
    152
    Thanks
    34
    Thanked 51 Times in 41 Posts
    Blog Entries
    2

    Pastel - Excel compatability in invoicing

    I wonder: Is there a way to import a spreadsheet in to Pastel to create an invoicing batch.
    I'm dealing with a large batch of invoices which cannot be grouped by customer, nor are recurring. However I do get the report in spreadsheet here at work

    Any one have experience with these things?

  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
    Hi Miro, it is possible to import data from Excel into an invoice batch, after rearranging the data into the correct format and then saving the file as a CSV file.

    I can assist you with setting this up for you if you drop me an email with the details.
    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. #3
    Bronze Member Miro Bagrov's Avatar
    Join Date
    Dec 2011
    Location
    Pretoria, South Africa
    Posts
    152
    Thanks
    34
    Thanked 51 Times in 41 Posts
    Blog Entries
    2
    Click image for larger version. 

Name:	Pastel Invoice Screen.jpg 
Views:	386 
Size:	49.4 KB 
ID:	3024

    The "batch - import" option doesn't seem to cover for CSV files, only bank manager does - they are using Pastel P11.
    Can it still be done?

  4. #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
    The Batch...Import option will import a CSV file, provided it is laid out correctly.
    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)

  5. #5
    Bronze Member Miro Bagrov's Avatar
    Join Date
    Dec 2011
    Location
    Pretoria, South Africa
    Posts
    152
    Thanks
    34
    Thanked 51 Times in 41 Posts
    Blog Entries
    2
    Can I email you one of the invoice spreadsheets to have a look at?

    The ABSA bank CSV file looks like a typical database structured file.

  6. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Miro Bagrov View Post
    Can I email you one of the invoice spreadsheets to have a look at?
    Sure, send it to me and I will then convert it into the correct CSV format, test it on my side, and then send the CSV file to you.
    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)

  7. #7
    Bronze Member Miro Bagrov's Avatar
    Join Date
    Dec 2011
    Location
    Pretoria, South Africa
    Posts
    152
    Thanks
    34
    Thanked 51 Times in 41 Posts
    Blog Entries
    2
    Quote Originally Posted by Neville Bailey View Post
    Sure, send it to me and I will then convert it into the correct CSV format, test it on my side, and then send the CSV file to you.


    I'll also upload one of the batches here so maybe others can also benefit.


    Maybe I must create a spreadsheet that runs a report to automatically structure the CSV file?
    Attached Files Attached Files

  8. #8
    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 two files.


    Invoice CSV Layout.pdf explains the requirements of the CSV file layout.


    invoices.csv is a sample CSV file that you can open in Excel and edit.


    I have used the first two invoice lines in the example. When you open the file, you will notice that cell E1 and cell E3 (which is where your customer codes must go) reflect 4 and 68 instead of 0004 and 0068. This is an inherent problem with CSV files that are opened in Excel, in which the leading zeros are discarded.


    Before you can import the CSV file into the invoice batch, you need to edit E1 and E3 by inserting '000 and '00 in front of the existing numbers, so that they display as '0004 and '0068. Don't forget to capture the single apostrophe and then save the CSV file.


    My suggestion, in order to avoid the above problem, is to not have leading zeros in your customer codes.
    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)

  9. Thank given for this post:

    Dave A (21-Nov-12), Miro Bagrov (22-Nov-12)

  10. #9
    Bronze Member Miro Bagrov's Avatar
    Join Date
    Dec 2011
    Location
    Pretoria, South Africa
    Posts
    152
    Thanks
    34
    Thanked 51 Times in 41 Posts
    Blog Entries
    2
    Thanks a lot for that advice, you're definitely the Pastel expert.

    This is running towards database management but I will definitely make use of it.

    Again, thanks!

Similar Threads

  1. Pastel Invoicing
    By Martinco in forum Accounting Forum
    Replies: 10
    Last Post: 13-Nov-12, 04:06 PM
  2. Pastel My Invoicing - compatability question
    By KimH in forum Technology Forum
    Replies: 3
    Last Post: 01-Oct-12, 03:23 PM
  3. Pastel My Invoicing
    By KimH in forum Accounting Forum
    Replies: 4
    Last Post: 08-Dec-11, 08:18 AM
  4. Pastel statements - Excel
    By KimH in forum Accounting Forum
    Replies: 7
    Last Post: 27-Sep-11, 12:12 PM
  5. [Question] Pastel invoicing
    By Martinco in forum Accounting Forum
    Replies: 12
    Last Post: 14-Apr-11, 03:07 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
  •