Effortless Import into QuickBooks Online using SaasAnt Transactions

December 23, 2016

blog_images1703124342445_review.png

SaasAnt Transactions allows Auto Creation of Customer, Vendor, Products & Services from an effortless Import into QuickBooks Online.

Contents

Live Example 1:

Live Example 2:

Auto Created Product Type

Auto Created Product / Service Income Account

Auto Created Product / Service Expense Account

Live Example 1:

We met a customer who had ginormous transactions to be entered in QuickBooks.The actual pain is he has to create new customers for each Invoice. ”SaasAnt Transactions” rescued him from entering Invoices and as well as from creating new customers.

Live Example 2:

One of our customers wants to create new products in QuickBooks from the invoices. He does not want to create Products each time when he imports Invoices. ”SaasAnt Transactions” has a feature that created products automatically. How can it be done using “SaasAnt Transactions”? If you want to create new Customers, Vendors, Products, Services automatically, you need to enable the “Auto Create List Entities” feature in Import Settings. You can open the Import Settings from Settings Menu or by clicking the “Settings” button in Upload Review Screen. QuickBooks Online Import saasant transactions QuickBooks Online Import Auto Creation for Customers,Vendors,Classes,Locations: Once you turned on “Auto Create List Entities” feature, “SaasAnt Transactions” creates Customers,Vendors,Classes & Locations automatically.  The name of the LIST entities (Customers,Vendors,Classes & Locations)  is used to find its equivalent in Quickbooks Online. QuickBooks Online Import Auto Creation for Products: By default, “SaasAnt Transactions” creates “Products” automatically with following details

Fields   

          Values

Product Type

NoN Inventory

Income Account

Uncategorized Income

Expense Account

Uncategorized Expense

However, you can control this behavior. In the Import Settings, Under “Advanced Tab”  , you can find the options to tune the auto-creation.

Auto Created Product Type

You can select the desired type of  List . It can be Non Inventory Product or Service.

Auto Created Product / Service Income Account

The name or account number of Income account which should be associated with auto-created products or services.

Auto Created Product / Service Expense Account

The name or account number of Expense account which should be associated with auto-created products or services. Turn Off : Sometimes, you don’t want “SaasAnt Transactions” to create products or customers automatically. Even human errors ( Spaces in Name, Incorrect Names ) may lead to creating wrong products or customers in QuickBooks.  You can turn off this feature if you want. More Settings: Please click here to know more about special settings in SaasAnt Transactions.

Tags

Automatic Creation

Excel

Item

Product

Quickbooks Online

SaasAnt Transactions

Service

Settings