Yearly Archives: 2012

Using Paypal As A Simplified Bookkeeping System

by

As a personal finance blogger, my business transactions are at a minimum, but around tax periods, I agonize over the involved bookkeeping task. I looked into different financial management systems and found that there are varying degrees to which businesses need finance programs.  I would meticulously copy the transactions from PayPal, my Chase Freedom credit card and my bank into my custom excel business spreadsheet that I use to calculate my taxes.  Things have changed recently, now I’m using PayPal to create a simplified bookkeeping system for blogging.

My Old Record-keeping System

I created an excel spreadsheet that had 13 tabs. Twelve tabs for each month, and one tab that represented a year end summary sheet.  For each month I would copy the transactions from the various sources and paste them into each month’s tab.  The Year End page would automatically update with revenue, expenses, profit, etc.

Of course I had a template to make this process easier by enabling me to just make a copy of the blank template and rename it to the current year (ex. moneyreasons_BK2012.xls).  This was highly functional and much cheaper than paying for an excellent program like Quickbooks, especially since blogging transactions are very simple and repetitive in nature.  Quickbooks (while awesome) is overkill for my simplified book-keeping requirements.

PayPal

 

My New PayPal Simplified System

First, let me mention what enabled me to do this new (nearly automated) simplified bookkeeping system!  I applied for a new PayPal credit card!  Yep just that simple change has enabled me to drastically simplify my bookkeeping process.  You see, now I can now track both my revenue and expenses within PayPal.  I use my PayPal credit card (which is a rewards card by the way), to pay for all my expense that I can’t pay with my paypal account, then I pay the credit card balance with my PayPal account directly.  That way I don’t have to send any check for my previous credit card bill anymore via snail mail anymore.

Now all I do is export my data from PayPal into a one sheet spreadsheet.  Next, I add any non-PayPal transactions (which are few at this point in time),  and that’s it!  Since the revenue is positive, and the expense are negative, I don’t have to do any special formula, just a sum at the end!  I do purge and clean up some statement that I export from Paypal, but that’s a pretty quick and painless process.

I’m actually pretty excited about the process.  I love to automate things as much as possible, and this will cut my time working on bookkeeping by hours!

Bests,
Don

An iPad Mini For Christmas

by

I broke down and bought an iPad Mini for Christmas!

Oh, not for me, instead it’s for my eight (soon to be nine) year old daughter!

As a frugal personal finance blogger that works in technology field, how could I justify the $129 increase in the price of a product that might be considered inferior to the Google Nexus 7?  After all, the Google Nexus 7 only cost $199 and is a very beefy, fast system?

An my answer is… I can’t.  From a personal finance perspective, the Google Nexus 7 is the more logical smart device to purchase.  Shoot, if I were to buy a 7 inch tablet for myself for Christmas, the Google Nexus 7 is what I would buy.  The Apple iPad mini is actually 7.9 inches, but that alone doesn’t warrant the 129 dollar price increase.

So again, why in the world would I buy an iPad mini for Christmas to give to my daughter?

The Apple culture and experience!

iPad mini

 

Yep, I’m buying my daughter the iPad mini, because all of the cool kids (and many adults) love Apple iPad minis (or really any Apple product).  I guess it’s the same reason that I bought my son an iPod touch.  In fact, he had such a great experience with his iPod touch that it was a no brainer to buy my daughter the iPad mini.

Vanity?  Yes to a certain extent, but much, much more too.

Why not buy my daughter an iPod Touch instead, after all I bought one for my son?

Because I can get an iPad mini for just $29 more.  Oh sure, the version I’m buying only has a storage capacity of 16G, but the rest of the system is decent enough!  Quite honestly, I’m getting the iPad mini for Christmas instead of the iPod touch because it’s a better experience…

Another big reason that I’m buying the iPad mini for Christmas is because of bragging right and for nostalgic reasons.  I want both of my kids to look back some day with fond memories 10 or 20 years down the road when the next big thing has replaced Apple from being the dominate smart device supplier that it is today.  There are thing in life that if you miss out on by not having such things in an earlier time period, you may never have.  Since I want my kids to be future digerati, I want to give them the best exposure to technology.

As for me, I’ve missed the Apple boat a long time ago.  I’m an Android guy and that’s a win too!

While we went with an iPad mini, there are definitely other choices that are worth consideration!  Look around and compare!

Happy Holidays,

Don

Why Young Investors Should Not Shy Away From Investing in Stocks

by

For college graduates lucky enough to find work after they receive their diploma, the question as to whether or not they should invest and how they should do so is often a tricky one. With the market experiencing incredible high and lows in short periods of time, most young professionals are afraid to invest in stocks and are instead leaving their money in savings accounts.

Leaving money in a savings account is a great idea if you are saving up for a future large purchase such as a house or a car, but don’t underestimate how quickly you could be saving for retirement too. Keeping all your money in a savings account is very secure, but it also has incredibly low returns. Therefore, only emergency money and that being saved for a down payment or vacation should be kept in savings, as it allows you to have quick and easy access to the funds you need when you need it.

Otherwise, young investors should be looking towards stocks as they have their youth on their side.

Stocks offer the quickest and greatest returns which make them a great investment. However, because of their volatility, they are also not a wise investment for older investors who have a lot more to lose should their stocks not provide adequate returns. Because a younger investor has more time before retirement, they are able to more easily recover by further balancing their portfolio.

Because of the potential for great returns offered by stocks, young investors should not in any way, shape, or form be intimidated by them. In fact, most young investors should have approximately 70 to 75 percent of their savings in stocks and the other 25 to 30 percent in bonds. Not only will the right amount of diversity help them yield much higher returns, but it will also reduce the age at which they will retire. A good balance like the 70/ 30 ratio will also make investing a bit more stable and secure while still producing higher yielding results.

However, that doesn’t mean that young investors should just start blindly throwing money into the stock markets. There is a lot to learn about this topic, and taking tips from professionals like practiced professionals with a proven track record, like the Brian F. Prince Blog is a good place to start. While playing with small Forex markets or penny stocks can be a good investing lesson, those interested in establishing a firm financial future should contact a financial adviser to help them determine which stocks are worth investing in, as well as an appropriate amount of portfolio diversity.

This guest post was brought to you by Ryan

Religion and Finances

by

Religion can have a powerful effect on not only your life, but also your finances.

Religion can make you Poor

I have older friends with pictures of Jesus on ever wall of their house, and they believe that money is the root of all evil.  I don’t believe that money is the root of good or evil, to me, money is just a tool.  But those that do believe that “money is the root of all evil” give all of their money way with no real focus on their own well-being.  This is noble, but also a financial mistake.  Now my elderly friends are old and don’t have the money for taking care of themselves.  They just thought that the god of their religion would take care of them, but s/he doesn’t.  In this way, religion is powerful, but in a negative way with respect to your finances.  If it were a movie ending, the couple would win the lottery or some other miracle would happen, but for the majority of people this never happens.  Many will say that they weren’t dedicated enough, but I beg to differ.  Bad things happen to good people sometimes, god has nothing to do with it.

Religion can make you Rich

The believe that you are running god’s course by take any reasonable risk or opportunity that god lays upon your doorstep is a powerful thought, and sometimes can enable a hard-working religious person to become rich.  In fact, the believe that you will become rich by starting your own business, and putting in the time at it, can be very, very powerful!  I have quite a few friends that have followed this path, and prospered greatly by following the opportunity presented to them.

Even in the classic book “Millionaire Next Door” by Stanley and Danko, there is a chapter on believe and wealth.  Yes, Believe can be a very powerful motivator to become wealthy, and it only makes sense.  If you are focused with a religious fervor on accumulating wealth, the odds are stacked in your favor… at least if you try to tackle it with 100% effort.

I’d love to hear comments on this or your personal stories.