Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How can I get either a report, or dump the data to Excel or use Access to pull ALL the transactions from QBO where I can sort and filter by the "customer/project" field. The user who set up this instance of QBO did not set up projects. Just "customers". Then another user started creating and trying to move transactions to the "project". I need to provide ONE report per "customer" or "customer/project" to show total cost (be that expense, vendor bills, etc.
I need to do this yesterday and I cannot seem to find ANYTHING in QBO that is actually helpful
Good day, @kathRSC.
I'll show you the steps on how you can view your project report and export them through QuickBooks.
Project reports can only be accessed from the Project Center. All of the project transactions you made will be reported on this page.
You've mentioned that another user moved your transactions to the project menu. If the transferring of data were successful, then this should show in the Project reports.
To verify, you can check the CUSTOMER / PROJECT column in the Invoices tab. This will show you the list of invoices that are created inside QuickBooks. If the transaction was linked to a project, then the customer name should show as "name of the customer: name of the project".
Here's how:
If you're unable to find one, you have to open each transaction and manually select the customer that was linked to the project. Just click the invoice and select Edit invoice. Then, click the Customer drop-down list and choose the customer. Once done, click Save.
This should now show in the project reports. To export your data to Excel, simply go to the Projects menu and select the name of the project. Then, click Project Reports and choose Project Profitability.
You can now customize the report and export it to Excel. Just click the Export button and select Export to Excel to download your data.
That should do it. Please let me know if you need further help in viewing your transactions in QuickBooks Online. I'll be more than happy to help.
Thank you for your time. It was not addressing what I actually needed but I have since found a resolution
Again, sincerely appreciate your time! Not sure how to note my issue has been resolved so as not to waste anyone’s time
take care! K
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