Page History

Staff -

...

How to Download and Format a Batch

...

Using Excel QRG

...

.pdf

Excel has features for editing column widths, filtering, and sorting columns.  Staff with the Payroll Team role can download a batch report into Excel. Then the batch can be organized and customized.

1. From your home dashboard, click Payroll, then click Batches.
   Image Added
2. Enter search criteria for the batch you want to download, such as date the batch was pulled.
3. Click Search.
4. Click the batch you want to download. You can click on any part of the row except the hyperlink under Created By.
   Image Added
5. The Batch Details will display. Click on Attachments.
   Image Added
6. Attachments will display showing the date, file name, file type, file size, added by, download & status. Click the blue arrow under Download.
   Image Added
7. Click on the Open file link. Depending on your browser settings, this may appear differently. You can also go to your Downloads folder and open the batch from there.
   Image Added

8. The batch will open in an un-formatted state.
   Image Added

   Note
   icon false title Note
   Make sure to save this as an Excel Workbook with the same name as was given to it in OR PTC DCI. In this example, save it as BR3311_2021_09_01-1133.

9. Re-size the columns.
   1. Click on the small triangle in the upper left corner of the data to highlight the spreadsheet.
   2. Place the curser in between two columns. The curser should become a cross type shape. Double-click. The columns will automatically re-size.
      Image Added
10. With the data still highlighted, click Data from the command ribbon.
11. Click Filter. The spreadsheet will now display filterable arrows in each column. This will give you the option to filter the data, so you are only seeing a portion of it at once.
    Image Added
12. Keep all data selected and under the Data tab, click Sort.
    Image Added
13. Sort the data by voucher number first and then service date for easy entry into Mainframe. To do this:
    1. In the Sort by Column drop down, select Voucher Number.
    2. Click Add Level.
    3. In the Then by Column, select Date of Service.
    4. You can continue this process to add any other sorting criteria that will make time entry into Mainframe easier. For example, you may wish to then sort by Start Time. How you sort is up to personal preference.
    5. Click OK.
       Image Added
14. Make sure to Save your changes.

...

Related articles

...