Results 1 to 2 of 2

Thread: Pastel Xpress V11 CSV file layout to import Invoices

  1. #1
    New Member
    Join Date
    May 2014
    Location
    South Africa
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Xpress V11 CSV file layout to import Invoices

    Hi

    We work on a system that generates invoices as we load bookings and receive bookings for our services through different portals. There is a feature to export a CSV file to import into Pastel Partner to upload all the invoices and relevant data. However no one seems to know the layout for the CSV file for import into Xpress.

    Is there any one that can assist with the correct lay out?

    Regards,
    Braam

  2. #2
    New Member
    Join Date
    May 2016
    Location
    Durban
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Cool Customer / Supplier CSV import template layout.

    Hi Braam

    I got this form the Help section of Pastel Partner. There will probably be a similar setup in your Xpress Help Section

    Click image for larger version. 

Name:	Import.jpg 
Views:	756 
Size:	76.7 KB 
ID:	6288

    Basically it is two lines of information (unless you are invoicing multiple lines)

    So example of a first line with be

    Header,,,,AAA001,3,01/01/2016,OrderNumber2,Y,0,Please Pay Bank, Bank Number, Pay Us Now, Number 1, Strand Street, Province, Code,,SALEC,0,31/01/2016,031 111 1111, 031 111 1114, Mr Braam,0,No Freight, No Ship,,

    Second line would be

    Detail, 13.44, 3, 15.00, etc etc

    Hope that helped

    Kind Regards

    Dale

    Our company creates EXCEL VBA Templates if you want to create a easier input section

Similar Threads

  1. [Question] How to View Batched Invoices on Pastel Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 5
    Last Post: 28-Jul-14, 12:19 PM
  2. [Question] Recurring Invoices Pastel Xpress?
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 22-Nov-12, 07:29 AM
  3. Replies: 3
    Last Post: 04-Aug-12, 08:18 PM
  4. File name for Tax Type report (Pastel Xpress)
    By J7J in forum Accounting Forum
    Replies: 4
    Last Post: 25-May-12, 10:06 AM
  5. Pastel Xpress Purchase Order Import
    By GerhardvdHeever in forum Accounting Forum
    Replies: 9
    Last Post: 12-Nov-11, 05:08 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
  •