Results 1 to 2 of 2

Thread: Problems importing csv into cashbook

  1. #1
    New Member
    Join Date
    Jul 2020
    Location
    Pretoria
    Posts
    1
    Thanks
    0
    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

    Paul

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,649
    Thanks
    44
    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
    neville@accountingsoftwaresupport.co.za
    www.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. Thanks given for this post:

    Alec Candiotes (30-Jul-20)

Similar Threads

  1. [Question] EASYFILE IMPORTING CSV FILE PROBLEMS
    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
  •