REPORTS: Export list of transactions
Lidia
Member Posts: 10
In the past I could go to Reports and export simple lists to XLS, e.g. list of all invoices between a selected date bracket. I need this list for my accounting to easily crosscheck data. The only thing I can do is literally take screenshots of the invoice list - this can't be true?
0
Comments
It was found in the Reports section and was called Sales Transactions. You could just select a date bracket and then it would give a simple table with all invoices, the customer name & the debit/credit amounts.
If I go to the P&L report, I cannot see this data. If I go to Account Transactions I cannot select all invoices, because it will ask me to select one specific account (I would either want to select multiple accounts, e.g. everything under the category Income). If I choose All Accounts it becomes a huge list and got lots of data I don't need and I need to spend a lot of time cleaning up the table).
What I did now is go to Export and simply exported all my Wave account data, and from that ZIP I took the Invoice-Items.csv file, which was what I was searching for. It wouldn't been easier to have the Export function nested with the Reports function instead of Settings (as this doesn't relate to Settings in my opinion).
Thanks for referring me to the Export function though, as I did find what I was looking for.
I also miss this report. When I try to use the "Export" feature - it gives me a list of individual invoice items vs. the invoice total. Using the Profit and Loss report, it also give individual invoice amounts (by products & services) vs the invoice total. Is there an easy way to list all the invoices and their totals? I use this for some year-end reconciliation. Ideally I want just an export of all invoices with the total for each one.
Hey @Shana . This report doesn't exist, but your next best bet would be to print page on the Invoices page itself. Because it is listed chronologically, you can use that to see a list of your invoices.