List Export

mwood94

Hi there, I would also like to have the ability to export invoices to csv for a given time period. My use case is, come tax season, I would like to have an overview list with Invoice number, customer, subtotal, tax, total. This was I can have a full breakdown as well as the bulk exported PDFs (great feature!).

Thanks,
Mitch

mwood94

SubTotal version: 1.5.65.0
Operating system: Windows 10

timo

mwood94 That's a good reason. Maybe we can collect the required data/columns that such a CSV export feature would need to have?
You named "Invoice number, customer, subtotal, tax, total" - any else?

When adding features like this, one question always is how to make this feature available in the user interface, without making it too confusing (e.g. I want to avoid an additional button in the invoice screen). Would it be sufficient to only offer it in the context menu of the "grouping" elements, so the same context menu that has the "Bulk export PDF" button?

mwood94

timo Line item description would possibly be helpful as well but not fully necessary for my use case. Yes, that context menu would be a great place for it without cluttering the interface. Thank you!

mwood94

mwood94 Apologies, the lines between SubTotal and WorkingHours got blurred for me. Line item description wouldn't make sense for this case. Invoice number, customer, subtotal, tax, total would be great!

timo

mwood94 And the monetary values should be exported as text, incl. the currency symbol and the same number formatting as in the app (which depends on the invoice type's language)? This could make it difficult to sum up columns in apps like Excel. Or do you not need the sum of the exported invoices?

timo

I will add this feature to the next update. If it turns out that it needs to be further improved, we can discuss it here

mwood94

Sum wouldn't be required, I could do that within excel after the csv has been exported. Personally I wouldn't need currency included in the text but whatever you feel most customers would want. Thanks for your quick response!

timo

mwood94 I could do that within excel after the csv has been exported

As I wrote above, the data is written as text, incl. the currency symbol. I don't know how smart Excel is to detect that as number to perform the summing

Piotr

timo I am new here. How do I export several invoices data to csv as you described above?

MacOS 1.5.67

timo

Piotr E.g. "group by year" and then use the context menu on the year list item

Dieseltaz

For me it would be nice to export all data and lines with everything, item lines, etc etc.

This would allow me to bulk upload into my accountancy app.

I read about how to do it above, but I can't see how or where this menu is in android or windows or osx? Sorry ...

timo

Dieseltaz Would it be possible to provide a CSV file with example data so I get an idea on what you have in mind?

Dieseltaz I read about how to do it above, but I can't see how or where this menu is in android or windows or osx? Sorry ...

I am referring to this context menu:

timo

I'm quoting my last response 🙂

timo Dieseltaz Would it be possible to provide a CSV file with example data so I get an idea on what you have in mind?

CSV requires that each invoice only uses one line - I don't know how you want to have a (variable) amount of line items in one line

Dieseltaz

Ahh, I didn't have grouping on so I didn't see these. Wonderful.

Could we now have all the invoice details or the option for specific bits in there? Client name/addressz inv date, due date, line item 1, price, qty, total ... Line item 2, price, qty, total etc etc. Then totals and maybe one more for status?

I can then export everything per year and backfill my accountancy software which would be outstanding? Currently having to process via OCR and it's never perfect.

Dieseltaz

timo

So sorry.

Can't seem to upload a zip or xslx as an blank example?

timo

You can send it to me via mail subtotalapp@outlook.com

Dieseltaz

Have just sent one. Sorry for delays.