Wednesday, January 28, 2015

Technology: Excel Checkbook

Balancing your Checkbook with Excel

The biggest struggle I have in life is remembering to balance my checkbook or write down where I have spent money. Usually I end up with a huge pile of receipts, and dread looking through them.

I Created a Solution

I was never able to find a solution online that was able to meet my needs full. So I took to Excel to create a way for me to to stay up-to-date on the go without much issue. You are able to download a copy of my Checkbook online here. I am going to go over some highlights of what I do with this checkbook, so that you can enjoy it too! First important notice is that if you are spending money will will write it -10.00 so that it will so as money spent.

Checking & Saving Tabs

On the Checking tab, you are able to input your expense, income, deposits, or anything other transactions that occur in your account. At the top of the sheet, there is a place to put the name of your Bank, and your log in information if you have online banking. There is also a legend to show you how to reconcile your checkbook. 

All you will need to do is input the details of the transaction. If the transaction relates to an expense you are tracking on another tab, you will enter the equals sign, then click the expense tab, and select the amount you want to connect it to.

Now when edits are made to your Expense, your checkbook will be up-to-date with the changes. Very helpful for budgeting ahead (you can input estimate amounts and update later with correct amounts).

If you have transactions that are not connected to an expense you can attach an receipt to the description. the below video is a walk through of how to connect to the document you want. I use my Google drive to store my Checkbook and all the documents. That way I am able to access it on the go.

Expense Tabs

The Expense tab is where you are able to keep track of current reoccurring expenses. I keep track of my utilities, credit cards, auto loans, and student loans on these tabs. You have a place to input the expense name, small description, due date, and web site/log int information if you have it.
You are able to input when bills are received, when payments are sent and link to any helpful documents such as bills, receipts, and notifications.


Income Tab

The income tab allows you to keep track of your pending deposits from work. There is space for you to input the needed details about your employer. There is a place for you to customize your wages. You will just need to change it in the one location, and the rest of the sheet will update. You are able to input regular work hours, holiday pay hours, and overtime hours. Deductions are auto calculated as an estimate. You can change them at anytime to the correct amount. There are columns for medical as well, if you don't have this deduction you can set it to 0 or leave it empty.

You are able to link to the net pay column in your checkbook to have your income deposit listed and update-able. Once again very helpful for budgeting ahead (you can input estimate amounts and update later with correct amounts). You can attach pay stubs on the date, same as we did with the expenses.

Video How-To

I have created a small video walk-through of how I use my checkbook and how to create and update the information. Please feel free to check it out, and if you enjoy what you are seeing, please subscribe to stay up to date on all the new items posted.

Let me know if you find this useful at all!

I have found I am able to keep track of my money and bills this way. Please feel free to leave any comment, questions, or suggestions on my Facebook, Twitter, Pinterest, Tumblr, Youtube, Google+, or Email me!! I always look forward to feedback!!

Thursday, January 22, 2015

Self Help: Sparkpeople Explained

SparkPeople In a Nutshell

I have talked about Sparkpeople in the my last post (Self Help: Weight Loss), but I wanted to elaborate and let you in on some finer details.

Website

The SparkPeople website is a great way to learn all the features that are available. You are able to set your goals, enter data, and plan ahead.

Once you log into the site, you are able to view your overage progress for the day. You can see how much you have eaten, what your work outs have burned, and how many calories you have left. This is a great way to know if you have room to munch a bit more, or if you need to work out a bit more.

After you review your In's and out's, you are able to track your other goals as well. They make this simple with sliders. These goals are editable and customizable.


After your done with the additional goals, you are able to connect with communities online. These are great ways to stay involved and motivated. SparkPeople will connect you with communities that are relovent to your life. For example, if you are in your twentys or thirties you will be able to connect with others your age. If you are a mother they will connect you to others who have children the same age. This is a great way to get advice on issues you have in common.

Tracking your Eats

Tracking you eats as well as plan out your meals in advance, so you can know where you stand and plan your shopping. I love this feature, because it are able to print a shopping list.

If you eat the same items for breakfast and lunch, you can create groups, so that it becomes easier to track and enter.

Tracking your Sweats

 Tracking your activities and workouts is fairly simple with SparkPeople. Like your food, you are able to create groups so that if you do the same workouts on a regularly then you can enter it quickly. You can also see your daily totals as well as your weekly goals.

Making progress

SparkPeople make it simple to track your progress by allowing for weight, and measurements to be tracked. That why if your workouts are burning fat, and building muscles you can see it.

Your wellness is displayed as well as last tracked, and you are able to preform a fitness test and health measurements. This is all in an effort to make sure you are doing what is best for you and your body.

Going Mobile

The best part of the SparkPeople is that they allow you to go mobile! They have several apps you can download:
  • Calorie Counter & Diet Tracker
  • Healthy Recipes
  • Nutrition Lookup
  • 30-Day Diet Makeover
  • Quick & Easy Recipes
  • Healthy Slow Cooker Recipes
These are to allow you to keep up to date on your eating and activities even while on the go!
Let me know if you can find another site that allows you to keep track of more!! Always willing to try out a new site to help me improve me!!