Abstract: A computer method and system to allow reconciliation of documents that were originally part of a first mail production job, but that may have been produced as part of a different second mail production job. A database stores a first record that identifies documents in the first mail production job. The record includes one or more fields indicating a production status of the documents in the first mail production job. At some point in the production process, a document is separated from what was originally defined as the first mail production job, to be instead produced as part of a second mail production job. The database further stores a second record identifying documents in the second mail production job. These records are updated to include a pointer indicating the relationship between the document and the first mail production job and the second mail production job. During mail production the production status of a document is determined.