Converting Sales Transactions from QuickBooks
Sage 50 will convert several types of sales transactions from QuickBooks. These are listed below.
Estimates
QuickBooks Estimates will be converted to Proposals (Sage 50 Premium Accounting and higher). Sage 50 will convert most of the information from QuickBooks Estimates into either Sage 50 Quotes or Proposals.
If you are using Sage 50 Pro Accounting or Sage 50 Premium Accounting, your Estimates will be converted into Quotes.
If you are using Sage 50 Premium Accounting or Sage 50 Quantum Accounting, your Estimates will be converted into Proposals. There will be truncation of certain fields, such as some address lines, P.O Numbers, and Description fields. See the Field Comparison list for more information.If the QuickBooks Estimate/Proposal associated with a job, Sage 50 will separate the job portion from the customer before importing the Customer ID.
Field Comparison List: Estimate to Quote
Field Comparison List: Estimate to Proposal
Note: During the conversion, any non-posting general ledger accounts will be replaced with the Accounts Receivable account. How does Sage 50 handle non-posting accounts?
Sales Orders
Sage 50 will convert most of the information from QuickBooks Sales Orders into Sage 50 Sales Orders. There will be truncation of certain fields, such as some address lines and Description fields. See the Field Comparison list for more information.
Sales Invoices
Sage 50 will convert most of the information from QuickBooks Sales Invoices into Sage 50 Sales Invoices. There will be truncation of certain fields, such as some address lines and Description fields. See the Field Comparison list for more information.
Receipts
Sage 50 will convert most of the information from QuickBooks receipts into Sage 50 Receipts. Depending on whether or not the receipt was applied to a sales invoice, Sage 50 will convert information differently. See the Field Comparison lists for more information.
Note: QuickBooks allows you to use Undeposited Funds as a default account for Receipts. Then, when a deposit is made in QuickBooks, amounts go from Undeposited Funds to the correct cash account. The Sage 50 conversion brings over the Receipt into Sage 50 with a Cash account of Undeposited Funds. To get the general ledger in balance during the conversion, a general journal entry is made to move the amount from Undeposited Funds to the appropriate cash account.
Deposits
Sage 50 will convert most of the information from QuickBooks deposits into Sage 50 deposits. See the Field Comparison lists for more information.
Sage 50 does not offer a cash back option. Any cash back for a deposit in QuickBooks will be converted as a General Journal entry in Sage 50 with a credit to the undeposited funds account and a debit to the cash acccount. The Journal Entry in Sage 50 will be given a reference number of CB<date>.
Credit Memos
Sage 50 will convert most of the information from QuickBooks customer credit memos into Sage 50 credit memos. There will be truncation of certain fields, such as some address lines and Description fields. See the Field Comparison lists for more information.