The 3-2 Receivable Invoices/Credits window lets you enter transactions that affect receivable accounts. You can create invoices or credit invoices, track retention, or view a history of payments for a specific invoice.
You can also create a simple invoice based on the percentage of work completed for the contract. This type of billing is suitable for subcontractors or small projects.
The Receivable Invoices window also provides the ability to enter taxable and non-taxable items on an invoice at the same time. When you enter a tax district number in the Tax District text box, you can select the items to tax in the Taxable column. If you leave the Tax District text box blank, Sage 100 Contractor assumes each item is non-taxable.
The status of a receivable record indicates its location in the process.
Important! You can change the status of records assigned status 1-Open, 2-Review, or 3-Dispute to another of the first three status settings. However, you cannot assign status 4-Paid or 5-Void.
Status |
Description |
1-Open |
Indicates a record posted to the general ledger. |
2-Review |
Indicates the management or bookkeeping staff should review the record. |
3-Dispute |
Indicates a record disputed by the client. |
4-Paid |
Indicates a record paid in full. |
5-Void |
Indicates a voided record. |
Note: When an invoice or credit is fully paid, Sage 100 Contractor automatically assigns status 4-Paid. If you void the record, Sage 100 Contractor automatically assigns status 5-Void.
Type |
Description |
1-Contract |
Use type 1-Contract when the invoice affects the billing for the contract. A receivable invoice assigned type 1-Contract increases the job balance, and a credit invoice with this type reduces the job balance. |
2-Memo |
Use type 2-Memo when the invoice does not affect the job billing for the contract. For example, when you enter a job deposit as a credit invoice, assign it 2-Memo so that the credit does not affect the invoiced to date amount. You can also use this type with bad debts. Entering a credit invoice assigned 2-Memo does not reduce the invoiced to date amount, but clears the debt. |
You can review the record totals before saving the invoice or credit. On the Options menu, click Calculate.
You can provide part numbers on an invoice. Sage 100 Contractor only includes the parts on the invoice, and does not use the part information elsewhere.
When you enter a tax district number in the Tax District text box, you can select which items to tax. In the Taxable column, type Yes if the item is taxable, or No if the item is non-taxable.
1 | Open 3-2 Receivable Invoices/Credits. |
2 | Do the following: |
a | In the Invoice# text box, enter the invoice number. |
b | In the Date text box, enter the date of the invoice. |
c | In the Job text box, enter the job number. |
d | If the job uses phases, enter the phase number in the Phase text box. |
e | In the Description text box, enter a brief statement about the invoice. |
f | In the Due Date text box, enter the invoice due date. |
g | In the Discount Date text box, enter the due date by which you must receive payment for the client to receive the discount. |
h | In the Status list, click the invoice status. |
i | In the Type list, click the invoice type. The contract affects the invoiced balance when Type 1-Contract is selected. Type 2-Memo does not affect the invoiced balance. |
3 | In the grid, do the following: |
a | In the Description cell, enter a brief statement about the item. |
b | In the Quantity cell, enter the quantity of items. |
c | In the Price cell, enter the price for a single item. |
d | In the Account cell, enter the ledger account number. |
4 | Repeat step 3 for each item. |
5 | In the Discount text box, enter the discount for early payment. |
6 | On the File menu, click Save. |
7 | In the Retention text box, enter the amount of retention. |
If you discover an invoice was entered incorrectly, determine the best method to correct the error. For example, if the error is in the header information, you can edit the information contained in any of the text boxes,
When the invoice contains an incorrect job number,
There are also circumstances when you cannot void the original record. For example, you cannot void a credit invoice that has been applied in full, or an invoice posted to period 0. Because you cannot void these types of transactions, it is necessary to enter an adjusting invoice.
Before voiding an invoice, reverse all the payments posted to it. You can then enter the invoice correctly and reapply the payments.
You can void a receivable invoice with an assigned status of 1-Open, 2-Review, or 3-Dispute.
When voiding an invoice that contains discretionary taxes, Sage 100 Contractor also voids the tax amount. If the voided invoice reduces the discretionary taxes below the billing maximum, Sage 100 Contractor continues to calculate the discretionary taxes until the tax maximum is met.
1 | Open 3-2 Receivable Invoices/Credits. |
2 | Using the data control, select the record. |
3 | If an amount appears in the Paid text box, reverse the payments. |
4 | On the Edit menu, click Void Invoice. |
You can create a receivable invoice for a job based on the amount of work completed. Using the original contract amount or the new contract amount and the amount you have invoiced to date, Sage 100 Contractor determines the balance remaining on the contract.
When you supply the percentage of the contract that is completed, Sage 100 Contractor computes the amount to bill. This method is similar to progress billing, but does not provide a detailed breakdown by cost code of the progress. Instead, the invoice contains a single line describing the percentage of work completed and the invoice amount. This method of billing is best suited for subcontractors.
1 | Open 3-2 Receivable Invoices/Credits. |
2 | Enter the invoice. |
3 | On the Options menu, click Contract Summary. |
4 | Choose the type of invoice you want to create by selecting the Percentage of Contract or Percentage of New Contract option. |
5 | In the Percent Complete text box, enter the total amount of the contract that is completed. |
6 | The Amount to Bill text box displays the computed amount. You can edit both figures if necessary. |
7 | Click OK. |
Note: Sage 100 Contractor automatically increments the new contract amount as change orders are approved. The amount billed does not change, but the percent billed changes since it is determined from the new contract amount.
Important! You cannot reverse a credit invoice after applying it to an invoice. If you apply a credit invoice to the wrong invoice, make adjusting invoice entries to correct the error.
Many situations could cause you to enter a credit invoice. Suppose a client provides a prepayment on a job, or overpays an invoice. In either case, it is necessary to reduce the accounts receivable.
When you save a credit invoice, Sage 100 Contractor reduces the job balance. However, the credit invoice retains status 1-Open until you apply it against other invoices in the 3-3-1 Cash Receipts window. After you have applied the credit balance to other invoices, Sage 100 Contractor assigns the credit invoice status 4-Paid.
You can also apply a credit invoice to an invoice at the time you save the record. If the invoice is fully paid by means of the credit invoice, Sage 100 Contractor changes the status of the invoice to 4-Paid. If the invoice still has a balance after applying the credit, the invoice status is not changed. Likewise, if the entire amount of the credit is applied, the status of the credit invoice changes to 4-Paid. If a credit invoice still has a balance after applying it to an invoice, the status of the credit invoice remains unchanged. You can then apply the remaining credit invoice balance to other invoices in the 3-3-1 Cash Receipts window.
After making changes, you can recalculate the new totals.
To calculate the balances, on the Options menu, click Calculate.
About accounts receivable Retention Accounts receivable payment history |
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.