Symptom: Balances disagree. Balance sheet accounts show on P&L or vice versa.
Cause: A partial chart of accounts in Sage or overlapping High and Low values
Explanation: A partial chart means that at least some of the nominal codes are not represented in the chart. Similarly if an account code is used that could sit in multiple accounts our conversion won’t know which it should use. This can lead to P&L accounts in Sage being interpreted as Balance Sheet Accounts once converted or vice versa. The cumulative properties of Balance Sheet accounts mean the converted balances don’t agree to the P&L balances that are “zero’d down” each year.
Fix: Ideally the Sage chart should be amended to be complete and free from overlapping code ranges before the conversion takes place. Where this problem has already occurred, if there’s only a few affected accounts you could attempt to calculate what the converted balance would be if the account type were switched from P&L to Balance Sheet or vice versa.
If most of the chart has been affected this could take too much time. You could instead choose to accept the data as it is and then to amend the chart later before reviewing the figures. Alternatively you could consider contactacting either Intuit or Xero and request they offer to pay again for a second conversion. If accepted the chart can be rectified prior to providing us with the latest backup for converting.