0

Update Quickbooks invoice with records from Excel spreadsheet

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

0 comments

Please sign in to leave a comment.