Salary Benefit Appropriation Allocations (APS 019)

Benefit Voucher Data Worksheet — Features and Instructions

Background

The Comptroller’s office offers a USAS upload process that uses a standardized Microsoft Excel template. Users can populate the Benefit Voucher Data Worksheet template with applicable financial information, then supply the completed document to their appropriation control officer (ACO).

The Benefit Voucher Data Worksheet template consists of a single-sheet Excel workbook that allows for data entry into all applicable USAS fields.

Data Worksheet Template Features

The data template worksheet:

• Provides smart column headings of USAS data elements. Hover over any heading for more information on that element such as definition, purpose and specific requirements. To determine the USAS data elements that may be required for a given USAS document type, see USAS Coding Instructions (FPP Q.010).
• Autocorrects date formats for data entry into USAS. Enter dates using any of these formats and the correct format will populate in USAS: 090123; 9/1/23; 9/1/2023; 09/01/2023.
• Supplies a leading zero for fields that require them such as transaction codes (T-codes: three-digit values per USAS) or program cost accounts (PCAs: five-digit values per USAS) that begin with zero (0). Note: Excel by default does not display placeholder zero digits.

  Examples:
  Enter TC 12 in the worksheet and 012 will be entered in USAS.
  Enter PCA 5070 in the worksheet and 05070 will be entered in USAS.

Basic Instructions

1. Enter values in applicable data element fields. Hover over field column headings for specific information as needed.
2. Submit completed worksheet to your ACO.

For More Information

Contact your ACO if you have questions about completing the Benefit Voucher Data Worksheet.