The data migration steps are as follows:
Import Jobs and debtors (all jobs)
- Before importing jobs make sure the default chart of account "Default (personal)" contains the correct accounts and account match codes for any future transaction based importing. Review the COA account codes.
- Ensure the Default (Personal) COA has "Applies to All Personal" selected.
- Check to ensure the number of number of jobs confirmed within the import process matches the number of jobs in the spreadsheet.
Import Contributions Schedules (all jobs)
- Check the correct Contribution Reference is entered against each schedule. This Contribution Reference is used to allocate Debtor Contribution Receipts against the schedule.
Import Debtor Contribution Receipts (all jobs)
- Where a debtor has multiple Contribution Schedules ensure the Contribution Reference against each Debtor Contribution Receipt is aligned.
- During the import make sure you select the appropriate option for assigning dishonor fees. If you allocate fees to each Job they will be deducted from Cash at Bank.
- Check on Job to confirm Debtor Contribution Receipt have imported against the Contributions Schedules.
- Check on Grouped Payments & Deposits to confirm it is in balance.
- Check the trust account to confirm the balance matches the imported contribution file total.
Import Creditors (bulk all jobs)
- You can import creditors and debts with each line identifying a Job, a Creditor and the Debt.
- You have the option to include a paid-to-date amount for dividends as a single entry or instead use the Transactions Import to capture all transactions.
- Check to see if Creditors (Counterparties) have imported correctly.
- Select a common or selected Counterparty and check under Counterparty Jobs to confirm the debts imported corrected. Repeat as needed.
Import other transactions (bulk all jobs)
- Dividend transactions for creditors are matched on "Trans ID" or "ABN" or "Creditor Reference". If you have already imported a paid-to-date amount for Dividends in the Creditor import then this would create a duplication of records.
- Check to ensure the value of the transactions confirmed within the import process matches the transactions in the spreadsheet.
- Check Jobs after import to confirm the transactions have been allocated to the correct accounts.
Accounts Payable (Bulk all Jobs)
- Create future accounts payable (Fees, Provisions, Expenses).
- Check to ensure the value of the transactions confirmed within the import process matches the transactions in the spreadsheet.
- Check Jobs after import to confirm the transactions have been allocated to the correct accounts.
Migration Steps
- Create journal entry to set up trust account opening balance for for the practice.
Run Annual Adminstration Return (AAR) for balancing
- Confirm AAR reports correctly.
Comments
0 comments
Please sign in to leave a comment.