Docs

Integrations Articles & FAQ

account, bad, debt, invoice, number, summary, tax, rate

Where can I see the details for bad debt?

Bad debt is the sum of the credit notes that has reason code as write off. Bad Debt details can be f

35484171

2020-06-21T18:56:13Z

2020-06-21T19:01:34Z

605

0

0

246675

Where can I see the details for bad debt?

Where can I see the details for bad debt? 

This article also includes

How to check if a Bad Debt has Tax Rate associated with it when I run the Account summary report without including Taxes?

Summary

Bad debt is the sum of the credit notes that has reason code as write off. Bad Debt details can be found in the Invoices report under the column: Write-off Amount

Note: The value in this section will differ from the bad debt column in Account Summary based on whether the option to include Tax was checked in the Account Summary section or not as displayed in the image below.

In the above Account Summary, the bad debt value for the month of Dec-2019 is $287.04 with taxes included. If you uncheck the “Show amounts after the tax is applied” and “Show amounts after the discount is applied” then your bad debt value shall be represented as $254.02.

In the above example, the tax component value is 13%. For the Invoice, of $288~ (i.e. the bad debt for the month of Dec 2019 as mentioned in the image below) the write-off amount shall be written as $287.04 while the associated bad debt in the Account Summary shall be mentioned as $254.02. This is because the 13% tax component is not included in the bad debt and was unchecked at the Account Summary section.

$254.03* (1.13 + (13% Tax)) = $287.04

To check whether the bad debt has tax rate associated with it, filter by Invoice Number in the line items, and check column-M if the tax rate has been defined or not.

For example, for the Invoice number: 228, the tax rate has been defined as 13% in Column-M.

Related Articles 

How to install the Google Chrome Extension for Xero/Quickbooks Reconciliation?
Xero sync error - Payments can only be made against Authorised documents & Payment amount exceeds the amount outstanding on this document.
Xero sync error - Price List Item Code must not be more than 30 characters long.
Xero Error : Account code '0000' is not a valid code for this document.
Configuration errors and their resolution for Xero
How to match invoices report to a line item report?
Xero sync errors - A currency rate must be specified
Xero - How to connect two Chargebee sites to one Xero account (Internal)?
Xero - Why is the round off amount so large?
The contact number XXX is already assigned to another contact. The contact number must be unique across all contacts.
The TaxType code 'X' cannot be used with account code 'Y'
How to map existing customers in Chargebee to existing customers in Xero/Quickbooks/NetSuite?
Xero app show error: The chart of account mapping for the plan/addon is not configured‌
Xero Sync Error - Invoice number must be unique
What is Default Sales Tax in Xero integrations?
"[Xero] 1) You have reached the limit of invoices you can approve" while syncing invoices
How to check the lock date in Xero?
Authentication for this Chargebee to Xero connection has expired. Click 'reconnect' to resume data sync
Plan level tracking categories in Xero
Error - Xero 1) Account must be valid. 2) Tax rate must be valid
Why is the round-off amount so large in Xero?
Adding additional email addresses to the customer card in Xero
Save option greyed out while trying to change account mapping on Xero.
Base Currency difference for Chargebee and Xero
Was this article helpful?
Loading…