The cash discount is not automatically calculated when you receive payments from customers in Small Business Accounting (898564)
The information in this article applies to:
- Microsoft Office Small Business Accounting 2006
- Microsoft Office Small Business Management Edition 2006
SYMPTOMSConsider the following scenario. You apply a credit memo or a payment to an invoice. When you receive
payments from customers, you
may notice that the amount in the Cash Discount column in the Customer Payment dialog box is $0.00. CAUSEMicrosoft Office Small Business Accounting is not designed
to automatically calculate a discount when a credit memo or a payment is applied
to an invoice.WORKAROUNDTo work around this issue, you must create a separate credit memo or a separate journal entry for the cash discount amount. The cash discount can then be applied to the invoice when payment is received. Use one of the following methods. Method 1: Record the cash discount amount as a credit memo- On the Customers menu, click Receive Payment.
- In the Received from box, click the name of the customer from whom you are receiving payment.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- Write down the amount of the cash discount.
- Repeat steps 2 through 4 for each invoice that has an available cash discount.
- Close the Customer Payment
dialog box, and then click No when you are prompted with the question of whether you want to save the changes.
- On the Customers menu, point to
New, and then click New Credit Memo to create
a customer credit memo.
- In the Customer name box, select the appropriate customer who will receive the cash discount.
- In the Products and services area,
click the icon on the left side of the first column, and then click Account in the drop-down list.
- Under Name column, click the arrow, and then click Cash Discount Given or whichever account is used to record the discount amount that is given to a customer.
- In the Unit Price column, type the cash discount amount that you wrote down in step 4.
Note If you are paying multiple invoices for one customer and cash discounts are available for more than one invoice, repeat steps 9 through 11 for each invoice and for the corresponding cash discount. You could also total all available cash discounts for multiple invoices and then record the total on one line in the Products and services area.
- Click Save and Close.
- On the Customers menu, click Receive Payment .
- In the Received from box, click the customer from whom you are receiving payment.
- In the Amount box, leave the amount $0.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- In the Credits column, click
Credits.
- Click to select the check box for the customer credit
memo or for the payment that was previously entered and should be applied to the selected invoice.
Note This credit memo or payment is not the credit memo that was entered in steps 6 through 12. This credit memo or payment is the credit memo or payment that was previously entered to reflect a product return, an adjustment, or a pre-payment. - Click Adjust.
- In the Payment column, type $0.
- Click Save and Close.
- Open the Receive Payment dialog box again by clicking Receive Payment on the Customers menu.
- In the Received from box, click the customer from whom you are receiving payment.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- In the Credits column, click
Credits.
- Click to select the check box next to the customer credit
memo that you entered in steps 7 through 12.
- Click Adjust. The amount in the Payment column in the Receive Payment dialog box is the payment amount due from the customer. The Payment total must match the amount that is received from the customer in the Amount box. If these amounts do not match, make the required changes.
- Click Save and Close.
Method 2:
Record the cash discount amount as a journal entry- On the Customers menu, click Receive Payment.
- In the Received from box, click the customer from whom you are receiving payment.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- Write down the cash discount
amount.
- Repeat steps 2 through 4 for each invoice that has an available cash discount.
- Close the Customer Payment
dialog box , and then click No when you are prompted with the question of whether you want to save the changes.
- On the Company menu, click New
Journal Entry.
- Click Customer in the Type column, and then click the appropriate customer name in the Account column. In the Credit column, type the cash discount amount that you wrote down in step 4.
- Press the TAB key until the focus is on a new line.
- In the
Type column, click Financial account. In the Account column, click Cash Discounts
Given. In the Debit column, type the cash discount amount that you wrote down in step 4 .
- Click Save and Close.
- On the Customers menu, click Receive Payment.
- In the Received from box, click the customer from whom you are receiving payment.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- In the Credits column, click
Credits.
- Click to select the check box next to the customer credit
memo or the payment that was previously entered and should be applied to the selected invoice.
Note This credit memo or payment is not the journal entry entered in steps 7 through 12. This credit memo or payment is the credit memo or payment that was previously entered to reflect a product return, an adjustment, or a pre-payment. - Click Adjust
- In the
Customer Payment dialog box, type $0 in the
Amount box and in the Payment column.
- Click Save and Close.
- Open the Receive Payment dialog box again by clicking Receive Payment on the Customer menu.
- In the Received from box, click the customer from whom you are receiving payment.
- Click to select the check box in the first column of the Due for Payment area to select an invoice.
- In the Credits column, click
Credits.
- Click the journal entry that you entered in steps 7 through 12.
- Click Adjust. The amount in the Payment column in the Receive Payment dialog box is the payment amount due from the customer. The Payment total must match the amount received from the customer in the Amount box. If these amounts do not match, make the required changes.
- Click Save and Close.
Modification Type: | Minor | Last Reviewed: | 8/10/2005 |
---|
Keywords: | kbMBSMigrate kbprb KB898564 kbAudEndUser |
---|
|