Skip to main content
April 6, 2025
Question

Importing Bills, why do i now get a message Multiple Terms - multiple terms found for the following bills 183816 - I always have multiple bills - why not now?

  • April 6, 2025
  • 1 reply
  • 0 views
this is importing bills taken from an excel spreadsheet and there are multiple entries for some of the Bill Number entries - I do this for a VAT return - it has never queries before - help?

    1 reply

    April 6, 2025

    The "Multiple Terms" error in QuickBooks when importing bills often occurs due to mismatched or duplicate data in the Excel spreadsheet. I'll guide you and provide all the details you need, denningtonbishop.

    To begin, I suggest examining your spreadsheet and making the adjustments outlined in the guide below:

    •  If the same Bill Number is repeated with different terms, consolidate or correct these entries in your spreadsheet.
    • Ensure that each Bill Number has a uniform set of terms.
    • Make sure to check that QuickBooks is up to date to improve compatibility.
    • Ensure that the Bill Number column in your spreadsheet doesn't have duplicate entries for the same bill. If duplicates are necessary, ensure they are formatted correctly.
    • Check for updates.

     

    Moreover, confirm that each Bill Number has consistent terms across all entries. If there's any discrepancy, correct it so all entries for the same Bill Number have the same terms.

     

    Additionally, verify the requirements for QBO and ensure you are using the correct template prescribed by QBO. We've assembled frequently asked questions about importing bills. Explore this article for details: Common questions about importing data to QuickBooks Online.

     

    To import batch bills, check this guide: Import your bills in QuickBooks Online. You can also check the capabilities and limitations of this article.

     

    Multiple Terms during import have several underlying causes, mostly related to data formatting or system updates. Thoroughly review your data, check guidelines, and import gradually. If you have any questions, please let us know in the comment section below.