Budget Builder for Civilian Personnel

Features

Features

Summary of New Features in Version 10

Reports Overview

Payroll Reports Column 1

Payroll Reports Column 2

Personnel  Reports Column 1

Personnel  Reports Column 2

Payroll and Personnel  Reports

Reports not on Reports Panel

Sample Reports

 

 

Features

 

Features

·   Uses standard DOD data elements plus 10 user defined data elements

·   Imports DCPDS personnel data

·   Imports DCPS payroll data from a gross pay files, Air Force R60s, Navy LXLs, and other sources

·   Compares payroll and personnel data

·   Automatically costs personnel data using built-in pay and benefit rates

·   Includes National Security Personnel System support

·   Forecasts include user defined values for NSPS payouts, future health plan increases, and pay raises

·   Provides standard step by step procedures for payroll forecasting and multi year budgeting

·   Manages gains, losses, promotions, reimbursables, allowances, WGIs, PCS, etc

·   Forty standard reports with six level sorting and numerous filter and output options

·   Users may customize and save standard reports … or create new reports

·   Custom terminology for Army, Navy, Air Force, Marine Corps, National Guard, and other DOD components

 

 

 

Summary of New Features in Version 10

 

 

Ease of Use:  New Help tab – addresses common technical support matters

Ease of Use:  New Basic tab – only essential options for forecasting civilian personnel

Ease of Use:  New Codes tab – many civilian personnel codes and definitions in one place

Ease of Use:  27 new reports make Budget Builder easier to use

Ease of Use:  Introductory video

Ease of Use:  Add user codes from a text file

Ease of Use:  Add payroll authorizations from a text file

Ease of Use:  Add user reports from previous installation

Ease of Use:  Improved Cost Transfer

Ease of Use:  New Special Batches button excludes biweekly pay periods for faster batch finds

Ease of Use:  Warning when DCPDS data is used before its effective date

Ease of Use:  Various fixes to eliminate version 9 workarounds

Ease of Use:  Added Pay System code to Employee and Payroll normal views

Ease of Use:  New User Guide

 

Forecasting:  Allows editing management estimate batches

Forecasting:  Allows quick entry of management estimates using a new brief screen

Forecasting:  New Management Estimates Only Report provides efficient review of mgt estimates

Forecasting:  Allows forecasting with a filter

Forecasting:  Renamed management estimates batches for clarity

Forecasting:  Allows databases of only management estimates

Forecasting:  Allows separate assumptions for NSPS payouts and non NSPS employee pay raises

Forecasting:  Changed WGI check to optional

 

NSPS:  Includes NSPS pay bands

NSPS:  Prints ten stages in NSPS pay bands

NSPS:  Report shows NSPS pay band usage (employee location in each pay band)

NSPS:  Added pay system filter

 

 

 

Reports Overview

 

83 reports are listed as ordered on the Reports panel.    Reports shown in green are new in Version 10.


 

Payroll Reports Column 1

# 70.0 Super Payroll           

# 70. 4 Premium Pay

 

Column Detail

# 146      Other Column (Super Payroll)

# 139      Lump Sum Leave

# 140      Separation Incentive

# 141      Night Pay

# 142      Sunday Pay

# 143      Holiday Pay

# 144      Other Object Class 11

# 145      Other Object Class 13

 

Payroll Fund Status          

# 70.7 Payroll Fund Status Report  

# 70.8 Payroll Work Year Status Report

               

Payroll Forecast

# 70.9   Payroll Forecast Report

# 70.16 Payroll Forecast Plus Report

 

#136 Payroll Authorizations

# 28  Cost Transfer Report

 

 

Payroll Reports Column 2

Pay Period Analysis

# 13        Payroll Gains and Losses (was Payroll Changes)

# 25        Payroll Increases and Decreases

# 26        Prior FY Transactions

# 27        Retroactive Transactions

# 69        Payroll Stragglers

 

Overtime / Awards

# 137      Overtime

# 138      Awards

 

Management Estimates

# 36        Management Estimates Only

# 35        Payroll and Management Estimates

 

Object Class / SF 113

# 70.20  Object Class w/ SF 113

# 70.21  Payroll Object Class

# 70.22  OPM SF 113 (Monthly Report of

                Federal Civilian Employment)

 

#70.3 Payroll Benefits

 

Work Year Costs               

# 70.12 Work Year Cost – Standard              

# 70.13 Work Year Cost - AF 1092

# 70.14 Work Year Cost – Overtime

 

More…

# 33.0  Payroll Interval Report        

# 70. 1  Payroll D/R            

# 70. 2  Payroll FY              

# 70.5  Brief Payroll           

# 70.6  USMC L509

# 70.10 Super Payroll With FTE Hours          

# 70.11 Super Payroll By Type Hour

# 70.15 Payroll Hours        


 

 

 


Personnel  Reports Column 1

 

# 8 Employee Report

# 7 Object Class Report

 

Trend

# 32 Trend Report   (using personnel file)

# 34 Trend Report   (using payroll and personnel files)

 

# 6    Phasing Report          

# 8.1 Employee Benefits Report     

 

Net Increase Reports        

# 17 WGI Cost Report       

# 23 Payout Cost Report  

# 21 Pay Raise Cost Report             

# 22 FEHB Cost Report

               

Personnel  Reports Column 2

 

Onboard…

#2  Onboard List (original)

#18 Onboard List (new)

# 11.1 Onboard Track

 

Pay Tables…

#1 GS, WG, etc

#3 NSPS

 

Salary Profiles

# 4   Salary Range Report

#24   NSPS Pay Band Usage

 

#18.1 Pay Pool Report

 

#18.2 Leave Balances

 

More…

# 11 Employee Changes   

# 12 Position Report          

# 14 OP-32           

# 15 CP-1             

# 16 CP-2             

# 47 Pay Table List

# 50 Calendar

 

Payroll and Personnel  Reports

# 9   Payroll vs. Personnel Report    

# 19  BACC Differences

               

More…

# 8.2  Payroll vs.. Personnel Report – FEHB 

# 8.3  Payroll vs. Personnel Report – CSRS   

# 8.4  Payroll vs. Personnel Report – FERS   

# 8.5  Payroll vs. Personnel Report – Medicare            

# 8.6  Payroll vs. Personnel Report – FEGLI 

# 8.7  Payroll vs. Personnel Report – OASDI

# 8.8  Payroll vs. Personnel Report – TSP      

# 8.9  Payroll vs. Personnel Report – TSP Basic           

# 8.10  Payroll vs. Personnel Report – Benefits            

# 8.11  Payroll vs. Personnel Report – All Costs

# 42 Payroll Differences Report      

 

 

Reports not on Reports Panel       

# 45 Payroll Compare Report           (run from the Open Payroll Files window)

# 62 Personnel Compare Report      (run from the Open Personnel Files window) 

# 5  Proof Sheet                   (run from an open personnel file)    

 

 

 

Sample Reports

 

Sample Reports is a 50 page PDF file containing an index and sample Budget Builder civilian personnel reports with notes.