offcntr: (rocket)
[personal profile] offcntr
I started my taxes this morning.

Oh, don't look at me that way.

I know, this is horribly, terribly early. But Saturday Market starts the beginning of April, Ceramic Showcase follows hard after in May. Looking at my production schedule, this is the last free time I'll have before April 15. And filing for an extension is no help; I still need to know how much we owe to pay with the form.

Besides, starting now gives me loads of time to procrastinate.

I've always done my own taxes, originally on paper, now with the computer. I've kept a ledger ever since I started Off Center Ceramics, once a green multi-column book, now an Excel file. I'm obsessive about recording income and expenses as they happen, so I have a minimum of digging for receipts when tax time comes around. (Except for one exception I'll get to in a minute) A number of years ago, I went from a simple two-column ledger (income and expenses) to an elaborate monster that separates out regular income from 1099 income, Cost of Goods Sold from other supplies, and has columns for pretty much every applicable expense category on a standard Schedule C, eighteen in all not counting date and description. When I went over to Excel, I added a macro that totals the columns at the bottom of each month, and at the end of the year I copy all the monthly totals onto a summary page that adds up the entire year.

I love tax software: it understands stuff I'm vague on, like how depreciation works. I follow the prompts, transfer numbers from the gallery 1099s and my ledger summary.

And then, just when I'm feeling smug and prepared, I realize I have to dig out all the utility bills, tax receipts, insurance and self-storage and everything that goes into the home office expenses schedule. It happens to me every year; fortunately, Denise saves all that stuff in the file cabinet. But I'm thinking for next year I might start a separate Excel ledger and track that stuff as we pay it. Yeah, that's the ticket...

Excel Geek

Date: 2015-02-16 08:34 pm (UTC)
From: (Anonymous)
Why did I suspect you might be an Excel geek? Math major that is it!

Re: Excel Geek

Date: 2015-02-16 10:10 pm (UTC)
From: [identity profile] offcntr.livejournal.com
You should see the spreadsheet I made for Clay Fest--all the bookkeeper has to do is input each potter's daily sales total, and it adds up, takes commission, throws in any incidentals like pipe-n-drape or broken pot pay-out and then, with a mail-merge, generates statements. Whee! I love a good tool.

Hmm, should flag this "favorite tools"...

January 2026

S M T W T F S
     12 3
45678910
1112 1314151617
18192021222324
25 262728293031

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Feb. 8th, 2026 06:27 pm
Powered by Dreamwidth Studios