Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThe company I work for invoices customers monthly. Not all customers pay in the same month. I would like to run a report showing payments received for invoices in the current year. Every report I try to run gives me payments received in 2024 but for invoices dated in 2023. Is there a way to only see payments for invoices dated in 2024?
I appreciate your efforts in pulling up reports, @MMajor2702. Currently, there isn't a report in QuickBooks Desktop that can directly provide the data you need. Also, this is because the program uses the transaction date.
The closest report we can open is the Customer Balance Detail. This report displays the invoices and payments you have made. Let's personalize this report and determine which invoices were generated last year and linked to a payment made this year. To access this report, follow these steps:
Once done, let's export this report to Excel by clicking the Excel dropdown so we can edit this report to your preference. From there on, you can manually edit or delete those entries that you don't need.
To learn more about personalizing your report, feel free to read this article: Customize reports in QuickBooks Desktop.
I'll be happy to assist you if you need further help in generating a report that specifically shows payments that are connected to invoices made this year. I'll be ready to help you out.
Try this:
Go to Reports > Customers & Receivables > Transaction List by Customer. Click on 'Customize Report', click Filters tab. Under Filters, scroll down and select Transaction Type and then click on Multiple Transaction Types. A box will pop up that allows you to select both Invoices and Payments. Select OK. Change the report date to 2024.
I'm not sure if that will work for you since it will pull up invoices dated 2024 that have not been paid as well as payments received in 2024 for invoices in previous years but it may get you what you need.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here