This troubleshooting guide will help you identify and fix discrepancies in your Balance Sheet.
Actuals out of Balance
If the discrepancy is in Actuals follow these troubleshooting steps.
Check Accounting Data
Run a balance sheet in your accounting system to ensure the problem does not start there.
Run a Balance Sheet in Calxa, using your Original Account Tree to compare to your accounting system report. If they do not balance run a manual sync:
Navigate to: Settings > Organisation Settings > Organisation Sync
On the right of your Organisation, click SYNC NOW
Re-run the report to confirm
If you're using a manual organisation please see Enter Actuals for a Manual Organisation, for details on entering balances values.
Retained & Current Earnings
Review the Bank & Equity menu and ensure the correct Retained Earnings & Current Year Earnings accounts are nominated. These must be your System accounts if you have a connected accounting file.
MYOB Example:
Xero Example:
For Current Year Earnings, you MUST use the account Current Earnings which does not have an Account Number or GST setting (This account is not visible in Xero):
Account Tree
Run a Balance Sheet report in Calxa using the Original Account Tree. If the discrepancy only occurs on a custom tree check the following.
Check ALL accounts are allocated.
Even Inactive accounts must be allocated.
Check there are NO Hidden Categories (Show in Reports turned off).
Even hiding P&L accounts will cause a discrepancy in Retained Earnings as the hidden accounts will not be included in the Retained Earnings calculation.
If necessary you can use different Account Tree versions for different reporting requirements.
MYOB Opening Balances
If you're connected to a MYOB AccountRight organisation please be aware that you should not edit Opening Balances. When you edit opening balances or merge accounts that cause a change to opening balances, these changes are not reflected in Calxa during the Sync. The preferred method to adjust balances would be to use a journal which will be reflected in Calxa after a Sync.
If you've adjusted opening balances and it's not possible to undo these changes please contact customer support.
Forecast out of Balance
If the discrepancy is in your Forecast follow these troubleshooting steps.
Check Actuals
First ensure the out of balance issue doesn't start from Actuals. If it does start from Actuals follow the troubleshooting steps above.
Check Cashflow Settings
Review the following Cashflow Settings menus to ensure accounts are nominated in all cases.
Company Tax (note you can set this settings as "No, I'll budget manually")
Balance your Budget
For the most part, Calxa will automatically balance you budget but there are a few exceptions. Refer to Balance your Budget with the Discrepancy Analysis Report for full details.