Tracking Writing SubmissionsWritersTechnology.com issues the second in a series on

The simplest way to track submissions is using a spreadsheet program like Excel. You could also use an online spreadsheet like Google Docs. Create a new spreadsheet and put the following as column headers:

Title of Piece | Length | Genre/Type | Query or Submission? |Market Submitted to | Market’s Address | Pay | Date Sent | Response Time | Response (Y/N) | Accepted? (Y/N) | Due date | Publish date | Pay date | Paid? (Y/N)

Source

Tune in to their site their site for future articles on this topic.