The following tables list the type of transactions generated through the QuickBooks Integration from MoversSuite items created within Transactions and created through the Send to QuickBooks function from the Summary tab.
Revenue Transactions
|
QuickBooks Transaction |
MoversSuite Item |
|
Customer Invoice |
For each customer on the order, if the sum of the revenue items is positive, then an invoice is generated for the customer in QuickBooks. The transaction can include positive and negative amounts as long as the total is greater than zero. |
|
Customer Credit Memo |
For each customer on the order, a credit memo is generated in QuickBooks when the sum of all revenue items (including positive and negative items) is less than zero. NOTE: Amounts involved with the credit memo are opposite between MoversSuite and QuickBooks, i.e. a negative MoversSuite results in a positive credit memo amount.
|
|
Transaction ID |
The MoversSuite Document Number associated to Billing Minor items is documented in QuickBooks as the Transaction ID. |
The following table details the mapping between MoversSuite and QuickBooks for revenue transactions (invoices and credit memos).
|
QuickBooks API Object Item |
MoversSuite Data | |
|
CustomField1 |
Order Number | |
|
CustomField2 |
Shipper Name | |
|
CustomField3 |
MS Invoice | |
|
TxnDate |
Transaction Date | |
|
For each revenue line: | ||
|
|
LineNum |
(incremental counter) |
|
|
Description |
Transaction Description |
|
|
Amount |
Final Revenue Amount |
|
|
SalesItemLineDetail Product/Service Class |
For each detail item associated to the revenue line: ItemRef links to a MoversSuite Item Code ClassRef links to a MoversSuite Branch ID |
|
CustomerRef |
Customer | |
Expense Transactions
|
QuickBooks Transaction |
MoversSuite Item |
|
Vendor Bill |
For each vendor on the order, if the sum of the payables (commissions and/or third-party payables) is positive, then a bill to the vendor is generated. |
|
Vendor Credit |
For each vendor on the order, if the sum of the payables (commissions and/or third-party payables) is negative, then a credit to the vendor is generated. |
The following details the mapping between MoversSuite and QuickBooks for expense transactions (bills and credits).
|
QuickBooks API Object Item |
MoversSuite Data | |
|
TxnDate |
Transaction Date | |
|
For each revenue line: | ||
|
|
LineNum |
(incremental counter) |
|
|
Description |
Transaction Description |
|
|
Amount |
Final Payable Amount |
|
|
AccountBasedExpenseLineDetail Account Class |
For each detail item associated to the expense line: AccountRef links to a MoversSuite Item Code ClassRef links to a MoversSuite Branch ID |
|
VendorRef |
Customer | |
|
DocNumber |
Invoice number from the third-party source. This data displays as the “Reference Number” on vendor invoices in QuickBooks. | |