Bills - Ability to Assign Project or Customer when importing
I have to create a biill with about 60 line items which contain a mix of duplicate and variable information. As there's no way to duplicate line items in bills, I employed a workaround by exporting Xero's inbuilt bills template file 'BillTemplate.csv'. In Excel I was then able to quickly and easily create 60 copies of the same line item, make the changes necessary and import the csv file into Xero which successfully created the bill containing the 60 line items - thus saving me hours of wasted time.
The only issue is that no provision has been made in the csv template file for assigning line items to a customer or project.
My request is for either:
a) ability to duplicate lines in bills (and invoices too would be beneficial) rather than just add empty lines.
and/or
b) ability to assign a line item to a customer or project in Xero's bill template csv file.
![](https://secure.gravatar.com/avatar/391d4bc6d0eaccbf96431c26b30ca6da?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Karen Steel commented
We also need to be able to import and assign each line to a project number. Having to go back in and assign each line individual is cumbersome and time-consuming!