You can import bills from text files or Excel spreadsheets directly into QuickBooks Online using SaasAnt Transactions (Online) software.

Pre Requisites:

Connect your QuickBooks Online account to SaasAnt Transactions (Online) App from QuickBooks AppStore by clicking the "Get App Now" button and get the 30 days free trial [No credit card required].

Video Tutorial for Importing Bills into QuickBooks Online using SaasAnt Transactions Online:

Steps to Import Bills into QuickBooks Online

To import bulk/batch bills into QuickBooks Online using the SaasAnt Transactions (Online) application, follow the steps below 

• Sign in to SaasAnt Transactions Online.

• Open Bulk Upload.

  

• From the entity list, choose Bills.

• Click Upload and select your file.

• Map your columns to SaasAnt fields. Use Preview Mapping to verify alignment with the QuickBooks screen.

• Click Review to validate rows. Fix any flagged issues.

• Click Upload.

• Check the result summary.

The important step in the import is to map your file headers to the QuickBooks field in Step 3. Some key steps below:

• You must map your file headers to "SaasAnt Transactions (Online)" fields. This mapping will enable us to import your transactions correctly into QuickBooks company.

• In the mapping screen, we have the "Preview Mapping" button, which can help you to visualize your current mappings as per the QuickBooks screen with your file headers.

• Please refer basics of field mappings for more info. If you have any confusion or doubts, feel free to drop an email to support@saasant.com.

SaasAnt Transactions (Online) Fields

Bills Settings Reference Guide

The Bills settings panel controls how incoming vendor bills, accounts payable entries, and product details are parsed, matched, and automated during your import.

Global Automation & Core Rules

• Do you want to apply suggestions automatically?

  • What it does: Uses automated matching logic and historical defaults to seamlessly resolve minor data gaps or map close matches without pausing your bill import.

• Do you want to create Customers, Vendors, Locations, Classes, and Accounts automatically?

  • What it does: Serves as a master background creation switch. If a bill row introduces a brand-new vendor profile, location, class, or ledger account that doesn't exist yet, this allows SaasAnt to build it on the fly to prevent validation errors.

• Date Format

  • What it does: Configures the system parser to correctly interpret your invoice/bill date column (e.g., DD/MM/YYYY) so days and months are never accidentally transposed.

Reference Numbers & Processing Controls

• Do you want to use the Transaction Reference Numbers from the uploaded file?

  • What it does: Instructs QuickBooks to record the explicit bill or voucher numbers provided in your spreadsheet instead of overwriting them with native, auto-sequenced sequence numbers.

• Do you want to disable the optimisation for the batch import?

  • What it does: Turns off parallel processing bundles in favor of a slower, line-by-line verification import—highly useful for auditing complex expense distributions or troubleshooting line item errors.

Mapping Overrides & Vendor Profiles

• Do you want to Update the address (Customer & Vendor) in QuickBooks from the file?

  • What it does: Overwrites the existing billing, shipping, or mailing address text saved in your QuickBooks profiles with the fresh address details found in your bill import file.

• Do you want to identify the vendor based on their Account Number?

  • What it does: Tells SaasAnt to track down and match up your supplier rows using their designated QuickBooks Vendor Account Number rather than searching by text name.

• Do you want to identify product details from SKU information?

  • What it does: Instructs the system to match line-item details or inventory items using their unique QuickBooks SKU field rather than relying on Item Name matches.

• Would you like to match the names exactly as they appear in your file for customers, vendors, and items?

  • What it does: Enforces a strict, character-by-character match against names. If enabled, it strips out formatting variations (like trailing spaces or case differences) when verifying records against your directory.

Automated Product/Service Creation Rules

If your spreadsheet introduces itemized lines or inventory that do not yet exist in your QuickBooks records, SaasAnt will automatically generate them on the fly using these default fallback rules:

• Select the product type to be created automatically if it does not exist

  • What it does: Establishes the default item categorization tier (such as Non-Inventory or Service) for brand-new items generated on the fly.

• Select the Income Account for the newly created Products/Services

  • What it does: Maps the default revenue/sales ledger account where income from this item should be tracked.

• Select the Expense Account for the newly created Products/Services

  • What it does: Maps the default expense or Cost of Goods Sold (COGS) ledger account for tracking purchase and procurement costs.

For Automated Inventory Items:

• Select the Inventory Account for the newly created Inventory Item

  • What it does: Maps physical stock adjustments directly to your preferred 'Inventory Asset' ledger account in QuickBooks.

• Select the Inventory Start Date for the newly created Inventory Item

  • What it does: Establishes the official tracking start date (MM/DD/YYYY) for the item's stock history.

• Select the default Inventory Quantity for the newly created Inventory Item

  • What it does: Automatically inputs an initial opening stock quantity balance for the profile.

• Find GL Account by Account Number

  • What it does: Forces SaasAnt to look up and map your chart of accounts using their exact numerical codes rather than full text account names.

Possible Failures & Troubleshooting Tips

The currency of the transaction is invalid for customer/vendor/account

The given Currency is different than the default currency of the vendor. Please refer to the Vendor's Currency in QuickBooks & update the same currency in the Currency Field. 

It is possible that the Multi-Currency feature in QuickBooks could be disabled. Please enable the feature.

Required parameter(s) missing: Line

Please provide at least one Item Line details or Expense Account Line Details to process.

Transaction amount (Sum of line amounts) must be 0 or greater

Please provide the valid (Non Negative) amounts in Line Item Amount and Expense Amount.

No matching Product/Service found (or) could be created for the provided details.

Please provide a valid name in the Product Field. You might have disabled Import Settings "Auto Create List Entities" Feature. By enabling this feature, QuickBooks will automatically create the product for the transaction.

Duplicate Document Number Error: You must specify a different number. This number has already been used.

There is another Expense that has the same reference number. Please use another reference number.

You have disabled "Assign Transaction Numbers from file" in Import Settings. By enabling this feature, QuickBooks will automatically assign numbers for the transaction.

No matching reference found for this account

Please provide a valid Expense account name in the "Account" field.

Invalid account type: You need to select a different type of account for this transaction.

Please provide a valid Expense account name in the "Account" field.

The amount is missing in the request.

The Line Item amount is missing for the particular line item.

The required parameter Line Amount is missing in the request.

The Line Item amount is missing for the particular line item.

Please check in QuickBooks company settings if the appropriate preferences are enabled to upload the current data set successfully. E.g: Shipping, Multi-Currency, etc.

If you have provided a Shipping Address or Currency, please enable the "Shipping & Multi-Currency" feature in QuickBooks Online.

The requested entity/feature (Billable Expense) is not supported by QuickBooks per your subscription.

Billable Customer or Expense feature is not available for your QuickBooks Online Subscription. Please remove the values in Billable Fields (Expense Billable, Line Item Billable)

No matching reference found for this customer.

There is no match found for the given Customer Name.

Please enable the "Auto Creation of List Entities (Vendor, Customer)" feature in import settings to create the customer automatically.

No matching vendor found (or) could be created for the provided details.

There is no match found for the given Vendor Name.

Please enable the "Auto Creation of List Entities (Vendor, Customer)" feature in import settings to create the customer automatically.

If the currency field has some value, Please enable Multi-Currency feature in QuickBooks.

Business Validation Error: There is no account associated with the item "XXXXX". Is it marked for purchase, and has an account associated with it?

Please assign the Expense Account for Product / Service "XXXXX" in your QuickBooks Online.

Business Validation Error: You must select a customer for each split line that is billable.

Please enable the below features in your QuickBooks Online.

• Track expenses and items by customer

• Make expenses and items billable