Results 1 to 5 of 5

Thread: Rogue cashbook transaction between two months... somewhere?

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    122
    Thanks
    14
    Thanked 3 Times in 3 Posts

    Question Rogue cashbook transaction between two months... somewhere?

    Hi there,

    My cashbook has been out of balance since the 1st of May last year. I have found that my May opening balance in Pastel is R8,662.04 less than my true Capitec opening balance for the 1st of May. As a check, I compared my total cashbook Receipts for April to the total Credits on my Capitec bank statement for April. They are exactly the same. I did the same for total Payments in my cashbook and total Debits in on my Captec bank statements. They are also exactly equal for April.

    More over if I add these pastel amounts I get the correct balance (as per capitec's online statement):

    (Cashbook opening balance April) + (Total Receipts April) - (Total Paments April) = 1,586,893.77 ... which exactly matches capitec's opening balance for the 1st of May.

    BUT for some odd reason, my cashbook's opening balance for the 1st of May in pastel is R1,578,230.29 (as apposed to R1,586,893.77)

    Question:
    I have no idea how to investigate any further... I'm hitting a brick wall now with my limited knowledge. Can anyone point me into a direction as to where I can find this mistake? Rogue transaction? Missing transaction? Goodness I simply don't know.

  2. #2
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    122
    Thanks
    14
    Thanked 3 Times in 3 Posts
    Or... since my pastel bank balance is less than what it should be in reality. How about I just make a positive adjustment of R8,662.04 to increase my cashbook's balance and be done with it? ... well if that is even possible. I'm not sure how to do such an adjustment to a cashbook. Would I do a General Journal (and if so what would my contra account be) or would I do a Cashbook entry?

    Fumble. Fumble. Fumble.

  3. #3
    Bronze Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    171
    Thanks
    0
    Thanked 31 Times in 27 Posts
    Print the bank account in the GL - check that all entries are cashbook1 payments/receipts. If you receipted from another cashbook into this one (funds transfer) or a general journal was processed to the account, you will see the entries in the ledger as different entrytypes.

  4. #4
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    122
    Thanks
    14
    Thanked 3 Times in 3 Posts
    Hi Kevin, I hope you are well. Thank you for your reply. Mmmm.... I held my breathe in hope, printed to excel and then filtered on the Entry Type. They were all Cashbook 1 Payments or Cashbook 1 Receipts (across April and May).

    any other ideas?

  5. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,621
    Thanks
    41
    Thanked 430 Times in 376 Posts
    Hi Michelle,

    Print the Detailed Ledger for the cashbook for April and for May (separately), and then print the Cashbook Details report for April and for May (separately), including opening balances.

    Compare the opening balances and closing balances for the two reports, for both April and May.

    Are there any differences?
    Neville Bailey - Pastel Accounting Consultant
    neville@accountingsoftwaresupport.co.za
    www.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. Find the rogue allocation
    By michellepace in forum Accounting Forum
    Replies: 1
    Last Post: 23-May-19, 12:06 PM
  2. Replies: 1
    Last Post: 06-Nov-18, 10:18 AM
  3. retrenched and company takes 2 months to issue ui-19 UIF , now 2 months lost UIF claim
    By Des357 in forum Labour Relations and Legislation Forum
    Replies: 3
    Last Post: 14-Jun-18, 08:46 PM
  4. Gremlin cashbook transaction - Newbee needing input
    By Pmilford in forum Accounting Forum
    Replies: 0
    Last Post: 04-Feb-16, 08:56 PM
  5. PPS BEE transaction
    By duncan drennan in forum BEE and Employment Equity Forum
    Replies: 0
    Last Post: 24-Nov-06, 11:48 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
  •