Receipt (Apply to Invoice) Fields (QuickBooks Conversion)

The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.

QuickBooks Field	Sage 50 Field	Comments
	Deposit Ticket ID	Converted via deposit ticket transactions.
Received From	Customer ID	Sage 50 will convert the first 20 characters of the Received From field. If it is associated with a job, Sage 50 will separate the job portion before importing the customer ID.
Class		Not converted
Template		Not converted
Amount	Receipt Amount
	Name	Not converted
Date	Date
Reference #	Reference
	Receipt Number
Deposit To
Customer Balance		Calculated field – not converted
Pmt Method	Payment Method
Memo	Notes	Memo is converted to an Internal Note in Sage 50. Only the first 2000 characters will be converted.
	*Cash Account
	Cash Account Balance	Calculated field – not converted
Date (invoice)		Not converted
Job		Not converted
Number	Invoice
	Date Due	This column is not displayed on the QB Customer Payment window. If the information is stored with the invoice we can populate this field in PT during the conversion.
Orig. Amt.		Not converted
Disc Date		Not converted
Amt. Due	Amount Due
	Description	Not converted
Discount	Discount
Payment	Amount Paid
Checkmark to mark as paid	Pay checkbox	Both grids include a column that allows the user to select an invoice to pay. This selection of an invoice will be converted directly.
Discount Account	Discount Account (not a grid column in PT)	In QuickBooks, discounts can be allocated by line item. This allows QuickBooks users to allocate discounts for different line items to different discount accounts. In Sage 50, only one discount account can be used even when multiple invoices are being paid on the same receipt. When the conversion discovers multiple discount accounts within the same receipt, a separate receipt will be created for each invoice being paid and the correct discount account will be converted in Sage 50. The invoices created will be assigned a reference number that includes the original reference number + -nn.

Credit Memo applied to invoice		In both Sage 50 and QuickBooks, a credit memo can be applied to an invoice. In both instances, the user can determine the amount of the credit to be with the receipt. When converted to Sage 50, the credit memo will show as a line item on the Apply to invoices tab. The amount in the Amount Paid column with show as a negative for the credit memo.
Select Credit	Pay (checkbox)	Both grids include a column that allows the user to select an invoice to pay. This selection of an invoice will be converted directly.
Date		Not converted
	Date Due	This column is not displayed on the QB Customer Payment window. If the information is stored with the invoice in QB we can populate this field in PT during the conversion.
Credit No	Invoice
Credit Amt.	Amount Due
	Description	Not converted
	Discount	Not converted
Amount to Use	Amount Paid
Credit Balance		Calculated field. Not converted.
Amount Due		Calculated field – not converted
Applied		Calculated field – not converted
Discounts and Credits Applied		Calculated field – not converted
Available Credits		Calculated field – not converted
Credit Card Information
Received From	Cardholder’s Name	Converted from Received from field if Card No. field is populated
	Billing Address
	City
	State
	Zip
	Comment	Not converted
	Date	Converted from date field
	Amount	Converted from amount field
Card No.	Credit Card Number	Not converted.
Exp. Date	Expiration Date	Not converted
	Verification Number	Not converted
	Authorization Code	Not converted

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