Results 1 to 2 of 2

Thread: PROCESSED CASH BOOK INTO WRONG BANK ACC BUT NOT UPDATED (PASTEL XPRESS V14)

  1. #1
    Junior Member
    Join Date
    Sep 2015
    Location
    johannesburg
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PROCESSED CASH BOOK INTO WRONG BANK ACC BUT NOT UPDATED (PASTEL XPRESS V14)

    Ok, so I've done something rather stupid! We have 2 bank accounts for our cash books: an old bank account that is no longer used and a new one that I process into daily. I have processed lots of receipts into the old bank account, but luckily not updated yet. Is there a way to copy and paste these receipts into the correct cash book, or is the easiest thing to just debit the total amount receipted and continue from now in the correct cash book?

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    In the wrong cashbook, click on batch ... export. Save the file as cb.txt in a location where you can find it. Open the file in notepad. You will see your account number for the wrong cashbook, eg "8410000". Press Ctrl and H (replace). Replace "8410000" with "8420000" (the correct cashbooks GL account number) and select replace all. Save the file as CB1.txt. Open the correct cashbook, select batch import, and bring in the file. If it imports cleanly with no errors, go to the old cashbook, select batch, delete batch and confirm. In the correct cashbook, you will have to go and match each transaction again back to the invoices, if you use open item processing. Go to each line and press F3, then complete the matching. Once done, you can update the batch.

Similar Threads

  1. [Question] CSV Template to Upload in Pastel Xpress Cash Book
    By StuMurless in forum Accounting Forum
    Replies: 4
    Last Post: 22-Mar-18, 05:21 PM
  2. pastelV14 - how to delete an updated cash book batch
    By joymash in forum Accounting Forum
    Replies: 1
    Last Post: 24-Sep-16, 06:46 PM
  3. How to correct payment processed for wrong date in Pastel
    By Trushil92 in forum Accounting Forum
    Replies: 1
    Last Post: 06-May-15, 08:10 AM
  4. [Question] How to resolve duplicate invoices that have been updated Pastel Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 12-Dec-12, 10:04 AM
  5. Replies: 1
    Last Post: 06-Mar-12, 07:06 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
  •