Results 1 to 2 of 2

Thread: Problems importing csv into cashbook

  1. #1
    New Member
    Join Date
    Jul 2020
    Thanked 0 Times in 0 Posts

    Wink Problems importing csv into cashbook

    Hi, I would like some help on how to solve problems experienced when trying to load a csv file into the cashbook.

    I only bought Pastel Express recently and have a backlog of bank transactions which I want to import into the cashbook.
    I have already gone to the trouble of populating the account codes of each of the transactions before deciding to purchase Pastel.

    We are talking about 500 lines.

    I only have the most recent ofx downloads and loading them to the cashbook works just fine.

    I have exported a sample payments batch to get the correct format of the bank csv document

    I copied all the transactions into this file.

    When I try to import it , it is rejected with message:

    Line 1 Date must be in format DD/MM/YYYY
    Line 1 Invalid date

    My dates are in the format DD/MM/YYYY

    I have tried copying the format of the date on the exported csv batch file but it makes no difference.

    My transactions look like this: ( The 03/01 refers to March/first transaction)

    3 1/3/19 G 1000000 03/1 Fee Account for Services Rendered -70942.96 15 -9253.43 8400000 1 1 0 0 0 -70,943


  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Westville, Durban
    Thanked 439 Times in 385 Posts
    Hi Paul,

    In your sample line, the date reads 1/3/19 whereas it should read as 01/03/2019 to conform with the DD/MM/YYYY format.

    Also, the amount at the end of the line should not have the comma symbol, i.e. it should read as -70942.96 and not as -70,943
    Neville Bailey - Sage Pastel Accounting Consultant
    Phone: 031 521 0080 or 087 095 7895
    IronTree Online Solutions

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

  3. Thanks given for this post:

    Alec Candiotes (30-Jul-20)

Similar Threads

    By Dido3436 in forum Accounting Forum
    Replies: 2
    Last Post: 04-Jul-19, 05:50 AM
  2. Replies: 1
    Last Post: 06-Nov-18, 10:18 AM
  3. Importing Cashbook into PASTEL
    By Elene in forum Accounting Forum
    Replies: 1
    Last Post: 23-Mar-16, 02:21 PM
  4. [Question] Importing Cashbook Payments Batch into Pastel
    By Anemari in forum Accounting Forum
    Replies: 3
    Last Post: 15-Jan-14, 04:30 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