Results 1 to 9 of 9

Thread: Pastel Xpress

  1. #1
    New Member
    Join Date
    Jun 2017
    Location
    Northriding
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Xpress

    Good Day,

    Please could you help me. On my cashbooks my balance is incorrect on one of my accounts. How do I undo the balance opening on a cashbook?

    Thanx

  2. #2
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,448
    Thanks
    216
    Thanked 328 Times in 286 Posts
    Hi Monique. You need to find out what caused the opening balance to be "incorrect". Check your earlier months to find out if they are still correct.
    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
    New Member
    Join Date
    Jun 2017
    Location
    Northriding
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Mike C View Post
    Hi Monique. You need to find out what caused the opening balance to be "incorrect". Check your earlier months to find out if they are still correct.
    Hi Mike,
    I went through every transaction for June and can not find the amount that is short. The balance captured and the bank balance does not tie up, I checked every month previous to June and all balance.

    How do I correct the balance on the cashbook? I updated the cashbook by accident before I reconciled the bank.... :-(

  4. #4
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,448
    Thanks
    216
    Thanked 328 Times in 286 Posts
    Hi Monique. The balance cannot just differ if all the transactions entered were correct ... unless of course there was some data corruption (which Neville Bailey would be able to help with).

    Try going to "File - Data Integrity" and run the "Verify Data Only" option. If there is data corruption it should give a report.

    The items I would look for are:
    Something entered in payments instead of receipts and vica versa (that would actually be half the amount that you are out by as the error is doubled by this kind of mis-allocation).
    An entry which has gone into the wrong month.
    A journal entry in which the contra account was a Bank Account. (Pastel normally warns you when you try to do that)
    A transfer from one cash book to another without going via a "Transfer Account".

    Let us know how you fare.
    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

  5. #5
    New Member
    Join Date
    Jun 2017
    Location
    Northriding
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok I found my mistake, I entered the bank statement amount wrong when I did my recon. It was a typo, now my balance on the cashbook shows wrong... How do I fix this mess now?

  6. #6
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,448
    Thanks
    216
    Thanked 328 Times in 286 Posts
    Hi Monique. Glad you found the error. Not too sure where the error occured though. Are you saying that you entered an amount from the bank statement into the cash book incorrectly and then updated or was it when you did the reconciliation that you entered the final total of the bank statement in incorrectly?
    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

  7. #7
    New Member
    Join Date
    Jun 2017
    Location
    Northriding
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Mike, it was when I did my Reconciliation. I entered the value there and updated so my cash book balance is incorrect. :-( Now I need to fix the cash book balance and don't know how!

  8. #8
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,448
    Thanks
    216
    Thanked 328 Times in 286 Posts
    Hi Monique - I see that under the "Change" tab there is an option to "Reconcile / Unreconcile Cash Book".

    I have never used this before so am not too sure how it will work. Please make a backup before you attempt it so that you can restore if it does not work out.

    If this doesn't work then I think we are now in the domain where it might need to be changed internally. Neville Bailey (a member of this forum) has the software to make various adjustment, so I would suggest that you send him a Private Message asking him about it. He is absolutely brilliant on Pastel matters and I can recommend him highly. Please let us know how you get on.
    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

  9. #9
    New Member
    Join Date
    Jun 2017
    Location
    Northriding
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Mike,
    I have done that exercise and still no luck with changing the balance on the cash book. ..... Think best I contact Neville.
    Will give feedback on this when we figured it out for future records :-)
    Thank you for your help!

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] Pastel Xpress POS
    By Col in forum Accounting Forum
    Replies: 1
    Last Post: 09-Jun-17, 01:58 AM
  3. Pastel Xpress v11
    By Colinje1 in forum Accounting Forum
    Replies: 0
    Last Post: 14-Feb-16, 05:07 PM
  4. [Question] Pastel My Business & Pastel Xpress
    By maloosa in forum Accounting Forum
    Replies: 0
    Last Post: 22-Sep-14, 03:17 PM
  5. Pastel Xpress V12
    By Isabel Bothma in forum Accounting Forum
    Replies: 12
    Last Post: 08-May-14, 08:28 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
  •