This article outlines the specific pre-conversion steps for Sage Peachtree.
We expect that you have already covered the general pre-conversion steps and you can simply go ahead with the remaining ones on this list.
Click here for the general pre-conversion checklist.
Step 1: Do your taxes (VAT/GST) report for the remaining quarter (MANDATORY)
Note: If you use Cash based accounting, we advise you to migrate directly after close (and reconciliation) of a taxes (VAT/GST) period. Otherwise the post-conversion work in the QuickBooks Online can be a lot of work (considering partial paid invoices).
We need to do your first tax report based on the old data in Sage Peachtree. Suppose we are converting on April 14 and we need to post our tax report every quarter to the tax agency. This means we are converting in the middle of a tax period. You need to do a tax report for the period April 1 until April 14 in Sage Peachtree.
After the conversion we will use this information to make a full report. We do this by adding the amounts in the boxes together (in the old and new software). You can read more about our VAT process here.
Step 2: Extract post-conversion check data (MANDATORY)
After the conversion is done you need to be able to check the results. This is why we need to extract the following reports from your system:
- Profit and loss until conversion date
- Trial balance until conversion date
- Balances on your bank accounts
- Print a list of outstanding invoices of your customers and suppliers per conversion date
When extracting the trial balance make sure you disable "Show foreign currencies" in the report, because Dataswitcher will transfer everything in home-currency.
Step 3: Extract data for auditing purposes (MANDATORY)
Since not all data is always converted to the new system during switching, it is essential that you extract data from Sage Peachtree for the tax or any other auditing purposes, and keep it in a safe location.
- Sales Tax report
- Purchase Tax report
- Account Transactions
Step 4: Check your file (MANDATORY)
You need to check your file via Help > Support Utilities > Integrity Check. If there are any inconsistencies, these needs to be resolved before posting the file to Dataswitcher.
Step 5: Requirements for Receivable and Payable accounts (MANDATORY)
Multiple Accounts Receivable (AR) and Accounts Payable (AP) accounts
In Sage Peachtree, multiple AR and AP accounts are possible. If no linked AR and AP account is set in the file, this will cause an error. Also, QuickBooks Online is using a single AR and AP account. These accounts will be merged during the conversion process.
Out of balance AR and AP accounts
Running an "Integrity Check" on the file is highly recommended (Step 4). It is also recommended to include the Invoice/Payment Sync.
Tests for Accounts Receivable and Accounts Payable.
Please take particular note for any AR/AP accounts versus unpaid receivables/payables, as such items will generate an exception during conversion.
Also ensure that the Aged Receivables and Aged Payables Reports match with the balances in the General Ledger as of the conversion date.
AR and AP accounts in Manual Journals
If there are manual journals using the AR and AP accounts, these transactions will be displayed to suspense Customer/ Vendor accounts.
While our service does not include fixing these transactions (except for the obvious and simple ones), these differences will be displayed once the conversion is completed.