Learn how to fix invoices with sales tax errors.

Have you ever incorrectly charged sales tax on an invoice where the customer should have been tax exempt? If you have ever needed to create a Sage 100 Accounts Receivable credit memo for sales tax only, this month’s software tip is for you. The steps below will who you how to correct the taxable and non-taxable sales amounts and issue the credit memo for the sales tax only.

  1. Open Accounts Receivable/Main/Invoice Data Entry, enter CM in the invoice number field and click on the “Next Number” button to generate a credit memo.
  2. On the ‘Header’ tab, select the customer. Be sure to select the same sales tax schedule as the original invoice.
  3. Enter the original invoice number in the ‘Apply to Invoice’ field to apply the credit memo to the invoice.
  4. On the Lines tab, add a line with the following information:
    1. Miscellaneous Item or Charge Code in the Item Number field. If using the “M” miscellaneous code, specify a GL account.
    2. Item description on the credit memo, if desired.
    3. Select “TX” as the ‘Tax Class’.
    4. Enter the taxable sales amount from the original invoice as a positive amount. Click ‘Ok’ to accept the line.
      NOTE:  Credit memos are normally entered with positive amounts. A negative on a credit memo will actually be an addition to the non-taxable sales amount.
  5. Enter a second line with the following information:
    1. The same Miscellaneous Item or Charge Code (or “M” code with same GL account as above).
    2. Select “NT” as the tax class.
    3. Enter the taxable sales amount from the original invoice as a negative amount. The two line items should have a net value of $0.
  6. On the ‘Totals’ tab, note that there is a positive amount in ‘Taxable Amount’ field (reducing the taxable sales) and an offsetting negative amount (increasing the non-taxable sales) in ‘Nontaxable Amount’ field. The total amount of the credit memo should be the original sales tax amount (as a positive number). Confirm that this is the correct tax amount and then click ‘Accept’.
  7. Post the Sales Journal.

For more information or assistance with creating an accounts receivable credit memo for sales tax only, contact our Sage 100 support team at 260.423.2414.

Register for our Sage 100 newsletter today!