Write off a bad debt

Overview: 

  • Learn how to create a provision for bad debts 
  • Learn how to write off bad debt in Wiise 
  • Learn how to recover written off bad debts 

Why write off a bad debt? 

When your customer fails to pay a debt, you’re unlikely to recover the full amount owed. In such cases, you may choose to create a provision for doubtful or bad debts. This provision can be used to write off the customer account when you have confirmed that the customers would no longer pay what is owed.   

How to write off a bad debt? 

Note: When accounting on a cash basis, no adjustment is required as income is only recognised when you've been paid.  

A provision for bad or doubtful debts can be created by estimating the bad debts using a measurement principle.  At every month end, you can estimate the bad debts and take up relevant accounting entries to create this provision.   

Note: You can write off a customer's account as bad when you know you will not be able to collect any funds from them.

 How to create a provision for bad debts? 

  1. To provide for bad debt, your Wiise chart of accounts must be setup with a Bad Debt Expense account and Less Provision for Bad Debts account.
    chart of accounts
    Tip: Based on the aged accounts receivable report, refer to your company policy to estimate doubtful debts and calculate the amount required in your provision account. You can update your provision, either by reducing or increasing it as you progress from one month to the other.  
  2. Search for General Journals at the top right-hand corner of the Wiise page.

    General Journals
    1. The General Journals task is displayed below.
       
      Provision Bad debt
    2. Select the appropriate Account No. to expense the bad debts. 
    3. Select the appropriate Bal. Account No as the provision for bad debt account. 
    4. Fill in the estimated bad debt amount in Amount.  
    5. Provide a narration on the Description column on the action you’re taking. Example: ‘Provide for Bad Debt Dec 2023.’ 
    6. Post the General Journal. Select Post/Print. Then, select Post.
        
      Post GL
    7. Do you want to post journal lines’ message appears. Select Yes to proceed or No to stay on the page.  

      Post GL yes
    8. When the journal lines have been posted successfully, the below information appears.  

      GL posted
    9. Select OK to continue. 
  3. Now that you’ve posted the general journals for bad debt expense, your chart of accounts will reflect that change on the general ledger entries.
    Provision bad debt
    Less Provision bad debt

How to write off a customer's account as bad? 

Note: You can run the aged accounts receivable report to determine which customers would not pay what they owe. Some of the reasons for non-payment would be bankruptcy or administration type of events. 

Note: You can use a sales journal or a general journal to complete this process. We’ll use a sales journal for this process.

    1. Search for and select Sales Journals at the top right-hand corner of the page. 

      Sales Journal Search
    2. Update the following information in the Sales Journal for the required customer.
       

      Sales Journal
      1. Select the Account No. of the customer.  
      2. Update the Document No for your journal lines. 

        Note: You can use automatic and manual number series for journals.  
      3. Apply a credit amount in Amount.  
      4. Select Process. Then, select Apply Entries.

        Sales Journal apply entries
    3. The Apply Customer Entries page for the specific customer is displayed. Select which invoices you want to apply to write off as bad debt.  

      ACE
      1. When you’ve made your selection, select Process, then select Set Applies-to ID. The Applies-to ID rows are updated with the Document No. that was specified in the sales journal.  

        Set to applied
    4. Go back to the Sales Journals page and update the Description column to ‘Write off bad debts.’ 

      Note: Write a description that will help you remember the reason for the journal.   

      Sales Journal bad debt description
      1. Post the journal. Select Post/Print, then select Post.

        post print
      2. A message pops up asking if you want to post the journal lines. Select Yes to continue or select No to stay on the page. 

        post journal line
      3. Select OK to continue after sales journal are posted successfully. 
      4. Check the balance against the customerto whom you’ve applied to write off the bad debt. 

        balance customer card
      5. All debt has been written off for this customer if the balancing account is down to 0.00.

    How to recover written off bad debts? 

    If you later receive payment in part or full for a bad debt you’ve written off, you’ll need to record the payment recovered and reverse the original write-off.  

     

    What’s next? 

    Find out how to run an aged receivables report to understand how many customers owe the business money and how much of this is past due.   

     

    Need help?

    If you have any questions reach out to support@wiise.com