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

Thread: Importing into Pastel

  1. #1
    Email problem
    Join Date
    Jan 2012
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Importing into Pastel

    I have a spreadsheet with columns and under each column is information that must be inserted into Pastel. Attached is a sample XL sheet.
    This xl file will change from month to month with multiple rows. The application generating the xl sheet can also generate a CSV file should the xls not be possible. Surely one of these formats must suffice?

    1. Can my objective be achieved with the attached xl sheet?
    2. How can I import the xl file?

    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
    I've just seen your post, but I'm about to do a remote consultation with a client.

    As soon as I am done, I will respond to your query.
    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
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    OK, here is my response.

    I have assumed the following:
    • The data on your Excel file represents sales data.
    • There is no VAT involved, i.e. the amounts are not VAT inclusive, nor is any VAT added to them.
    • You do not want Pastel to produce invoices, i.e. the data will import as a sales journal.
    • You will have created customer accounts in Pastel with the codes that you have used in column D of your file.
    • Your sales account in Pastel is 1000/000.

    You need to capture your data into a CSV file, in a very specific layout, which can then be imported into a sales journal in Pastel.

    I have attached an Excel file, using your example data, which shows what the layout should be. I wanted to attach a CSV file, but the forum does not allow me to use *.csv as a file extension, so I used *.xls instead - you will need to resave the file in CSV format.

    I have also attached a PDF file which explains what each column heading is, and in what format it should be.

    Once you have populated your CSV file, open a blank sales journal in Pastel, and then select Batch...Import and browse for your CSV file. After the journal has been populated, you can update the journal.

    Let me know if you need any further help.
    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)

  4. Thanks given for this post:

    Missnancyalex (09-Jan-12)

  5. #4
    Email problem
    Join Date
    Jan 2012
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing into Pastel

    Hi Neville & thanx for the quick reply.

    As per your questions: -
    I have assumed the following:
    - The data on your Excel file represents sales data.
    Yes, the XL sheet represents sales data.
    - There is no VAT involved, i.e. the amounts are not VAT inclusive, nor is any VAT added to them.
    Correct, there is no VAT added to the XL Sheet. Can Pastel not add the VAT component or should it be added before importing?
    - You do not want Pastel to produce invoices, i.e. the data will import as a sales journal.
    No, I want to import the XL sheet and want to run the invoicing from Pastel. My third party software cannot do credit notes etc. Only providing sales on a daily basis, therefore the importing on a monthly basis to Pastel.
    - You will have created customer accounts in Pastel with the codes that you have used in column D of your file.
    Correct, all debtors company details & account numbers will be replicated in third party software which will do all costings etc & at month end export into Pastel. Must it be imported into `Sales Journal` or `Debtors`?
    - Your sales account in Pastel is 1000/000.
    Not sure what your question is.


    Attached find a sample of what the Pastel invoice looks like with its relevant columns.

    How long will a XL sheet consisting of 1200 rows take to import into Pastel?

    Thanks again Neville
    Attached Files Attached Files

  6. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by mtpocket View Post
    Correct, there is no VAT added to the XL Sheet. Can Pastel not add the VAT component or should it be added before importing?
    Yes, Pastel can add the VAT component if you set up the CSV file appropriately. I asked the question to establish whether or not your company was registered as a VAT vendor.

    Quote Originally Posted by mtpocket View Post
    No, I want to import the XL sheet and want to run the invoicing from Pastel. My third party software cannot do credit notes etc. Only providing sales on a daily basis, therefore the importing on a monthly basis to Pastel.
    So, do you want the data in your spreadsheet to produce Pastel invoices? If so, then the CSV layout will be completely different to what I attached in my earlier post. Your attachment, however, looks like a monthly statement layout, which implies that you don't want to create Pastel invoices from your spreadsheet, but only to create the accounting entries in Pastel and to produce a monthly debtors statement. If the second scenario is what you want, then how will your tax invoices be produced - outside of Pastel?

    Quote Originally Posted by mtpocket View Post
    Correct, all debtors company details & account numbers will be replicated in third party software which will do all costings etc & at month end export into Pastel. Must it be imported into `Sales Journal` or `Debtors`?
    Not quite - you are now talking about importing Masterfile data, rather than Transaction data. I have attached a PDF file, outlining the CSV requirements for the importing of Customer details. In Pastel, you would go to File...Export/Import and then select Import Customer Accounts and browse to your CSV file.

    Quote Originally Posted by mtpocket View Post
    - Your sales account in Pastel is 1000/000.
    Not sure what your question is.
    This is the default general ledger account reflecting your Sales value in the trial balance or income statement.

    Quote Originally Posted by mtpocket View Post
    Attached find a sample of what the Pastel invoice looks like with its relevant columns.
    As I mentioned above, your attachment is actually a monthly statement layout, not an invoice layout.

    Quote Originally Posted by mtpocket View Post
    How long will a XL sheet consisting of 1200 rows take to import into Pastel?
    A few seconds.

    Perhaps you and I need to have a realtime discussion, outside of the forum, to establish your situation in more detail? I can log onto your system remotely with TeamViewer and we can talk VOIP on TeamViewer.
    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)

  7. #6
    Email problem
    Join Date
    Jan 2012
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import into Pastel

    Hi Neville,

    I do not have Pastel loaded on my side, that is installed at the client. I've created a software that is web based for the courier industry. It does track & trace, POD's saved into a document library, costs a waybill on the fly, etc. I have an export facility i.e. CSV or XL that can export costed waybills between dates etc. My problem is how to import this into Pastel.

    I would like to take this discussion outside the forum & see what can be conjured up. How can we connect?

    Thanks

  8. #7
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Neville Bailey View Post
    I wanted to attach a CSV file, but the forum does not allow me to use *.csv as a file extension, so I used *.xls instead - you will need to resave the file in CSV format.
    Thanks for pointing that out, Neville. Just to let you know I've added csv files to the list of allowed attachment types, just in case you have the need again some time in the future.

  9. Thanks given for this post:

    Neville Bailey (09-Jan-12)

  10. #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
    Quote Originally Posted by mtpocket View Post
    I would like to take this discussion outside the forum & see what can be conjured up. How can we connect?
    We can communicate via TeamViewer and its VOIP utility.

    As a fellow TFSA member, your first hour's consultation with me is free of charge, but I would still like you to fill in your details on my online form here, so that I can open an account for you. Once I receive your details, I will contact you to arrange a mutually convenient time to connect.

    If you can obtain a copy of your client's Pastel database, I can run it on my Pastel system and then run tests on it from the data exported from your system (I can reverse the TeamViewer view so that you can see what I am doing on my system).
    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)

  11. #9
    New Member
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Copy of LJR Prices.xlsxHi,

    I used pastel my business on line, but on the request of my accountant he asked me to revert back to pastel express again.
    I requested from my main supplier for them to send me their price list so that I can import this into pastel, I assumed you can do it.
    Now, the question is:
    How do I import this into pastel, and under which heading do I import it into. The help files I have seen and tried to follow did not include a price cell.
    I will attach the file so that you can see. Your help in this regard will be greatly appreciated.

    Regards

  12. #10
    New Member
    Join Date
    Nov 2015
    Location
    Mozambique
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can't download the attachments, why?
    Last edited by Dave A; 04-Nov-15 at 10:53 AM.

Page 1 of 2 12 LastLast

Similar Threads

  1. [Question] Importing Sales Order detail into Pastel Partner
    By J7J in forum Accounting Forum
    Replies: 5
    Last Post: 19-Feb-14, 11:49 AM
  2. information needed on importing and vat
    By NSW-Jono in forum General Business Forum
    Replies: 1
    Last Post: 06-Jul-11, 04:19 PM
  3. Importing Products, help needed
    By Soundinmind in forum General Business Forum
    Replies: 8
    Last Post: 22-Apr-10, 10:01 AM
  4. Importing 101
    By alm in forum General Business Forum
    Replies: 6
    Last Post: 10-Feb-10, 07:04 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
  •