Report inaccuracies

Report inaccuracies

I just generated an Expense by Category report in Zoho Books, expecting to get the expenses as reported in the Profit & Loss statement. No so! Specific expense categories that I had added in the chart of accounts were not included in the report, and some Cost of Goods Sold categories that should not have appeared were included.

The Profit & Loss statement appears to be correctly reflecting all expenses, and the Expense by Category report is not. it is all over the place!

From what I can tell, the Expense by Category report is using the "type of transaction" or the entry procedure used as a basis for what to include or not include in the report. As a result, if I purchase materials using a credit card that are intended to be categorized along with Cost of Goods Sold, they get re-classified in the Expense by Category Report as an expense.

Has anyone else run into issues like this?

I think it would be useful for explanations (and guidelines) to be provided along with the reports so that users don't misunderstand their purpose and waste time wondering why the reports don't reconcile with each other! Ideally, some of the reports should be re titled to avoid misunderstanding.

    Access your files securely from anywhere







                            Zoho Developer Community





                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner






                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources


                                                                                              Zoho Writer Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ








                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • Email for customer to provide payment information

                                                                                                              Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?
                                                                                                            • Unable to display field label from a hidden Single Line Textbox in Description

                                                                                                              Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, and
                                                                                                            • Lookup fields

                                                                                                              Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules
                                                                                                            • Zoho Analytics - Bill Table

                                                                                                              Hi I am new to Zoho and mainly work in Books. Recently learned of Zoho Analytics and am exploring it to create reports that would be useful for me. For example, I want to create a bills cash forecast by week for cash flow planning. When I start to create
                                                                                                            • Creating a tax - amount table in Analytics

                                                                                                              Hi everyone, I would like to create a report in Zoho Anayltics that creates the tax and amounts in a table. I have been able to create a report that shows me all the tax accounts, but I can't get it combined with the amounts of the accounts. Is there
                                                                                                            • Is it possible to do custom domains on test accounts that use saml setups?

                                                                                                              In Zoho Billing, Is it possible to do custom domains on test accounts that use saml setups for the customer portal?
                                                                                                            • I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API.

                                                                                                              Hi Zoho Team, I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API. I am able to manually upload a PDF into this field through the UI. I am also able to upload files as attachments
                                                                                                            • No chat option

                                                                                                              Chat option is not available in Android app.
                                                                                                            • How to add custom templates in zoho sheets mobile

                                                                                                              How can I add custom templates in Zoho spreadsheet mobile?
                                                                                                            • Order Items

                                                                                                              Hi .. We have to implement orders with line but each line should have a separate record and not as a subform, does anyone have experience with that kind of solution what is the best practice for that kind of thing Thanks
                                                                                                            • Trello: Invalid Client - Client ID passed does not exist

                                                                                                              Hello, I am trying to authorize the Zoho CRM power-up in Trello but always land on the following page: I tried adding a trello client to the Zoho API console but this generated a different client ID to the one in the link of the page in the above picture.
                                                                                                            • Zoho Sprints - Q2 updates for 2025

                                                                                                              Hello everyone! We’re excited to share the latest updates from Zoho Sprints for Q2 2025! This quarter, we rolled out a few highly-requested features designed to enhance collaboration and time management across your projects. Here's a look back at the
                                                                                                            • CRM Email Insights Not Working - Status not Changing

                                                                                                              I used to be able to see if a customer opened/read an email in CRM, but I no longer get those status changes inside their record. I have everything enabled and I am sending the email from CRM. The experience center has the status' enabled as well. Any
                                                                                                            • The use of Ticket statuses

                                                                                                              When your support team mark a ticket "Closed" before I had a time to check what your team has done on the ticket - I have to consider this as you consider the ticket closed even if I dont consider it closed. Which automatically produce a negative sentiment.
                                                                                                            • "Replace" an existing version of CRM

                                                                                                              Hi all, I have a question, I saw an article about this once, but I now cannot find it. I am working with a client who has had their CRM in Zoho One built and extensively modified. But it is non-functional now, and rather than try and unpick the system,
                                                                                                            • Data Import From a private PostgreSQL RDS Instance

                                                                                                              Hello All, I feel like the problem I am experiencing has been seen before; however, I am having a difficult time finding any solutions. Hoping the community has some insights. I am trying to import data from a PostgreSQL RDS instance that is behind an
                                                                                                            • Assistance Required: Authentication Error When Sending Credit Application Form

                                                                                                              Hi, I'm encountering an error message that states: "Authentication unsuccessful – the user credentials were incorrect." This occurs when I attempt to send the credit application form to our customers. I've attached the form I’m trying to send for your
                                                                                                            • Missing Fields in Lead Conversion Mapping

                                                                                                              I’ve been using Zoho CRM since 2013 to manage leads and convert them into contacts and jobs. When I convert a lead to a customer, I create a new contact and a job. Previously, this process automatically transferred key information from the lead to the
                                                                                                            • Allow selection of select inactive users in User data fields

                                                                                                              Hello, We sometimes need to select a previous employee that has an inactive account in the User data field. For example, when doing database cleanup and indicating actions are done by a certain employee that weren't filled out when they were part of the
                                                                                                            • Connection to Zoho One

                                                                                                              My org has a Zoho One account, which includes Zoho Social. We are wanting to try linkthread. However, I want to make sure it is set up properly from an account perspective, as I have accidentally created Zoho accounts separate from Zoho One when I didn't
                                                                                                            • Ticket Automatically Created from Closed Chat

                                                                                                              Is there a way to prevent a ticket being create for every chat.... or at the very least have it automatically closed.
                                                                                                            • IMPORT INVOICES CSV

                                                                                                              Hi, Impossible to import invoices in Zoho books with a csv file. I have also tried with the template. My topic keeps getting closed but I did not get any answer Is there an issue with this fonctionnality ?
                                                                                                            • Related Lists in Email Templates

                                                                                                              Hi Zoho team, I would love to see a feature where related list information can easily be added to an email template (instead of mail merge). I have a client who books flights for their customers. They do this through a Flights module so all booked flights
                                                                                                            • Outlook plugin funktioniert nicht.

                                                                                                              DAs Outlook Plugin funktioniert nicht mehr. Ich werde aufgefordert, mich mit der App "OneAuth" anzumelden Intelligente Anmeldung per OneAuth funktioniert nicht zufreidenstellend. Nach erfolgreicher Anmeldungung mittels QR Code lande ich wieder beim QR
                                                                                                            • iOS App Version 3.0 - Customer list gone?

                                                                                                              Not sure when this changed, but I seem to have been updated to 3.0 for the phone app (on iOS). I'm pretty sure that I used to have a Customers button that allowed me, for example, to see what appointments a customer has. Has this disappeared or am I just
                                                                                                            • Zoho Signature, "For Demo Purpose Only Powered by Zoho Sign"

                                                                                                              How to disable this text on the documents for signature. "For Demo Purpose Only Powered by Zoho Sign"
                                                                                                            • Add Resource variable to notification email customisation for Event Type

                                                                                                              The notification email customisation feature for Event Type does not include a variable for the Resource field. Without this field, Zoho Bookings cannot be used by any business for resource-based services or event types e.g. room bookings, equipment bookings.
                                                                                                            • Can't find add role button, is iet st because I have the free subscription

                                                                                                              Trying to add my accountant in Zoho Books if I press the add accountant button, I get stuck as it says no such role exists, and won't let me continue, I can't find the add roles button, so I am stuck. Is it because I have the free subscription? Also can't
                                                                                                            • Calendar view all appointments in workspace

                                                                                                              In the Calendar page, add the ability to view all appointments in the Workspace. The Manage Calendars filter requires me to select at least one user or resource, and it only lets me select up to five of them. There's no filter option to view the entire
                                                                                                            • Tip #13: Identify where your bookings come from with Source Tracking

                                                                                                              Source tracking is the practice of identifying where your bookings originated. This is important, because online bookings come from a wide variety of sources like social media platforms, your website, email and ad campaigns, partner websites, organic
                                                                                                            • Unable to Add Notes

                                                                                                              I've had a user report that they are unable to add notes to account records. I attempted and found the same issue. There is no option to save the note.
                                                                                                            • Workflow Rule Alert Not Working

                                                                                                              I have a workflow rule set (that I've been using for years) that suddenly stopped working. Module - Leads Execute on - Create Alerts - Email Active - Yes When I create my lead I no longer receive my email notification. 
                                                                                                            • Unify Overlapping Functionalities Across Zoho Products

                                                                                                              Hi Zoho One Team, We would like to raise a concern about the current overlap of core functionalities across various Zoho applications. While Zoho offers a rich suite of tools, many applications include similar or identical features—such as shift management,
                                                                                                            • Assignment Thresholds Resetting After Lead Conversion

                                                                                                              Hello everyone, We're facing an issue with Zoho CRM's lead assignment thresholds that makes them unsuitable for our workflow. I'm hoping to find a potential workaround or solution from the community. Here’s our current process: A new lead is created automatically
                                                                                                            • Can zoho sign collect data feeding Zoho Sign?

                                                                                                              I m sending contracts to client who are not in my zoho CRM database yet. Can the data they enter in Zoho sign contract I send them, (that includes...) official company name address first name second name etc, ...Create or update a contact / account
                                                                                                            • IMAP ACCOUNT ACCESS PROBLEM

                                                                                                              Hi! I moved from Gmail some time ago to ZOHO. It works fine and it worked till yesterday. I found out that on my MAC OSX mail client I can not receive emails from ZOHO using IMAP. Gmail is set to IMAP and works OK. My company email account uses POP and works good as well. Is there anybody else who has such problem or this might be something with my email client...? I didi check for the settings but everything is as it was from the beginning. Honestly, I didn't change anything recently. It just stopped.
                                                                                                            • Modified approved time log

                                                                                                              I can’t seem to find a way to make change to approve time log entry. The case is the following. We pay the employees every 2 weeks, so employe A enter is time for the 2 weeks and then submit his timesheet. Now is superior approve the time he worked via
                                                                                                            • I want to Show the product list based on the drop Down

                                                                                                              in quotation app , amc form form i have Department drop down field and in subform i have loop up field item description taken from the anothe app PRO I want to show the product list look up based on the deparment selected example if they selected deparment
                                                                                                            • Inventory Barcode Creation - Add Picture of Item

                                                                                                              Hi I am trying to set up bar code labels and include a picture of the item on the label - any idea on how to add that field to the barcode generator?
                                                                                                            • Shared Snippets Everyone

                                                                                                              Hi, Now that the Shared Snippets have been released and I think will be the most used feature implemented in 2023 :) Creating and Using Snippets in Ticket Responses - Online Help | Zoho Desk Maintain consistency in ticket responses with shared snippets
                                                                                                            • Next Page