Products

Advanced Analysis Tools

Accounting
Project Management
Imaging and Work Flow
Estimating
Advanced Analysis Tools
Hardware and General Software

Excel Tool - Net Check Payroll Calculations

Tool: Calculator for Specific Net Check Payroll Amounts
Tool Type: Excel Spreadsheet with Sage Master Builder Component
Compatibility: Sage Master Builder version 12.x, 13.x, Microsoft Excel 2000, 2003, 2007

This clever little spreadsheet allows the user to specify an exact net check amount, FICA and Medicare tax rates, Federal Income tax rate, and State Income tax rate, and it returns the correct gross payroll amount and each tax deduction for a simple cut and paste into a Master Builder payroll record.

Calculate exact net bonus check amounts. For example, calculate the gross payroll and tax deductions required to create a net bonus check of $1,000.

Create a payroll record to accomodate year-end benefits. For example, calculate the gross payroll to cover a $500 personal use of auto with the appropriate tax deductions and have a net check of zero dollars.

Calculate correcting payroll records for employees that are no longer active. For example, if you have an employee where there needs to be a FICA adjustment, calculate the gross pay that is needed in a payroll record to cover the adjustment and leave a net check of zero dollars.

Calculations take into account the current FICA cap and gross wages to date of the employee. Rounding errors are resolved prior to entering into Master Builder.

Instructions and examples are included in the spreadsheet.

Price: $ 195

Note: This tool is available as a free download for Syscon Intense Master Builder Subscription Members.

Labels: bonus, master builder, payroll, year end benefit

Certified Payroll Reporting for CT

Tool: Connecticut Payroll Certification for Public Works Projects
Tool Type: Excel Template for Sage Master Builder
Compatibility: Sage Master Builder version 12.x, 13.x, Microsoft Excel 2000, 2003, 2007

Substantially reduce the frustration and time of preparing weekly certified payroll reports!

Preparation of certified payroll reports is time consuming and prone to errors. This sophisticated Microsoft Excel spreadsheet template is populated with two queries generated directly from Sage Master Builder. The result is an excellent duplication of the Connecticut Payroll Certification report for public works projects, Form WWS-CP1 that can be printed directly from Excel and submitted to the Connecticut Department of Labor. This template will allow you to:

Eliminate duplicate data entry for certified payroll reports
Extract weekly payroll data for specific jobs
Print up to 40 employees on a single job
Print the required statment and signature page for each certified submission
Create an electronic "history" of certified report submission

Example CT Certified Payroll Report and Statement

Price: $ 1,200

Register for a demo of the Syscon CT Certified Payroll Excel Template

Labels: certified, connecticut, master builder, payroll, sage