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

Video Tutorial for Importing Vendor Credits into QuickBooks Online using SaasAnt Transactions Online:

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].

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.

How to Import Vendor Credits into QuickBooks Online using SaasAnt Transactions Online

1) Login into SaasAnt Transaction Online

2) Select the Bulk Upload Tab.

3) Select the QuickBooks entity as "Vendor Credits".

4) Select the files you want to upload.

5)  Set up the Mapping of the columns in your Vendor Credits.

6) Select the "Preview Mapping" button to visualize current mapping based on QuickBooks.

7) Select the Upload tab.

8) The data will be imported successfully into QuickBooks.

Let’s have a look at the SaasAnt Transactions Online Fields.

SaasAnt Transactions (Online) Fields

Vendor Credits Settings Reference Guide

The Vendor Credits settings panel governs how supplier returns, purchase credits, and general ledger accounts are managed and structured when importing negative expense adjustments into QuickBooks.

Global Automation & Core Rules

• Do you want to apply suggestions automatically?

  • What it does: Uses automated matching logic and historical fallback parameters to fill minor data gaps or map close matches, keeping your vendor credit import moving smoothly.

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

  • What it does: Acts as a master background creation switch. If a vendor credit row references a brand-new supplier profile, 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 transaction 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 credit or reference 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 reversals.

Mapping Overrides & Supplier Directory Lookups

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

  • What it does: Overwrites the existing billing or mailing address text saved in your QuickBooks profiles with the fresh address details provided in your vendor credit 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 strictly 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.

• Find GL Account by Account Number

  • What it does: Forces SaasAnt to look up and map your underlying asset, liability, or expense 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 the Vendor's Currency in QuickBooks & update the same currency in Currency Field.

It is possible that 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 amount (Non Negative) in Line Item Amount and Expense Amount.

Amount is not equal to Unit Price * Qty Supplied value: XXXX

Please provide valid Amount in Line Item Rate & Line Item Amount.

No Account or Product / Service is available for this line.

Please provide valid Account Name in Expense Account or valid name in Line Item Product / Service Field.

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

Please provide valid name in Product Field. 

You might have disabled "Auto Create List Entities" Feature in Import Settings. 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 an another Expense has the same reference number. Please use the 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 valid Expense account name in "Account" field.

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

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

Amount is missing in the request.

The Line Item amount is missing for the particular line item

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 for the successful upload of current data set. E.g. Shipping, Multi-Currency, etc.

If you have provided Shipping Address or Currency, then please make sure you have enabled Shipping & Multi-Currency feature in QuickBooks Online.

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 given Customer Name.

Please enable "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 given Vendor Name.

Please enable "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