An efficient way to import invoices with a lot of line items.

Currently we have to manually enter long invoices with many line items (each line going to different GL account, project #, etc.). There is a way to import an invoice using Excel, but this method does not save any time since all the data for the entire invoice has to be entered all on one row. What would help immensely is a new import Excel file that has a separate row for each line item on the invoice. That way we can just copy and paste our long invoices into the import quickly.

  • Patrick Jamieson
  • Jan 30 2025
  • No Status
Invoices
  • Attach files
  • Guest commented
    December 17, 2025 17:57

    I FULLY SUPPORT THIS! THE IMPORT SHOULD BE A MULTI-ROW ALLOCATION BASED ON INVOICE NUMBER/DISTRIBUTION AMOUNT.

    I REPEAT, THIS NEEDS TO HAPPEN ASAP!

    Attachments Open full size
  • Matthew Maylath commented
    July 01, 2025 15:49

    Yes, this is exactly what I would like too. The current invoice import is limited to 99 extensions, meaning an invoice with more than 99 lines of distribution can't be imported. We sometimes have invoices with 500 to 1000 lines of expense distribution by account/project. There should be a way to import an Excel file as Patrick has suggested with one row for each line of distribution.

    Attachments Open full size

Related ideas