Results 1 to 5 of 5

Thread: How to "undo" a cashbook entry to a GL a/c and rather map to a supplier

  1. #1
    Full Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    83
    Thanks
    9
    Thanked 2 Times in 2 Posts

    Question How to "undo" a cashbook entry to a GL a/c and rather map to a supplier

    Hi there,

    We have Voda Plumming as a supplier in Pastel. I imported our bank transactions, and when I was mapping my cashbook I accidentally mapped the payment we made to Voda Plumming to the GL account "Maintenace". I then updated my batch. What I really should have done is mapped it to S for a suppler, and then Voda Plumming.

    Does anyone know how I can undo my mistake and have it map to Voda Plumming? Really, the end result I need to make sure of is that when I pull my suppliers report, our expenditure on Voda Plumming will be correctly reflected. I suspect then I need to do a couple of adjustments?

    Sorry, quite confused here. I'd really appreciate the help.

    Best regards,
    Michelle

  2. #2
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,645
    Thanks
    226
    Thanked 353 Times in 309 Posts
    Hi Michelle.

    First make a backup so that if things do not work out the way you expect them to you can restore and try again.

    Now make the exact same entry that you did under payments using the GL Account "Maintenance". Same date ... same reference same everything ... EXCEPT make the amount a minus figure.
    This should reverse the incorrect entry.

    Now make the entry as you should have made it using the "S" supplier and match it to Voda Plumbing.

    Update and check your detailed ledger for supplier and your detailed ledger for "maintenance" to see that it has been sorted.
    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
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,597
    Thanks
    41
    Thanked 424 Times in 370 Posts
    I second what Mike has suggested, but I would like to add that you need to edit the mapping rule that you have created in Bank Manager, so that the error does not repeat itself for future payments to that supplier.
    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)

  4. #4
    Full Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    83
    Thanks
    9
    Thanked 2 Times in 2 Posts
    Hi Mike & Neville,

    Thank you both for your replies. Sorry I've taken such a time to reply. I try to follow your instructions at the time but did not come right. I've been procrastinating since then and finally now I need to get this done. I'm actually in the General Journal right now trying to do the correction. Sorry, I think your steps may assume more knowledge than I have. I have a feeling I should not even be in the General Journal.

    "Now make the exact same entry that you did under payments using the GL Account "Maintenance". Same date ... same reference same everything ... EXCEPT make the amount a minus figure.
    This should reverse the incorrect entry. Now make the entry as you should have made it using the "S" supplier and match it to Voda Plumbing.
    "

    Mike - are you meaning I need to be in the cashbook to do this correction?

  5. #5
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,645
    Thanks
    226
    Thanked 353 Times in 309 Posts
    Hi michellepace. Sorry for the misunderstanding. Yes you need to be in the cashbook.
    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

Similar Threads

  1. Advice? I "sold" two vehicles, signed change of ownership forms and ...
    By Charmaine Walkinshaw in forum General Business Forum
    Replies: 14
    Last Post: 26-Feb-17, 10:02 PM
  2. Unable to view "calculation" or "dispute" - e-filing
    By Boeriemore in forum Tax Forum
    Replies: 3
    Last Post: 14-Sep-15, 09:38 AM
  3. Zuma Controversy " Cast the First Stone...""
    By sgafc in forum South African Politics Forum
    Replies: 23
    Last Post: 17-Feb-10, 03:02 PM
  4. "Grandad Bandit" Serial Bank Robber - Can only happen in the States
    By BBBEE_CompSpec in forum General Chat Forum
    Replies: 0
    Last Post: 13-Nov-09, 12: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
  •