Does anyone know a way to match the vendor bill to the check number in QBO.  We need a report by row that lists the vendor name, invoice #, date, due date, AP status and check number .  The bills and applied payments come on two separate lines and it is cumbersome to adjust everything in excel.  I want to reconcile vendor statements using Vlookup in excel (looking up the vendor invoice number and returning the check number).  Can't seem to make this work.  Any ideas would be appreciated.