3-3 Cash Receipts
In the 3-3 Cash Receipts window, you can enter payments for invoices, discounts for early payment of invoices, and overpayments. You can also reverse payments.
When the invoices are displayed, select an invoice and enter the amount of the payment and any applicable discount or overpayment. If the payment is for a credit invoice enter a negative amount.
If a client pays more than the net amount of an invoice but less than the invoice balance, Sage 100 Contractor applies the payment to the retention. Suppose you created an invoice for $1000 minus 10% retention, resulting in a net total of $900. The client, however, sends a $950 payment. After entering the payment in cash receipts, the total balance due is $50 and the Retention column shows a balance of $50. It is important to note that this is not a substitute for releasing retention.
Sometimes clients will receive a discount for early payment. Sage 100 Contractor automatically determines whether a discount is available based on the due date you indicated on the invoice. When a discount is available, it is shown in the Discount Available text box. If a discount is not available, you can still apply a discount to an invoice.
When a client pays more than the total balance of an invoice, you can enter the additional money as an overpayment. The total amount of the Paid and Discount cells must equal the amount in the Balance cell before Sage 100 Contractor will allow you to enter the overpayment. When you save the cash receipts, Sage 100 Contractor reduces the job balance by the amount of the overpayment. In addition, the invoice now carries a negative balance and acts as a credit invoice.
Suppose a client informs you that he is going on vacation for a few weeks. The client wants to make sure you have enough money to continue building while he is gone, so instead of paying the $5,000 he was billed, he sends a check for $10,000. For the invoice, enter $5,000 in the Paid cell and $5,000 in the Overpayment cell. After saving transactions, the invoice now carries a –$5,000 balance. The next time you invoice the client, you can apply the credit.
The Cash Receipts window also allows you to reverse payments and discounts. To reverse payments, enter a negative amount in the paid column and discount column if you have taken a discount. If the reversal is for a credit invoice enter a positive amount in the paid column.
To enter a payment against an invoice:
|
1
|
Open 3-3 Cash Receipts. |
|
a
|
In the Account text box, enter the ledger account number for the cash account. |
|
b
|
In the Deposit# text box, enter the deposit number. |
|
c
|
In the Date text box, enter the deposit date. |
|
d
|
In the Description text box, enter a brief statement about the transaction. |
|
3
|
Do one of the following: |
|
a
|
In the Client text box, enter the client number. |
|
b
|
In the Job text box, enter the job number. |
|
4
|
Do one of the following: |
|
a
|
Click the Contract Invoices tab. |
|
b
|
Click the Service Invoices tab. |
|
5
|
Click the Display button. |
|
6
|
In the grid, do the following: |
|
a
|
In the Paid cell, enter the total amount received.
Do not include any discount or credit in this amount. |
|
b
|
If you are using discounts, in the Disc Available cell, enter the amount of the discount.
If you are not using discounts, skip step b. |
Important! To enter an overpayment for an invoice, the total of the Paid and Discount cells must equal the amount in the Balance text box. Then in the Overpayment cell, enter the amount paid in addition to the invoice payment, not the total amount.
|
7
|
Repeat step 6 for each invoice you want to pay. |
|
8
|
On the File menu, click Save. |
Tip: If you do not enter a job number or client number, Sage 100 Contractor displays all invoices.
Entering payments and applying credits to invoices simultaneously
You can simultaneously enter a payment and apply a credit invoice. Suppose a job has a $500.00 credit invoice, a $1,000 invoice, and a $3,000 invoice. The client sends a payment of $3,500, the total amount due. You can apply the credit to either invoice, then apply the payment to the remaining balance.
To enter a payment and apply a credit to an invoice:
|
1
|
Open 3-3 Cash Receipts. |
|
a
|
In the Account text box, enter the ledger account number for the cash account. |
|
b
|
In the Deposit# text box, enter the deposit transaction number. |
|
c
|
In the Date text box, enter the deposit date. |
|
d
|
In the Description text box, enter a brief statement about the transaction. |
|
3
|
Do one of the following: |
|
a
|
In the Client text box, enter the client number. |
|
b
|
In the Job text box, enter the job number. |
|
4
|
Do one of the following: |
|
a
|
Click the Contract Invoices tab. |
|
b
|
Click the Service Invoices tab. |
|
5
|
Click the Display button. |
|
6
|
In the grid, do the following: |
|
a
|
In the Paid cell, enter the total amount received. |
|
b
|
In the Discount Available cell, enter the amount of the discount. |
|
c
|
To apply the credit in the Paid cell of the credit invoice, enter the credit as a negative amount. |
|
7
|
Repeat step 6 for each item. |
|
8
|
On the File menu, click Save. |
Applying credit invoices to receivable invoices
You can apply the balance of a credit invoice to one or more receivable invoices. It is also possible to apply only a portion of the credit invoice balance to an invoice and apply the remaining balance later.
To apply a credit invoice to a receivable invoice:
|
1
|
Open 3-3 Cash Receipts. |
|
a
|
In the Account text box, enter the ledger account number for the cash account. |
|
b
|
In the Deposit# text box, enter the deposit transaction number. |
|
c
|
In the Date text box, enter the deposit date. |
|
d
|
In the Description text box, enter a brief statement about the transaction. |
|
3
|
Do one of the following: |
|
a
|
In the Client text box, enter the client number. |
|
b
|
In the Job text box, enter the job number. |
|
4
|
Do one of the following: |
|
a
|
Click the Service Invoices tab. |
|
b
|
Click the Contract Invoices tab. |
|
5
|
Click the Display button. |
|
6
|
In the grid, do the following: |
|
a
|
In the Paid cell, enter the credit as a negative amount. |
|
7
|
Repeat step 6 for each invoice to which you want to apply a credit. |
|
8
|
On the File menu, click Save. |
Reversing cash receipts
Important! After you apply a credit invoice to an invoice and save the transaction, you cannot reverse the credit. If you have applied a credit invoice to the wrong invoice, enter an invoice to correct the error.
To reverse a cash receipt:
|
1
|
Open 3-3 Cash Receipts. |
|
a
|
In the Account text box, enter the ledger account number for the cash account. |
|
b
|
In the Deposit# text box, enter the deposit transaction number. |
|
c
|
In the Date text box, enter the deposit date. |
|
d
|
In the Description text box, enter a brief statement about the transaction. |
|
3
|
Do one of the following: |
|
a
|
In the Client text box, enter the client number. |
|
b
|
In the Job text box, enter the job number. |
|
4
|
Do one of the following: |
|
a
|
Click the Contract Invoices tab. |
|
b
|
Click the Service Invoices tab. |
|
5
|
Consider the following: |
|
a
|
If the invoices are partially paid, the Open only option should be selected. |
|
b
|
If the invoices are completely paid, select the Paid only option. |
|
c
|
If you have a combination of paid and partially paid invoices, select the All option. |
|
6
|
Click the Display button. |
|
7
|
In the grid, do the following: |
|
a
|
In the Paid cell, enter the amount as a negative amount. |
|
b
|
In the Discount cell, enter the discount amount, if any, as a negative amount. |
|
8
|
Repeat step 7 for each payment you want to reverse. |
|
9
|
On the File menu, click Save. |
Notes:
- When you reverse a payment made to an invoice with status 4-Paid, Sage 100 Contractor changes the status to 1-Open.
- After reversing all payments made to an invoice, you can void the invoice.
Reversing an Accounts Receivable Credit Applied to an Invoice with a Reference Number
|
1
|
Open 3-3 Cash Receipts. |
|
2
|
In the Job field, select the correct Job. |
|
3
|
Click the [All Invoices] button. |
|
4
|
Click [Display Invoices]. |
|
5
|
On the Contract Invoices tab grid, locate the accounts receivable invoice and the accounts receivable credit which was applied to the invoice. |
|
6
|
On the grid line for the accounts receivable credit memo, click the Discount field and enter the amount of the credit you wish to reverse as a positive sum. |
|
7
|
On the grid line for the accounts receivable invoice, click the Discount field and enter the amount of the credit you wish to reverse as a negative sum. |
|
8
|
In the Account field, enter the correct cash account. |
|
9
|
In the Deposit # field, enter a number. |
|
10
|
In the Description field, enter a description. |
|
11
|
In the Date field, enter the correct date. |
|
12
|
Select the correct Posting Period. |
Entering receivable two-party checks
There are several ways to handle two-party checks. If the other payee has signed the check over to your company, deposit and receive the check normally. When you have to sign over the check to a second payee, it is necessary to enter two transactions in the accounting. Make the first transaction in 3-3 Cash Receipts, and the second in 4-3-1 Select Invoices to Pay and 4-3-2 Pay Vendors.
To enter a receivable two-party check:
|
1
|
Open 3-3 Cash Receipts. |
|
a
|
In the Account text box, enter the cash clearing account number. |
|
b
|
In the Deposit# text box, enter the deposit transaction number. |
|
c
|
In the Date text box, enter the deposit date. |
|
d
|
In the Description text box, enter a brief statement about the transaction. |
|
3
|
Do one of the following: |
|
a
|
In the Client text box, enter a client number. |
|
b
|
In the Job text box, enter a job number. |
|
4
|
Do one of the following: |
|
a
|
Click the Contract Invoices tab. |
|
b
|
Click the Service Invoices tab. |
|
c
|
Click the Display button. |
|
5
|
In the grid, do the following: |
|
a
|
In the Paid cell, enter the total amount received. Do not include any discount or credit in this amount. |
|
b
|
In the Discount Available cell, enter the amount of the discount. |
|
6
|
Repeat step 5 for each invoice. |
|
7
|
On the File menu, click Save. |
|
8
|
Open 4-3-1 Select Invoices to Pay. |
|
9
|
In the Invoice Selection window: |
|
a
|
Enter the selection criteria. |
|
b
|
Select other options as desired. |
|
11
|
In the Set to Pay text box, enter the total amount to be paid. |
|
12
|
Do not include a discount in this amount. |
|
13
|
On the File menu, click Save. |
|
14
|
Open 4-3-2 Pay Vendors. |
|
16
|
Select Check in the Pay By field. |
|
17
|
Click [OK]. Print the check to blank paper in the 4-3-5 Report Printing window. |
Note: The account used should be the same check clearing account used when you received the two party check, not your regular checking account.
Tips:
- Entering the two transactions produces the same audit trail as if you cashed the client’s payment and then sent a check to the vendor. If you do not have to send a check, immediately print the check on blank paper instead of a check form. This will help prevent any confusion about the transaction the next time you print checks.
- It is a good idea to include a note referencing the client check number in both transactions. This connects the two transactions together, providing a clear audit trail.