Sage 100 Contractor Version 20.7 User's Guide

1 Sage 100 Contractor 2017(formerly Sage Master Builder) User's GuideUnited States EditionVersion Version of the software has been retiredThis is a publication of Sage Software, Inc. 2017 The Sage Group plc or its licensors. All rights reserved. Sage, Sage logos, and Sage product and servicenames mentioned herein are the trademarks of The Sage Group plc or its licensors. All other trademarks are theproperty of their respective updated: March 19, 2018 This Version of the software has been retiredContentsWelcome to Sage 100 Contractor A better way to run your busi-ness1 What's New in this Release?1 About Sage Advisor Update1 About Sage 100 Contractor Intelligence Reporting2 About Sage Payment Solutions3 Sage 100 Contractor Printable Documentation6 Printing Sage 100 Contractor Documentation7 Customer Support and resources7 Training resources10 Business partners10 The Users Group10 Business forms11 Sage 100 Contractor Add-on Modules11 Chapter 1: General Ledger15 General Ledger Reports151-1 Checks and Bank Charges151-2 Deposits & Interest211-3 Journal Transactions251-4 Recurring Journal Transactions281-5 Bank Reconciliation301-6 Period and Fiscal Year Management421-7 General Ledger Accounts711-8 General Ledger Setup82 Methods for entering financial activity for the current year861-9 Company Departments98 Chapter 2.

2 Accounting Reports101 Working with Accounting Reports1012-1 Trial Balance Reports1012-2 Balance Sheet Reports101 User's Guide iiiThis Version of the software has been retired2-3 Income Statement Reports1012-4 General Ledger Reports1022-5 General Journal Reports1022-6 Check Register Reports1022-7 Chart of Accounts Reports1022-8 Financial Reports1032-9 Statement of Cash Flows Reports103 Chapter 3: Accounts Receivable105 Working with Accounts Receivable1053-1 Receivable Reports1053-2 Receivable Invoices & Credits1053-3-1 Cash Receipts1123-3-2 Electronic Receipts1183-4 Statements1233-5 Jobs (Accounts Receivable)1243-6 Receivable Clients1493-7 Progress Billing1643-8 Loan Draw Requests1773-9 Unitary Billing1833-10 Time and Materials1903-11 Recurring Receivables198 Accounts Receivable Startup Information200 Chapter 4: Accounts Payable203 Working with Accounts Payable2034-1 Payable Reports2044-2 Payable Invoices & Credits2054-3 Vendor Payments2264-4 Vendors (Accounts Payable)235 About 4-5 Vendor 1099 Forms and eFiling by Aatrix2714-6 Recurring Payables2724-7 Credit Card Management274 Contentsiv Sage 100 ContractorThis Version of the software has been retiredChapter 5: Payroll283 Working with Payroll2835-1 Payroll Reports2835-2 Payroll Processing2875-3 Payroll Management3445-4 Federal and State Tax Filing3775-5 Daily Payroll385 Chapter 6: Project Management3916-1 Job Reports3916-2 Budgets3916-3 Job Costs3996-4 Change Orders4066-5 Cost Codes4196-6 Purchase Orders4256-7 Subcontracts4336-8 Cost-to-Complete4396-9 Proposals4446-10 Unitary Proposals4486-11 Document Control4506-12 Project Work Center468 Chapter 7.

3 Utilities471 Working with Utilities471 Specify Sage License Server471 About the Connect to SQL Server window476 Company List Window4777-1 Company Information4797-2 Company Security4837-3 Repair Database4977-4 Contact Manager4987-5 Scheduled Reports Manager5007-6 Alerts Manager501 ContentsUser's Guide vThis Version of the software has been retiredData Maintenance508 Printers510 Chapter 8: Equipment Management513 Working with Equipment Management5138-1 Equipment Reports5138-2 Equipment Costs5138-3 Equipment Records5178-4 Equipment Allocation5268-5 Equipment Payments5288-6 Equipment Depreciation5298-7 Equipment Revenue529 Chapter 9: Estimating531 Working with estimating, assemblies, and parts531 What is assembly estimating?531 Pre-Built Data Sets5329-1 Takeoff Reports5349-2 Parts5349-3 Assemblies5419-4 Part-Assembly Classes5469-5 Takeoffs5519-6 Add Parts-Update Prices5929-7 Maintain Parts Database5989-8 Board Footage601 Chapter 10: Scheduling603 Working with Scheduling60310-1 Scheduling Reports60310-2 Tasks60310-3 Schedules607 Chapter 11: Service Receivables619 Working with Service Receivables619 Contentsvi Sage 100 ContractorThis Version of the software has been retired11-1 Service Reports61911-2 Work Orders, Invoices, & Credits61911-3 Dispatch Board658 Chapter 12: Inventory671 Working with Inventory67112-1 Inventory Reports671 Inventory Startup67112-2 Inventory Allocation67312-3 Inventory Locations68012-4 Purchase Order Receipts68212-5 Inventory Audit683 Chapter 13.

4 Review and Reporting685 Working with Review and Reporting685 Selecting and Creating Reports68613-1 Financial Review69013-2 Project Review69313-3 Report Writer69313-4 Report Printing72313-5 Form/Report Page Design73413-6 Report & Query Lists74313-7 Print Database Format74613-8 Search Reports747 Working with Mailing Labels and Label Form Designs749 Using MICR to Print Your Own Checks752 Report Scheduling758 Emailing and Faxing Reports762 Exporting Data to Microsoft Excel773 Appendix A: Sage 100 Contractor Features777 About Sage 100 Contractor Features777 Basic Features777 Sage 100 Contractor Dashboard791 ContentsUser's Guide viiThis Version of the software has been retiredWorking with Grids805 Working With Records808 Working With Attachments811 About Lookup windows817 Working with Picklist Windows819 Function Keys and Shortcuts820 Working with the Calendar821 Working with the Calculator823 Working with Notes824 Opening text files826 Working with Find queries826 About customizing Sage 100 Contractor defaults827 Working with Images827 Working with Templates828 Working with Document Tracking829 Exporting and Importing Files829 Appendix B.

5 Sage 100 Contractor Reports835 About Sage 100 Contractor Reports8351-General Ledger Reports8352-Accounting Reports8383-Accounts Receivable Reports8434-Accounts Payable Reports8645-Payroll Reports8726-Project Management Reports8808-Equipment Management Reports8979-Estimating Reports90110-Scheduling Reports90611-Service Reports90812-Inventory Reports91513-Review and Reporting Reports917 Appendix C: Timetable of Office Procedures919 About office procedures919 Contentsviii Sage 100 ContractorThis Version of the software has been retiredDaily Routines919 Monthly Routines921 Quarterly Routines923 Weekly Routines924 Year-End Routines925 Appendix D: Tax Setup Information927 Federal, City, and State Tax Setup Information927 About tax setup information927 Alabama State Tax927 Alaska State Tax928 Arizona State Tax928 Arkansas State Tax930 California State Tax931 Colorado State Tax931 Connecticut State Tax932 Delaware State Tax933 District of Columbia Income Tax933 Federal Income Tax934 Florida State Tax935 Georgia State Tax935 Hawaii State Tax936 Idaho State Tax936 Illinois State Tax937 Indiana State Tax938 Iowa State Tax938 Kansas State Tax939 Kentucky State Tax940 Louisiana State Tax940 Maine State Tax942 Maryland residents working in Delaware942 Maryland State Tax943 Massachusetts State Tax945 ContentsUser's Guide ixThis Version of the software has been retiredMichigan State Tax945 Minnesota State Tax946 Mississippi State Tax947 Missouri State Tax947 Montana State Tax948 Nebraska State Tax949 Nevada State Tax950 Nevada Workers' Compensation950 New Hampshire State Tax951 New Jersey State Tax951 New Mexico State Tax952 New York City and Yonkers City Tax953 New York

6 State Tax954 New York Workers' Compensation955 North Carolina State Tax956 North Dakota State Tax956 Ohio State Tax957 Ohio Workers' Compensation958 Oklahoma State Tax958 Oregon State Tax959 Oregon State Workers' Compensation959 Pennsylvania State Tax960 Setting up local taxes for Pennsylvania961 Puerto Rico Income Tax964 Rhode Island State Tax965 South Carolina State Tax966 South Dakota State Tax966 Tennessee State Tax967 Texas State Tax967 Utah State Tax968 Utah Workers' Compensation969 Vermont State Tax969 Virginia State Tax970 Contentsx Sage 100 ContractorThis Version of the software has been retiredWashington State Tax971 Washington State Workers' Compensation972 West Virginia State Tax972 Wisconsin State Tax973 Wyoming State Tax973 Appendix E: Transaction Sources975 About transaction sources975 Appendix F: System Configuration977 Configuring Windows Regional and Short Date Format977 Special Configurations Operating Systems and Services977 Appendix G: User Interface Reference983 Activity Center Icons983 Shortcut Icons983 Appendix H: Working with the Act!

7 Plug-in987 Setting up Act! Integration987 Setting up an API security group and an API user in Sage 100 Contractor988 Setting up companies in Act!990 Creating a Sage 100 Contractor Client from an Act! Company991 Creating a Sage 100 Contractor Job from an Act! Company993 Creating a Sage 100 Contractor Client/Job from an Act! Opportunity995 Creating a Sage 100 Contractor Vendor from an Act! Company998 Removing associations in Act! and deleting the entry in Sage 100 Contractor999 Appendix I: Working with Sage Construction Anywhere1003 Additional required software1003 Duration of the installation process1003 Pre-installation information1003 Setting up an API security group and an API user in Sage 100 Contractor1004 Setting up Sage Construction Anywhere Integration1005 Index1007 ContentsUser's Guide xiThis Version of the software has been retiredThis Version of the software has been retiredWelcome to Sage 100 Contractor Abetter way to run your businessSage 100 Contractor is an integrated, construction-specific, estimating, accounting, and project managementsoftware solution.

8 Whether you are a general Contractor , a subcontractor, or service Contractor , Sage 100 Contractor manages your business using one 100 Contractor provides many features that are beneficial for customers with complex environmentsthat may include remote connections, many simultaneous users, and/or multiple 's New in this Release?For detailed information about program enhancements, fixes, known issues, and comments for this release,refer to the Release Notes. To open the Release Notes installed on your system, clickHome & Resourcestab > Printable Documentation > Release NotesorResources > Product Documents > Release Notesif you have Activity Centers Sage Advisor UpdateWhen you install Sage 100 Contractor on a server or a workstation, you can select an option to install SageAdvisor Update. We recommend that you install Advisor Update is a notification and download service that alerts you when an update is available forSage 100 Contractor . You can use Sage Advisor Update to download and install updates available for Sage100 Contractor and other Sage products for which you have a current Sage Business Care !

9 You must be connected to the Internet to use Sage Advisor theSage Advisor Updateicon in your Windows system tray at any time to:View and manually check for updates that are available for your Sage the frequency and time of day to check for a location on your computer to download up email notifications to alert you by email when updates are update history for your Sage the status of your Sage Business Care can also open Sage Advisor Update by clickingStart > Programs > Sage > Sage Advisor help on using Sage Advisor Update, see the help for that :Use theCustomizesettings in the Windows system tray to make sure you can view the SageAdvisor Update icon and notifications from the System Tray in your 's Guide 1 This Version of the software has been retiredAbout Sage 100 Contractor Intelligence ReportingSage 100 Contractor integrates with Sage Intelligence Reporting, a Microsoft Excel-based businessintelligence reporting tool designed to help you to make timely, informed decisions for your business, whilereducing spreadsheet use Sage Intelligence Reporting to create financial reports and analyze Sage 100 Contractor data usingthe familiar Microsoft Excel application.

10 It includes the following modules:Report this module to create and edit reports using Sage 100 Contractor datacontainers, and to run this module to create new financial reports. You can easily:"Drag and drop" columns and predefined additional calculated fields using the Formula amounts dynamically when forecasting and this module to view existing this module to enter or edit Sage Intelligence Reporting module this module to define security for reports and this module to connect to unlimited ODBC data sources or additional Sage 100 Contractor !The first time you run Sage Intelligence Reporting, you must log in as the Windowsadministrator. A user with Windows administrator privileges must register the ActiveX component, , that Sage Intelligence Reporting requires. To register this component, open any SageIntelligence Reporting module. Once the component is registered, other users can use Sage following predefined reports come with Sage Intelligence Reporting:2-3 Income Statement: 21 Income Statement2-3 Income Statement: 31 Income Statement ~Period and YTD2-3 Income Statement: Dept.