I need a way to export QB customer and invoice data to a spreadsheet with a numeric customer reference. When I came across the Account No. field in the Edit Customer/Payment Info form, I thought maybe that was the answer. Is there a way to import many customer account numbers and apply them to current customers and their invoices? or do I need to go in and change them all one by one in the above form? Also, is there integrity built in to not allow duplicate account numbers for customers?

Thanks!