Results 1 to 5 of 5

Thread: PASTEL-CASHBOOK BALANCE AND BANK STATEMENT BALANCE INCORRECT

  1. #1
    Junior Member
    Join Date
    Jan 2016
    Location
    Cape Town
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Unhappy PASTEL-CASHBOOK BALANCE AND BANK STATEMENT BALANCE INCORRECT

    Hi All.

    I have the following problem on Pastel.
    My pastel cashbook balance is completely different as my bank statement balance.
    It reconciles correctly up until the end of October with o differences,it displays a difference from November on wards.
    I've been through my bank statement and my detailed ledger entries thousand times and can't see anything wrong.I went through it entry by entry.
    I've also noticed that I've put through receipts for that month but it does not reflect on the customer statements or in the ledger BUT it does reflect when I want to match open items so that means I did actually process it but it still does not reflect on my statement or ledger.
    Could this be due to using incorrect back ups etc as I might of restored to the incorrect back up.Also is there any way where I can rectify this and how as I would love my bank and cashbook to be reconciled correctly.

    Appreciate any help.

    Regards

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,980
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Doesn't Pastel have a reconcile function?
    The trouble with opportunity is it normally comes dressed up as work.

  3. Thanks given for this post:

    Marley29 (22-Jan-16)

  4. #3
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,242
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi Marley29 - it sounds to me like you have entered your data and then and some stage restored an older backup. That means that all your entries would have been lost and need to be re-entered.

    You should be able to check your cash book against your bank statement by printing out the cash book for November via ...View ... General Ledger ... Transaction Details ... Cash Book Details ... and selecting the month or months that you need to check. If it appears in your bank statement and not in the cash book, then that data will need to be re-entered. If it appears correctly in both, then there might have been some data corruption and I would suggest that you send Neville Bailley a private message asking him to help you as he has the necessary software to do that.

    The other way in which a discrepancy can happen is if you post an amount from one cash book directly to another without going via a ledger account. That will adjust the balance of your Cash Book without reflecting it in any of your ledgers and your Bank Statement will no longer match your cash book.
    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. Thanks given for this post:

    Marley29 (22-Jan-16)

  6. #4
    Junior Member
    Join Date
    Jan 2016
    Location
    Cape Town
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hi Mike

    Thank you for the feedback,I appreciate it.
    I will send an email to Neville requesting him to look at my work via Team Viewer.
    Hopefully I can get this sorted asap.

    Thanks all

    Regards

  7. #5
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    It turns out to have been a data capture error - the period 1 (March 2015) cashbook entries were processed in period 13 (March 2016) by mistake.
    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)

  8. Thank given for this post:

    Marley29 (22-Jan-16), Mike C (21-Jan-16)

Similar Threads

  1. [Question] incorrect opening bank balance in pastel
    By nivashini in forum Accounting Forum
    Replies: 0
    Last Post: 20-May-15, 07:35 AM
  2. Pastel Partner - Trial Balance out of Balance
    By prettypegagirl in forum Accounting Forum
    Replies: 7
    Last Post: 17-Nov-14, 10:47 AM
  3. Replies: 2
    Last Post: 03-Nov-14, 08:43 AM
  4. [Question] Income Statement or Balance Sheet
    By OdetteBK in forum Accounting Forum
    Replies: 3
    Last Post: 12-Jun-14, 04:49 PM
  5. Credit card cashbook won't balance
    By Vinruby in forum Accounting Forum
    Replies: 2
    Last Post: 10-Jan-12, 12:53 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
  •