Jan 23, 2012

How to reverse an Accrual Journal Entry in a different date than the original one


Tcode: FBS1 – Enter Accrual / Deferral Journal Entry

FBS1


Enter the data corresponding to your Accrual Journal Entry with a “Reversal Reason” (always 05 for Reversal Journal Entries) and provide a “Reversal Date”. This date should be the date that you intend to reverse your entry; normally for accruals you will put 1st day of your next accounting period. In this case February 1st 2012.

Then complete all the other lines concerning your debits and credits on your entry and save the document.

Now, for any particular reason; you realized that your accrual is not correct and you need to reverse it. Trust me this happens really often at Month End.

To reverse a document you would use FB08 or F.81 to reverse Accrual documents in Mass. But since your Entry is not correct you do not want to reverse it in the actual expected date of reversal that you entered (in my example 2012-02-01); instead you what to reverse it in today’s date.

How would you do that ? Here is a simply trick that not everybody knows .

You should NOT solve this error by creating another Accrual document that offsets your original document.

Go to FB02 to modify the Document that you created.

FB02 Toolbar

Hat

Click on the "Hat" and you will get to the Document Header. There in the lower right part of the window you have a field “Reversal Date” that has the original date that you entered when you created your Reversal Journal Entry. Change that date for today’s date and once you execute FB08 or F.81 your Reversal will be done as of today.

Document Header

Reversal Date

Then you can go ahead and create your new Reversal Entry with the proper information.


If your Company and/or Project needs to implement this, or any of the functionalities described in my Blog, or advise about them, do not hesitate to reach out to me and I will be happy to provide you my services.

9 comments:

  1. This is great information, thank you very much!

    ReplyDelete
  2. Thank you, very helpful

    ReplyDelete
  3. Thanks for the information. I have 1 question though. I deleted the reversal date entry from the header data accidentally and saved it. Now am not able to see the "Reversal date" field in the header data. How to get this field back to key in the old date? or how to deal with this now. Let me now thank you

    ReplyDelete
  4. this is very good explanation. Could you please give us some explanation on FICO

    ReplyDelete
  5. Thank you for this information. Very easy to follow. I was able to reverse my document after changing the reversal date, which was input incorrectly.

    ReplyDelete
  6. I have a question. In your original scenario, by some mistake the document was not reversed in Feb 2012. Now we are in March 2012, is there a way I can change the reversal date to 01-Mar-2012. When I try using FB02, it says the period 01 is closed for editing. Is there an option.

    ReplyDelete
  7. Thanks for helpful information, it had supported me during my peak time

    ReplyDelete