Skip to content

How to move TDR reporting off a spreadsheet (and into TDR Prep)

Copying invoice lines into a workbook or the Excel template for GSA’s Sales Reporting Portal (SRP)? Save it as CSV, match its columns once, map each item once. Next month starts from the export.

What you already have

The workbook is your file, on your machine. No vendor to ask; every month you kept can be saved as CSV.

Each file you uploaded to SRP is your record of that month. Months already in SRP stay there; switching changes only the next month.

Getting the spreadsheet ready

TDR Prep reads CSV, so the preparation comes down to saving the sheet in that format.
  1. Open the workbook you build the month in, or the export it is filled from.
  2. Keep one header row at the top, one invoice line per row, and no totals or blank rows inside the data.
  3. Save the sheet as CSV. A workbook file is not read; a CSV of the same sheet is.
  4. Start with the earliest month you have not reported, because SRP takes reports in chronological order.

Bringing it into TDR Prep

  1. Add the contract

    Enter the MAS contract number and the month its reporting starts. Dashes are dropped, the way SRP expects.

  2. Drop the CSV and match its columns

    Match each column once: order number, description, SKU, quantity, unit price, total, dates. Next month’s file needs no matching.

  3. Map each item once

    Give each SKU its SIN, unit, manufacturer and part number, or mark it as a service. The mapping is reused every month.

  4. Fix the lines SRP would reject

    Every line is checked against the SRP file rules. A failing line reads "SRP will reject this because" and names the field.

  5. Download the file, then upload and certify in SRP

    Upload and certify from your own SRP sign-in, within 30 days after the month ends.

What carries over, and what does not

The sales lines carry over: they are what the CSV holds.

Item details do not carry over on their own. Keep part number and unit columns in the export; you still confirm each SKU once.

Formulas, tabs and colors stay in the workbook.

TDR Prep archives each month’s file and its lines. A lapsed subscriber keeps read and export access to the archive and mapping.

Before you stop using a spreadsheet

  • Keep the workbook and every file you uploaded to SRP: your record of months already reported.
  • Note the last month reported on each contract. Your first import is the month after.
  • Run one month in both for proof. The import, the mapping and the check are free with no card.

What it costs

TDR Prep: $99 a month for the first contract, $49 for each one you add. Import, mapping and validation are free with no card.

Frequently asked questions

Can I upload the SRP Excel template I already use?

Save the sheet as CSV and drop that. Columns are matched once and remembered.

Do I have to re-enter months already reported?

No. Months already in SRP stay there. Start from the first month you have not reported yet.

Does TDR Prep connect to SRP?

No. The contract holder uploads each month and certifies it in the portal.

Sources, as published on October 5, 2026

Read next