Which balance sheet accounts should be reconciled every month?
At minimum cash and bank, receivables, payables, prepaids, accruals, intercompany balances, fixed assets, payroll liabilities, debt, and anything material or prone to error. Lower-risk accounts can be reconciled less often if your policy says so. The point is a documented, risk-based list, not every account every month out of habit.
How do you automate reconciliations if the team still works in Excel?
Load balances and transactions from the ERP and the bank automatically, let rules match what matches, and send only the exceptions to a person. The team can keep working in an Excel interface while preparer, reviewer and status are tracked centrally, so automating the work doesn't mean retraining everyone who does it.
What do auditors look for in reconciliation sign-offs?
Evidence that each reconciliation was prepared and reviewed by different people, on time, with reconciling items explained and supported, and that the reconciled balance agrees to the general ledger. Missing sign-offs, stale reconciling items and unexplained differences are what turn into audit questions, and later into audit findings.
How do you track who prepared and reviewed each reconciliation?
Record it in the same place the reconciliation lives. Each account carries its preparer, reviewer, dates and status, with support attached. Then the close checklist is a live view rather than a spreadsheet someone remembers to update, and an audit request becomes a filter instead of a week of digging through folders.
What are the signs you've outgrown spreadsheet reconciliations?
The close regularly runs long because reconciliations eat the first days of the month, senior people are still ticking and tying, the same reconciling items roll forward month after month, and nobody can say which accounts are done without asking around. Two of those together usually means it's time to change.