Switching accounting software is far more complex than simply running a data migration tool and expecting business as usual. It’s a strategic undertaking that requires meticulous planning, process re-evaluation, and a keen eye for potential pitfalls. As you’re discovering with your client’s transition, the journey involves uncovering inefficiencies and opportunities for significant improvement.
Here’s an expansion on the challenges and opportunities you’ve identified, along with suggestions for other elements to consider for a successful upgrade in record-keeping:
Switching cloud software:
The allure of a quick data transfer is tempting, but it masks a deeper reality: moving from one cloud software to another is a comprehensive business transformation project. It’s an opportunity to not only update technology but to also streamline workflows, improve data accuracy, and empower your team with better financial insights.
1. The Interconnected Ecosystem: Industry-Specific Systems
Your client’s industry-specific production system, which generates sales orders, sales invoices, and purchase orders, highlights a critical point: accounting software rarely operates in isolation. The integration points between this production system and the accounting systems are paramount.
Challenges & Opportunities:
- Data integrity & flow: How does data currently flow from the production system into accounts? Is it manual entry, an imperfect integration, or a combination? This is a prime area for re-evaluation. With Xero for example, you have an opportunity to explore more robust, perhaps API-driven, integrations that automate the transfer of sales and purchase data, reducing manual errors and saving time.
- Source of truth: It’s crucial to define which system is the “source of truth” for specific data points. For instance, if the production system creates sales invoices, that should be the master record for sales details, which then feed into accounts for financial reporting.
- User training: Users of the production system will need to understand how their actions impact accounts and vice-versa, especially if there are changes to the integration or data entry points.
2. Accurate stock may be an issue:
The fact that the production system “should have accurate stock but it doesn’t” is a major red flag and a critical area for investigation. Inaccurate stock figures ripple through the entire business, affecting sales, purchasing, and financial reporting.
Challenges & opportunities:
- Process audit: This requires a deep dive into the physical stock processes as well as the software-based ones.
- Goods In/Out: How are goods received and dispatched recorded? Are there delays in recording?
- Returns: How are customer returns or supplier returns handled and updated in the system?
- Damage/Loss: Are there processes for recording damaged, lost, or obsolete stock?
- Stocktakes: How frequently are physical stocktakes performed, and how are discrepancies reconciled?
- System configuration: Is the production system correctly configured to track stock movements? Are there specific settings or modules that are not being fully utilised?
- Human error: Are there points in the process where manual errors are introduced, such as incorrect data entry or miscounts?
- Reporting discrepancies: Is the discrepancy consistent, or does it fluctuate? This might point to specific types of transactions causing the issue.
- The new accounting system’s role: While the production system is the primary stock management tool, your new accounting system will reflect the financial value of inventory. Ensuring that the stock valuation accurately reflects the true physical stock is vital for accurate financial statements. This might involve setting up appropriate stock accounts and ensuring correct cost of goods sold calculations.
3. Uncovering workflow realities:
The manual is not always followed and seldom reflects day to day processes. This is a common scenario and a huge opportunity for efficiency gains with a new accounting system.
Challenges & Opportunities:
- Comprehensive bank feeds: Connecting all bank accounts directly to accounts software will revolutionise reconciliation. Daily feeds mean no more waiting for statements, no more manual data entry of transactions, and a much clearer, real-time view of cash flow.
- Automated expense reconciliation: Connecting credit cards directly to software is a game-changer for employee expenses.
- Real-time visibility: Transactions appear almost instantly, allowing for daily reconciliation.
- Reduced admin: No more waiting for paper statements, manual coding, or chasing employees for receipts. Using “receipt capture” can further streamline this.
- Improved compliance: Easier to ensure expenses are coded correctly and supported by documentation.
- Process mapping: The “who and how employees work with the existing software” is invaluable. This process mapping should extend beyond just the accounting team. How do sales staff create orders? How do production staff manage stock? How do purchase orders get approved? Understanding these interdependencies is crucial for a smooth transition.
Other elements to consider
Beyond the immediate issues, a software switch is the perfect catalyst to elevate the client’s entire record-keeping framework.
- Chart of Accounts Review and Optimisation:
- Purpose: The existing chart of accounts might be overly complex, too simplistic, or not aligned with current reporting needs. your new software offers flexibility.
- Action: Review every account. Can similar accounts be merged? Are there new accounts needed for better granularity (e.g., specific revenue streams, different expense categories)? A well-structured chart of accounts is the foundation for meaningful financial reports.
- Historical data migration strategy:
- Depth: How much historical data needs to be migrated? Just opening balances, or a full two years’ worth of transactions for comparative reporting?
- Accuracy: Ensure the migrated historical data is clean and accurate. This often involves a “cut-off” date where new transactions are entered and older data is imported.
- Format: Consider the format of the historical data and how it will map to the new nominal structure.
- Third-Party App ecosystem evaluation:
- Current Integrations: Beyond the production system, does the client use any other software that integrates with the accounts (e.g., CRM, payroll, e-commerce platforms)?
- App Marketplace: Explore the new App Marketplace for existing integrations with their current apps, or identify new apps that could further streamline operations (e.g., dedicated expense management tools, project management software, advanced reporting tools).
- API opportunities: For unique needs, investigate Xero’s API capabilities for custom integrations.
- Reporting Requirements & Customisation:
- Key Performance Indicators (KPIs): What are the client’s crucial KPIs? Ensure new software can easily generate reports that track these.
- Custom reports: Does the client require specific reports that are not standard? Does the new software offer customisation options. This is a chance to move beyond basic financial statements to more insightful management reports.
- Budgeting & forecasting: Can the new software or integrated apps assist with more robust budgeting and forecasting processes?
- User roles & permissions:
- Granularity: Define clear user roles and permissions. Who needs access to what? Who can approve payments?
- Security: This enhances internal controls and data security.
- Internal controls & workflow approvals:
- Purchase Order approvals: Can the new software or integrated apps automate purchase order approvals based on value or department?
- Invoice approvals: Streamline the process for approving supplier invoices before payment.
- Expense approvals: Formalise the employee expense approval process.
- Segregation of duties: Ensure that different individuals are responsible for different parts of a financial transaction to prevent fraud and errors.
- Training & change management:
- Phased training: Don’t just throw new software at the staff. Implement a phased training approach tailored to different user groups.
- Champions: Identify internal “champions” who can become super-users and assist colleagues.
- Documentation: Create internal guides and FAQs specific to the client’s new setup and workflows.
- Communication: Clearly communicate the “why” behind the switch and the benefits to the employees. Address concerns and provide ongoing support.
- Data cleansing & standardisation:
- Before migration: Clean up existing data in the old software before migration. Remove duplicate contacts, correct errors, and standardise naming conventions (e.g., consistent supplier names).
- During setup: Establish clear rules for data entry moving forward to maintain data integrity.
Conclusion
A client’s transition from one software to another is not merely a software upgrade; it’s a profound opportunity to enhance operational efficiency, improve data accuracy, and gain richer financial insights. By meticulously addressing the interconnectedness of their systems, unearthing the root causes of data inaccuracies, and proactively optimising their workflows, we are setting them up for a future where their record-keeping is not just functional, but a true asset to their business. This holistic approach, moving beyond the simplistic idea of a data migration tool, is what transforms a challenging switch into a significant strategic advantage.