Results 1 to 2 of 2

Thread: Different Cash Book balances

  1. #1
    Email problem
    Join Date
    Mar 2012
    Location
    Gaborone
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different Cash Book balances

    I am faced with a situation whereby my closing cash book balance in Pastel is different from the opening balance for the cash book for the following month.I cannot figure out where the difference is coming from.Someone had said I should compare the cash book details against the entry type details but I cannot get the difference.PLEASE HELP

  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
    The probable cause of the different balances is that you processed transactions directly into a cashbook ledger account, thereby bypassing the cashbook.

    Whenever you process transfers from one cashbook to another, you need to first process a cashbook payments transaction in the originating cashbook, using a Cashbook Transfer account as the allocation, and then you need to process a cashbook receipts transaction in the destination cashbook, using the same Cashbook Transfer account as the allocation.

    If you have allocated cashbook payments directly to another cashbook's GL account, it will process the entries correctly as far as the GL is concerned, but the cashbook detailed ledger, for the destination cashbook, will not reflect the incoming amount, as no cashbook receipt was processed in that cashbook.

    To fix the above scenario, first create a Cashbook Transfer account in the GL (make it a Balance Sheet account, with Bank as the Financial Category). Then, once you have identified the cashbook payments that were processed incorrectly, recapture them exactly as you did before, but with a minus sign in front of the amount, so that it will reverse your original entry. Then capture them again in the cashbook payments journal, as per the method I described in the second paragraph above.
    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)

Similar Threads

  1. [Question] Opening balances
    By LGripper in forum Accounting Forum
    Replies: 15
    Last Post: 20-Feb-18, 09:59 PM
  2. [Question] How to correct a double entry in my cash book
    By AntoinetteReed in forum Accounting Forum
    Replies: 4
    Last Post: 13-Sep-12, 07:32 PM
  3. [Question] 2011 Opening Balances
    By Rika in forum Accounting Forum
    Replies: 3
    Last Post: 12-Sep-12, 10:28 PM
  4. [Question] Opening Balances
    By JPWilliams007 in forum Accounting Forum
    Replies: 4
    Last Post: 27-Mar-12, 10:44 AM
  5. Take on balances
    By nessa in forum Business Finance Forum
    Replies: 2
    Last Post: 09-Jun-10, 08:42 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
  •