Hi, we are trying to update Quickbooks payments with an Excel spreadsheet. We currently use Web Connector to download orders from our web site into QB. However, not all payments are properly recorded. So, we are downloading processed payments from our payment processor, and now want to update the Quickbook invoices with those which have been processed by the Processor, but are not yet in the QB records
Attached is our Excel spreadsheet. The order_id field should be matched to the RefNumber
Thanks
FIRST DATA 2012.xls