Receipt (Apply to Revenue) Fields (QuickBooks Conversion)
The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.
|
QB Field |
Sage 50 Field |
Comments |
|---|---|---|
|
Deposit Ticket ID |
For duplicate IDs, Sage 50 will remove the slash marks found in the date and append numbers to the end. |
|
|
Customer;Job |
Customer ID |
This field will be shortened to 20 characters when the Customer field in QuickBooks is converted. The Job portion of the field will be used to create a Job ID. |
|
Class |
Not converted |
|
|
Template |
Not converted |
|
|
Sold To |
Name: |
Line 1 will be converted into the Customer name. For Address Lines 1 and 2, Sage 50 will convert the first 30 characters. Only the first 20 characters of the City field will be converted, while the first 12 characters of the Zip Code will be converted. Finally, Sage 50 will convert the first 15 characters of the Country field. |
|
Ship To |
Not converted |
|
|
Date |
Date |
|
|
Check Number |
Reference |
|
|
Sale No. |
Receipt No. |
Duplicate Sale Numbers in QuickBooks will have a two-digit number appended to them in Sage 50. |
|
Payment Method |
Payment Method |
|
|
Due Date |
Not converted |
|
|
Rep |
Not converted |
|
|
Account Number |
Not converted |
|
|
Ship Date |
Not converted |
|
|
Ship Via |
Not converted |
|
|
FOB |
Not converted |
|
|
Project/Job |
Job |
Job converted to line items |
|
Other |
Not converted |
|
|
Custom Fields |
Not converted |
|
|
*Cash Account |
||
|
Cash Account Balance |
Not converted. This is a calculated field |
|
|
Service Date |
Not converted |
|
|
Item Code |
Item |
|
|
Description |
Description |
Sage 50 will convert only the first 160 characters. |
|
Quantity |
Quantit |
|
|
Other 1 |
Not converted |
|
|
Other 2 |
Not converted |
|
|
U/M |
Not converted |
|
|
G/L Account |
||
|
Rate |
Unit Price |
|
|
Amount |
Amount |
|
|
Job |
Converted directly when a job is associated with a Receipt via the customer; job field in QuickBooks. The job, when available, will be converted to every line item on the Receipt. |
|
|
Tax |
Tax |
Tax converts as either 1-regular or 2-exempt in Sage 50. All taxable tax types in QuickBooks will convert to 1-regular and all exempt tax types will convert to 2-exempt. |
|
Color |
Not converted |
|
|
Material |
Not converted |
|
|
Customer Message |
Note |
Converts to a Customer Note. It is set to print “After Line Items.” |
|
Sales Rep |
Not converted |
|
|
Tax (Code) |
Sales Tax ID |
|
|
Tax (amount) |
Sales Tax (amount) |
|
|
Total |
Receipt Amount |
|
|
Prepayment |
Not converted |
|
|
To be emailed |
Not converted |
|
|
To be printed |
Not converted |
|
|
Customer Tax Code |
Not converted |
|
|
Memo |
Note |
Memo is converted to an Internal Note in Sage 50. Only the first 2000 characters will be converted. |
|
Process Credit Card Payment when saving |
Not converted |
|
|
Deposit To |
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.