How are opening balances created in QuickBooks after a Sage conversion?
It depends on the conversion: balances either arrive as dated journal entries or as converted detail, and both must tie to the Sage trial balance.
It depends on how the conversion was run. Balances arrive either as one or more dated journal entries posted to each account, or as real converted transactions whose totals form the balances. Either way, every account should reconcile to the Sage trial balance at the cutoff date, and tying them out is the first review task after any conversion.
Journal entries or converted detail
Two approaches exist, and which one applies depends on the file and on what you need afterward. In a summary conversion, a journal entry dated at the cutover carries a line for each account balance. Customers and vendors hold balance-forward amounts rather than their original documents.
In a detail conversion, open invoices, unpaid bills, and other records come across as live transactions. The balances then sit behind real documents, so aging reports work from the first day. Which records can convert in full depends on the source file, and our engineers confirm that during a Sage to QuickBooks conversion review before any work starts.
The account that absorbs the offset
QuickBooks requires every journal entry to balance. When customer or vendor opening balances are set one by one, the offset side lands in an account QuickBooks calls Opening Balance Equity. The same happens when account balances load individually rather than through a single entry. Our engineers clear that account once the tie-out is complete, moving the residual into retained earnings or the correct equity accounts. A large balance left there is a sign the tie-out never finished.
Tie every account to the Sage trial balance
Start by producing the Sage trial balance as of the cutoff date, the last day books were kept in Sage. Then run the same report in QuickBooks on that same date, and compare line by line. Retained earnings deserves special attention: prior-year income should already be folded into it, not sitting in income accounts. After the balance sheet accounts, reconcile the customer and vendor aging summaries to their control accounts, then check inventory value and quantities against the Sage records.
A balance that will not tie out
Differences almost always trace to the cutoff date or to account mapping. A transaction posted in Sage after the trial balance was drawn, or an account mapped to a different type, will cause a mismatch. Find the source before adjusting anything. Editing the opening entry without knowing why it differs hides a real problem and makes the books harder to defend later.
The useful next step is a review of both files before you trust the new books. Send the Sage backup and the converted QuickBooks file to our team for a free evaluation. We will identify where each opening balance came from, flag anything that does not tie to the trial balance, and quote any repair work before it begins.