tracking story submissions

Part of today is going to be spent sorting through my spreadsheet of what stories are out where and getting stuff out. That’s one of the really tedious things about being a writer – all the paperwork.

So how do I track submissions and figure out where to send them?

I have an Excel spreadsheet. One page has short stories that are circulating, a second does the same with flash pieces, a third tracks sold stories, a fourth audio reprints, and a fifth foreign reprints. When a rejection comes in, I mark the story on the sheet as freed up and put it in bold red. Once it’s been submitted, I switch the color to blue. That lets me look over the sheet and get an idea of what needs to go out. Right now it’s looking pretty red, so I’ve compiled a list of five flash pieces and ten short stories that need to go out, making a note of the word count.