Thursday, April 28, 2016

In Conclusion

As my final week draws to a close, I am wrapping up my research with one final post to summarize what I have learned.

I came in thinking that there was a quantifiable percentage of time dedicated to both serving the government and serving the client. I thought that around 75% of the time would go to filing government forms and making sure plans are in compliance, and the other time would be spent talking to clients and administrating each plan.

However, my research has showed me that there actually is not a quantifiable amount of time being spent on each thing; in fact, much of the government-related and the client-related work overlaps. Filling out Account Reconcile and Balance and Income sheets helps the client know what is going on in their plan and the financial state of their plan as a whole, but it is also important to helping us with compliance testing for the government.

Also, not everybody does the same thing; some don't ever talk to clients, and some don't fill out Account Reconcile and Balance and Income sheets. As a result, you can't quantify allocation of time, because everybody's allocation is different.

I really enjoyed my time as an intern for MGKS. All of my co-workers were very nice, and I got a lot of experience in the workplace. I am happy that I enjoy accounting, and am very excited to study it in college. I hope you liked reading my blog, and I hope you learned a lot too!

-Alexandra Cvancara

Efficiency In The Workplace

Included in the survey were also questions regarding what helps you work, such as listening to music and snacking.



Most of my coworkers seem to enjoy a tasty snack while they work (same goes for me). They also all said that snacking helps keep them focused on work.

Also, most listen to music. The music they listen to varies widely- from Disney music to country to classical to rap, and more. They said that listening to music helps filter out the outside noise, so they can focus on the work that they are doing.

Time Spent On Government Comlpience

This survey also included questions about how much time they spent filling out government forms, like the 5500 and the 5330.

Like the previous graphs, the answers here were also very spread out. This is because there are many different forms, and everyone fulls out different amounts of these forms.

In general, the 5500 Short Form takes about 10-20 minutes to complete, while the long 5500 form can take anywhere from an hour to an entire day, depending on the plan.
The 8955 is one of the shortest, taking around 10 minutes to complete, sometimes less. The same goes for the 1099 R forms.

Time Spent Serving The Client

I handed out a survey to my co-workers that asked them to detail how much time they spent answering emails, talking on the phone and filling out Accounts Reconcile and Balance and Income statements. Here are the results:



As you can see, there are many different answers for each of these questions. This is because everybody's job is different; some people administrate many small plans, while others administrate a few very large plans, and in between. 

Monday, April 25, 2016

Filing a Tax Return

While my work doesn't deal with filing tax returns, I have learned what not to do with taxes from the people around me (many of them are CPAs).

You see people all over the internet that received their tax refund, and go buy a video game console or a tiger or something, and you think, I want that! Well, here's why you don't:

That money is not free money that the government is giving you out of the goodness of their heart; it's YOUR money that YOU overpaid. No big deal though, they're giving it back to me, right? Wrong. It's always better to owe money, because someone could easily steal your identity and file a tax return in your name
(this has happened to my parents both the last 2 years). If you are getting a refund and someone files a tax return in your name, they now have your money, and you're fresh out of luck. But if you owe money, then the identity thief doesn't get anything (what're they gonna do, pay your taxes for you?). The money you would have gotten back as a refund, you already have, and you just owe some money to the government.

This is the one time I would say that owing money is a good thing. Your money is safe from identity thieves who file a tax return in your name.

Type Of Investments

There are 3 typed of investments: Safe, medium, and aggressive.

Safe investments will get you small, steady growth in your retirement account. An example of this would be government bonds and money market funds.

Medium investments can increase or decrease, but the fluctuations are not by a huge amount. An example of this would be buying a stock in google or apple, companies that may fluctuate, but in general are stable and aren't a risk of going out of business. When invested smartly, these investments will get you more back than a safe investment, but there is always a risk that you will lose money.

Aggressive investments are high risk, high return investments. These can fluctuate a lot, and you can either lose a lot or gain a lot. I've seen a plan with risky investments that started off with around $500k in the plan, and by the end of the year had $1.5 million. To put that in perspective, your money is said to double every 7 years, and his tripled in just 1. However, I've also seen plans with risky investments that lost $100k in a year. If you're someone that really likes to take risks and is willing to spend a long time researching the best risky investments, by all means invest here, but if you're just a regular person, stay away from these.

How Should I Save My Money?

Remember, all the money you save won't be all you have. You'll receive interest payments on the money you deposit. Also, your employer will deposit some money to your account, depending on the kind of plan you have with them (as discussed in previous posts). But the real bucks comes in when you start to invest.

Investment dividends can get you a couple hundred bucks a month for your retirement. Also, the stocks you hold in your account can change value, which adds value to your retirement account (and if they go down, it can subtract value). So while you could have $300k in your account, only a couple thousand of that would be cash, and the rest would be the value of stocks that you buy. Depending on the economy, you can gain or lose, so you should always talk to your financial adviser about what type of investments you can make (more on investments in the next post).

But you should be smart with your investments; I've seen plans with steady growth, and I've seen plans with massive increases and decreases per month. I've seen doctors that throw money into their account like it's going out of style, just to lose $60k in one month due to over-investment. Be smart, this is your hard earned money, and if it looks like the economy is going downhill, invest in something safe.

How Much Should I Save?

Hopefully, you'll live a nice, long life after you hit 65. But those social security checks from the government aren't going to be enough to live off of (and let's face it, social security probably won't even be around by the time we hit retirement).

So how much should you save?  I'd say the golden number for how much to save is anywhere from 15-20% of your total income, the higher the better (at least, when you're young). Also, if you work at a job that gives you a pension after you retire (like a government job), then you don't have to save as much. You should consider this when choosing your first job.

When to Start Saving for Retirement

There are a lot of misconceptions about saving for retirement. One of them is that you start saving for retirement when you're around middle age, and you're salary is high (or at least, higher than when you started working). But this is not the case.

Through my work, I have come to learn that the opposite is true: you need to start saving NOW. When you've just started working, you should have a strict budget; instead of buying the new PlayStation or going on that trip with all your friends, you should save that money for retirement. When you're young, you don't have kids to pay for or, and you may not even have a mortgage or a car loan yet. This is when you need to start saving.

I know it's exciting to have your first professional job, now you have money and can buy the things you want, but what you really need is to save, save, save. Your future self will thank you. Because once you hit the age where you want to get married and have kids, you can cut back on the saving, because the dividend and interest money you get off the money you saved when you were young will make it so you don't have to save as much in the future.

Bottom line, SAVE NOW! This is something you can't put off.

Sunday, April 24, 2016

Online Statements

Some of our statements we get online. While it would seem like it would be much easier to do things online, it is actually a huge pain.

Because of all the security on these sites, in order to access the online statements, we have to have an account set up for us. To get this account, we have to ask the plan administrator to ask the statements company, Like Morgan Stanley, to set it up. All this can take days to set up, which means we have to put work for that plan aside for a while.

Once we have an account, a password must then be created for us. The company gives the password to the plan administrator, then the administrator gives the password to us. However, these passwords expire within a few hours of being created if they are not used to log in. The first 3 times we got passwords, too much time must have passed, because we were unable to log in with it. By the time we finally got the password to work, we hours had passed.

And when we finally did log in, there was a SECURITY QUESTION! So we had to email the plan administrator to find out what town she was born in so we could finally access these plans and get going with the work we had to do.

All in all, I much prefer having physical statements to online statements. It takes a long time to sort them all, but it's much less frustrating than dealing with all the excess security. Sorry trees. You lose this round.

What I'm Currently Doing

This month, we just got 3 huge bins of account statements. I'm opening them and sorting them to DC and DB plans. DB goes upstairs and I don't deal with them. As for DC plans, I alphabetize them and file them away in the file cabinet, where we use them later for our beloved excel documents.

Form 5500

The IRS Form 5500 is for reporting a retirement plan's financial condition, investments and operations. This is so the government can make sure that nothing iffy is going on with the plan. (for example, there was a series of unusually large deposits into an account, suggesting potentially illegal activity). It is filed annually, depending on a date set by the plan.

The main part of the Form 5500 is two pages long and requests certain information about the plan, including its name, the date it first became effective, plan sponsor information, information about the plan administrator, a breakout of the number of participants in the plan at the end of the plan year, how the plan is funded or benefits are provided, the schedules that are attached to the Form, and specific characteristics of the plan (for example, if it provides matching contributions).

Depending on how big the plan is, we either file a 5500 short form (for plans with 100 or less participants) or a 5500-EZ form (for plans with greater than 100 participants). Here is an example of a form: 



Pension Administrators

To sum up, this is pretty much what a pension administrator does:

Monday, April 18, 2016

Everything Hangs In The Balance

One of the most annoying things about accounting is having to make sure everything balances. Whether it's $50,000 or a few cents, it all has to be accounted for.

While entering data from my spreadsheets into other spreadsheets, I encountered this problem: there was an entire 12 cents missing. 12 whole cents! It might not seem important, but if you're being paid to keep track of someone's money, you better be keeping track of it. It took me over an hour to figure out where this 12 cents was and why it wasn't balancing out. I had to re-check all the numbers I entered into the spreadsheet, which is difficult when you have to keep switching between tabs (which is why most of the people I work with have 2 screens).

Eventually I was able to find the 12 cents: there was a plan for an employee within the company that was with a different financial institution, so his account wasn't in my first spreadsheet with all the account data, but it was already accounted for in the balance sheet. This account earned, wait for it, a whopping 12 cents in dividends the entire year! This just goes to show how time consuming it can be to account for money that really doesn't even matter and nobody cares about (sorry penny, but let's face it, all you're good for is scraping the silver stuff off a lottery ticket).

Safe Harbors

As I mentioned before, employers deposit what is called a "safe harbor" into their employees' retirement accounts. These contributions are calculated by us and deposited by the employer. But what happens when our dear employer doesn't pay the amount that we told him to? Well, we get to fill out what's called an IRS Government Form 5530.

If an employer deposits too much into an employee's account, that means that they didn't pay taxes on all the money that they should have. The IRS has strict regulations on the amount of money employers can deposit, because they don't want to be cheated out of tax revenues. 

Sometimes it's a big amount that the employer was off by, but oftentimes it's a relatively small number. Even if they overpay by 20 cents, we have to file the 5530 form so they pay taxes on the 20 cents. This form takes a few hours to fill out, and, as all IRS forms are, is a pain in the neck. You can see for yourself how much jargon is in these forms and how much you have to type into these reports here: https://www.irs.gov/pub/irs-pdf/f5330.pdf

Sunday, March 20, 2016

How the Government Makes Life Harder



And now we come to the fun stuff. The Government.


Perhaps the most time consuming part of accounting is making sure that you are in compliance with the government. In fact, there is a 8 book set of books that describe the laws that require compliance. Each book has thousands of pages. The 8th book is just the index.

My on-site adviser gave me a question and challenged me to find the answer in one of the books. I couldn't even navigate my way through the index, let alone find the answers I was looking for. Government compliance is a pain because there are so many laws and regulations, and it is hard to follow them all. My adviser told me that before they can really understand the current volume, the next year rolls around and a new volume of books comes out. It's as if they write the laws faster than we can understand them!

As discussed in a previous post, there are many different types of retirement plans. The government has set regulations regarding how much money a company can put into each employee's retirement plan (mostly for tax reasons, they don't want companies to write off a ton of deposits). During this time of the year, we must review all the companies and their plans to make sure they are in compliance. If they fail, we have to make sure they take back the money they deposited (or fix whatever the problem was). This year, we've had a much larger amount of failed compliance tests, which means we have to put aside other projects to make sure the companies pass their compliance before the March 15th deadline.

Government compliance is very important, because we would get in big trouble if we ignored it. Spending tons of time working through the legislation is unavoidable.

I have attached some pictures of these regulations books to show you just how much government regulation there is:





This is the Index:



The Beauty of Excel Spreadsheet

Excel Spreadsheet is the lifeline of accounting. To put it simply, without Excel I would MUCH rather be working at the DMV than being an accountant. Excel has the means of double-checking your numbers for you and adding numbers together with a simple equation, as well as organizing your numbers in a way that is easily readable.

 One of the best parts of Excel is the functions; if you can do Excel functions, you can rule the world. Say you want to add two numbers together. All you have to do is, in the space you want, put an equals sign and click on the first number you want to add, the hit + and click on the second number. Hit enter, and boom you have an equation. The best part is, the equation isn't actually adding the numbers; it's adding the spaces in the spreadsheet. So if you're adding column A row 1, and Column B row 1, your equation would be =A1+B1. Then take the space with the equation and drag the corner down, and the equation will be copied to all the spaces you dragged it too. But the best part is that it automatically adjusts the equation for each row; In row 2, it would be =A2+B2, and row 3 would be =A3+B3.

Excel spreadsheet makes the process of accounting much easier and faster, meaning you can do more work in a shorter amount of time.

More on Account Statements

A big part of this internship has been the account statements, so I wanted to explain more about them. The statements come from companies like TD Ameritrade, Wells Fargo and Merrill Lynch.

These statements usually come monthly, and detail all the transactions that happen within a certain account. What I do is I need to check the balance from the end of the previous month and the balance at the end of the current month, and check all the transactions to make sure they all dd up. For example, let's say that Bob's account had $100 at the end of January, and $200 at the end of February. Bob deposited $150 into his account. He also took in $25 in dividend money. That makes a total change of $175 in the month of February. Logically one would think that he would not have $275 in his account, the first $100 and this month's $175. But he doesn't, he has $200. Where did that $75 go? The account statement will contain information on the seemingly missing money. If you look through the statement, you'll find that there was a $50 fee charged to the account. Also, his stocks wend down in value by the amount of $25. That accounts for the missing $75.

 Each company's statement has a different layout, but all convey the same information. With this information, I go through and figure out what went into and out of the account, and make sure all the numbers add up. Obviously most accounts deal with numbers much higher than a few hundred dollars. Usually the accounts contain hundreds of thousands of dollars, sometimes even millions. The more money in the account, the more activity in the account; accounts with not very much money usually don't have investments and dividends to worry about.

Thursday, March 3, 2016

Week 2

This week I worked with spreadsheets and entered data from account statements. For example, I took note of changes in account balances, and entered deposit/withdrawal and interest/dividend data. One thing that made the process go a lot faster was the using equations in excel. Instead of havig to type all the numbers into a calculator to add them all up, excel will add up numbers via a simple equation. This was a huge time saver.

After entering all the data came the real time consuming part. All the statements had to be scanned into pdf documents. The scanner is this big clunky thing. The most annoying part as that the scanner didn't remember the settings you typed in the scan before; for every new scan, you have to specify where the document is to be scanned to (for my case, it was the intern computer), make sure you check that the document is to be scanned double sided, and, if necessary, scan the document in color (this is necessary for some statements where the numbers look gritty and hard to read if not scanned in color). And even when you do all this, sometimes the pages of the paper stick together and you have to re-scan the whole thing because a page is missing on the pdf. Which means you have to count every page of every document and make sure the document and the pdf match up. It took me all day to scan in and check just a stack of documents.

I mentioned in a reply on my last post that it poses a security risk to electronically receive the documents. The process of scanning documents is different than receiving them electronically because they are at no point of the scanning process being delivered via online means. Although they are now stored on the computer, they are not at risk to be stolen.

Saturday, February 27, 2016

Week 1

Important terms:

A 401k is a company/employer sponsored retirement plan that allows workers to take out a portion of money from their daily paychecks, store it on a retirement plan account and earn interest that is tax-deferred, meaning this saved income is not taxable until you withdraw it when you retire.

With a profit sharing plan, the company can decide from year to year how much of the employee's pay to contribute (or whether to contribute at all) to the employee's plan. If the company does not have a profit, it does not have to make contributions to the plan. The employee makes no direct contribution to the plan.

Finally, a defined benefit plan is a company pension plan where an employee's pension payments are calculated according to length of service and the salary they earned at the time of retirement.

What I did this week:

This week I worked on sorting and filing account statements. Account statements are summaries of retirement savings accounts, either 401(k) plans. profit sharing plans or defined benefit plans.

Surprisingly, most of the account statements are received as physical mail. The result is two huge shelves filled with folders of account statements. It took me about a week and a half to sort and file two postal service baskets worth of mail. The most important part of this process was alphabetizing everything, which made the process a lot faster, though it was still slow.

Monday, February 8, 2016

Introduction

Hello all and welcome to my blog! 

This blog is dedicated to my Senior Research Project that I am conducting during my final trimester of high school. I am very excited for this opportunity and I can't wait to learn more.

 I will be studying accounting at Barrett Honors this Fall. I am interested in how an accounting firm dedicated to pension administration (a firm that manages retirement accounts); meaning how much time they spend doing government-required tasks vs. mail sorting vs. talking to the client, etc.


 More to come as I continue further with my internship, which starts Monday, February 8th!