I know that tracking work-in-progress balances provides critical operational and financial visibility when managing projects. Let me provide some information about generating related reports in QuickBooks, Codilynn98.
If you use estimates and invoices to track work in progress, QuickBooks will automatically update the status of these transactions as you record payments against them.
For now, we're unable to generate a report showing customers with ongoing projects or outstanding payments from last year if those jobs have since been closed or paid off in QuickBooks.
As a workaround, you can get a partial picture by running a customized Transaction Detail report for 2023. Then, select invoices and payments for Transaction Type.
This will display all invoices issued last year along with any corresponding payments made. By reviewing this report, you can identify customers who likely were active and had open invoices during that period.
Here's how:
- Go to the Reports menu, look for Custom Reports, and then click Transaction Detail.
- Click Customize Report and proceed to the Filters tab.
- Look for Transaction Type in the Choose Filter field and click on it.
- Click the drop-down list for Transaction Type and choose Multiple Transaction Types.
- Check both Invoice and Payment.
- Click OK.
Let me also share this article for additional details about customizing reports in the program: Customize Customer, Job, And Sales Reports In QuickBooks Desktop.
I can certainly see the value of enhanced visibility when managing cash flow. Having insights into work-in-progress balances would certainly aid planning and decision-making.
Having said that, I recommend providing this input to QuickBooks' product engineers. Here's an article as a guide: How Do I Submit Feedback?
Your insightful suggestions provide valuable guidance for our Product Development team as they work to continuously enhance the user experience of our programs.
Feel free to check out these articles in case you need more resources when running reports:
As always, feel free to reach out or reply if you have any other questions when tracking project completion or related works in QuickBooks. My colleagues and I are always happy to provide assistance.