UCR Summary

---

Overview

Instructions
Agency Information
Return A
Return A Supplement

---

Sheet 1: Instructions

UCR SUMMARY EXCEL WORKBOOK

The FBI UCR Program is providing this UCR Summary Excel Workbook to law enforcement agencies who are otherwise unable to submit monthly UCR data via electronic means.

This workbook is not intended to serve as a replacement for any agency's record management system. It should be used in place of the standard, OMB-approved UCR crime-reporting forms and submitted to the UCR Program on a monthly basis.

Once the workbook is filled out for a given month, please email it to your UCR Program liaison. Should you need to submit a later update, please make the appropriate change in your existing file and re-submit the entire workbook.

Usage Information

The UCR Summary Excel Workbook is a standard Microsoft Excel spreadsheet, consisting of several individual worksheets (tabs).

The first tab in the spreadsheet, titled Agency Information, should be filled out prior to the UCR form tabs but can be returned to at any time. The fields are broken down into two categories: Required and Optional. The three required fields (ORI, Month of Report, and Year of Report) are mandatory – the FBI cannot compile your data without these fields. The required fields will automatically be populated throughout the UCR form tabs. The optional fields do not affect data processing, but like the required fields, they will automatically be populated throughout the UCR form tabs.

Also on the Agency Information tab is the UCR Workbook Options Box. This box is meant to be a replacement for the "nothing to report" checkboxes present on the Return A form. For each form in the UCR Summary Excel Workbook, the UCR Workbook Options Box contains three options:

1.     Original Report / Zero Report

a.       Select this option if this is the first time you are submitting data for the month or if you wish to report 0 incidents for the month.

b.      Example: For January 2014, you are submitting Return A, Return A Supplement, LEOKA, ASR, Arson, and SHR. You had no LEOKA, Arson, or SHR data. You would select "Original Values/Zero Report" for every form, and simply leave the LEOKA, Arson, and SHR forms blank. Also, you are not reporting Police Employees, Hate Crime, Human Trafficking, or Cargo Theft so you would select "No Change/No Report".

2.       Adjustment

a.      Select this option if you are resubmitting data for any form in a given month.

b.      Example: You notice that some of the January 2014 numbers were off, requiring updates of Return A and ASR for that month. You would select "Adjustment" for Return A and ASR and set everything else to "No Change/No Report" since the other reports have been previously submitted.

a.       This option is used to let the FBI know that, even though you are resubmitting the workbook for the month, certain forms did not change from the original submission. Alternately, you can use this option to let us know that you do not wish to submit a particular form.

b.      Example: With the adjustment example from above, you would select "No Change/No Report" for every form except for the forms being adjusted.

c.       Example: Your agency does not submit Hate Crime or Cargo Theft data to the FBI, so every month you check "Original Values/Zero Report" for every form except Hate Crime or Cargo Theft, and select "No Change/No Report" for the Hate Crime or Cargo Theft forms.

The remaining tabs in the UCR Summary Excel Workbook represent the standard OMB-approved UCR paper forms and have been formatted to look as familiar as possible. These forms should be filled out exactly as you would fill out the paper forms, and they may be filled out in any order.

On every tab in the workbook, certain fields are highlighted light yellow. These fields are the only fields where data can be entered and, in most cases, should all contain data. The exception is the Optional fields on the Agency Information Tab.

All fields that are not highlighted light yellow are locked; that is, unable to be clicked in or to have data entered into them. To reduce data entry time and increase accuracy, all totals on every form are computed via formulas and may not be manually entered.

All yellow cells on every form must be whole numbers with no decimals or special characters ($, !, @, etc.) In most cases these numbers must be between 0 and 99999, though in some cases (arson values, stolen property, population) larger numbers are allowed as well as negative numbers.

Any cells which are highlighted in a light red/pink color indicates an invalid value and therefore should be corrected before saving the UCR Workbook. In some instances, you will be required to make the change before saving is allowed to occur while in other instances the highlighted cells are simply a warning that data values do not match.

Please note that the majority of the fields on the SHR forms will open up an option box when clicked. We ask that you please choose one of the available options and do not enter any other data in those fields.

In order to preserve the visual integrity of the OMB-approved forms, some cells are merged together. Note that if you are using the Tab key to move between cells on a form, these merged cells may require you to hit Tab several times before the cursor will move past the merged cell.

Additional Considerations

If you need to update numbers on any given form, you must re-send the entire workbook as it was originally presented, with the exception of changed numbers. Do not empty out the other forms. Use the Options Box on the Agency Information tab to indicate which form(s) have changed (click the Adjustment button for that form or forms) and which have not (click the "No Change/No Report" button for those forms). With this in mind, we suggest that you save a copy of each month's completed workbook for your records, in the event that you need to re-submit a form later on.

The UCR form worksheets were modeled after the paper UCR forms such that when the worksheets are printed, they are nearly identical to their official paper versions. No information has been added to or removed from the forms with the exception of the yellow highlighting to increase visibility of editable fields.

The UCR Summary Excel Workbook makes heavy use of Excel Macros. You may be required to allow these macros to run each time you open the UCR Summary Excel Workbook. It is also possible to set Excel to always accept macros, but doing so could lead to accidental infection by malicious macros in the future and should be discussed with your technical staff.

---

Sheet 2: Agency Information

Required Fields			Application Version	1.7
Agency Identifier (7 or 9 digit ORI)
Month of Report
Year of Report (YYYY)
Optional Fields
Agency
City
County
State
Population
Prepared By *
Title of Preparer
Telephone Number *
Email Address *
Chief, Sheriff, Superintendent, Commanding Officer, or Supervisor
Date Prepared
*Note: Please provide your contact information

---

Sheet 3: Return A

RETURN A - MONTHLY RETURN OF OFFENSES KNOWN TO THE POLICE						1-720 (Rev. 2-22-13)
This report is authorized by law Title 28, Section 534, U.S. Code. Your cooperation in completing this form will assist the FBI, in compiling timely,						OMB No. 1110-0001
comprehensive, and accurate data. Please submit this form monthly, by the seventh day after the close of the month, and any questions to the FBI,						Expires 07-31-16
Criminal Justice Information Services Division, Attention: Uniform Crime Reports/Module E-3, 1000 Custer Hollow Road, Clarksburg, West Virginia
26306; telephone 304-625-4830, facsimile 304-625-3566. Under the Paperwork Reduction Act, you are not required to complete this form unless it contains
a valid OMB control number. The form takes approximately 10 minutes to complete. Instructions for preparing the form appear on the reverse side.
	DATA ENTRY	2	3	4	5	6
		OFFENSES REPORTED	UNFOUNDED, I.E.,	NUMBER OF ACTUAL	TOTAL OFFENSES	NUMBER OF CLEARANCES
CLASSIFICATION OF OFFENSES		OR KNOWN TO	FALSE OR BASELESS	OFFENSES (COLUMN	CLEARED BY ARREST	INVOLVING ONLY
		POLICE (INCLUDE	COMPLAINTS	2 MINUS COLUMN 3)	OR EXCEPTIONAL	PERSONS UNDER 18
		"UNFOUNDED" AND		(INCLUDE ATTEMPTS)	MEANS	YEARS OF AGE
		ATTEMPTS)			(INCLUDES COL. 6)
1. CRIMINAL HOMICIDE a. MURDER AND NONNEGLIGENT HOMICIDE (Score attempts as aggravated assault) If homicide reported, submit Supplementary Homicide Report	11			0
b. MANSLAUGHTER BY NEGLIGENCE	12			0
2. RAPE TOTAL	20	0	0	0	0	0
a. Rape	21			0
b. Attempts to commit Rape	22			0
Historical Rape (See Instruction #15 below)
3. ROBBERY TOTAL	30	0	0	0	0	0
a. Firearm	31			0
b. Knife or Cutting Instrument	32			0
c. Other Dangerous Weapon	33			0
d. Strong-Arm (Hands, Fists, Feet, Etc.)	34			0
4. ASSAULT TOTAL	40	0	0	0	0	0
a. Firearm	41			0
b. Knife or Cutting Instrument	42			0
c. Other Dangerous Weapon	43			0
d. Hands, Fists, Feet, Etc. - Aggravated injury	44			0
e. Other Assaults - Simple, Not Aggravated	45			0
5. BURGLARY TOTAL	50	0	0	0	0	0
a. Forcible Entry	51			0
b. Unlawful Entry - No Force	52			0
c. Attempted Forcible Entry	53			0
6. LARCENY - THEFT TOTAL (Except Motor Vehicle Theft)	60			0
7. MOTOR VEHICLE THEFT TOTAL	70	0	0	0	0	0
a. Autos	71			0
b. Trucks and Buses	72			0
c. Other Vehicles	73			0
GRAND TOTAL	77	0	0	0	0	0
CHECKING ANY OF THE APPROPRIATE BLOCKS BELOW WILL ELIMINATE YOUR NEED TO SUBMIT REPORTS WHEN THE VALUES					DO NOT USE THIS SPACE
ARE ZERO. THIS WILL ALSO AID THE NATIONAL PROGRAM IN ITS QUALITY CONTROL EFFORTS.
						INITIALS
NO SUPPLEMENTARY HOMICIDE REPORT SUBMITTED SINCE NO		NO AGE, SEX, AND RACE OF PERSONS ARRESTED			RECORDED
MURDERS, JUSTIFIABLE HOMICIDES, OR MANSLAUGHTERS BY		UNDER 18 YEARS OF AGE REPORT SINCE NO ARRESTS
NEGLIGENCE OCCURRED IN THIS JURISDICTION DURING THE		OF PERSONS WITHIN THIS AGE GROUP.
MONTH.					EDITED
NO SUPPLEMENT TO RETURN A REPORT SINCE NO CRIME		NO AGE, SEX, AND RACE OF PERSONS ARRESTED			ENTERED
OFFENSES OR RECOVERY OF PROPERTY REPORTED DURING		18 YEARS OF AGE AND OVER REPORT SINCE NO ARREST OF
THE MONTH.		PERSONS WITHIN THIS AGE GROUP.			ADJUSTED
NO LAW ENFORCEMENT OFFICERS KILLED OR ASSAULTED		NO MONTHLY RETURN OF ARSON OFFENSES KNOWN TO LAW			CORRES
REPORT SINCE NONE OF THE OFFICERS WERE ASSAULTED		ENFORCEMENT REPORT SINCE NO ARSONS OCCURRED.
OR KILLED DURING THE MONTH.
Month and Year of Report		Agency Identifier				Population
			Prepared by			Title
			Telephone Number			Date
Agency and State			Chief, Sheriff, Superintendent, or Commanding Officer
INSTRUCTIONS FOR PREPARING RETURN A
(Detailed instructions are given in the Uniform Crime Reporting Handbook)
1. All Offenses listed on the Return A which occur during the month should be scored whether they become known to the police as the result of:
a. Citizens' complaints.
b. Reports of police officers.
c. "On view" (pick-up) arrests.
d. Citizens' complaints to sheriff, prosecutor, county police, private detectives, constables, etc.
e. Any other means.
2. The offenses listed in Column 1 are the Part I offenses of the Uniform Crime Reporting Program plus the offenses of simple assault
and manslaughter by negligence. Follow the instructions for classifying and scoring as presented in the Uniform Crime Reporting Handbook.
Offenses committed by juveniles should be classified in the same manner as those committed by adults even though the juveniles may be handled
by juvenile authorities.
3. Adjustments should be made on this month's return for offenses omitted or scored inaccurately on returns of preceding months or those now
determined to be unfounded. Offenses that occurred in a previous month but only became known to you this month should be scored this month.
4. Consider all spaces for each classification of offenses in Columns 2, 3, 4, 5, and 6. The breakdowns for forcible rape, robbery, assault, burglary,
and motor vehicle theft, when added should equal the total for each of these offenses. Do not enter zeroes where no count exists.
5. Attempts of rape, robbery, assault, burglary, larceny-theft, and motor vehicle theft are to be scored on this form.
6. Column 2: Enter opposite the proper offense classification the total number of such offenses reported or known through any means.
"Unfounded" complaints are included. Attempts are included except in homicide classifications.
7. Column 3: Enter the number of complaints which were proven to be "unfounded' by police investigation. An "unfounded" offense is one in
which a complaint was received, but upon investigation, proves either to be baseless or not to have actually occurred. Remember that recovery
of property or clearance of an offense does not unfound a complaint.
8. Column 4: Number of actual offenses. This number is obtained by subtracting the number in Column 3 from that in Column 2.
9. Column 5: Enter the total number of offenses cleared during the month. This total includes the clearances which you record in Column 6.
An offense is cleared when one or more persons are charged and turned over for prosecution for that offense. Clearance totals also include
exceptional clearances which are explained in the Uniform Crime Reporting Handbook.
10. Column 6: Enter here the number of offenses which are cleared through the arrest, releasing to parents, or other handling of persons under
the age of 18. In those situations where an offense is cleared through the involvement of both an adult and a person under 18 years of age, count
the clearance only in Column 5.
11. The grand totals for Columns 2, 3, 4, 5, and 6 are the totals of each of the seven classifications.
12. Tally books can be used to maintain a running count of offenses through the month. Totals for the Return A can then be taken directly
from the Tally book. These Tally books can be obtained by corresponding with the FBI, Criminal Justice Information Services Division,
Attention: Uniform Crime Reports/Module E-3, 1000 Custer Hollow Road, Clarksburg, West Virginia 26306; telephone 304-625-4830,
facsimile 304-625-3566.
13. This Return A report should be forwarded to the FBI Uniform Crime Reports even though no offenses of this type listed were committed
during the month. However, it is not necessary to submit supplemental reports in such cases. Simply check the appropriate box within the
block near the bottom of the Return A report.
14. Any inquiry regarding the completion of this form, the classification and scoring of offenses, or prior to submitting crime data by computer
printout, contact the Uniform Crime Reporting Program at the above-mentioned address.
15. Reporting according to the historical definition of rape is optional. This count should be included in the total reported in line 2a or line 2b.

---

Sheet 4: Return A Supplement

SUPPLEMENT TO RETURN A

1-706 (Rev. 2-22-13)

SUPPLEMENT TO RETURN A

OMB No. 1110-0001

MONTHLY RETURN OF OFFENSES KNOWN TO THE POLICE

MONTHLY RETURN OF OFFENSES KNOWN TO THE POLICE

Expires 07-31-16

This report is authorized by law Title 28, Section 534, U.S. Code. Your cooperation in completing this form with the

Return A will assist the FBI in compiling timely, comprehensive, and accurate data. Please submit this form monthly,

by the seventh day after the close of the month, and any questions to the FBI, Criminal Justice Information Services Division,

Attention: Uniform Crime Reports/Module E-3, 1000 Custer Hollow Road, Clarksburg, West Virginia 26306; telephone

304-625-4830, facsimile 304-625-3566. Under the Paperwork Reduction Act, you are not required to complete the form unless

it contains a valid OMB control number. The form takes approximately 11 minutes to complete.

This form deals with the nature of crime and the monetary value of property stolen and recovered. The total offenses recorded

on this form, page 2, should be the same as the number of actual offenses listed in Column 4 of the Return A for each crime class.

Include attempted crimes on this form, but do not include unfounded offenses. If you cannot complete the report in all areas,

please record as much information as is available. Tally sheets will be sent upon request.

PROPERTY BY TYPE AND VALUE

Type of Property (1)

Data Entry

Monetary Value of Property Stolen in Your Jurisdiction

Stolen (2)

Recovered (3)

Note: Form continues below

(A) Currency, Notes, Etc.

01

(Please scroll down)

(B) Jewelry and Precious Metals

02

(C) Clothing and Furs

03

(D) Locally Stolen Motor Vehicles

04

(E) Office Equipment

05

(F) Televisions, Radios, Stereos, Etc.

06

(G) Firearms

07

(H) Household Goods

08

(I) Consumable Goods

09

(J) Livestock

10

(K) Miscellaneous

11

TOTAL

00

$0

$0

Matched - Total Value of Property Stolen by Classification (See data entry line 77 below)

Prepared by

Title

Telephone Number

Date

Chief, Sheriff, Superintendent, or Commanding Officer

Month and Year of Report

Agency Identifier

Population

Agency and State

DO NOT USE THIS SPACE

INITIALS

RECORDED

EDITED

ENTERED

ADJUSTED

CORRES.

PROPERTY STOLEN BY CLASSIFICATION

CLASSIFICATION

DATA ENTRY

Number of Actual Offenses (Column 4 Return A)

Monetary Value of Property Stolen

Return A Actual Offenses (Column 4)

1. MURDER AND NONNEGLIGENT MANSLAUGHTER

12

0

2. RAPE

20

0

3. ROBBERY

31

(a) HIGHWAY (streets, alleys, etc.)

(b) COMMERCIAL HOUSE (except c, d, and f)

32

(c) GAS OR SERVICE STATION

33

(d) CONVENIENCE STORE

34

(e) RESIDENCE (anywhere on premises)

35

(f) BANK

36

(g) MISCELLANEOUS

37

TOTAL ROBBERY

30

0

$0

0

5. BURGLARY - BREAKING OR ENTERING

51

(a) RESIDENCE (dwelling)

(1) NIGHT (6 p.m. - 6 a.m.)

(2) DAY (6 a.m. - 6 p.m.)

52

(3) UNKNOWN

53

(b) NON-RESIDENCE (store, office, etc.)

54

(1) NIGHT (6 p.m. - 6 a.m.)

(2) DAY (6 a.m. - 6 p.m.)

55

(3) UNKNOWN

56

TOTAL BURGLARY

50

0

$0

0

6. LARCENY - THEFT (Except Motor Vehicle Theft)

61

(a) $200 AND OVER

(b) $50 TO $199

62

(c) UNDER $50

63

TOTAL LARCENY (Same as Item 6x)

60

0

$0

0

$0

7. MOTOR VEHICLE THEFT (Include Alleged Joy Ride)

70

0

GRAND TOTAL - ALL ITEMS

77

$0

Matched - Total Value of Property Stolen by Type and Value (See data entry line 00 above)

ADDITIONAL ANALYSIS OF LARCENY AND MOTOR VEHICLE THEFT

81

6x. NATURE OF LARCENIES UNDER ITEM 6

(a) POCKET-PICKING

(b) PURSE-SNATCHING

82

(c) SHOPLIFTING

83

(d) FROM MOTOR VEHICLES (except e)

84

(e) MOTOR VEHICLE PARTS AND ACCESSORIES

85

(f) BICYCLES

86

(g) FROM BUILDING (except c and h)

87

(h) FROM ANY COIN-OPERATED MACHINES (parking meters,etc.)

88

(i) ALL OTHER

89

TOTAL LARCENIES (Same as Item 6)

80

0

$0

0

$0

7x. MOTOR VEHICLES RECOVERED

91

(a) STOLEN LOCALLY AND RECOVERED LOCALLY

(b) STOLEN LOCALLY AND RECOVERED BY OTHER JURISDICTIONS

92

(c) TOTAL LOCALLY STOLEN MOTOR VEHICLES RECOVERED (a & b)

90

0

(d) STOLEN IN OTHER JURISDICTIONS AND RECOVERED LOCALLY

93