Skip to main content
December 6, 2020
Question

Hello, we have a problem in the total expense amount when we are creating an offical report

  • December 6, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

katherinejoyceO
December 6, 2020

Hello there, @info-flogapp-com.

 

Thanks for coming to the Community. I want to make sure I'm providing you with the best answer to your concern. 

 

May I know the problem specifically? And please attach a screenshot of the report where you have issues with the total expense. 

 

Any information that you can include in your response would be of great help to me in finding the resolution of your concern. 

 

For future reference, you can also check out this article to learn more about how to filter your report to show what you only need: Customise reports in QuickBooks Online

 

I'll be looking forward to hearing again from you, @info-flogapp-com. Take care. 

December 6, 2020

so the main problem is we have different categories and different suppliers that we add for the expenses on monthly bases so when you go to expenses and you filter by month you will see the total amount down and the details of every transaction, and when we go to report < profit and loss per month we see a different number other than the one in the expenses at the same time some suppliers is not shown in the report so we see big difference in pricing 

 

unfortunately i cant attache more than one attachment to show you the difference but as you can see its around AED 33 K and in the report it show the same but with AED 17K 

December 6, 2020

Hello @info-flogapp-com,

 

Let me help share information about how you can compare your report to get the most out of your expenses.

 

To start with, the transactions you pulled up from the Expenses page is in a detailed display while your Profit and Loss report is displayed in summary. This is the reason why comparing them seems to be off for a large sum of expenses.

 

Instead, you can consider customising your Transaction Detail by Account report and compare it with your expenses for a month. Let me show you how.

  1. Go to Reports.
  2. Under For my accountant, select Transaction Detail by Account.
  3. Click Customise.
  4. Select the appropriate report period. Say This month or Last month.
  5. On the Filter menu, select Transaction Type and Distribution Account.
  6. Choose Expenses for Transaction Type.
  7. Select All Expenses account for Distribution Account.
  8. Click Run report.

In addition, here's an article you can read to learn more about how you can customise a report: Customise reports in QuickBooks Online.

 

Lastly, I've also included this helpful article for the steps in saving your report after customising it: Memorise reports in QuickBooks Online.

 

If you have any other questions, please let me know in the comments below. Stay safe!