Converting Sales Transactions from QuickBooks

Related topics

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.

Field Comparison List

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.

Field Comparison List

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.

Field Comparison List: Apply to Revenues

Field Comparison List: Apply to Invoices

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>.

Field Comparison List

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.

Field Comparison List