a glob of nerd­ish­ness

Numbers.app spreadsheet template for 2012 IRS Form 1040

published by natevw on

This year I'm trying to get a head start on taxes, so I've already updated my traditional Numbers template. This is an unofficial, potentially incorrect, use-at-your-own-risk spreadsheet for unofficial, potentially incorrect etc. tax preparation number crunching. I use it so that I can gradually prepare my return as I collect all the correct numbers, as well as to get some quick estimates to answer questions as I prepare (e.g. is this deduction form worth the time it will take to fill out?).

Title/header of first spreadsheet page

This spreadsheet is only optimized for basic personal/sole proprietor/small business taxes, but within the basic 1040 form it's rigged up to automate just about as much as I could. It was fun many years ago to turn the form's IRS instruction tables/logic into its raw algorithmic form, and now it's fun to not need to sign up for some spammy scammy "file your taxes online for free(asterisk asterisk asterisk)" e-File thing. When I've got everything figured out in the spreadsheet, I then copy it to a the IRS's PDF forms and print on a stack of good old paper for mailing.

You can try it out by downloading my f1040-2012 Numbers template file — it should open as an "Untitled" doc you can save to a new spreadsheet. Would love to hear if you find it useful!

Update: posted a revision which adds a small Schedule A table, half of self-employment tax deduction, and slight update to the mileage rate.

blog comments powered by Disqus HTTP/1.0 500 Internal Server Error Cache-Control: must-revalidate Connection: close Content-Length: 60 Content-Type: application/json Date: Sat, 22 Jul 2017 00:40:04 GMT Server: CouchDB/2.0.0 (Erlang OTP/19) X-Couch-Request-ID: 5b92e1d977 X-Couch-Stack-Hash: 2053811356 X-CouchDB-Body-Time: 0 {"error":"unknown_error","reason":"undef","ref":2053811356}