Symptom: Aged Debtors or Creditors balances include an amount against a No Name contact.
Cause (Sage): Often the result of journals being entered in Sage to the Debtors or Creditors Control Account.
Cause (QuickBooks): A possible corruption of data or other underlying problem that causes the control account to be different to the list of contact balances.
Check (Sage): Click File > Maintenance > Check Data. View the warnings and see if it reports “Sales/purchase aged balance disagrees with control account”. Expand the warning to see the amount they disagree by.
Check (QuickBooks): Generate a Trial Balance and compare the Debtors / Creditors Control balance to the Aged Receivables / Payables Report. Any difference would result in the “No Name / Default” balance.
Explanation: It’s possible in Sage and QuickBooks for the list of customer or supplier balances not to agree to the control account. Other systems don’t allow these balances to disagree, so while converting the data, we ensure the control account balances agree from the old system to the new. We convert all the individual customer and supplier balances, but the difference is posted to a “No Name” (Xero) or “Default” (QuickBooks Online) customer or supplier to ensure the total equals the control account.
Fix: Since this problem already existed in Sage or QuickBooks, it’s been transferred to your new software. Sage differences can be resolved (like they would in Sage) by determining which customer(s) or supplier(s) the journal in Sage relates to, and posting the necessary transactions required to cancel the “No Name” or “Default” entries and re-post them to the relevant customer(s) and / or supplier(s). QuickBooks corruptions may require the data to be verified and rebuilt or possibly returned to Intuit for fixing.