Departments - For job costing and departmental reporting - OR

Categories - For additional classification and filtering

QuickBooks account numbers are preserved when available

Missing account numbers are auto-generated in AccountEdge format (X-XXXX)

Account number format follows AccountEdge conventions by account type:

Non-posting accounts are skipped and not imported

QuickBooks uses colons (:) to denote subaccounts (e.g., "Income:Services:Consulting")

The tool automatically creates header accounts for parent levels

Detail accounts are linked to their appropriate headers

Multi-level hierarchies are fully preserved

Non-posting accounts (NONPOSTING type) are automatically skipped and not imported

These are QuickBooks accounts used only for organization and totaling, not for transactions

If you need organizational headers in AccountEdge, create them manually as header accounts

Preserved from QuickBooks OBAMOUNT field

Credit balances (negative amounts) are properly formatted

Balance formatting follows AccountEdge conventions

QuickBooks uses 5 address lines (BADDR1-5, SADDR1-5)

The tool intelligently extracts:

Common QuickBooks terms are mapped to AccountEdge equivalents:

Primary contacts: First name, Last name, Phone, Fax, Email, Mobile

Alternate contacts: Contact name and phone

Credit card information is preserved in notes if present

QuickBooks custom fields (up to 6) are mapped to AccountEdge custom fields

Field labels are preserved from QuickBooks field definitions

Only fields marked for Customers/Vendors/Employees are included

Generated from customer name and job name

Format: “LastName, FirstName:JobName”

Example: “Smith, John:Kitchen Remodel”

Ensures unique, readable job identifiers

QuickBooks status codes are mapped:

Other statuses are left blank

Jobs are automatically linked to the corresponding customer

Customer must exist before job import

QuickBooks item types are converted as follows:

The following QuickBooks item types are not imported:

Skipped items are logged in the import summary

Sale prices preserved from QuickBooks PRICE field

Purchase costs preserved from COST field

Standard cost calculations included

Income accounts: Mapped from QuickBooks ACCNT field

Asset accounts: Mapped from QuickBooks ASSETACCNT field

COGS accounts: Mapped from QuickBooks COGSACCNT field

Expense accounts: Mapped from QuickBooks ACCNT for purchase items

Account names are matched to converted AccountEdge accounts

"Tax" field from QuickBooks determines tax-when-sold setting

Tax codes are matched to converted AccountEdge tax codes

Tax-exempt items are properly flagged

Item custom fields (up to 6) are mapped

Field labels preserved from CUSTITEMDICT definitions

QuickBooks tax code names are converted to AccountEdge format:

COMPTAX items from the INVITEM section are imported as non-consolidated tax codes

STAX items (group tax codes) are imported as consolidated tax codes in AccountEdge

Component taxes within STAX groups are properly linked to create the consolidated tax code

Generates readable abbreviations from full names

Example: "California Sales Tax" → "CASALESTAX" or “CALSALEST”

Uses word-based abbreviation when needed

Adds numeric suffixes for duplicates (CALSALEST1, CALSALEST2)

Preserved from QuickBooks PRICE field (as percentage)

Rates are properly formatted for AccountEdge

Tax collected accounts are mapped from QuickBooks ACCNT field

Account references are updated to match converted AccountEdge accounts

QuickBooks STAX (group tax) items are imported as consolidated tax codes in AccountEdge

Component taxes are properly linked

Total rates are calculated from components

Each component tax code must already exist (imported from COMPTAX items)

These simple list items are imported with minimal transformation: