a method and a system keeps travel data consistent between a database of airline reservations storing passenger name records including travel segments , and a database of electronic tickets including travel coupons , this latter database being independently controlled from a ticketing server . whenever a travel segment is updated or added in one of the pnr &# 39 ; s an electronic reconciliation service receives images of updated pnr &# 39 ; s . corresponding e - ticket images are requested by ers and received from the database of e - tickets . then , ers establishes a matrix of links between orphan pnr travel segments and orphan e - ticket travel coupons so that e - ticket orphan travel coupons are re - associated with matching pnr orphan travel segments . after e - ticket is updated it is revalidated or reissued . optionally , a penalty generator calculates penalty fees on the basis of changes brought to the revalidated or reissued e - tickets . the penalty fees are then attached to the updated pnr &# 39 ; s .