Monday, June 14, 2010

, , ,

Accounting Software Packages: Selection, Controls and Setup

Last reviewed: July 2026.

An accounting package is not merely a digital cash book. It is a controlled information system that records transactions, supports reconciliations, produces reports and preserves evidence for management, tax, audit and statutory filing.

The best product is the one that fits the organisation’s processes and control needs. This guide explains selection, implementation, migration, access, integrations, cybersecurity and post-launch review without recommending a particular vendor.

Define requirements before comparing products

List the entity types, currencies, locations, users, transaction volumes, reporting frameworks and regulatory filings the system must support. Include practical needs such as inventory, projects, payroll, fixed assets, purchase approvals, customer credit, consolidation and tax.

Separate essential requirements from desirable features. A long feature list can distract from core needs such as reliable ledgers, audit trails, reconciliations, exportability and support.

Evaluate modules and integration architecture

Most packages contain a general ledger plus receivables, payables, cash, inventory, fixed assets and reporting modules. Some add payroll, projects, expenses, budgeting and consolidation. Determine whether information will be entered once and flow automatically or move through interfaces.

Document each integration, its owner, frequency, error report and reconciliation. Bank feeds, ecommerce platforms and payroll systems save time only when failed or duplicate imports are detected quickly.

Design the chart of accounts and dimensions

The chart should support financial statements, management reporting, tax and internal accountability without becoming unmanageable. Use departments, projects, products or locations as dimensions rather than creating thousands of nearly identical accounts.

Lock naming conventions and mapping rules before migration. Changes after go-live can break comparisons, budgets and electronic filing tags.

Build role-based access and segregation of duties

Users should receive only the permissions needed for their responsibilities. The person who creates a supplier should not automatically be able to approve and pay that supplier. Journal entry, bank detail changes, credit notes and user administration deserve strong controls.

Use named accounts, multi-factor authentication, approval limits and periodic access reviews. Remove access promptly when roles change or staff leave.

Plan data migration and opening balances

Decide how much transaction history to migrate. Clean supplier, customer and inventory records before loading them. Duplicate accounts, invalid tax codes and inconsistent dates become harder to fix after migration.

Reconcile opening balances to the approved closing trial balance. Also test customer and supplier ageing, bank balances, inventory quantities, fixed asset cost and accumulated depreciation, tax accounts and equity.

Test transactions from source to report

User acceptance testing should cover ordinary and unusual transactions: purchases, sales, returns, discounts, foreign currency, asset disposal, bad-debt write-off, payroll journals, bank transfers and period-end adjustments.

Trace each test from source document through approval, posting, ledger, reconciliation and financial report. Confirm that reversing and correction procedures preserve the audit trail.

Control bank feeds and reconciliations

Automatic matching can reduce routine work but should not replace review. Configure tolerances carefully, prevent duplicate imports and keep unmatched items visible.

Bank reconciliations should be prepared regularly, independently reviewed and supported by statements. Old outstanding items, unexplained transfers and recurring manual overrides are warning signs.

Protect data and maintain resilience

Accounting data is sensitive and operationally critical. Use the NIST Cybersecurity Framework concepts to govern risk, identify important systems, protect access, detect anomalies, respond to incidents and recover from disruption.

Backups should be encrypted, tested and separated from the live environment where appropriate. Document recovery time objectives, vendor dependencies, data ownership and export procedures.

Assess reporting and filing capability

Check whether the package produces reliable trial balances, audit trails, cash-flow data, budgets and management dashboards. Reports should allow drill-down without exposing unauthorised information.

For jurisdictions moving toward software-based statutory filing, confirm supported taxonomies, digital signatures, validation and update arrangements. Software capability does not remove management’s responsibility for the information filed.

Vendor due diligence and exit planning

Assess the vendor’s financial stability, service levels, data-centre arrangements, subcontractors, incident history, update policy and customer support. Review the contract for data ownership, confidentiality, breach notification, uptime, price changes and termination assistance.

Plan the exit before signing. The organisation should be able to export transactions, master data, attachments, audit logs and reports in usable formats. Test an export during implementation so that switching systems or responding to an audit does not depend entirely on the vendor.

Post-implementation review

After the first two or three month-end closes, compare actual processing time, reconciliation exceptions, user workarounds and reporting quality with the approved business case. Correct root causes and update procedures before temporary workarounds become permanent.

Use a controlled implementation checklist

  • Approve requirements and vendor due diligence.
  • Configure accounts, tax codes, periods and dimensions.
  • Establish roles, approval limits and MFA.
  • Clean and reconcile migrated data.
  • Test transactions, interfaces and reports.
  • Train users using documented procedures.
  • Back up the legacy system and define retention.
  • Review the first two closes and fix root causes.

Measure success through faster close, fewer reconciling items, stronger access control and better information—not simply whether the system went live on the planned date.

Related accounting guides

Authoritative references

This educational guide explains general accounting principles. Legal, tax and filing requirements vary by jurisdiction and entity type, so confirm the rules that apply to the reporting period.

Advertisement