Results 1 to 5 of 5

Thread: Pastek Xpress12 casbook import

  1. #1
    New Member
    Join Date
    May 2013
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastek Xpress12 casbook import

    Hi I am using Pastel Xpress 12 _ and I am struggling to import the excel cash book for an exciting Co._ I have imported the new debtor & creditor codes successfully. Please assist.

    Regards
    Paul

  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
    Hi Paul,

    What exactly do you mean by "importing the cash books"? Do you want to import the opening balances or do you want to import the bank transactions from the bank website?
    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
    May 2013
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville

    I receive the bank transactions (exported to excel), I then "code" each transaction_ receipts to a Debtor account and payments to a Creditor and link this to a pastel account
    (see extract below).
    when I try to import this into pastel (I go to process casbooks then Batch), I get a list of errors.

    1 7/3/2012 C 3200000 PayMar_007 #Monthly Account Fee 49.5 0 0 8400000 1 1 0 0 0 49.5
    1 10/3/2012 C GOO001 PayMar_008 Google Cc@google.Co 485442*7795 08 Mar 287.69 0 0 8400000 1 1 0 0 0 287.69
    1 13/03/2012 C MEL002 PayMar_009 C*melkbos Service S 485442*7795 12 Mar 100 0 0 8400000 1 1 0 0 0 100
    Last edited by Dave A; 13-May-13 at 07:27 AM.

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Paul,

    In the three sample rows that you have published here, I can see why you are having errors with the import. The first row should have a G instead of a C just after the date, as the account number (3200000) is a General Ledger account, not a Customer account. What errors are you getting?

    By the way, Pastel does have a Bank Manager module, that will import the bank statements for you, with the added benefit that it can be trained to automatically code the transactions.
    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)

  5. #5
    New Member
    Join Date
    May 2013
    Location
    Cape Town
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville

    Thank you very much!_ you will seriously laugh if I told you what G & C describes.
    The other error I get is the date format with the lines identified - I don't understand because I make sure to use the same format throughout.

    The Xpress package I bought came with a Bank Manager module for a trial period but I did not take advantage of that. Definitely a future option_ just can't afford it right now.

    you have been more than helpful > thank you very much Neville

    regards
    Paul Bailey

Similar Threads

  1. Export/Import
    By Scaffold in forum Tax Forum
    Replies: 5
    Last Post: 22-Oct-12, 10:16 AM
  2. VAT on import
    By Jennajay in forum Accounting Forum
    Replies: 1
    Last Post: 13-Mar-12, 01:33 PM
  3. Can i import these seeds.
    By Meat in forum General Chat Forum
    Replies: 2
    Last Post: 08-May-11, 08:42 PM
  4. [Question] import duty
    By lark ireri in forum Tax Forum
    Replies: 8
    Last Post: 19-Jan-11, 07:41 PM
  5. Import tax???
    By skatingsparks in forum Tax Forum
    Replies: 1
    Last Post: 15-Jul-09, 04:35 AM

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
  •