Thursday, July 29, 2010
Reconnecting
As I suspected, I would have to use the same EFIN number as the Federal Consolidated Group these companies file as part of. It is amazing how speaking to former colleagues can help one figure out obscure questions like this.
I look forward to filing my first tax returns electronically, hopefully my company can file a good many this way, even some that we can file voluntarily.
My final blog entry on this topic is coming up, I plan on pulling together everything I have discussed and discussing this subject more fully.
Until next time, peace.
Saturday, July 17, 2010
New Technological Tax Topic
I would rate myself, on a scale of 1-10 using excel, as maybe a 7.0 or 7.25. Now that I am comfortable using the vlookup function, perhaps even a 7.5 on a scale of 10.0.
I was given the responsibility to automate how certain state tax data is imported into OneSource, the tax processing software used by my company. I had a very good idea how the automatic importation was supposed to work, but I did not have the know-how on how to do it much more efficiently. Learning vlookup helped, but that was not enough.
After speaking to a colleague who gave me a few tips, it made the process of importing data into onesource much easier, which finished my task. The scary thing is all I wound up doing differently was using paste specials, transposing functions, and a new function where a data field is named to make this so much easier to manipulate data. It saved me probably four hours on my project.
It is truly scary what technology is capable of doing sometimes, and how simple functions can really save lots of time.