QuickBooks HelpQuickBooksHelpIntuit

Write off customer and vendor balances

by Intuit17 Updated 5 months ago

You may have small balances that are the result of an error, an overpayment, or an underpayment. Often it would cost more time and materials to collect or pay the amount due than it would be to clear it from your accounts.

We recommend two ways to remove the amounts. Make sure to consult your accounting professional before trying any of these options.

Option 1: Create a general journal entry to write off the amount

Accounts receivable

  1. Create an appropriate journal entry.
    1. From the Company menu, select Make General Journal Entries.
    2. In the Make General Journal Entries window, change the date and fill in the entry number if necessary.

      For a customer with an overpayment

      1. Select the Account field and select Accounts Receivable from the dropdown list.
      2. Enter the amount under the Debit column, tab to the Name column and select a Customer Name from the dropdown list.
      3. In the next line, select the offset account and enter the amount under the Credit column. The offset account is usually an Expense account.
        User-added image

      For customers with an underpayment

      1. Select the Account field and select Accounts Receivable.
      2. Enter the amount under the Credit column, tab to the Name column and select a Customer Name from the dropdown list.
      3. In the next line, select the offset account and enter the amount under the Debit column.
        User-added image
    3. Select Save & Close.
  2. Apply the General Journal Entry to the Existing Credit/Debit.
    1. From the Customers menu, select Receive Payments.
    2. Enter the name of the customer in the Received From field.
    3. Select the invoice and choose Discounts & Credits.
    4. Under the Credits tab, select the available credit and select Done.
    5. Select Save & Close.

Accounts payable

  1. Create an appropriate journal entry.
    1. From the Company menu, select Make General Journal Entries.
    2. In the Make General Journal Entries window, change the date and fill in the entry number if necessary.

      For vendor with overpayment

      1. Select the Account field and select Accounts Payable from the dropdown list.
      2. Enter the amount under the Credit column, tab to the Name column and select the vendor name from the dropdown list.
      3. In the next line, select the offset account and enter the amount under the Debit column.
        User-added image

      For vendor with underpayment

      1. Select the Account field and choose Accounts Payable from the dropdown list.
      2. Enter the amount under the Debit column, tab to the Name column and select the vendor name from the dropdown list.
      3. In the next line, select the offset account and enter the amount under the Credit column.
      4. Select Save & Close.
  2. Apply the journal entry to the existing debit/credit.
    1. From the Vendors menu, select Pay Bills.
    2. Select the bill and choose Set Credits.
    3. Under the Credits tab, select the available credit and select Done.
    4. Select Save & Close.

Option 2: Use discounts to write off small amounts

  1. Create an account and item to use when writing off small amounts.
    1. Create a Charge off Account.
      1. From the Lists menu, choose Chart of Accounts.
      2. Select the Account button and choose New.
      3. Select Income, then Continue.
      4. Enter Minor A/R and A/P Charge-Off in the Account Name field and select Save & Close.
    2. Create a Charge-off item.
      1. From the Lists menu, choose Item Lists.
      2. Select the Item button and choose New.
      3. Choose Other Charge as Item Type and select Continue.
      4. Enter Minor Charge-Off in the Item Name/Number field.
      1. Select Non-Taxable Sales in the Tax Code field.
      1. Select Minor A/R and A/P Charge-Off in the Account field.
      2. Select OK to save and create the item.
  2. Select the scenario that best describes the small amount that you want to clear.

    Customer underpayment

    1. From the Customers menu, select Receive Payments.
    2. Choose the name of the customer in the Receive From field.
    3. Select the invoice that you want to write off the amount.
    4. Select Discounts & Credits.
    5. Select the Discount tab:
      1. Enter the amount in the Amount of Discount field.
      2. Select Minor A/R and A/P Charge-Off in the Discount Account field.
      3. Select Done to close the Discount and Credits window.
        User-added image
    6. Select Save & Close to close the Receive Payments window.

    Customer overpayment

    1. From the Customers menu, choose Create Invoices.
    2. Select the customer name in the Customer:Job field.
    3. Select Minor Charge-Off in the Item field and enter the amount of overpayment.
    4. Select Apply Credits.
      User-added image
    5. Select the credit in the Available Credits section (The amount of credit should match the amount of invoice).
      User-added image
    6. Select Done to close the Apply Credits window.
    7. Select Save & Close.

    Vendor underpayment

    1. From the Vendors menu, select Pay Bills.
    2. Choose the bill that has the balance that you need to write off.
    3. Select Set Discount.
      User-added image
    4. Select the Discount tab
      1. Enter the amount in the Amount of Discount field.
      2. Select Minor A/R and A/P Charge-Off in the Discount Account field.
        User-added image
      3. Select Done to close the Discount & Credits window.
    5. Select Pay Selected Bills to close the Pay Bills window.
    6. Select Done in the Payment Summary window.

    Vendor overpayment

    1. Enter a Bill that will offset the credit.
      1. From the Vendors menu, choose Enter Bills.
      2. Select the vendor in the Vendor field.
      3. Under the Items tab, select Minor Charge-Off in the Item field.
      4. Select Save & Close.
        User-added image
    2. Apply the available credit to the bill that you created.
      1. From the Vendors menu, choose Pay Bills.
      2. Select the bill that you entered to offset the credit.
      3. Select Set Credits.
      4. Choose the Credits tab and select the credit.
        User-added image
      5. Select Done to close the Discount & Credits window.
      6. Select Pay Selected Bills to close the Pay Bills window.
      7. Select Done in the Payment Summary window.
QuickBooks Desktop Mac PlusQuickBooks Desktop Premier 2021QuickBooks Desktop Premier PlusQuickBooks Desktop Pro 2021QuickBooks Desktop Pro PlusQuickBooks Desktop for Mac 2020QuickBooks Desktop for Mac 2021

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this