Account Reconciliation cannot be performed on Group Heading accounts
Sage 50 blocks reconciliation on accounts that are structural or linked, because they do not hold their own clearable transactions.
When Sage 50 tells you “Account Reconciliation cannot be performed on Group Heading, Subgroup Total, Group Total, and most linked accounts,” it is refusing to open the reconciliation window for the account you selected. Despite the wording, nothing is broken. Sage 50 is telling you that the account you clicked on is not the kind of account that gets reconciled, and it never will be.
What these account types are
Group Heading, Subgroup Total, and Group Total accounts are structural. They exist to organize your chart of accounts and to roll up subtotals on financial statements. They do not hold individual transactions themselves; they display the sum of the real accounts nested beneath them. Because there are no individual entries to clear, there is nothing to match against a bank or credit card statement.
Linked accounts are different. They are accounts that Sage 50 posts to automatically behind the scenes, such as accounts for taxes, payroll, or certain inventory activity. Most of these cannot be reconciled through the normal reconciliation window because their entries are generated by the system, not by transactions you clear manually.
Reconcile the actual account instead
The fix is usually a matter of selecting the right account. Go back to your chart of accounts and look for the specific checking, savings, credit card, or loan account where the transactions actually live, not the heading or total line above it. Reconciliation is done at that individual account level.
If your real account is showing as a linked account
Sometimes an account that should be reconcilable has been designated as a linked account in your company settings, which removes it from the reconciliation list. Whether you can safely unlink it depends on how your file is configured and what that account is used for. Changing link settings can affect how transactions post, so it is worth understanding the implications before making that change.
If the account structure itself is the problem
In some files, the chart of accounts has grown over many years and the real bank account is buried under layers of groups and subgroups, making it hard to identify. If you are unsure which account to reconcile, or if reconciliations have not been done in a long time and the balances do not make sense, the cleanest path is to have the file reviewed. Our engineers can examine the structure, identify the correct accounts, and, if the chart of accounts needs to be cleaned up or the data converted to QuickBooks, handle that for you.
If you are stuck on which account to reconcile or the chart of accounts looks wrong, send us the file for a free evaluation and we will tell you exactly what is going on.