Showing posts with label money. Show all posts
Showing posts with label money. Show all posts

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!!

Wednesday, December 31, 2014

Technology: Helpful Apps

Helpful Apps for the New Year

Tomorrow marks the start of a new year, and I wanted to share a few free apps that might get you started on the right foot! Apps are always helpful for passing the time, and making the best of your time. I am including links to both and Android App Store and the iOS App Store for each product. Let me know if you have any other apps to suggestion or try!

Files

I have found the best way to stay organized and be able to access files on the go is through Cloud Storage. There are several options based on what you use most.
Each of these apps also has a counter part that you can dowloand on your PC/Mac to be able to access the sames files through the computer. This way you can work across platforms. But to make these apps really useful you will need to have one of the following apps to view and edit the docuements.

Finances

There are many apps to help with your fiancances and money. Not all banks offer a moblie app, but most credit cards have an app
Apps like these will allow you to always be able to be in the know of your dollar amounts.

Fun Apps

It is always good to have a few fun apps to play around and help pass the time. Here are a few apps I use for various reasons.