Solution of the Week: Financial Reports with Impactful Visuals

Solution of the Week: Financial Reports with Impactful Visuals

Finance reporting is a critical part of understanding an organization’s financial health. With Zoho Analytics, you can easily create dynamic reports such as Balance Sheets, Budget Statements, and Profit and Loss Statements.

Now, with the release of Zoho Analytics 6.0, the platform offers even more advanced tools to optimize the financial report view. While Zoho Analytics has always enabled comprehensive financial reporting (through its integration connectors for Zoho Books, QuickBooks, Xero, Sage), the latest version enhances this with powerful visual features like Data Bars, which provide clearer insights into performance trends.

This document outlines how these reports can be generated using simple drag-and-drop functionality and customizable features in Zoho Analytics.

Creating a Balance Sheet Using Finance Data

Generating a Balance Sheet in pivot using Zoho Analytics allows you to visualize your organization’s financial position in a comprehensive and structured way.
  1. Drag and Drop the Data: Start by selecting the Balance sheet base type, Account group, Balance Sheet Account Type, and Balance Sheet Account Name from the Accounts table and drop them into the Rows shelf. Drag and drop the Credit Amount, Debit Amount, and Balance Sheet Total from the Accrual Transactions table into the Data shelf.


  2. Layout Adjustments:
    1. Navigate to Settings > Layout.


    2. Change the Layout to Compact.
    3. Check Increase Font Size for each higher group in Rows.
    4. Uncheck Show row numbers.
    5. Uncheck Show vertical lines between them.
    6. Set Column Width to Fit to Screen.


  3. After making layout adjustments, click Apply to finalize the formatting.

  4. Go to Visuals and select Data Bars With Data to improve the presentation of financial data, making it easier to interpret key insights visually.


By following these steps, you will generate a clear and structured Balance Sheet that highlights your organization's assets, liabilities, and equity.


Key Features of the Balance Sheet Report

  1. Increased Font Size for Key Categories:
    Emphasizes important financial categories like Assets, Equity, and Liabilities, improving readability and focus.
  2. Compact Layout:
    Ensures a clear, organized display of financial data, enabling efficient consumption of the report.
  3. Line Removal for Clean Aesthetics:
    Removal of vertical and horizontal lines results in a cleaner visual presentation, improving the user experience.
  4. Data Bars for Quick Insights:
    Visual data bars provide a quick snapshot of financial status, allowing users to identify key trends at a glance.
  5. Timeline Filter for Flexibility:
    Filters allow users to view financial data across different periods, making it easier to analyze financial trends over time.
In Zoho Analytics, utilizing the Timeline Filter allows users to transform static financial data into a time-based, dynamic report. The formulas used in creating this filter enable detailed insights into financial performance over a selected period. Below, we explain the key aggregate formulas and how they enable users to achieve greater flexibility and customization, going beyond the typical app potential.

  • Opening Balance Formula
    sum_if("Accrual Transactions"."Transaction Date" < ${system.timeline.date.from},if("Accounts"."Account Base Type" in ('Asset') OR ("Accounts"."Account Base Type" in ('Equity') and "Accounts"."Account Name" in ('Drawings')),"Accrual Transactions"."Debit - Credit","Accrual Transactions"."Credit - Debit"),0)
    This formula calculates the Opening Balance for a selected period by summing transactions that occurred before the specified date (timeline.date.from). 
    This approach allows users to view the Opening Balance as of a given date, making it highly flexible for periods that differ across user's datasets.



    if("Accounts"."Account Base Type" in ('Asset') OR ("Accounts"."Account Base Type" in ('Equity') and "Accounts"."Account Name" in ('Drawings')),"Accrual Transactions"."Debit - Credit","Accrual Transactions"."Credit - Debit")
    This part of the formula can be customized based on the unique financial structure you follow.

  • Period Balance Formula

    sum_if("Accrual Transactions"."Transaction Date" > ${system.timeline.date.from} and "Accrual Transactions"."Transaction Date" <= ${system.timeline.date.to},if("Accounts"."Account Base Type" in ('Asset') OR ("Accounts"."Account Base Type" in ('Equity') and "Accounts"."Account Name" in ('Drawings')),"Accrual Transactions"."Debit - Credit","Accrual Transactions"."Credit - Debit"),0)

    The Period Balance formula calculates the net balance of transactions within a specific time range, defined by the timeline filter. The formula sums transactions between the start date (timeline.date.from) and the end date (timeline.date.to). This provides users with a snapshot of their financial activity for any custom date range they select.



  • Closing Balance

    sum_if("Accrual Transactions"."Transaction Date" <= ${system.timeline.date.to},if("Accounts"."Account Base Type" in ('Asset') OR ("Accounts"."Account Base Type" in ('Equity') and "Accounts"."Account Name" in ('Drawings')),"Accrual Transactions"."Debit - Credit","Accrual Transactions"."Credit - Debit"),0)

    The Closing Balance formula calculates the final balance as of a selected date (timeline.date.to). It works by summing all transactions up until the specified date, following the same account type distinctions used in the previous formulas.
     

    This formula is essential for determining the financial standing of an organization at the end of a reporting period, such as the end of a quarter or year.


Follow the below steps to create opening and closing balances with timeline filters:
  1. Drag and drop the created aggregate formulas into the data shelf.
  2. Select Data as row from the drop-down.


  3. Click on Show/Hide, then select Totals.


  4. Click on Columns drop-down, then set the Opening Balance as Top.

  5. Navigate to Settings > Layout and set Column Width as Equal. Provide Width value as required in px.


  6. Click Apply.
  7. Check Include Timeline Filter.


    The Timeline Filter is now enabled, and users can apply time-based filters to their data.


By utilizing these timeline-based formulas, Zoho Analytics allows users to move beyond static, historical reporting and into dynamic financial analysis. With the Timeline Filter, users can interact with their data in a more flexible way, selecting custom periods to analyze financial trends over time.

Click here to access the sample workspace.

Creating a Budget Statement

A Budget Statement helps compare actual financial performance against projected budgets, identifying variances and areas of concern. This visually enhanced report is designed to help businesses quickly assess deviations between expected and real expenditures, allowing for better budget management and financial decision-making.
  1. Drag and drop Account into the Row shelf, and Actuals and Budget into the Data shelf from the Budget vs Actual table.


  2. Add Report Formula:
    1. Click Add Report Formula to create custom calculations.


    2. Name the formula column appropriately (e.g., “Deviation”).
    3. Set Data Type as Decimal Number
    4. Create a formula to calculate the difference between actuals and budget as shown in the image.


    5. Click Save.
    6. By following the same steps mentioned above, create one more formula to calculate the percentage difference between actuals and budget as shown in the image.


    7. Click Save.
      The created formulas will appear in your data shelf and columns, reflecting in the report.


  3. Go to Visuals and choose Data Bars With Data for a more intuitive understanding of budget performance.
By following these steps, you will have a detailed Budget Statement that compares actual spending to the budget, highlighting deviations.


Report Structure and Visuals

  1. Account Breakdown
    The report is organized by account categories, such as Bank Fees, Cost of Goods Sold, and more, showing both Budgeted and Actual amounts for each category.
  2. Key Columns
    The report includes the following key columns:
    1. Total Budget - Displays the budget allocated for each account.
    2. Total Actuals - Shows the actual amount spent or earned for each account.
    3. Variance (Deviation) - Represents the difference between the budgeted amount and the actuals.
    4. Variance Percentage (Deviation %) - This column shows the percentage difference between the budgeted and actual amounts, highlighting under- or over-expenditure.
  3. Data Bars for Clarity
    1. Green Bars indicate favorable performance (within or under budget).
    2. Red Bars highlight overspending or budget deviations (e.g., Office Expenses or Rent).

Key Features of the Budget Statement Report

  1. Visual Representation of Deviations
    Data bars visually indicate how spending aligns or deviates from the budget, enabling quick identification of problem areas.
  2. Concise Overview of Financial Performance
    The report provides a clear overview of actual versus budgeted performance, allowing decision-makers to assess financial health efficiently.
  3. Enhanced Usability with Percent Deviations
    Percentage-based deviation columns allow users to understand the scale of over- or under-performance relative to the budget, making it easy to identify areas that are significantly off track.
Click here to access the sample workspace.

Creating Profit and Loss report

A Profit and Loss (P&L) report in Zoho Analytics helps businesses assess their revenue, expenses, and profitability over a specific period. By following these steps, you can create a detailed and visually engaging P&L report.
  1. Drag and drop Account base type, P&L Operating Profit Type, P&L Gross Type, Base type P&L, and Account Name into the Columns shelf from the Accounts table and Profit and Loss Balance into the Rows from Data shelf from the Accrual Transactions table.


  2. Layout Adjustments:
    1. Navigate to Settings > Layout.


    2. Change the layout to Compact.
    3. Set Indent Level to 3.
    4. Check Increase Font Size for each higher group in Rows to make key categories more visible.
    5. Uncheck Show row numbers for a cleaner report.
    6. Uncheck Show Vertical Line between Each Column to streamline the visual presentation.
    7. Set Column Width to Equal and specify the width as required in px.


  3. Once the layout adjustments are made, click Apply to lock in the formatting.
  4. Click Themes, and select the second theme. Set Row Spacing as 2.


  5. Navigate to Visuals and select Data Bars With Data to provide a quick and clear visual representation.


By following the above steps, you will create a Profit and Loss report which provides a concise and structured view of your business’s financial performance, making it easy to track profitability over time and identify key financial trends.



Click here to access the sample workspace.

Zoho Analytics provides an intuitive and customizable platform for generating comprehensive Balance Sheets, Budget Statements, and Profit & Loss reports. With its drag-and-drop functionality and powerful visual tools, Zoho Analytics transforms finance reporting into a data-driven process that improves decision-making, forecasting, and resource management.
Start leveraging Zoho Analytics today to create reports that provide actionable insights, helping your organization thrive financially!

    • Recent Topics

    • Is there a way to automatically add Secondary Contacts (CCs) when creating a new ticket for specific customers?

      Some of our customers want multiple contacts to receive all notifications from our support team. Is there a way to automatically add secondary contacts to a ticket when our support team opens a new ticket and associates it with an account? This would

    • How to Set Up Zoho Mail Without Cloudflare on My Website

      I'm having some trouble with Cloudflare here in Pakistan. I want to configure Zoho Mail for my domain, but I'm not sure how to set it up without going through Cloudflare. My website, https://getcrunchyrollapk.com/ , is currently using CF, but I'd like

    • Spam is Being Forwarded

      I am filtering a certain sender directly to the Trash folder. Those messages are still being forwarded. Is this supposed to happen?

    • IMAP Block

      My two accounts have been blocked and I am not able to unblocked them myself. Please respond to email, I am traveling and this is urgent.

    • "DKIM not configured"

      Hello. I have been attempting get the DKIM verified but Toolkit keeps sending the message that it is not configured, but both Namecheap and Zoho show it as configured properly. What am I missing?

    • Zoho mail with custom domain not receiving email

      i registered zoho mail with my own domain. I can login and access the mail app. I tried to send email from an outlook email account and an icloud email account. Both emails were not received. My plan is free. I also tried to send email from this zoho

    • Set connection link name from variable in invokeurl

      Hi, guys. How to set in parameter "connection" a variable, instead of a string. connectionLinkName = manager.get('connectionLinkName').toString(); response = invokeurl [ url :"https://www.googleapis.com/calendar/v3/freeBusy" type :POST parameters:requestParams.toString()

    • Waterfall Chart

      Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?

    • Help Center and SEO: Any Benefit to My Domain-Mapped Website Ranking?

      First of, I love the Help Center which I've just decided to integrate into my website to replace its old-fashioned FAQs. So much more to achieve there now! Lots of new benefits to the site visitors and to me in terms of organizing and delivering all the

    • Issue with Importing Notes against Leads

      Hi, I am attempting to import some Notes into Zoho CRM which need to be assigned to various Leads. I have created a csv file which I am testing that contains just one record. This csv file contains the following columns: Note Id Parent Id       (I have

    • Trigger a Workflow Function if an Attachment (Related List) has been added

      Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger

    • Creator Add Records through API - Workflows not triggered ?

      Hi Everyone, I am trying to add records to my Creator application through a third party app that I am developing. Currently, I am testing this through Postman. The records I need to add have a lot of workflows to run to populate dropdowns, fields, use

    • Zoho Error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details

      Hello There, l tried to verify my domain (florindagoreti.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details. Screenshot Given Below -  please check what went wrong. Thanks

    • Important Update: Changes to Google Translate Support in Zoho SalesIQ

      We’re updating our default chat translation options across all Zoho SalesIQ data centres to offer a more secure, in-house solution for your translation needs. What’s changing? We will be offering Zoho Translate (our in-house tool) as the default translation

    • FSM Improvement Idea - Show an Import button when there is no data

      I am setting up FSM for a client and I noticed that there is no option to import data, see screenshot below. Even when you click Create Contact there is only an option to Import from Zoho Invoice. It is only after you add at lease 1 record that the Import

    • Zoho CRM Community Digest - July P1 | 2025

      Hey everyone, The start of July 2025 marked a special milestone: 200 posts in our Kaizen series! For those new here, Kaizen is a go-to series for Zoho CRM developers, where we regularly share best practices, tips, and expert insights to help you build

    • Join our BI & Analytics Workshop at Zoholics UK 🇬🇧

      Hello users, We are thrilled to announce a hands-on workshop at Zoholics UK, 2025, led by Ashwinth and Alan, our Product Experts. This session is designed for anyone who wants to move beyond raw data and truly understand their business performance using

    • What’s New in Zoho Expense (April – July 2025)

      Hello users, We're happy to bring you the latest updates and enhancements we've made to Zoho Expense over the past three months, which include introducing the Trip Expense Summary report in Analytics, extending Chatbot support to more editions, rolling

    • Weekly Tips: Insert frequently used phrases in a jiffy using Hotkeys

      You often find yourself using similar phrases in an email —like confirming appointments or providing standard information. Constantly switching between the mouse and keyboard interrupts your flow and slows you down.Instead of typing the same phrases over

    • Undo Command in Notebook

      It would be handy to have an Undo in the row of icons at the bottom of the notes.

    • Improved UI for a Seamless User Experience - Calls, Tasks, and Meetings

      Hello all, We are making UI unification across CRM so that the UI experience is seamless across the product. As part of that effort, we have made changes to the details page of activity-based module records—Meetings, Calls, and Tasks. Let's look at these

    • New Customization options in the module builder: Quick Create and Detail view

      Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the number

    • Cross References Do Not Update Correctly

      I am using cross references to reference Figures and current am just using the label and number, i.e. Figure #. As seen here: When I need to update the field, I use the update field button. But it will change the cross reference to no longer only including

    • Add multiple users to a task

      When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman

    • Narrative 9: GC—Meaningful conversations that benefit your customers

      Behind the scenes of a successful ticketing system - BTS Series Narrative 9: GC—Meaningful conversations that benefit your customers Customers often seek immediate solutions, which is why self-service options are essential. Guided Conversations provides

    • FSM App Oddity

      We recently rolled out FSM to our technicians, and only one technician is having an issue. He's using an iPhone with iOS 18.6 installed. When he goes to service appointments using the calendar icon at the bottom of the app, he gets a list view only. Typically,

    • Cliq Not Working !

      Zoho Cliq has been experiencing connectivity issues since this morning. The app is unable to establish a connection with the server.

    • Injecting CSS into ZML pages

      Is there a way to inject CSS into ZML pages? Use case: 1. Dashboard displays 'Recent Activities' card displaying a list of newly added records 2. Each item in list links to the record onClick 3. When a user points the cursor over an item in the list,

    • Power of Automation :: Automated Weekly Notifications for Unapproved Timesheets

      Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate

    • Extracting Data from Sitelink APIs

      Hi All, I'm working to pull data on Sitelink using API calls but i can't seem to extract it. If you click expand, you will see it has a lot of data in it. I tried extracting from the map but it's not giving me anything. Is there a workaround on this or

    • Export a list of fields for all modules in a spreadsheet with specific field data

      Many of my clients are using spreadsheets to create lists of fields for all modules when starting a new implementation or when updating an existing setup. This is a useful process but also a very time consuming one. It would be good a list of fields could

    • [Important announcement] Zoho Writer will mandate DKIM configuration for automation users

      Hi all, Effective Dec. 31, 2024, configuring DKIM for From addresses will be mandatory to send emails via Zoho Writer. DKIM configuration allows recipient email servers to identify your emails as valid and not spam. Emails sent from domains without DKIM

    • 【Zoho Backstage】2025年7月のアップデート紹介

      本投稿は、本社のZoho Desk コミュニティに投稿された以下の記事を翻訳し、一部抜粋したものです。 What's New - July 2025 | Zoho Backstage ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 本投稿では、Zoho Backstage の直近のアップデートを3点抜粋して、ご紹介します。 目次 1.参加可否の確認：RSVP 2.証明書作成ツール：Certificate Builder 3.登録の承認 ：Registration Approval 1.参加可否の確認：RSVP

    • Option to select location?

      As a business coach, I meet with clients at various public locations. I have two or three pre-determined locations that I meet at. I would like the client to choose the location when booking an appointment. Is there a way to do that with a single service, or is the best way to accomplish this by creating one service for each location offered?

    • Can we have Backorder Management ?

      Can we have Backorder Management ?

    • Display a field of an Account on the Ticket view

      Hi there, We would like to display of the Account of the user submitting a ticket on the ticket view. See for example: How can this be achieved? It doesn't really matter where it will be placed as long as it is shown there. Thanks, Snir

    • Two factor authentication for helpdesk users

      The company i work for wants use the helpdesk site in Zoho desk, as a place for their distribution partners to ask question and look for information about our product. The things there is suppose to go up there is somewhat confidential between my company

    • Remove "Invalid entries found. Rectify and submit again" modal

      Following up on a post from a few years back, but can the Zoho team consider either removing the 'Invalid entries found. Rectify and submit again' modal that displays for empty mandatory fields OR allow an admin to change it? I've built a custom error

    • Insurance Agencies

      I am reaching out to see if anyone has any experience in the Insurance Agency world with using Zoho exclusively for the CRM and commissions side of things. Lots of strong features like drip campaigns, meeting, calendars, emails, can all be found in here.

    • Problem with Egyptian internet ISP

      Dears,  We have problem with our ADSL internet SP, That your site not working with. So, we contact them and they asking us to contact you to solve this problem.  The problem that when we are connecting to Tedata ADSL your website not working (Business Email).  BR,, Mohamed Omar 

    • Next Page