Selecting these dates excludes some transactions from the conversion
This Sage 50 conversion warning means your chosen date range leaves out transactions that QuickBooks needs to calculate correct account balances.
This message is Sage 50’s way of telling you that the date range you picked for the conversion does not cover every transaction that feeds into an account balance. When QuickBooks rebuilds those balances from the transactions that are inside the range, the numbers will not tie back to what Sage 50 shows. It is not a crash or a data-corruption alert — it is a math warning. The conversion tool can see that something will be off, and it is pausing to let you decide what to do about it.
What “incorrect balances” really means here
Account balances in Sage 50 are the running total of every transaction posted to that account from day one. When you convert to QuickBooks and choose a start date that cuts off earlier history, QuickBooks has two choices: carry forward a single opening-balance figure for each account, or try to recalculate from whatever transactions fall inside the range. If some transactions fall outside the range but later transactions in the range reference them — an invoice applied to an older payment, a deposit linked to an older receivable, inventory built from older purchases — the recalculated balance will be wrong because the supporting detail is missing.
Choose the safest option: convert the full history
The cleanest fix is to widen the date range to include every transaction in the Sage 50 company file. This avoids the warning entirely because nothing is excluded. If the file is large and you are concerned about size, our engineers can condense the converted QuickBooks file afterward rather than stripping data during the conversion itself. Condensing after conversion preserves the audit trail and gives you a clean set of books that still ties out.
If you must limit the date range
Sometimes a full-history conversion is not practical — the Sage 50 file may go back many years, contain a discontinued product line, or be too large for QuickBooks to handle. In that case the conversion needs properly calculated opening balances as of your chosen start date. That means every customer, vendor, account, and inventory item must begin with an accurate balance figure representing everything that came before the cutoff. This is where most do-it-yourself conversions go wrong: the opening balances are estimated or skipped, and the resulting QuickBooks file never reconciles to the bank or to the prior-year totals.
Why this is hard to get right without help
The transactions most likely to cause balance problems are the ones that cross the cutoff date invisibly — partially paid invoices, outstanding purchase orders, inventory assemblies that draw on older layers, and multi-currency revaluations. Sage 50 tracks these linkages internally, and translating them correctly into QuickBooks opening balances requires understanding how both products handle applied credits, job costs, and inventory valuation. If the warning appears and you are not confident about every opening figure, the file needs professional attention rather than a guess.
Next step
If you need a date-limited conversion done correctly — with opening balances that reconcile — send us the Sage 50 file for a free evaluation and quote. Our engineers will identify which transactions fall outside your range, calculate the correct opening balances, and deliver a QuickBooks file that ties back to your Sage 50 records.