Migrating to Dynacom Accounting Lite: Step-by-Step Data Transfer Checklist
1. Pre-migration planning
- Backup current system: Create full backups of your existing accounting data and export copies (in native and common formats like CSV/XML).
- Inventory data to move: List companies, chart of accounts, customers, suppliers, items, opening balances, invoices, payments, bank statements, tax settings, and historical transactions.
- Confirm requirements: Note Dynacom Lite version, supported import formats, and any limits (file size, field lengths).
- Schedule downtime: Pick a migration window (end of month/quarter preferred) and inform stakeholders.
2. Clean and prepare source data
- Reconcile accounts: Ensure bank accounts, receivables, payables, and inventory reconcile to avoid transferring errors.
- Remove duplicates and inactive records: Archive or delete unused customers, suppliers, and items.
- Standardize formats: Normalize date formats (YYYY-MM-DD), currency codes, tax codes, and contact fields.
- Record opening balances date: Decide the cutover date and compute opening balances as of that date.
3. Export data from the old system
- Export master data first: Chart of accounts, customers, suppliers, items/products, tax codes (CSV/XML).
- Export opening balances and beginning ledger: Trial balance or opening entries as of cutover date.
- Export transactional history: Invoices, credit notes, receipts, payments, purchase orders, bills, and bank statements (date range as needed).
- Export attachments and documents: Save PDFs/receipts linked to transactions if required.
4. Map fields to Dynacom Accounting Lite
- Create a field mapping document: Match each source field to the corresponding Dynacom field (account codes, customer IDs, item SKUs, tax types).
- Handle mismatches: Define rules for missing fields (e.g., default tax code, default currency) and concatenate or split fields if needed (e.g., full name → first/last).
- Account code alignment: Ensure account codes in the source map to Dynacom’s chart—create new accounts in Dynacom if necessary.
5. Import master data into Dynacom Lite
- Import chart of accounts first.
- Import customers, suppliers, and items next.
- Verify imports: Check counts, spot-check records for correctness (addresses, tax IDs, open balances).
- Resolve errors: Correct and re-import failed rows.
6. Import opening balances and beginning ledger
- Enter opening balances: Use Dynacom’s import tool or manual journal entries for opening retained earnings, account balances, AR/AP balances.
- Validate trial balance: Ensure debits = credits and totals match source system.
7. Import transactional history (if needed)
- Import in logical order: sales invoices → receipts/payments → purchase bills → payments → journals.
- Batch test first: Import a small date range (e.g., one month) and validate posting, tax treatment, and aging.
- Reconcile imported transactions: Run AR/AP reports, aged receivables/payables, and bank reconciliation to confirm accuracy.
8. Bank feeds and reconciliation
- Connect bank feeds (if supported): Set up bank import or automatic feeds and categorize recent transactions.
- Reconcile opening bank balance: Match imported bank transactions to opening balances.
9. Configure system settings
- Set fiscal year and accounting options: Tax rules, numbering sequences, currency, and rounding.
- User roles and permissions: Create users and assign access levels.
- Templates and layouts: Update invoice/receipt templates and email settings.
10. Testing and validation
- Run key reports: Trial balance, balance sheet, P&L, aged AR/AP, VAT/GST reports and compare with source.
- Sample audit: Trace several customers/suppliers through full lifecycle (invoice → payment → reconciliation).
- Fix discrepancies: Investigate and correct mapping or import errors; re-import if necessary.
11. Go-live and post-migration tasks
- Cutover: Freeze old system after cutover date and switch operations to Dynacom Lite.
- Support window: Monitor transactions closely for 1–4 weeks; keep backup of old system accessible.
- Train users: Provide quick reference guides and run training sessions for daily processes.
- Document migration: Save mapping documents, import logs, and troubleshooting notes for future audits.
12. Rollback plan
- Define rollback criteria: Conditions under which you would revert to the old system.
- Retention of backups: Keep all pre-migration backups until migration is fully validated.
If you want, I can produce: a CSV field-mapping template for imports, a one-page cutover checklist for the migration day, or a short user-training agenda—tell me which.
Leave a Reply