--- title: Understanding Why Budget Totals in Excel Don’t Match the Budget Overview Report description: Learn why Budget Overview totals may match in Aclarian but not in Excel exports when some exported values are stored as text, and how to fix the issue in Excel. --- [Skip to content](https://support.aclarian.com/aclarian-client-support-knowledge-base/understanding-why-budget-totals-in-excel-dont-match-the-budget-overview-report-client-facing-article#main-content) English - United States Show submenu for translations [Client Support Portal](https://support.aclarian.com/aclarian-tickets?hsLang=en-us) [![BRANDING ELEMENTS LIBRARY (11)](https://support.aclarian.com/hs-fs/hubfs/BRANDING%20ELEMENTS%20LIBRARY%20(11).png?width=500&height=141&name=BRANDING%20ELEMENTS%20LIBRARY%20(11).png)](https://Aclarian.com) Open main navigation Close main navigation - English - United States Show submenu for translations - [Client Support Portal](https://support.aclarian.com/aclarian-tickets) How can we help you? - There are no suggestions because the search field is empty. 1. [Aclarian Client Support Knowledge Base](https://support.aclarian.com/aclarian-client-support-knowledge-base?hsLang=en-us) 2. [Budgeting](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us) 3. [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us#reports) May 14, 2026 # Understanding Why Budget Totals in Excel Don’t Match the Budget Overview Report ## Learn why Budget Overview report totals may not match Excel export totals and how to fix text-formatted values so the numbers align. **Overview** You noticed that the totals in the Budget Overview report match, but the totals in your Excel exports do not. This can be confusing, especially when you’ve checked the rows multiple times and the numbers still don’t line up. After reviewing the files and screenshots, the issue is caused by a very common Excel formatting behavior. **Why the totals don’t match** Some of the dollar amounts in the exported file are being stored as **text** instead of real numbers. When Excel sees a value as text, it will not include it in the SUM function, even though the value looks like a normal dollar amount. You can identify these cells by the **small green triangle** in the top left corner. Because those cells are treated as text, Excel leaves them out of the total, which makes the sum appear lower than the amount shown in the report. **How to fix the issue in Excel** Follow these steps to convert the text values into real numbers: 1. Select the cells that show the green triangle 2. Click the warning icon that appears 3. Choose **Convert to Number** Once the values are converted, the SUM function will include all rows, and the total will match the report. ![](https://support.aclarian.com/hubfs/Knowledge%20Base%20Import/47046495213716.png)   **How the system calculates the Budget Outflow total** It also helps to understand how the system builds the total shown in the report. The Budget Outflow amount is made up of **two separate sections**: - **Personnel and Operating expenses** - **Capital expenses** These sections belong to different account characters, so the system totals each one separately and then combines them to produce the final outflow amount of **$85,371,214**. When Excel excludes text‑formatted values, it looks like the report and the export don’t match, but once everything is converted to numbers, the totals align. **Summary** The difference you’re seeing is caused by some values being stored as text in Excel. Converting those cells to numbers will allow Excel to include them in the SUM, and the totals will match the Budget Overview report. If you need help reviewing the file or want us to double‑check the totals with you, we’re happy to assist. - [Billing/AR](https://support.aclarian.com/aclarian-client-support-knowledge-base/billing-ar?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/billing-ar?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/billing-ar?hsLang=en-us#data-management) - [Budgeting](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us#data-management) - [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/budgeting?hsLang=en-us#reports) - [Capital Assets](https://support.aclarian.com/aclarian-client-support-knowledge-base/capital-assets?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/capital-assets?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/capital-assets?hsLang=en-us#data-management) - [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/capital-assets?hsLang=en-us#reports) - [Cashiering](https://support.aclarian.com/aclarian-client-support-knowledge-base/cashiering?hsLang=en-us#main-content) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/cashiering?hsLang=en-us#data-management) - [General](https://support.aclarian.com/aclarian-client-support-knowledge-base/general?hsLang=en-us) - [General Ledger](https://support.aclarian.com/aclarian-client-support-knowledge-base/general-ledger?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/general-ledger?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/general-ledger?hsLang=en-us#data-management) - [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/general-ledger?hsLang=en-us#reports) - [Payments](https://support.aclarian.com/aclarian-client-support-knowledge-base/payments?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/payments?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/payments?hsLang=en-us#data-management) - [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/payments?hsLang=en-us#reports) - [Project & Grants](https://support.aclarian.com/aclarian-client-support-knowledge-base/project-grants?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/project-grants?hsLang=en-us#forms) - [Reports](https://support.aclarian.com/aclarian-client-support-knowledge-base/project-grants?hsLang=en-us#reports) - [Purchasing](https://support.aclarian.com/aclarian-client-support-knowledge-base/purchasing?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/purchasing?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/purchasing?hsLang=en-us#data-management) - [Treasury Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/treasury-management?hsLang=en-us#main-content) - [Forms](https://support.aclarian.com/aclarian-client-support-knowledge-base/treasury-management?hsLang=en-us#forms) - [Data Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/treasury-management?hsLang=en-us#data-management) - [User Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/user-management?hsLang=en-us) - [Workflow Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/workflow-management?hsLang=en-us) - [FAQs](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#main-content) - [Budgeting](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#budgeting) - [Capital Assets](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#capital-assets) - [Cashiering](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#cashiering) - [General / Login](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#general-login) - [General Ledger](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#general-ledger) - [Payments](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#payments) - [Purchasing](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#purchasing) - [User Management](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#user-management) - [Workflow](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#workflow) - [Templates](https://support.aclarian.com/aclarian-client-support-knowledge-base/faqs?hsLang=en-us#templates) - [Aclarian Enhancements](https://support.aclarian.com/aclarian-client-support-knowledge-base/aclarian-enhancements?hsLang=en-us) [![Aclarian\_logo\_Horiz\_4CTM](https://support.aclarian.com/hs-fs/hubfs/Aclarian_logo_Horiz_4CTM.jpg?width=375&height=64&name=Aclarian_logo_Horiz_4CTM.jpg "Aclarian_logo_Horiz_4CTM")](http://Aclarian.com) Copyright © 2026, Aclarian LLC