Department Out of Balance
When you run a Balance Sheet by department, here's the criteria that must be met in order to stay in balance:
- Both the Assets/Liabilities/Equity and Income/Expense side of the COA must use departments.
- All transactions for a specific department must only be posted to accounts in that department.
- All accounts must have a department, especially with the Balance Sheet. Any accounts that don't have a department close out to the first Retained Earnings account found. When running by department, the first RE account may not be your typical default. Running the whole Balance Sheet usually identifies these differences in the RE account.
Here's what you can do:
- Run the Original Balances report for those departments. This ensures what you're starting with is in balance.
- On the Other Information tab, click .
- Under Chart of Account Reports, expand Accounting Reports, and select Original Balances. Run the report as usual.
- If the original balances are in balance, try the next step.
- Run the Crossing Account Part report to see if a certain transaction caused the issue.
- On the Other Information tab, click .
- Under General Transaction Reports, expand Listing Reports, and select Crossing Account Part Report. Run the report as usual.
- Identify if any transactions did not stay within the same department. These would show as out of balance when running for a specific department.
- If you don't find a certain transaction that caused the issue, try the next step.
- Check the full Balance Sheet against the Balance Sheet for those departments to see if the Retained Earnings account balance changed.