Results 1 to 4 of 4

Thread: METHOD OF EXPORTING CORRECT PASTEL CASHBOOK

  1. #1
    New Member
    Join Date
    Feb 2015
    Location
    Johannesburg
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    METHOD OF EXPORTING CORRECT PASTEL CASHBOOK

    Hi Everyone, please advise on how I can export or import my CASHBOOK which I have captured into the incorrect Cashbook to the correct Bank Account.

    Thank you

    Kristin

  2. #2
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,242
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi Kristen,

    Make a backup of your work thus far so that you can always restore to your present state if something goes wrong.

    Go to the Cash Book where you have captured everything. Click on Batch at the bottom, and select export. Give it a name such as Payment.asc and save it to your desktop or a place where you can find it easily.

    Do the same with your receipts, giving it a different name.

    Now go to the Cash Book where these entries should have been made. Go to Batch at the botttom, and click import. Find the batch that is relevant, and double-click it. It should import all your entries into the correct cash book.

    NOTE: entries already in the cash book may be overwritten

    Once you have completed it successfully, go to the incorrect Cash book, goto Batch at the bottom and click "delete" and it will clear it for you. Do the same with the Receipts batch.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  3. #3
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Hi Mike,

    Your advice is perfect, but I hope you don't mind if I add one little, but critical, piece of information to your post.

    Before you import the exported batch file into the correct cashbook, the file needs to opened and the reference to the cashbook's GL account code needs to be edited to that of the correct cashbook.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "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:

    Mike C (02-Feb-15)

  5. #4
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,242
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Thanks Nevillie. You are a star!
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

Similar Threads

  1. Correct method to record vehicle expenses for a Sole Prop?
    By Intothedeepbluesea in forum Tax Forum
    Replies: 7
    Last Post: 26-Feb-15, 09:55 AM
  2. Exporting out of Pastel Xpress 12
    By newbie101 in forum Accounting Forum
    Replies: 0
    Last Post: 10-Dec-14, 09:28 AM
  3. [Question] Exporting and Importing Inventory Master File in Pastel
    By HermanS in forum Accounting Forum
    Replies: 6
    Last Post: 26-Feb-14, 09:12 AM
  4. Exporting from Pastel V12 to excel
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Feb-14, 08:26 AM
  5. [Question] exporting data in pastel to excel
    By bernardshap in forum Accounting Forum
    Replies: 5
    Last Post: 28-Aug-12, 01:19 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
  •