We are aiming to cover all the possible scenarios of your source accounting system when converting it to the new system. However, the systems subtly vary on how they are handle accounting, and it is not always possible to convert everything and for all your accounting period. It is important you take your time to understand the limitations of our service.
Learn more about
Apart from the limitations listed in the article linked above, Sage Peachtree also has the following limitations:
Cash refunds and cheque refunds will be posted as journals
Quickbooks Online does not support refunding a cash payment or cheque from a supplier. So these entries will be posted as regular journals with no link back to the customer or supplier.
Reversed journals will not be posted
All reversed journals will not be posted.
If your file fails the Data Integrity Check in Sage Peachtree
If your file fails the Data Integrity check (Maintenance > Data Integrity Check) you might experience several issues during the conversion. Including but not limited to:
- Balances on zCustomer or zVendor
- Non-matching trial balances for several years
Overall, the end result of the migration should be ok, but there might be slight discrepancies in previous years.
Some debtor or creditor transactions, might not be posted as you expect
Due to various reasons, Dataswitcher might need to use a dummy customer or supplier to align your AR and AP history. AR/AP auto-matching only occurs when the outstanding balance of the customer or supplier is 0.00.
Dataswitcher will try to auto-allocate all customers and suppliers that have a zero amount outstanding on conversion date with a special algorithm. If you have posted directly to your AR or AP system accounts, you need to correct this post migration. Dataswitcher will try to make sure your historical AP and AR reports are similar for key dates (end of years and conversion date). In between these dates the reports might show discrepancies. When checking the AR and AP reports, please make sure that the data from Sage Peachtree is correct. There are situations where open invoices do not show up in the summary, but do show up in the detailed view in Sage Peachtree. Also make sure you are checking on either one of these dates:
- Last transaction date in file
- Migration date (the date when your data moved to QBO)
- On any end of year
Alignment of AR/AP only happens on these moments. If you are using multiple accounts receivables and payables accounts, these will be merged into one. As Quickbooks Online does not support having multiple of these accounts. We will use the accounts in linked accounts (settings in Sage Peachtree) as the main AR/AP accounts.
If you are transferring money between AR/AP accounts in transactions, these will be treated as journals. If you have purged data from your file, payments and invoices will be posted as journals instead. You might have to allocate debits to credits for customers / suppliers that have an outstanding amount on migration date.
If your system accounts or AR and AP do not align with the total outstanding balances on the accounts payable or receivable summary in Sage Peachtree, this will be reported by the Sage Peachtree Data Integrity Check. Dataswitcher will post these discrepancies to the outstanding balances of z.
We will copy dates straight from the file
In Sage Peachtree, we will copy the dates straight from your file. If the journals in your file are dated in the future, the transactions will also be posted in the future to the destination system.
Foreign data will be converted in home-currency
All foreign currency data, is converted in home-currency. The historical exchange rate in Sage Peachtree will be used to do the conversion.
Historical migrations of accounts
Sage Peachtree allows you to transfer balances to new accounts on the close of year (transferring of opening balances). Quickbooks does not support this as it does not support fiscal years so Dataswitcher closes the account off on the start of the financial year. Example: You have an old account 1250 which you have used in 2018, start of year 2019 you renumber this account to 1251.
What will happen in DS is the following:
- Dataswitcher will close the balance (example 1500) of account 1250 to 0.0
- Dataswitcher will open the balance in 2019 of 1251 with 1500.00
AR/AP starting and ending balances in Quickbooks are not supported and there will be discrepancies when comparing the trial balances. The end balances however will be correct. Dataswitcher cannot align end balances with their start balances for these AR and AP balances.
When comparing AR and AP reports in Quickbooks to Sage Peachtree, please make sure you are using the "Current" setting.
Financial start date
In Sage Peachtree, it is possible to choose a start day other than one, i.e. 14-01-2020 instead of 01-01-2020. Quickbooks does not support this. Please keep this in mind when you are checking your trial balance since they may cause profit and loss accounts to be off. In that case, your retained earnings will also be off.
Check your retained earnings
In Sage Peachtree you can setup an opening balance for an account. In some cases, (especially when the file is relatively new - or you have never run a close of year before) Dataswitcher cannot reconstruct the account used for creating that opening balance (often it is retained earnings). That is why Dataswitcher will create the opening balance transaction, and will send the net result to the retained earnings account in the destination system. You need to check your retained earnings post-migration to see if this agrees. In some cases, DS might use the opening balance equity account. You might need to transfer from that account into retained earnings to get the amounts to agree.
Department and Classes
If you pick the classes and locations and paid extra during the migration, the migration will be done as journal only. Next to that the departments and classes might not agree on retained earnings. Since you can purge data from Sage Peachtree for the old journals, the classes and departments for retained earnings might be off. Due to QBO API limitations, only departments are converted, not projects.
Forward journals (Next Year) will not be posted
If you have any next year journals, these will not be posted to Quickbooks Online. You have to add these manually.
Items and stock
Dataswitcher does not post a lot of fields for items and stock. Only code, stock code, location, name and description are posted. Current stock and purchase and sales price are also posted. Income and asset accounts are not posted to Quickbooks. We can however deliver you a set of files (the database tables from Sage Peachtree) which you can import manually into Quickbooks Online.
Positions for COA numbers
Quickbooks does not support chart of account numbers that exceed the length of 7. If you have accounts in your chart of accounts which are 7 or longer, the migration will fail. If you are using a lot of linked accounts, the migration might also fail.
Renaming of Sage Peachtree system accounts
We can support renaming of normal balance sheet accounts, but renaming the system accounts (Retained Earnings, Accounts Receivable, Accounts Payable, etc.) through the history can cause issues - suspense accounts showing up as zCustomers or Zvendors, after the conversion.
Information, if available in Sage Peachtree, that cannot be converted
- Bank Reconciliation (You will need to do a single bank reconciliation after the conversion. You should know how to do this.)
- Paychecks are converted as Journal Entries (Importing Paychecks is not supported by Quickbooks)
- Employee YTD information
- Employee Payroll setup data is not converted (Sick Pay, Vacation, Direct Deposit information, Pay rates, Tax setup including Withholdings, Deductions, etc.)
- Individual employee wage or deduction information
- Custom templates
- Jobs that are not attached to transactions
- Fixed Asset Items (This is only applicable if your Sage Peachtree data file is linked to Sage Peachtree Fixed Assets)
- Work Tickets
- Posting and Non-posting transactions after the current date are not converted
- Closed or partially closed Sales Orders, Purchase Orders, and Estimate
- Sales Tax items are converted to Quickbooks but Customer Sales Tax defaults are not assigned to customers.
You have to map every available field in Sage Peachtree to the corresponding field in Quickbooks. In some cases, fields are not compatible and are not transferred over. You will need to manually enter such fields after the conversion. Examples of such fields are vendor default account numbers, preferred vendors for inventory, multiple shipping addresses for customers, and default Customer Sales Tax settings.