QuickBooks Payable Export - Bill and Credit Created

Date Of Print: N/A - Currently Under Revision

Payable Exports to QuickBooks are creating both a Vendor Bill and a Vendor Credit in some instances, why does this happen? 

With QuickBooks version 2010 and later, when importing Vendor Bills with negative tax amountsb these bills could not be marked paid in QuickBooks. The solution that has been implemented is to import tax exempt items as a Vendor Bill and items with negative tax amounts as a Vendor Credit. The total of the resulting Vendor Bill and Vendor Credit will match the total of the original Vendor Bill.

For example, when exporting Owner Operator payroll if there are any driver deductions containing tax, there will be both a Bill posted for tax exempt items as well as a Credit posted for items with negative taxes (deductions). If you wish to have these Credit invoices automatically applied to the imported Bill, there is a setting that can be turned on in QuickBooks to automate this. 

NOTE: This setting will apply to all payables and will impact all vendors whether imported from Fleet/Logistics Manager or not. Please discuss the implications of changing this setting with your accountant before proceeding.

This QuickBooks setting is located in:

Edit > Preferences > Bills

By automatically using credits when paying bills, you’ll essentially simulate the past behavior of QuickBooks and Vendor Bill exports from Fleet/Logistics Manager, except you’ll now be able to mark these Vendor Bills as paid, which wasn’t possible previously.

Please contact support@transpluscorp.com if you require further assistance with this.