Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveHi Everyone,
I'm looking for a way to import invoices incrementally from a CSV file, ensuring that QuickBooks only adds new invoices while skipping duplicates.
I recently tested this by creating a simple CSV file with one invoice and a specific invoice number. The first import worked fine, but when I tried to re-import the same file, QuickBooks parsed it again and attempted to create a duplicate invoice for the same customer instead of recognizing that it already exists.
Is there a setting or a best practice to make QuickBooks detect existing invoices and prevent duplicates during imports?
Thanks for your help!
I appreciate what you've done so far, AdrianFL. Yes, there is. You can turn on the Custom transaction numbers option in the Account and Settings to detect duplicate invoice numbers from importing to QuickBooks Online (QBO). I'll guide you through the steps below.
You can also check out these articles to learn more about the use of custom transaction numbers and importing invoices in QuickBooks:
Moreover, please check this handy article for future reference in recording customer payments: Record invoice payments in QuickBooks Online.
Mention me in the comments if you need further clarification on importing your invoices without duplicates in QuickBooks. I'm readily available to assist you.
Many thanks! I will be trying it out soon.
Additinal question I have, but maybe it is better to start as new thread if you suggest it.
Do you have any logic for taxation developed to cover Federal Excise Taxes (FET) taxes for aviation business?
The Federal Excise Tax (FET) in the U.S. isn't always a simple percentage applied to the total fare.
It has specific rules regarding what portions of the flight are taxable, and certain segments may be excluded from your overall trip charge.
Do you have any customers implementing FET within Quickbooks and what could be possible suggestions to implement it?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here