What you have is an Excel type of file, where they are going to read each Row as having specific status indicators, and info, each time you upload.
This is a bit beyond the QB user forum, a text-based interface. You should find out if their Payroll Support person has the info for how to Send QB report data using an Excel import, to them. What you are asking about is a Prepared Interface. Or, you need to ask them to work with you on preparing this interface. This really is Coding, or Programming. If that isn't your Job, then this should not be your task. Or, you will hire someone to do the interface for you. Or, you are good enough with Excel, that you can use the Reports in QB, some of which are already part of "More Reports in Excel" and some will be your Permanent Excel template already, and some will be payroll paydate reporting that you run in QB and Export to Excel, choosing to Update an existing spreadsheet, which you are using to either hold the updated values or hold the new Current Values to provide for the raw data in a Linked Workbook.
I do a lot of this from QB to Excel because I do Auditor reporting and Graphing. QB doesn't handle this as a Standardized Function. Intuit has done it for uploading required E-filing to States and the Feds. You might search the Web, to see if your format already exists. I would start with your TRS programming staff. You are the End User, and that sort of makes you their Customer.
