Recently I used up all the lines in my check register for my checking account. You usually get a new one when you order new checks but I won’t need to order checks for a while and I didn’t have an extra register laying. I went to several stores trying to buy a new register but I could not find any. Then it dawned on me that I could easily make one from a spreadsheet. This is how I did it (files below).
It is not difficult to construct a check register using a spreadsheet program. I just measured and copied my old one and made a few minor changes based on my preferences. Then I printed out 5 copies at 100% scale making sure it was centered both horizontally and vertically. Then I flipped the paper over and turned it around so that the top became the bottom and the front became the back and then printed 5 more copies. This left me with 5 sheets with the register printed on both sides but turned upside down on one side. This allows you to flip through the register. If you print it wrong, you’ll figure it out when you put everything together. I used a paper cutter to cut very closely around the grid. Scissors or an X-Acto knife would work but a paper cutter is easier to use. I then folded the 5 sheets in half and put 2 staples in the crease. This fits nicely in my checkbook and I can continue to keep track of my account.
Here are the files if you wish to use my design. I use OpenOffice 3 and I recommend you use that file (.odt) but I’ve included a PDF, which should work, and an Excel 97/2000/XP file (.xls), which may or may not be formatted perfectly on your machine.
Check_Register_Makify.ods <– OpenOffice 3
Check_Register_Makify.pdf <– PDF
Check_Register_Makify.xls <– Excel 97/2000/XP
The PDF file looks great when opened up with adobe reader but when I printed it instead of the top line reading correctly it printed jiburish type characters. not the displayed top line of the check register as it appears in the reader.
Hmm, that’s odd. I’m away from a printer right now but I’ll check into it as soon as I can.
Tried doing this myself in Open Office yesterday, but couldn’t figure out how to make 2 sided pages line up. Found your form today, modified the contents a bit, and it worked beautifully. Much better than the registers you get with checks. Thanks so much.
I just go to my credit union and they give me an extra check register for free. It’s hard to beat that!
Steve, that’s a great idea! I never thought to try that.
Thanks so much!!! It work perfectly in my Excel 2007 program.
Perfect size! Thanks so much! (I used the .pdf file, btw.)
This is perfect, thanks! I always use up the register long before I need to order checks, and dealing with the local branches to even request a new register would take longer than this.
Thank you so much for the check register! I was in the middle of writing checks this morning and ran out of space yet again with no replacement register. I was able to download your wonderful PDF file in a matter of seconds! Thank you for making my day so much easier!
Blessings!
Thank you so much for the check register! PDF worked perfectly. Needed it while waiting for checks and register to come in the mail. Great job!
Thank you so much. I have been trying to find a way to print a check register on both sides. This works perfectly!
Perfect and very useful but it prints 14cm x 13.5cm which is smaller then the standard bank check registry booklets which in my case is 15cm x 15cm. (as I have a habit of binding the new booklet behind the old and continuing. Also the tick mark column is missing. But better then nothing…thanks
This truly is the best check register that I have found online that prints on both sides and lines up fairly well and does not waste paper. I have priced them online and they are around $3. I have made my own before but they are not nearly as good as this. Thank You!
Excellent blog you have got here.. It’s difficult to find
high-quality writing like yours these days.
I seriously appreciate people like you! Take care!!
What’s up Dear, are you truly visiting this website daily, if so then you will
definitely get good knowledge.
Simply wish to say your article is as astounding.
The clarity in your post is just nice and i could assume you’re
knowledgeable on this subject. Fine together with your permission allow me to snatch your feed to keep up to date with imminent post.
Thanks a million and please carry on the gratifying work.
I’m really enjoying the theme/design of your weblog. Do you ever run into
any browser compatibility issues? A couple of my blog
visitors have complained about my blog not working correctly in Explorer but looks great in Safari.
Do you have any recommendations to help fix this
issue?
Works great! Many thanks!
Thank you so much! I had made a check register using Excel then couldn’t figure out how to print it to make the booklet. Didn’t know about the horizontal/vertical centering under scaling. You saved me a ton of time.
I have noticed you don’t monetize makify.com, don’t waste your traffic,
you can earn extra bucks every month with new monetization method.
This is the best adsense alternative for any type of website (they approve
all sites), for more info simply search in gooogle: murgrabia’s tools
Thank you! This is just what I needed. You are so kind to tell me how to print it double sided.