We have no way of knowing all the consequences of our decisions. Perhaps your truth telling kept the business from folding sparing dozens of families. Perhaps the person you refused to lie to/for had a seed planted that changed their lives years later. Lying is always wrong as it causes us to deceive others and to misrepresent objective reality to others. It is also an ideal that no human has ever lived up to, because sometimes, in this impefect world we find ourselves in positions where we have to choose lesser evils.
A classic philosophical/theological conundrum was, "The Gestapo comes to your door and asks if you are hiding Jews in your attic. Is it still a sin to lie, knowing the fate that awaits the Jews if you tell the truth?" Lying is wrong. In this case telling the truth is by far, the greater evil.
You will receive your reward in heaven, though.
Well put.