Preparing a sample data quality scorecard in Google Sheets

Continuing with our example of the Pizza Factory, management noticed that it was receiving a lot of follow-up inquiries from its suppliers as to when the invoices they sent would be paid. Upon discussion with the finance team and looking at the accounts payable account, it noticed that some of the transactions had missing data, such as payment terms and due dates, and also noted that some invoices were duplicated in the system.

Management was worried that the late payments would affect its relationship with its suppliers and increase the risk of duplicate payments. In addition to this, management wanted to take advantage of potential discounts if it paid the invoices before their due dates. Apparently, the person who had resigned after handling the recording of the inventory had also been the one responsible for recording the accounts payable, which affected the quality and integrity of the data in the system. Given the...