Custom Reports With Detail

tlenzmeier · ‎September 03, 2020

Hello,I am trying to create a report that lists out every transaction. I need to see all the detail in split transactions. I've tried running some of the canned reports (Transaction List By Date, Transaction Detail By Account, and Transaction List With Splits). I am unable to get to the detail behind each of the splits. If a deposit has multiple donations, then I want to see all of them, not just the total. Ultimately, I am going to export the detail to a file for use in our analytics database. In sum, I need transaction date, transaction amount, account, debit amount, credit amount, and memo/description.

MaryAnn_E · ‎September 03, 2020

Hi there, @tlenzmeier.

You can pull up a General Ledger in QBO. This report contains all the accounts for recording transactions relating to your company's assets, liabilities, equity, income, and expenses. To do that, please follow the steps below:

Click the Reports menu.
Type General Ledger in the search bar.
Click the Customize button found at the top-right of the report.
Update the Report period.
Tap the Row/Columns arrow then click the Change columns link.
Scroll down and mark the columns you want to view.
Click Run report.

Also, you can pull up the Journal Report to show the best of your records with credit and debit. Then, click the customize report to filter the transaction type. Then Run Report in the bottom right.

Here's an article you can read to learn more about customizing your report: Customize reports in QuickBooks Online.

I'm also adding a video tutorial if u wanted to save your report after customizing it: How to Save Customized Reports?

If you have any other questions, feel free to use the Reply button below. Take care always.

View solution in original post

MaryAnn_E · ‎September 03, 2020

Hi there, @tlenzmeier.

You can pull up a General Ledger in QBO. This report contains all the accounts for recording transactions relating to your company's assets, liabilities, equity, income, and expenses. To do that, please follow the steps below:

Click the Reports menu.
Type General Ledger in the search bar.
Click the Customize button found at the top-right of the report.
Update the Report period.
Tap the Row/Columns arrow then click the Change columns link.
Scroll down and mark the columns you want to view.
Click Run report.

Also, you can pull up the Journal Report to show the best of your records with credit and debit. Then, click the customize report to filter the transaction type. Then Run Report in the bottom right.

Here's an article you can read to learn more about customizing your report: Customize reports in QuickBooks Online.

I'm also adding a video tutorial if u wanted to save your report after customizing it: How to Save Customized Reports?

If you have any other questions, feel free to use the Reply button below. Take care always.

View solution in original post

Foody · ‎November 20, 2020

1. The Cost of Goods is reported as $0.00. The average inventory cost of goods is $0.00. How do I edit the average inventory cost of goods (by Invoice) and will it retroactively correct my Customer Detail Report and database. I do not want bad data haunting QuickBooks.

2. I have phantom shipping charges showing up as Revenue and the next line is Cost of Shipping. How do I stop that.

3. I have Customer revenue showing up from the previous year. We entered the revenue about 3 months after payment. The entry showed up in the wrong year. How do I fix.

JasroV · ‎November 20, 2020

Good day to you, @Foody.

I’m here to help and ensure your QuickBooks Online (QBO) data is accurate.

To edit your average Inventory cost of goods, you’ll have to open your inventory item and edit the cost from there. Let me show you how:

Go to the Gear icon.
Click Product and services.
Select your preferred inventory item and click the Edit link under the Action column.
Adjust the cost of the item and click Save and close once done.

You can also read through these articles for more details about managing your inventories and Cost of Goods Sold (COGS) in QBO:

Secondly, you’ll want to turn off your shipping charges from your Account and Settings. That way, it’ll not show as revenue in your reports. Here’s how:

Go to the Gear icon.
Select Account and settings.
Go to the Sales tab and select the Sales form content section.
Toggle off the Shipping option to turn off the shipping fee.
Click Save and then Done.

However, if you’re using a third-party app for your shipping fee, you’ll want to contact your third-party app customer team. There, they’ll be able to assist you on how to disable the option.

Lastly, you’ll want to ensure your report is set to the correct accounting method. Thus, it could be the reason it shows incorrect data. You can refer to these links to learn more about managing your report in QBO:

In case you need to refund your customer, you can refer to this link that can walk you through the process seamlessly: Record a customer refund in QuickBooks Online.

Let me know if there's anything else I can help you with regards to your QBO account. I'm just a post away from you. Keep safe!

Topics

Training

Community

Resources

Custom Reports With Detail