Not applicable
This widget could not be displayed.

importing invoices vs memorized transactions

I have QB Enterprise 18.0.  Currently my reoccurring (monthly) invoices are memorized transactions that I manually update to month of service.  I'd like to import a list that I can easily update from excel instead.  I cannot use QB (I think) to batch invoice a billing group as these accounts have a variety of amounts and services that are individually specific.  I believe I will have to use Transaction Pro to do this.  Before that I want to prep the file.  My question to the community is, what format will the excel file need to be in, what are the data sets QB will be demanding, or how do I set those in QB?  I am willing to change the QB template for my invoices to accommodate.  Thank you