3-5 Jobs (Accounts Receivable)
When you create a job in the 3-5 Jobs (Accounts Receivable) window, Sage 100 Contractor creates a record containing job-related information such as important contract dates, job financial information, and job-related contacts. In addition, the 3-5 Jobs (Accounts Receivable) window provides a variety of tools to help you manage contracts, such as pre-liens and lien releases. You may also create phases or bid items to divide work into more manageable sections.
Billing information such as the client, job architect, engineer, or project lender, may also be included as part of the job record. For example, when you supply the client number, Sage 100 Contractor includes the client information on invoices printed for that job. If you include the architect or engineer’s name in the job record when using progress or unitary billing, Sage 100 Contractor uses that information when creating a progress or unitary bill. If you include the lender, Sage 100 Contractor uses the lender information when creating a loan draw document. You can also set job level security for each job.
You may manage all your jobs directly from your Project Work Center. You may also create a desktop shortcut to Project Work Center and place it on the Sage 100 Contractor Desktop. This gives you the power to access all your job-related data from one place.
Entering jobs
If you select the Post expenses to WIP asset account check box, and you have selected Job# as Subaccount# on a general ledger account(s), upon job save, you will be prompted to create subaccounts under those ledger accounts.
Upon saving the job, Sage 100 Contractor checks the client’s balance for any past due invoices and displays a message indicating the amount past due, if any. To turn this option off, in the Options menu, click Check Client Balance.
To enter a job
|
1
|
Open 3-5 Jobs (Accounts Receivable). |
|
2
|
Enter header information, as follows: |
|
a
|
In the data control text box, enter the job number. |
|
b
|
In the Job Name text box, enter the full job name. |
|
c
|
In the Short Name text box, enter an abbreviated name for the job. |
|
d
|
In the Job Status list, click the job status. |
|
e
|
In the Job Type list, click the type of job. |
|
3
|
In the General Information tab: |
|
a
|
In the Client text box, enter the client number. |
|
b
|
In the Address 1, Address 2, City, State, and Zip text boxes, enter the client's address. |
|
c
|
If the job is in a sales tax district, enter the district in the Sales Tax District text box. |
|
d
|
If the job is in a local payroll-tax district, enter the district in the Payroll Locale text box. |
|
e
|
In the Income Account text box, enter the default income account. |
|
f
|
If you departmentalize income, enter the default department number in the Department text box. |
|
g
|
If the job requires certified payroll reporting, click the Requires certified payroll reporting check box. |
|
h
|
If the job requires posting payroll to WIP asset accounts, select the Post expenses to WIP asset account check box. |
|
i
|
In the Due Terms text box, enter the cycle for the date when the invoice is due. |
|
j
|
In the Discount Terms text box, enter the cycle by which payment must be received for the discount to apply. |
|
k
|
In the Discount Rate text box, enter the discount rate. |
|
l
|
In the Finance Rate text box, enter the annual finance rate. |
|
m
|
In the Retainage Rate text box, enter the rate of retention. |
|
n
|
If the customer provides a purchase order for the job, enter the purchase order number in the Client PO# text box. |
|
o
|
If the customer provides a contract number for the job, enter the contract number in the Contract# text box. |
|
p
|
In the Contract Amount text box, enter the amount of the original contract. |
|
4
|
In the Contacts and Personnel tab: |
|
a
|
In the Architect text box, enter the vendor number of the architect or engineer. |
|
b
|
In the Lender text box, enter the vendor number of the lending institution. |
|
c
|
In the Estimator text box, enter the employee number of the estimator. |
|
d
|
In the Salesperson text box, enter the employee number of the salesperson. |
|
e
|
In the Supervisor text box, enter the employee number of the job supervisor. |
|
f
|
In the Job Access List text box, click the Edit list of users with security access to job button to select up to 5 users with security access to this job. |
|
i
|
In the Contact Name text box, enter the contact's name. |
Note: The first contact in the list is considered to be the primary contact in reports.
|
ii
|
In the Job Title text box, enter the contact's job title. |
|
iii
|
In the Phone# text box, enter the contact’s telephone number. |
|
iv
|
In the Extension text box, enter the contact's telephone extension, as necessary. |
|
v
|
In the Email text box, enter the contact's email address. |
|
vi
|
In the Cell Phone# text box, enter the contact’s cellular number. |
|
vii
|
In the Fax# text box, enter the contact’s fax number. |
|
viii
|
In the Other# text box, enter the contact’s other telephone number. |
|
ix
|
In the Other Description text box, enter the contact’s other telephone number description. |
|
x
|
In the Notes text box, enter any applicable notes about the contact. |
|
5
|
In the Project Dates and Sales Information tab: |
|
a
|
In the Project Dates section, enter the job dates in the appropriate text boxes. |
|
b
|
In the Sales Information section, enter the project and sales details in the appropriate text boxes. |
|
6
|
If you are using phases, click [Phases] and enter the phases. |
|
7
|
If you are using bid items, click [Bid Items] and enter the bid items. |
|
8
|
On the File menu, click Save. |
Tips:
- The Post expenses to WIP asset account check box does not affect whether the job appears in the WIP report.
- The contract dates allow you to track important aspects of the project, but Sage 100 Contractor does not use these dates for any reports or documents.
Setting up the default taxability of cost types for jobs
In some regions, work that is normally not taxable becomes taxable when performing certain services on a job. Sage 100 Contractor provides you the ability to manage the taxability of cost types for a specific job. Sage 100 Contractor uses the tax rate from the sales tax district indicated in the job record, but uses the cost type taxability you set up in the Taxable Cost Types dialog box.
To set up the default cost type taxability
|
1
|
Open 3-5 Jobs (Accounts Receivable), and then select the job. |
|
2
|
On the Options menu, click Taxable Cost Types. |
|
a
|
In the Materials text box, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
|
b
|
In the Labor text box, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
|
c
|
In the Equipment text box, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
|
d
|
In the Subcontract text box, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
|
e
|
In the Other text box, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
|
f
|
For each customized user-defined cost type, type [Y] if the cost type is taxable or [N] if the cost type is not taxable. |
Note: If you leave a Cost Type text box blank, Sage 100 Contractor uses the default indicated in the Tax District window.
About contract terms
Important! When entering the discount date and due date for a job, you must also indicate the billing cycle.
|
Enter the finance rate to apply when payments are late.
|
|
Enter the percent of the entire contract withheld as retention. When you enter an invoice, Sage 100 Contractor automatically calculates retention for the invoice.
|
|
Enter the discount rate.
|
|
Indicates the date payment is due.
|
|
Indicates the date by which payment is due for the client to receive a discount.
|
|
Indicates the total amount of the contract, excluding sales tax.
|
Tip: If you have indicated a client number in the job record, Sage 100 Contractor uses the term rates from the client record.
About beginning and ending balances for jobs
The 3-5 Jobs (Accounts Receivable) window displays the contract balance for the current fiscal year.
|
Displays the balance of outstanding invoices at the beginning of the fiscal year.
The Beginning Balance box only displays an amount when the ending balance carries over to a new fiscal year.
|
|
Displays the total balance to-date for outstanding invoices posted to the job for the current fiscal year.
|
About job status
The job status lets you follow the condition of a job, and does not affect your ability to post to a job. You can change the status of a job record at any time and still post invoices or credits to it.
Note: The Job Status list is not editable. The six existing job statuses are defaults for the program.
|
You are currently bidding for the job.
|
|
You submitted a bid for the job, but it was awarded to another contractor.
At the fiscal year-end, you can remove job files assigned status 2-Refused.
|
|
You won the contract but have not begun work.
|
|
Work is in progress on the contracted job.
|
|
You have completed work on the contracted job.
At the fiscal year-end, Sage 100 Contractor does not remove job files assigned this status.
|
|
You have completely invoiced the job and received full payment and have approved the deletion of the job file.
At the fiscal year-end, you can remove job files assigned status 6-Closed.
|
Setting up job types
You can classify jobs that your company performs by contract, work performed, or any other means.
Example 1: Invoice Method
The following table shows a list for a general contractor based on the method of invoicing:
1
|
Time and Materials Projects
|
2
|
Progress Billing Projects
|
3
|
Government Projects
|
Example 2: Type of Work
The following table shows a list based on the type of work performed:
1
|
Remodeling
|
2
|
New Residential
|
3
|
New Commercial
|
4
|
Schools
|
5
|
Tenant Improvements
|
To set up job types
|
1
|
Open 3-5 Jobs (Accounts Receivable). |
|
2
|
Next to the Job Types list, click the detail button. |
|
3
|
In the Job Type# text box, enter the number of the job type. |
|
4
|
In the Type Name text box, enter a description of the job type. |
|
5
|
In the Notes text box, enter notes about the job type. |
|
6
|
Repeat steps 3–5 for each job type. |
|
7
|
On the File menu, click Save. |
To assign status 5-Complete to a group of jobs
|
1
|
Open 3-5 Jobs (Accounts Receivable). |
|
2
|
On the Update menu, click Completed Status. |
|
3
|
In the Picklist window, select the jobs to which you want to assign status 5-Complete. |
|
4
|
Click the check mark button. |
To close a job
|
1
|
Open 3-5 Jobs (Accounts Receivable), and select the job that you want to close. |
|
2
|
In the Current Balance text box, verify that the job-ending balance is $0.00. |
|
3
|
On the Options menu, click Invoices. |
|
4
|
Verify that the status of each invoice/credit is 4-Paid and close the Receivable Invoices window. |
|
5
|
In the Status list, click 6-Closed. |
|
6
|
On the File menu, click Save and close the Jobs window. |
|
7
|
Open 4-1-2-23 AP Invoice List~with Payments, and print the report for job that you are closing. |
|
8
|
Verify that all the invoices are paid or void. |
Tips:
- Add a copy of the Payable Invoice List report to the physical job file.
- You can always post invoices or credits to a job assigned status 6-Closed. Posting an invoice or credit invoice does not affect the job’s status.
- When you close the books at the fiscal year-end, you can remove all closed jobs and their related records.
To close a group of jobs
|
1
|
Open 3-5 Jobs (Accounts Receivable). |
|
2
|
On the Update menu, click Closed Status. |
|
3
|
In the Picklist window, double-click the jobs to which you want to assign status 6-Closed. |
|
4
|
Alternatively, you can select a job, press the Ctrl key, and then drag the cursor over several jobs. Red text indicates the jobs are selected. |
|
5
|
Click the check mark button. |
|
6
|
Open 4-1-2-23 AP Invoice List~with Payments, and print the report for jobs that you are closing. |
|
7
|
Verify that all the invoices are paid or void. |
|
8
|
Open 3-1-2-23 AR Invoice List~with Payments, and print the report for jobs that you are closing. |
|
9
|
Verify that all the invoices are paid or void. |
Deleting jobs
Deleting a job in the 3-5 Jobs (Accounts Receivable) window requires that the job have a status of Closed or Refused. In addition, the job cost records existing in the current year must have a status of Open.
You may not delete a job in 3-5 Jobs (Accounts Receivable) if:
- There is a balance in a WIP Asset subaccount that matches the job number, and;
- The job is marked as Post expenses to WIP asset account in 3-5 Jobs (Accounts Receivable), and;
- The WIP Asset account is marked to use the Job# as Subaccount in 1-7 Ledger Accounts.
These restrictions help maintain the balance between job costs and the general ledger and the consistency between deleting jobs in 3-5 Jobs (Accounts Receivable) and removing jobs in 1-6 Period/Fiscal Year Management.
To delete a job:
|
1
|
Open 3-5 Jobs (Accounts Receivable). |
|
2
|
Using the data control, select the record. |
|
3
|
On the Edit menu, click Delete Job. |
Note: If a WIP job with a balance does not have any current year job costs, you may delete it, but first you have to clear the Post expenses to WIP asset account check box.
More resources
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.