Checkbook Register

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).

Front view of checkbook register
Front view of checkbook register

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.

Side view of checkbook register
Side view of checkbook register

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

13 thoughts on “Checkbook Register”

  1. 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.

  2. Hmm, that’s odd. I’m away from a printer right now but I’ll check into it as soon as I can.

  3. 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.

  4. I just go to my credit union and they give me an extra check register for free. It’s hard to beat that!

  5. 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.

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

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

  8. Thank you so much. I have been trying to find a way to print a check register on both sides. This works perfectly!

  9. 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

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

Leave a Reply

Your email address will not be published.

Where I make and modify stuff