I am importing data into Quickfile from an Excel spreadsheet (csv) for sales invoices. I have included the mandatory columns but also wanted to have the “quantity” and “unit cost” appear in my invoices. For example I sold 4 items at £20 each and want to show Quantity = 4 and unit cost = 20 on one invoice. Any ideas on this?
It’s not currently possible to specify the unit cost and quantity for the import tool. Have you issued these invoices from a different system (e.g. another accounting system), or do you just have a list in a CSV file?
There is one way of doing it however, and that’s with our API. This does however require some coding knowledge, so if you know what you’re doing it’s worth taking a look. If you need help with some code, we have a Marketplace category on the forums you can post, to find someone who could help with setting that up for you.
It doesn’t look like this has actually come up previously on the forums (although I may be wrong), so if you wish, you’re welcome to start a new feature request for this, and we’ll monitor the interest.
I only have a list in a CSV file unfortunately. I do not want to mess about with API and coding as not worth the effort in my case. Thanks for the reply!