UltraBooks

UltraBooks - Sending orders to QuickBooks™

UltraBooks is a program that interfaces UltraCart with QuickBooks Desktop version.  Please see QuickBooks Online for our integration with QBO.

Introduction

Many online merchants use Intuits industry leading QuickBooks™ accounting software to maintain their company books. UltraCart has enhanced support for Merchants using QuickBooks™ with the addition of our QuickBooks™ integration tool called UltraBooks.

UltraBooks allows UltraCart merchants to import data directly to QuickBooks™ software. There's no need to deal with file formats and data conversion as UltraBooks does it all for you. Once configuration steps are complete, merchants simply run UltraBooks and it handles all the communication and importing between UltraCart and QuickBooks™.

Getting Help

As of version 5.7, you may (and should) create a support request within Ultrabooks.  Doing so will upload your settings and the temporary database used by Ultrabooks.  If you don't use the built-in feature, Ultracart staff will just ask for these files manually before anything else.   So upgrade and use the built-in feature.  It greatly accelerates conflict resolution.

To create a support case, you must be first authenticated with the system.  Once you've performed the authentication (See the 'Accounts' screen), click on the Help button at the top right of the application.   Follow the instructions within.

 

Change Log

Background

UltraBooks is an installed Microsoft Windows application that connects up to the central UltraCart system and downloads orders into Intuit's United States editions of QuickBooks™ version 2004-Current (Pro, Premium or better versions).

****The software is not compatible with Mac, Online, Canadian, International, or Simple Start versions of QuickBooks™.

When the UltraBooks program is launched it will prompt you for the same login information that you use to access your UltraCart account. UltraBooks then securely downloads all the new (completed) orders.

What Type of Data will UltraCart Import?

UltraBooks will create customer profiles for your customers automatically if they do not already exist. After creating the customer profile, UltraBooks will create a sales receipt or, in the case of purchase orders, an invoice for each completed order (i.e. marked as shipped). Those using QuickBooks™ Merchant Services (QBMS) will also have credit card transaction information imported.

Getting Started

To begin the UltraBooks Configuration navigate to:

Main Menu → Configuration → UltraBooks

Required Software:

• Microsoft VC++ Redistributable

• Microsoft .NET Framework (v4.6.1)

• QuickBooks™ SDK QBFC 13.0

• UltraBooks v6.4

In order to use UltraBooks you must first download and install all the required components onto the same PC that QuickBooks™ is installed (for server installations see the note at end of the installation section).  It's recommend that you read through all the UltraBooks documentation before you install the software discussed below.

• The installer will install the application and create a desktop icon named 'UltraBooks v5' to launch the application.

• If you wish to pin the application to your Start Menu or Task Bar, click the desktop icon, and then right click on the running application to pin UltraBooks wherever you desire.

• For technical reference, the application installs to C:\Program Files (x86)\UltraCart\UltraBooksNG_5.10\

Prior Versions of UltraBooks

Uninstall previous versions

This version of UltraBooks may be installed along side the legacy version (v4.0), but only one version 5 may be installed at a time. Once you are comfortable with the new version, you may uninstall 4.0 at your discretion.  They cannot both run at the same time, but they can be installed side-by-side and run separately.

• Latest version (link is directly above, scroll up 5 inches).

• UltraBooks 6.0

• UltraBooks 5.10

• We've removed prior versions due to a bug with tax importation.

Supported Versions of QuickBooks: QuickBooks 2012 through 2020 (Pro, Premium, Accountant or Enterprise)

Quickbooks Compatability

UltraBooks is an installed Microsoft Windows application that connects up to the central UltraCart system and downloads orders into Intuit's United States editions of QuickBooks™ version 2012-Current (Pro, Premium or better versions).

This software is not compatible with Mac, Online, Canadian, International, or Simple Start versions of QuickBooks™.

QuickBooks Point Of Sale (POS) version is also not supported.

QuickBooks Online is supported as a seamless integration with UltraCart. See QuickBooks Online for more information.

Software download links within secure.ultracart.com

You may also install UltraBooks via links in the ultracart.com site.  In UltraCart, navigate to:

Main Menu → Configuration → (middle menu) Back Office → UltraBooks

After clicking on the UltraBooks link you'll be taken to the UltraBooks configuration screen (shown below). 

There you'll find instructions for installing the required software. We've even provided hyperlinks that will take you to the install process for each application.

 

After installing the required software, enter the configuration mode by clicking the Configuration Mode button on the UltraBooks screen.

Note Regarding Server Installations

Question: We run our QuickBooks from our server, do we have to install UltraBooks on the server or can each user needing to use it install UltraBooks on their workstation?

Answer: It is okay to install UltraBooks onto workstations, provided that each employee will be downloading the orders into the same QBW file.

 

Configuration Mode

 

QuickBooks Codes

Clicking the Configuration Mode button at the bottom of the Configuration Screen will enable your merchant account for QuickBooks™ configuration and present the "UltraBooks™ Configuration Mode" screen. There, you will be shown a list of your specific areas that will need accounting codes.

Assigning accounting codes allows UltraBooks to match up and properly categorize data in UltraCart to data in QuickBooks™ each and every time you download data.

Click on the QuickBooks Code Configuration Checklist link to be taken to the Unconfigured QuickBooks Codes Screen.  Each time you return to the main UltraBooks configuration page, you will be presented with the list of pending items until all have been configured.

Unconfigured QuickBooks Codes

This is a helpful screen for the entering of the QuickBooks Codes.  It will list all the UltraCart items that have yet to be assigned appropriate QuickBooks Codes.  In addition, each item is a link that when clicked, will take you to the appropriate screen for configuration.  The next time you return to the Unconfigured QuickBooks Codes screen, that particular item will no longer be listed. It's imperative that you complete all the items and that the codes match perfectly with those in QuickBooks.

Coupon QuickBooks Codes

Each of your "active" coupons (Main Menu → Configuration → Checkout → Coupons) must also have a QuickBooks™ code associated with it. Edit each of your coupons and enter the corresponding QuickBooks™ code in the field.

 Typically merchants have a single Item called "Discount" in their QuickBooks™ file that they associate with all of their UltraCart coupons. Click on Lists -> Item List in QuickBooks™ to review your discount items.

Creating a QuickBooks™ Discount Item

Note: Once you create a discount item, you cannot change it to another type.

1. Go to the Lists menu and click Item List.

2. Click Item at the bottom of the list and then click New.

1. In the New Item window, click the Type drop-down list and choose Discount.

2. Enter an item name, such as Discount.

3. Enter the description that you want QuickBooks™ to put on your sales forms when you apply the discount.

4. Enter the discount amount or percentage:

If the discount is a percentage, enter the number of the discount followed by the % symbol. For example, 5% tells QuickBooks™ to multiply the previous line by .05. In the case of downloaded UltraCart sales, you will want to leave the Amount field blank.

1. Enter the account that you use to track discounts you give to customers. You can use either an expense account or an income account. When an income account tracks discounts on sales, the account is often called a "contra-income" account.

2. Click the Tax Code drop-down list and choose a tax code for this item.

If you select a taxable code, the discount you specify on taxable sales is applied before the sales tax is calculated. If you select a non-taxable code, the discount is applied after the tax is calculated.

1. Click OK or click "Next" to create another item.

Payment Method QuickBooks Codes

In UltraCart navigate to:

Configuration → Checkout (section) → Payments

For each of the payment methods you have enabled in UltraCart you will need to specify what the corresponding code is in QuickBooks™.

Run QuickBooks™ and from the drop down menus click on Customers -> Enter Sales Receipts.  You can also access this from the Home window. Click on the "Create Sales Receipts" button.

Then, click the drop-down under Payment Method

Lastly, click on the Payment Method desired or, click "Add Item" if it doesn't exist.

Deposit to Account

Also located on the UltraCart Configuration -> Payments screen is a field called QuickBooks™ deposit to account. This is the account you want the funds to be deposited into in QuickBooks™ when the sales receipts are added. By default, if this field is left blank the funds go into the "un-deposited Funds Account". The following are sections of the payments screen depicting the location of those codes.

COD

Credit Cards

Paper Checks / Money Orders / Electronic Checks 

PayPal

 

To specify a different account click on the Chart of Accounts in QuickBooks™ and enter the name of the account you want to deposit funds into. Please note this is the NAME of the account and not the number!

Surcharge QuickBooks™ Code

The Surcharge QuickBooks™ code depicted above for Credit Cards and COD are to allow merchants to charge for those special services payment options. These codes come from the Item List in QuickBooks™. You'll probably need to create new Items in the QuickBooks™ Item List for these surcharges. The Item List can be found under the "Lists" menu or by clicking on the "Items & Services" icon on the Home screen. You'll see a row of menus at the bottom of the Item List window. Click on the Item drop down and select "new" to create a new item. Remember to enter the "name" you assign the item into the Surcharge QuickBooks™ Code field.

 

Each of your unique tax jurisdictions inside of UltraCart must have a corresponding entry in the QuickBooks™ system. To make this part of the configuration easier, UltraBooks can automatically add the missing tax jurisdiction to your QuickBooks™ file during the import process if it exists in UltraCart. So it is very important to configure the QuickBooks™ Codes inside of UltraCart for each tax jurisdiction.

Shipping Method QuickBooks Codes

Each of your shipping methods needs to have a QuickBooks™ code associated with it. Click on Configuration -> Checkout  -> Shipping -> Methods. Then for each of the methods click on Edit -> Other (tab). In the QuickBooks™ code field enter the corresponding item name in QuickBooks™.

Most merchants typically set up a single Item in QuickBooks™ that represents their shipping costs such as "Shipping and Handling". Click on Lists -> Items List inside of QuickBooks™ to view your item list. Add an item for Shipping and Handling if it does not already exist. 

 

Tax Rate QuickBooks Codes

Click on Configuration → Sales Tax. Start drilling down into your States, then Counties, then Cities going as deep as you have configured tax . At each level configure the QuickBooks™ tax code. During the import process, UltraBooks will present you with an import dialog if a sales tax item isn't configured in QuickBooks™ and needs to be.

UltraBooks v5.0+ will automatically sync UltraCart tax fields with QuickBooks if you allow it to do so. If you wish to manage this process completely on your own, check the "Use legacy tax code method" on the UltraBooks Order Settings screen.

Open

 

The typical naming convention for the code is "<state abbreviation> Sales Tax" at the state level, then "<state abbreviation> <county> Sales Tax" at the county level, and finally "<state abbreviation> <county> <city> Sales Tax" at the city level. An Example for a state sales tax code would be: "CASalesTax". For more information on configuring your sales tax within UltraCart, see page .

Setting up Sales Tax in QuickBooks

This section only discusses where to set up your Tax Items and Codes in QuickBooks™. You may want to learn more about sales tax concepts. QuickBooks™ will help you understand how QuickBooks™ uses sales tax items, rates, and codes to track the sales tax you collect from your customers and pay to your tax agency. The QuickBooks™ help section has a tutorial about tracking and paying sales tax that should be very helpful to the novice.

Turn on Sales Tax in QuickBooks

. First you need to make sure you have turned on Sales Tax if you haven't done so already.

• Go to the Edit menu and click Preferences

• In the Preferences window, click Sales Tax in the list on the left.

• Click the Company Preferences tab.

• For the question "Do You Charge Sales Tax?" select "Yes".

There are several other settings that you will need to make decisions on.

QuickBooks will insist that you set up a most common sales tax item.   This will usually be your state sales tax.   However, it may be multiple jurisdictions such as state, county, and city tax.   These will need to be created before QuickBooks will accept Sales Tax.

 

 

You may need to get expert advice for your company tax settings.

Sales Tax Codes

Depending on your state and local sales tax requirements, the preset taxable (TAX) and non-taxable (NON) sales tax codes you see may be the only ones you'll need. If your tax agency requires you to specify additional sales tax codes to track taxable and non-taxable sales, such as for non-taxable out of state sales, refer to QuickBooks™ Help for more information on how to set up additional sales tax codes and for some examples of commonly-used non-taxable sales tax codes.

To add a sales tax code

1. Go to the Lists menu and click Sales Tax Code List.

2. Click Sales Tax Code at the bottom of the list and then click New.

1. In the New Sales Tax Code window, enter a sales tax code you want to use and a description for it.

2. Choose whether the code is Taxable or Non-Taxable.

3. Click OK.

Sales tax items, rates, and tax agencies

QuickBooks™ uses sales tax items to calculate and add sales tax charges when you make a taxable sale. When you set up a sales tax item, you assign it a sales tax rate and associate it with the tax agency to which you pay the sales tax.

1. Still in the Sales Tax Preferences window, click the "Most common sales tax" drop-down list and choose <Add New>.  The New Item window opens with Sales Tax Item already selected in the Type drop-down list.

2. Enter a sales tax name.  Use the name that you assigned for this location in UltraCart. This name appears as one of the choices in the Tax field on your sales forms.

3. Enter a description for the way this sales tax item will appear as a line item on your sales forms.  The description prints on your sales forms after the final line item. You can't edit it on the forms themselves. Users frequently use the name of the sales tax item as the description.

4. Enter the sales tax rate.  The percentage you enter is the rate you set up in UltraCart. For example, your sales tax rate for XYZ County might be 8.25% (or 8 and 1/4 cents per dollar purchased). This rate also appears on your sales forms.

5. In the Tax Agency drop-down list, select <Add New>.  This will open the New Vendor window where you'll set up the tax agency (a vendor) to which you pay this sales tax.

6. In the Vendor Name field, enter the name of your tax agency. For example, in California, sales tax is paid to the Board of Equalization. You can enter the other information now, such as the address and opening balance, or you can do it later.

7. Click OK to close the New Vendor window.

8. Click OK to close the New Item window.

9. Repeat steps 1 through 8 for each sales tax item you need to set up for your business.

Selling to Non-taxed customers

If your out-of-state sales aren't taxed, set up a single sales tax item with a 0% rate. You also need to set up sales tax codes to track your non-taxable out-of-state sales. This is required even if you were not going to have any out-of-state sales at all.

Other Codes (Gift Certificates)

If you are selling gift certificates to customers then you will need to create an item called "Gift Certificate" which will be used when the customer redeems the certificate.

When to Import into QuickBooks

The 2nd part to the above screen allows you to indicate when (under what circumstances) you want to import orders into QuickBooks. The options are based on the state or status of your orders.

As seen above, the three options to import orders are:

1. after shipment

2. after payment (shipped in UltraCart/Fulfillment House) or

3. after payment (shipped in QuickBooks)

The recommended time is after the order has shipped (and is complete). If you want to import the order after the payment is processed there are two methods depending upon whether you are shipping the order from within QuickBooks or UltraCart/Fulfillment House.

If you choose option 3; to ship after payment (shipped in QuickBooks), the order will be marked shipped in UltraCart. It will be the responsibility of QuickBooks to notify the customer of the tracking information (number). UltraBooks does not currently export tracking information back to UltraCart.

 

 

Matching UltraCart Items with QuickBooks Items

Different scenarios required different actions

It's absolutely necessary to set up UltraBooks Items that exactly match each of your UltraCart Items. When doing so, one of the following scenarios will apply:

Although it's not common, Scenario #4 above does indeed occur.   One's first thought is to either change all the Item ID's in UltraCart to the same as QuickBooks™ (not recommended) or vice versa.  That is one way of doing it (for new accounts) but we have an easier solution.  You can leave the Item names in both applications as they are and simply enter the QuickBooks™ Item name into the QuickBooks™ Code field for all your UltraCart Items.  See the screen shot below for an example.

Manage Inventory in QuickBooks

 

Item Type - Inventory

QuickBooks™ definition: "use for goods you purchase, track as inventory, and resell"

If you plan to manage inventory via QuickBooks™ there's one important configuration. When you create a "New Item" in QuickBooks™, you not only want the name to exactly match that of the Item in UltraCart, you also need to set the Item Type as "Inventory Part".   If you do not see Inventory Part in your list below, you need to turn inventory management on within your QuickBooks.  Edit → Preferences and make the changes shown below.

 

Create New QuickBooks Item

In your QuickBooks program navigate to:

Home → Lists (menu item) → Item List   →

From the Item List window, click the Item button (bottom left corner) and select New from the top of the pop up list.

Select Inventory from the Type field drop-down menu.  Configure the rest of your Item details and click the OK button when finished.

 

How UltraCart stores data

Once an order is placed all the data is packaged up and stored separately from your configuration information. So if you configure a shipping method and use it on an order before configuring the QuickBooks™ code for that new shipping method, you will receive an error message during import about something not being configured that you can not work around without the assistance of UltraCart Support. Always configure the QuickBooks™ code for everything before using it.

Using Sequential Order Ids

If you are currently using date/time based order Ids you should switch to numerically sequential order IDs. The date/time format is too long for QuickBooks™ to store and makes matching up orders between the systems difficult. Click on Configuration -> Order ID Scheme to verify your order ID configuration. We typically recommend that merchants start at 10000 and a width of 8 on their order ID scheme.
If you decide to stick to using the date/time based order ID then UltraBooks will allow QuickBooks™ to assign the next sales receipt number automatically and will place the UltraCart order number in the memo.

 

Going Live with UltraBooks

After configuring all of the required Accounting Codes, the following screen will appear. Please read the disclaimer statement.

 Click the box to the left of "I accept this agreement" and then click the "Go Live" button. The following confirmation screen will appear.

After you have entered live mode, all new orders placed on the system will be eligible for export to QuickBooks™. Any existing orders placed on the system before entering live mode will not be eligible for export to QuickBooks™. If you are interested in importing all your historical order data, please contact support@ultracart.com.  Reminder: All the required software must be installed, on the same PC as your QuickBooks™ installation, in order for UltraBooks to work properly.

Running UltraBooks

Prior to launching your UltraBooks program from your Start button, make sure you have your QuickBooks™ company file open in the background.

Start → Program files → UltraBooks → UltraBooks

(Jan. 2026) - Unable to open UltraBooks due to Windows Smart App Control?

Our engineers are aware of this compatibility challenge with modern Windows security features, however, we are not going to pursue a digitally signed experience for UltraBooks because the cost ($15k-20k) can't be justified because Intuit is pushing all customers towards Quickbooks Online.

Steps to Disable Smart App Control

1. Open Windows Security (search for it in the Start menu).

2. Go to App & browser control.

3. Under Smart App Control, select Smart App Control settings.

4. Switch it to Off.

Note: As of early 2026, Microsoft has started rolling out updates that make toggling Smart App Control on/off easier without requiring a Windows reset or reinstall (previously it was a one-way change). If the toggle is available and grayed out on your system, a "Keep my files" reset via Settings > System > Recovery > Reset this PC may be needed to re-enable flexibility (but try the direct toggle first.)
*Disabling Smart App Control reduces one layer of protection against untrusted apps. We recommend keeping Microsoft Defender active and only running trusted software.

 

Connecting to UltraCart

The application will prompt you to Authorize UltraBooks to manage orders on your behalf.  Click the Authorize Merchant Account button.

 

 

The UltraBooks application will display the UltraCart login screen.  Login, then click the green button to authorize UltraBooks.