Results 1 to 3 of 3

Thread: Imports to Pastel Partner

  1. #1
    New Member
    Join Date
    Feb 2015
    Location
    Paarl
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Imports to Pastel Partner

    I hope someone can assist me in creating an import sheet for my Invoices into Pastel.

    I generate our invoices on Excel and then have to capture it in Pastel again... Surely there must be a way of importing this data without having to capture invoices again on Pastel...

    I am attaching a spread sheet of some typical data I would like to import.

    Thanks
    Attached Files Attached Files

  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, provided that you set up a CSV file in the correct layout and format. It also depends on whether you want to import the data as invoices, or as journals to the various customer accounts. From the spreadsheet you attached, I think a journal import will be sufficient and easier.

    In order to establish a template CSV layout, into which you can copy and paste the data from your spreadsheet, open Pastel and create a sample customer journal, using one or two of the invoices in your spreadsheet. Then export the journal batch by clicking on the Batch button at the bottom and selecting the Export option. When typing in the export file name, make sure that you insert the file extension cvs. For example, name the exported file as batch.csv. This will allow you to open the file in Excel.

    Once you have populated the CSV file with the invoice data you wish to import into Pastel, save the file and then open a blank customer journal. Then click on the Batch button, select the Import option and browse for the CSV file.
    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. #3
    New Member
    Join Date
    Feb 2015
    Location
    Paarl
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Neville...
    I will do that!

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] Pastel Partner v 9.3.4
    By Martinco in forum Accounting Forum
    Replies: 6
    Last Post: 07-Jan-16, 05:17 PM
  3. [Question] Pastel Partner over VPN
    By kevvie in forum Accounting Forum
    Replies: 1
    Last Post: 14-Aug-14, 06:36 PM
  4. Pastel Partner to Pastel Express
    By vieome in forum Accounting Forum
    Replies: 2
    Last Post: 19-Feb-13, 12:45 PM
  5. [Question] Pastel Partner
    By Goop in forum General Business Forum
    Replies: 5
    Last Post: 15-Aug-10, 06:58 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
  •