As soon as I began submitting two stories going at a time, I started losing track of when I had sent them, and to where. I am not sure what other writers do to keep track of submissions, but I made an Excel sheet for the task.

The main tab is a chronological list of the each submission.

I also have tabs for each of the individual stories to see the chronological history of where they have been submitted.  I see on the tab below that I did submit this story to the same place twice, which is really a no-no, but it was after some editing, a name change to the story and after almost four years had elapsed. Unfortunately, they still didn’t like it.

I have another tab  that automatically adjusts so I can tell from a quick glance which stories are available to be submitted. I am not sure if there is actually a “sub-type” category for writing. I just do that for my own reference, because, yes, sometimes I do forget what my own stories are about.

If this is something you feel may be useful, feel free to comment with your e-mail and I will send you the template.

-James