I'm trying to come up with a simple list of non-labor costs charged to projects but the canned reports seem to only include trx that came in via bank (cc) trx.

jack Thompson · ‎January 04, 2024

Irene R · ‎January 04, 2024

Thank you for coming back to us here in the Community with more information regarding the reports you are looking for in QuickBooks Online (QBO), Jack.

Instead of creating a report from scratch via report builder, you can use the existing reports in the QBO to view the information you need for your business.

To get a detailed report of your transactions by account, use the Transaction Detail by Account report. You can customize this report by grouping your customers according to their respective projects. Furthermore, you can add customer columns, filter transaction types to expenses, and allocate accounts to specific expenses.

Here’s how you can locate these features:

At the left panel of your QBO account, choose Report.
On the Reports search tab, type in Transaction Detail by Account.
From there, you can personalize your reports by clicking on the Group, Filter, General Options, and Columns. You can also choose the dates by tapping on This month to date.

You can check out these articles on personalizing your reports here in QBO:

Don’t hesitate to reach out to us again if you have more inquiries about generating your QBO reports. I’ll be here to assist you at any time.

View solution in original post

FaithA · ‎January 04, 2024

Hi, Jack. Thanks for posting your concern.

For me to be able to provide you with an appropriate solution, I'd like to know what type of report you tried to run which only showed the banking transactions. Could you also elaborate on how you went on tracking the non-labor costs in QuickBooks Online? Any additional information will be much appreciated.

I'll be on the lookout in the comment section for your response and any of your QuickBooks-related queries. Take care.

jack Thompson · ‎January 04, 2024

Hey, Faith;

I believe the report I used came from the report creation wizard, 'Expenses by Account for the last 12 months'.

The costs that are showing up have all been imported to QBO from the CC bank feed. I don't use bank feed for actual bank transactions, and it seems to be ignoring the AP trx.

Costs I'm trying to capture are booked to various Cost of Goods accounts.

CGS account trx are included in the report generated but it looks like nothing paid through AP.

Does this help?

Irene R · ‎January 04, 2024

Thank you for coming back to us here in the Community with more information regarding the reports you are looking for in QuickBooks Online (QBO), Jack.

Instead of creating a report from scratch via report builder, you can use the existing reports in the QBO to view the information you need for your business.

To get a detailed report of your transactions by account, use the Transaction Detail by Account report. You can customize this report by grouping your customers according to their respective projects. Furthermore, you can add customer columns, filter transaction types to expenses, and allocate accounts to specific expenses.

Here’s how you can locate these features:

At the left panel of your QBO account, choose Report.
On the Reports search tab, type in Transaction Detail by Account.
From there, you can personalize your reports by clicking on the Group, Filter, General Options, and Columns. You can also choose the dates by tapping on This month to date.

You can check out these articles on personalizing your reports here in QBO:

Don’t hesitate to reach out to us again if you have more inquiries about generating your QBO reports. I’ll be here to assist you at any time.

jack Thompson · ‎January 04, 2024

Groovy, thanks.

Never occurred to me that I might be overthinking it!

jet

SashaMC · ‎January 04, 2024

Good afternoon jack Thompson,

You are welcome! If you have any other questions, let us know! We are here to help.

Topics

Training

Community

Resources

I'm trying to come up with a simple list of non-labor costs charged to projects but the canned reports seem to only include trx that came in via bank (cc) trx.