Is the sentence It was after reporting in your office had I understood my impulsiveness right?

Nope, unfortunately not. This is a somewhat complex formal sentence. The correct structure will be as follows:

"It was after reportingin your office that I understood my impulsiveness"

It is however still not ideal. Please state in which context you wish to use this sentence...