Mapping Vehicle Type in QuickBooks

Create Asset, Income and COGS in Products and services in QuickBooks.

IMPORTANT:  Identify the Chart of Accounts the item will be mapped to in QuickBooks from EverLogic. Create three Accounts, Asset Account, Income Account and COGS Account.

 

QuickBooks Steps

Set-up Asset Account

1. Access QuickBooks

2. Click the Gear Icon for Settings and select Products and services

3. Click the New Button

4. Select Non-inventory Option


5. Key the name of the Asset in the Name Field

IMPORTANT:  Be mindful of naming conventions. Follow these guidelines to organize the data better and promote a common language with EverLogic Support. 

      • Leading word
        • Inventory = Asset
        • Sales = Income 
        • COGS, Expense, Accrued Liability = Used in the COGS field


6. Select Income Account; choose the account within the Chart of Accounts the Item needs to link to

Note:  A sub-account can also be selected.

7. Check-mark the Purchasing Information Box, to ensure anything related to this Item is directed to the accounts within the Chart of Accounts selected

8. Select correct option from the Expense Account dropdown menu, choose the same option as the Income Account selected

Note:  A sub-account can also be selected.

9. Click the Save and Close Button

 

Set-up COGS (Cost of Goods Sold) Account

1. Access QuickBooks

2. Click the Gear Icon for Settings and select Products and services

3. Click the New Button

4. Click the Non-inventory option

5. Key the name of the COGS in the Name Field

IMPORTANT:  Be mindful of naming conventions. Follow these guidelines to organize the data better and promote a common language with EverLogic Support. 

      • Leading word
        • Inventory = Asset
        • Sales = Income 
        • COGS, Expense, Accrued Liability = Used in the COGS field

6. Select Income Account; choose the account within the Chart of Accounts the Item needs to link to

Note:  A sub-account can also be selected.

7. Check the checkbox for Purchasing Information

8. Select correct option from the Expense Account dropdown menu, choose the same option as the Income Account selected

Note:  A sub-account can also be selected.

9. Click the Save and Close Button

 

Set-up Income Account

1. Access QuickBooks

2. Click the Gear Icon for Settings and select Products and services

3. Click the New Button

4. Select Non-inventory Option


5. Key the name of the Income in the Name Field

IMPORTANT:  Be mindful of naming conventions. Follow these guidelines to organize the data better and promote a common language with EverLogic Support. 

      • Leading word
        • Inventory = Asset
        • Sales = Income 
        • COGS, Expense, Accrued Liability = Used in the COGS field

6. Select Income Account; choose the account within the Chart of Accounts the Item needs to link to

Note:  A sub-account can also be selected.

7. Check the checkbox for Purchasing Information

8. Select correct option from the Expense Account dropdown menu, choose the same option as the Income Account selected

Note:  A sub-account can also be selected.

9. Click the Save and Close Button

 

EverLogic Steps

Confirm Mapping

1. Navigate to the Office Operations Tabs and select Set Map Codes

2. Locate the Item and click the drop-down arrow in the QuickBooks Item Column 
3. Fill-in the blanks, use the drop-down menus to select the QuickBooks Account, you need this Item mapped to

REQUIRED:  Products require all three, Asset, Income and COGS Accounts, to function properly. The pop-up window may be different, based on the type of Item you are mapping.

4. Click OK

5. Type the Reason, at least a 10 characters, then click Record

6. Click Save, the item is now mapped and will communicate with QuickBooks during posting

7. Log out of EverLogic to accept these changes

 

For additional help on mapping to QuickBooks, check out this video below:

 

 

Related Articles: 

New Vehicle Purchase Order Form (Multi-Unit Ordering)

Vehicle Cycle Count

Adding PAC as a Default to Vehicles

Enter Floor Plan Balance on a Unit

How to Change the Floor Plan Starting Balance of Unit Inventory

Import the QuickBooks Chart of Accounts and Item List

Mapping from EverLogic to QuickBooks

List Unposted Stock

List Unposted Deals

List Unposted Bills / Credits

List Unposted Curtailments / Interest

Accounting for Trades on a Deal