I'm happy to help get this information prepared for your accountant! Here's how to print expense transactions for an entire year:
From QuickBooks Online, navigate to the Expenses tab and the Expenses section.
Open the Filter dropdown menu (▼) and set the date range to Last Year (or Custom to whatever you need).
You'll also need to filter the Expense List to include the Attachments column to include the receipts. Click the gear icon to the top right of the report to find this filter.
Click the page and arrow icon to Export the list to Excel, which offers greater variety and control.
Please let me know if you have any additional questions on this or anything else! I hope you have a wonderful rest of your Thursday!
I tried this also, as I need my receipt images in my report. When I select attachments and export to excel there is an attachment column, but it only contains a number to indicate that there is an attachment, but no receipt image. How does one get the receipt image in a report of all expenses? Thank you
I still do not see a way to print all expenses with receipts. As part of a Kansas Revenue audit, they want to see receipts with expenses. I realize it may be a large PDF to download but having the expense enumerate as 1, 2, 3, etc and then at the end each receipt attached at the end of the pd would have the same referenced number.
I am just not seeing how i can download all receipts in an easy manner so that they align with an expense. If someone knows how that can be be done, that would be great.
To provide you with an accurate solution, could you please clarify which report you’re trying to run? That said, if you're working with an Expense report, you can filter or customize the date range to cover 07/01/2025–06/30/2026.
Here’s how:
Go to Reports and open the Expense report (or whichever report you need).
At the top of the report, find the Report period field.
Manually enter 07/01/2025 as the start date and 06/30/2026 as the end date.
Click Run report.
Just a heads-up that receipt photos are not embedded directly into reports as they’re stored and accessible within each transaction. You can open them separately to view or download the attachments.
Let me know if you have any other questions.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.