At the same time, when it comes to a business, migrating accounting data is one of the most fragile projects. Decisions, compliance and reporting are all based on financial records — and losing or damaging them during a migration can be an expensive and time-consuming mistake. An organized, prioritized backup checklist will set a tone that you are protecting what is important, streamlining downtime and keeping your stakeholders at ease throughout the entire transition.
PointSheet: So why is backup priority important?
But not all data is created equal. There are records that you’re legally required to maintain, ones that are absolutely essential for the continuity of your business, and others that it’d be nice to hang onto — if only they were not replaceable. Firstly prioritising files to be backed up decreases risk by ensuring the most important information is saved first. It also simplifies verification and recovery in case something wrong happens during migration.
Pre-migration planning: the essentials
- Assign ownership and responsibilities: Identify a migration lead to point the way, and clearly indicate who is in charge of each backup task, verification step and communication with stakeholders.
- Define scope and timeline Determine which accounts, periods, and record types you will move to the new system and create a schedule that allows additional time for proofing.
- Define storage and retention parameters: Decide where backups will be stored (on-premise, off-premise, encrypted in the cloud) and for how long they need to be kept for compliance or internal purposes.
- Document document structure and customizations (or include a chart of accounts with a list of your custom fields, templates or special configurations). This is useful for accurately mapping data during migration.
What to back up first: a hit list of priorities
Master data and setup (Highest priority)
- Chart of accounts: The foundation of financial reporting. Back up account name, number, type and hierarchy.
- Customer and vendor master data: Names, contact info, payment terms, tax IDs and any classification tags.
- Products & Service lists: Item names, SKU numbers, Price, UOM and Inventory settings.
- Tax and payroll settings: Use them to specify the rates, benefits or withholding rule.
- Company configuration: Fiscal Year, Accounting Method and Periods for reporting.
- Why front: These records define how transactional data gets parsed. And without them, the transactions cannot be appropriately reaggregated or understood.
Encryption And Key Management
Encrypted backups are only as secure as the keys protecting them. If key management is disorganized, you can end up with backups you cannot actually open during a recovery. Make sure encryption standards are documented, key rotation is on a schedule, and there is a clear recovery path if the key holder is unavailable.
- Document the encryption algorithms and standards used for all backup files
- Set a regular key rotation schedule and document the recovery procedure for each key
- Store keys in a centralized system with access controls and approval workflows
- Log every key access and recovery attempt so any unusual activity is visible
- Test decryption in a controlled environment before relying on it for actual recovery
Open Trades and Balances (High priority)
- Bank and credit balances: Statements and reconciliations of all accounts as at the migration date.
- AR & AP ledgers: Aging & Detailed report, open invoices and supplier bills.
- Inventory counting and valuation: Including physical quantities of inventory on hand, available for sale and valuation methods.
- Payroll liabilities & employee balances: Unpaid Wages, taxes owed, accrued benefits or vested interest but still unpaid.
- Why next: This is current liabilities and cash. Preservation of them insulates against misinformation and operational disruption.
Historical transaction data (Medium priority)
- General ledger History: Periodic journal entries, adjustments and closing entries to maintain consistency of reporting.
- Sales and purchase histories: Invoices, credit memos, purchase orders and receipts that help explain balances.
- Fixed asset registers: Detailing descriptions of the asset, purchase date, the depreciation policy as well as details regarding disposal.
- Why: Historical data provides continuance for audits, trending and comparative reporting. Determine how many years of history you require in the new system and in archive storage.
Appendices and other file attachments (Medium/Low priority)
- Contracts, invoices, receipts, bank statements and legal documents: Connections to certain transactions may be crucial for audits or disputes.
- Notes and memos: ‘H’ for internal explanations of irregular transactions or manual adjustments.
- Why: While frequently voluminous, supporting files are an essential part of regulatory compliance and reconstruction in certain circumstances. Order by regulatory requirements and audit exposure.
Reports and templates (Low priority)
- Report templates and export settings: Save layout definitions and customize filters or groupings your team use regularly.
- Why: It can be long and cumbersome to replicate complex reports. And waiting in the wings, standing by to maintain productivity post-migration.
- Opt for open formats that the original software can read (CSV,XML) to facilitate re-import and checking.
- Export ledger at full detail or consolidated at summary so you can reconcile in a snap.
- Keep filename and modified date of attached files to export.
- Try to keep all folders and files consistent: YYYYMMDD_account_ledgers. csv) so that files are easy to be located.
Automated Backup Schedules
Manual backups during a migration are easy to forget, especially when the team is focused on data validation and cutover tasks. Automated schedules eliminate that risk by creating consistent snapshots on a fixed cadence. Schedule backups around your accounting close windows so you are not capturing partial-period data, and set up failure alerts so a missed backup does not go unnoticed until it is too late.
- Set snapshot frequency and retention windows based on how much data you can afford to lose in a worst-case scenario
- Schedule backups during non-peak hours to avoid disrupting active accounting work
- Set up automated alerts for backup failures so the team is notified before it becomes a problem
- Store snapshots in immutable or write-once media to prevent accidental overwrite
- Validate snapshot integrity automatically on a regular basis to confirm they are actually restorable
Check/verification: backups need to be working.
- Verify files: Make sure file hashes and sizes of what you have match this. An incorrect export is worse off than no export.
- Import into sandbox: Test the import if you can in a new instance to validate mapping, format and completeness.
- Reconciliation totals: Audit your exported totals against system balance and independently compiled statements (e.g., bank statements) to ensure that the sums are consistent.
- Preservation of audit trail: Make sure that logs or change history are retained, including changes made during the migration window sometime.
Data mapping is where most migration surprises happen. Rules that look simple on paper often involve subtle transformations such as consolidated account codes, currency conversions, and adjusted tax codes that can produce unexpected results downstream. Keep a living transformation table that maps every source field to its destination and documents any formula or adjustment applied. Version-control those mapping rules so you can roll back cleanly if a change causes problems during testing.
- Build a field-by-field mapping matrix covering every source and destination field
- Note any aggregation logic or currency conversion rules applied during transformation
- Keep a version history for mapping changes so you can identify what changed and when
- Include sample before-and-after records in the documentation so reviewers can verify the logic
- Share a read-only mapping document with auditors and external accountants for review
Communication and documentation
- Announce planned backups and migration windows to stakeholders. This consists of finance teams, external accountants, and department heads.
- Keep a log of migrations: Document the name of the person who created each backup, the time and date it was created, where it’s stored and whether it passed verification.
- Document easy recovery steps: Also cover the instructions on what you need to do in order to restore items if you eventually need to roll some of them back.
Legal Hold And Retention Policies
Legal holds and compliance retention requirements do not pause for a migration. If you have ongoing litigation, active audits, or unresolved tax reviews, the related records need to be tagged and protected before the migration begins. Make sure retention metadata moves intact so future deletion processes do not accidentally remove records that are still under a hold.
- Identify all active legal holds and tag the related records before export begins
- Verify that retention metadata is preserved through the export and import process
- Document who has authority to release or extend a hold and what the escalation path looks like
- Audit retention compliance at regular checkpoints during the migration, not just at the end
- Bring in legal counsel early for complex requirements rather than trying to interpret them internally
Common mistakes and how to avoid them
- Limited scope: Not accounting for tax settings or custom fields can lead to incomplete reporting. Create a detailed inventory early.
- Single backup point: The more you bet on one, the greater the risk. Use several different backups to multiple dispersed locations.
- Not tested exports at all: Exports that are untested may become unreadable to migrate. Test a restore of your backups all the time.
- Not accommodating compliance requirements: Some records may have unique formats or longer time retention. Check the legal landscape before cutting the past.
Post Migration Monitoring And Validation
The migration is not done when the import finishes. That is actually when some of the trickier issues surface, like rounding differences, template mismatches, or reconciliation gaps that did not show up in testing. Running parallel reports for a defined stabilization window and assigning clear ownership for each reconciliation metric gives you confidence the data is correct before you decommission anything.
- Define the key financial metrics you will monitor after migration, such as trial balance equality and AR aging variances
- Run parallel reports from both systems for a stabilization window to catch any discrepancies
- Assign a named owner to each reconciliation task so nothing falls through the gaps
- Schedule a formal sign-off meeting and agree on the plan for decommissioning legacy systems
- Keep legacy systems in read-only mode until sign-off is complete to prevent data divergence
Final checklist (quick reference)
- Assign migration conductor and duties
- Export master data and settings
- Export opened balances, and reconciled files (PDF of the bank statements)
- Export historical ledgers, and fixed assets registers as required
- Priority should be there to export supporting documents and attachments.
- Save custom reports/templates
- Backup copies to 2+ locations - 29) Multiple safe depot storage of backups
- Checksum your files and test imports
- Balance export totals to original system
- Document everything and involve stakeholders
Staff Training And Handover
Even a technically successful migration can stall if the team does not know how to operate the new system. Concise task-specific guides, hands-on sessions for key users, and a short troubleshooting FAQ go a long way in the first few weeks. Document escalation contacts clearly and use the post-migration period to capture lessons learned while they are still fresh.
- Write short how-to guides for the routine tasks staff will need to do from day one
- Run hands-on workshops for key users before the cutover, not after
- Give teams quick-reference troubleshooting flowcharts for the most common issues
- Designate specific escalation contacts and the hours they are reachable
- Hold a post-mortem to capture lessons learned and update the runbook for future migrations
Next steps
Having all your backups identified, prioritized and verified, you can now start mapping and importing with confidence. Consider the backup stage as an essential insurance policy: it ensures your company’s financial sustainability and sets out a straightforward recovery path if anything doesn’t go to plan. A systematic, considered process not only saves time and maintains trust, but also involves an approach to migration that accommodates growth rather than disturbing the present.
Third-party migration tools can make bulk exports and data mapping much faster, but the selection process matters. Security practices, support responsiveness, and direct experience with your accounting platform are all worth checking before you sign anything. Get access to a sandbox environment for testing, confirm the export formats work with your destination system, and make sure the contract is clear about liability if something goes wrong.
- Check vendor security practices and ask for relevant compliance certifications
- Ask for case studies or references from companies in a similar industry or with a similar setup
- Test the tool in a non-production environment before committing to it for the live migration
- Confirm support SLA terms and escalation procedures in writing before signing
- Include explicit data liability terms in the contract covering loss or corruption during migration
