Sheet 1: Instructions

	
	
	

		
This spreadsheet will help you upload your invoice data into CPRM for GSA programs.
		


		
Email oasisCPRM@gsa.gov with questions
	
	

		


		


		


	
	

		
Zero invoices cannot be reported using this method.  You must go into the task orders, and report an invoice, choosing "Zero Invoice Data"
		


		


	
	

		


		


		


	
	

		
You must use these values EXACTLY as they appear here.  No extra spaces, misspelled values, no leading zeros, etc.  
		


		


	
	

		


		


		


	
	

		
To create the file to upload into CPRM:
		


		


	
	

		
On the "gsa_gwac_upload" tab of this file, you can see several sample rows of how to fill out this template.  This file mimics very closely the way you'd fill out the Invoice inside CPRM on the "add Invoice" screen.  For each Line Item on each Invoice you wish to report:
		


		


	
	

		
     - you'll need the Order Number, as shown in CPRM
		


		


	
	

		
     - you tell us the Invoice Number you want to use; this should be an invoice number that's new, not in use in CPRM.  You should not use this method to supplement/add to an already existing incoice in CPRM.
		


		


	
	

		
     - report the Date of the Invoice using whichever method you chose for this task order, either when you bill your customer or when your customer remits payment to you
		


		


	
	

		
     - add a sequential Line Number for each unique invoice, start with 1 and go as high as you need
		


		


	
	

		
     - for Line Type in this file, you use a code rather than having a pull-down list like you do in the CPRM invoice creation screen.  Open the tab for your master contract in this file.  The tab lists the codes for each of the items in the pull-down on the CPRM invoice screen under "type."  Copy the code for your types of cost, and paste into the "line type" column
		


		


	
	

		
     - type a description of your choice in the Line Description field - usually it shows a level for the labor type, or more adjectives about the labor type
		


		


	
	

		
     - under Line Location, type one of three values:
		


		


	
	

		
n/a
		


		


	
	

		
Government Site
		


		


	
	

		
Contractor Site
		


		


	
	

		
     - Type in the Line Unit Price in the same way that you would on the Invoice screen
		


		


	
	

		
     - Type in the Line Quantity in the same way that you would on the Invoice screen, remembering that the line's invoice amount is equal to Line Unit Price multiplied by Line Quantity
		


		


	
	

		
     - under Line Unit type one of these values:
		


		


	
	

		
Unit
		


		


	
	

		
Hour
		


		


	
	

		
Each
		


		


	
	

		
Package
		


		


	
	

		
Box
		


		


	
	

		
Delete the sample rows (in italics) from the top of the "gsa_gwac_upload" tab; be sure to leave the column headings
		


		


	
	

		


		


		


	
	

		
Delete all tabs in this workbook except "gsa_gwac_upload" and save this file as a microsoft excel version 97-2003 workbook under whatever filename you choose
		


		


	
	

		


		


		


	
	

		
Log into CPRM and under the "Invoice Data" menu, choose "Upload Multiple Invoices (Upload Package)", even if you only have data for one task order or invoice to upload.  
		


		


	
	

		
     - click "choose file" and select the file you saved in excel 97
		


		


	
	

		
     - click "upload"
		


		


	
	

		
     - CPRM will report if the invoice data was correctly read and is ready to be submitted/uploaded.  Click "Submit All Valid Invoices" to upload the invoice data.
		


		


	
	

		


		


		


	
	

		
CPRM will confirm the data was uploaded.  You can confirm by looking immediately under the task order(s) to ensure it's there.
		


		


	



Sheet 2: gsa_gwac_upload

	
	
	
	
	
	
	
	
	
	
	

		
Order Number
		
Invoice Number
		
Invoice Date
		
Line ID
		
Line Type
		
Line Description
		
Line Location
		
Line Unit Price
		
Line Quantity
		
Line Unit
	
	

		
123456oasis
		
TEST1234
		
5/11/2020
		
1
		
11-3011
		
Administrative Services Managers, mid
		
Government Site
		
100
		
40
		
hour
	
	

		
123456oasis
		
TEST1234
		
5/12/2020
		
2
		
99-9998
		
Contract Access Fee (CAF)
		
n/a
		
30
		
1
		
Unit