# \#financial-statements **URL:** https://pug.phocassoftware.com/tag/financial-statements/59.md [Latest](https://pug.phocassoftware.com/latest.md) · [Categories](https://pug.phocassoftware.com/categories.md) · [Tags](https://pug.phocassoftware.com/tags.md) --- ## [Permission controls per individual financial statement layout](https://pug.phocassoftware.com/t/permission-controls-per-individual-financial-statement-layout/3050)
**Author:** [@ann.pham](https://pug.phocassoftware.com/u/ann.pham)\ **Replies:** 1\ **Last updated:** [October 6, 2026, 3:17am UTC](https://pug.phocassoftware.com/t/permission-controls-per-individual-financial-statement-layout/3050 "2026-10-06T03:17:01Z")
Hi, In the Phocas Financial Statements module, all layouts created within a database are globally visible to anyone who has access to that database’s financial statements. While row-level security handles the underlyin… --- ## [Restricting Account-level View in Financial Statements](https://pug.phocassoftware.com/t/restricting-account-level-view-in-financial-statements/3006)
**Author:** [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\ **Replies:** 0\ **Last updated:** [March 16, 2026, 8:59pm UTC](https://pug.phocassoftware.com/t/restricting-account-level-view-in-financial-statements/3006 "2026-03-16T20:59:02Z")
Hi, I know I can use “Account Restrictions” to prevent users from drilling into the transaction level on Financial Statements, and I also know that I can set restrictions on a user’s license/access to the Financial Stat… --- ## [Retained Earnings Calculation](https://pug.phocassoftware.com/t/retained-earnings-calculation/2995)
**Author:** [@avazquez1](https://pug.phocassoftware.com/u/avazquez1)\ **Replies:** 0\ **Last updated:** [November 18, 2025, 7:41pm UTC](https://pug.phocassoftware.com/t/retained-earnings-calculation/2995 "2025-11-18T19:41:18Z")
We’ve come across a bit of a hurdle in reconciling between the Eclipse generated Financial Statement and the Phocas Financial Module. In Eclipse there exists a system generated account 47 (Current Year Eclipse Net Incom… --- ## [Cash Flow Statement - Non Cash Items](https://pug.phocassoftware.com/t/cash-flow-statement-non-cash-items/2933)
**Author:** [@sszafranek](https://pug.phocassoftware.com/u/sszafranek)\ **Replies:** 0\ **Last updated:** [April 29, 2025, 6:17pm UTC](https://pug.phocassoftware.com/t/cash-flow-statement-non-cash-items/2933 "2025-04-29T18:17:34Z")
Anyone know how to add non-cash items to a cash flow statement? Is this even possible in EDA? It would be nice to have this functionality for certain periods --- ## [Option to allow mapping Accounts without transactions](https://pug.phocassoftware.com/t/option-to-allow-mapping-accounts-without-transactions/2287)
**Author:** [@hakio](https://pug.phocassoftware.com/u/hakio)\ **Replies:** 6\ **Last updated:** [March 26, 2025, 7:28pm UTC](https://pug.phocassoftware.com/t/option-to-allow-mapping-accounts-without-transactions/2287 "2025-03-26T19:28:16Z")
When mapping accounts in the Financial Statement module’s Statement window - in the Accounts tab - ONLY account which have actuals transactions linked is shown. Accounts without transactions, cannot be mapped. Instead,… --- ## [Transaction Mode Report?](https://pug.phocassoftware.com/t/transaction-mode-report/2803)
**Author:** [@khogg](https://pug.phocassoftware.com/u/khogg)\ **Replies:** 0\ **Last updated:** [September 12, 2024, 5:54pm UTC](https://pug.phocassoftware.com/t/transaction-mode-report/2803 "2024-09-12T17:54:15Z")
Hello - Most of our employees are viewer licenses, and do not have access to Transactions/Transaction Details. Does anybody know of a way to run a scheduled report or create a dashboard so the viewer license users can l… --- ## [Year setting for future and past](https://pug.phocassoftware.com/t/year-setting-for-future-and-past/2771)
**Author:** [@Leila.Lu](https://pug.phocassoftware.com/u/Leila.Lu)\ **Replies:** 2\ **Last updated:** [August 14, 2024, 11:49pm UTC](https://pug.phocassoftware.com/t/year-setting-for-future-and-past/2771 "2024-08-14T23:49:19Z")
Hi, when we set up reports, we need to compare with the third most recent year (2022) and next first year (2025) , is that possible to add these 2 choices in the year list? this will be very helpful. thanks Leil… --- ## [Divisional Financial Statement](https://pug.phocassoftware.com/t/divisional-financial-statement/2646)
**Author:** [@yioriya](https://pug.phocassoftware.com/u/yioriya)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 8:04pm UTC](https://pug.phocassoftware.com/t/divisional-financial-statement/2646 "2024-02-12T20:04:36Z")
Hi, I am new here, so I apologize in advance if someone previously asked this. My GL Account has sub account, based on division. Ex. 4000-10 is sales for 1 division and 4000-20 is for another. This is happening virtua… --- ## [Excel export -subtotals & consolidated financial statements](https://pug.phocassoftware.com/t/excel-export-subtotals-consolidated-financial-statements/2331)
**Author:** [@KRIS\_M](https://pug.phocassoftware.com/u/KRIS_M)\ **Replies:** 1\ **Last updated:** [November 21, 2022, 6:58am UTC](https://pug.phocassoftware.com/t/excel-export-subtotals-consolidated-financial-statements/2331 "2022-11-21T06:58:53Z")
In order to issue profit & loss statements to all of our users, we export them to Excel. We’ve had to create a very complicated macro to run after we export to get in the format we want. Phocas has made many great impr… --- ## [Better filter-options in Financial Statements Accounts-mapping tab](https://pug.phocassoftware.com/t/better-filter-options-in-financial-statements-accounts-mapping-tab/2286)
**Author:** [@hakio](https://pug.phocassoftware.com/u/hakio)\ **Replies:** 0\ **Last updated:** [October 7, 2022, 7:39pm UTC](https://pug.phocassoftware.com/t/better-filter-options-in-financial-statements-accounts-mapping-tab/2286 "2022-10-07T19:39:39Z")
When working with Financial Statements and the account mappings, within the edit statement windows Account-tab, there are limited options for filtering the accounts, if only some of them are relevant for the Statement be… --- ## [Excel Add-In instead of "Download to Excel"](https://pug.phocassoftware.com/t/excel-add-in-instead-of-download-to-excel/2235)
**Author:** [@barb.berg](https://pug.phocassoftware.com/u/barb.berg)\ **Replies:** 1\ **Last updated:** [August 7, 2022, 9:46pm UTC](https://pug.phocassoftware.com/t/excel-add-in-instead-of-download-to-excel/2235 "2022-08-07T21:46:32Z")
Hi, We are using Financial Statements and need to provide our financials to externals in a very specific format. The reports are created in Excel and have the same layout every month. Unfortunately, the download from P… --- ## [YTD vs Custom Period?](https://pug.phocassoftware.com/t/ytd-vs-custom-period/2012)
**Author:** [@jmills](https://pug.phocassoftware.com/u/jmills)\ **Replies:** 4\ **Last updated:** [July 24, 2022, 9:27pm UTC](https://pug.phocassoftware.com/t/ytd-vs-custom-period/2012 "2022-07-24T21:27:06Z")
Is there anyway to run a P&L for YTD vs Custom Period? The Last Period check box works great if we’re looking at the current period but if we want to run this for Last Period or the period before we’ve not been able to r… --- ## [View Finanicals Statements with a "Moving" Period](https://pug.phocassoftware.com/t/view-finanicals-statements-with-a-moving-period/2210)
**Author:** [@luke.gallo](https://pug.phocassoftware.com/u/luke.gallo)\ **Replies:** 2\ **Last updated:** [July 18, 2022, 4:21am UTC](https://pug.phocassoftware.com/t/view-finanicals-statements-with-a-moving-period/2210 "2022-07-18T04:21:55Z")
Had a request from our Accounting team to view the Financials statements with a Moving Period for Rolling twelve months. I know the can switch from the Statements screen to the moving mode in financials. What they want t… --- ## [Grouping Expenses into Categories](https://pug.phocassoftware.com/t/grouping-expenses-into-categories/2188)
**Author:** [@wpratt](https://pug.phocassoftware.com/u/wpratt)\ **Replies:** 4\ **Last updated:** [June 9, 2022, 9:52am UTC](https://pug.phocassoftware.com/t/grouping-expenses-into-categories/2188 "2022-06-09T09:52:18Z")
Is there a way group certain expense line items together (i.e., group all payroll accounts together and have it subtotal to Total Payroll)? I guess my question is there a way to group accounts based on Level2PL? Any fi… --- ## [IBCS compliant data visualisation](https://pug.phocassoftware.com/t/ibcs-compliant-data-visualisation/2123)
**Author:** [@Tarek](https://pug.phocassoftware.com/u/Tarek)\ **Replies:** 0\ **Last updated:** [February 24, 2022, 2:03pm UTC](https://pug.phocassoftware.com/t/ibcs-compliant-data-visualisation/2123 "2022-02-24T14:03:53Z")
Could you improve the data visualisation in Phocas by making it IBCS compliant → About IBCS → --- ## [Statutory Consolidation](https://pug.phocassoftware.com/t/statutory-consolidation/2117)
**Author:** [@Tarek](https://pug.phocassoftware.com/u/Tarek)\ **Replies:** 1\ **Last updated:** [February 24, 2022, 6:20am UTC](https://pug.phocassoftware.com/t/statutory-consolidation/2117 "2022-02-24T06:20:08Z")
A nice add on product for the Financial Statement product would be a rock robust consolidation module to produce IFRS, and statutory consolidation with the usual features Inter Company Elimination Currency Translations… --- ## [Financial Intelligence - Synchronisation for the 3 Financial Statement : P&L, BS, CF](https://pug.phocassoftware.com/t/financial-intelligence-synchronisation-for-the-3-financial-statement-p-l-bs-cf/2116)
**Author:** [@Tarek](https://pug.phocassoftware.com/u/Tarek)\ **Replies:** 0\ **Last updated:** [February 22, 2022, 11:06pm UTC](https://pug.phocassoftware.com/t/financial-intelligence-synchronisation-for-the-3-financial-statement-p-l-bs-cf/2116 "2022-02-22T23:06:19Z")
When submitting budget on the P&L it will be great if Phocas could automagically synchronize the Balance Sheet & Cash Flow Statements. This would maybe require to generate journal/gl entries in Phocas ? This would be a… --- ## [Suggestions for Period Functionality](https://pug.phocassoftware.com/t/suggestions-for-period-functionality/2103)
**Author:** [@kai](https://pug.phocassoftware.com/u/kai)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 5:16am UTC](https://pug.phocassoftware.com/t/suggestions-for-period-functionality/2103 "2022-02-03T05:16:18Z")
Hi, Two request in regards to periods: It would be wonderful if the standard “Month” selection included a “Next” (and “After Next”) in addition to “Most Recent”, like this: It would very useful, also, to allow … --- ## [Statement View and Formatting](https://pug.phocassoftware.com/t/statement-view-and-formatting/2030)
**Author:** [@kai](https://pug.phocassoftware.com/u/kai)\ **Replies:** 5\ **Last updated:** [January 18, 2022, 6:10am UTC](https://pug.phocassoftware.com/t/statement-view-and-formatting/2030 "2022-01-18T06:10:18Z")
Hi, Is there some way to use the period view while looking at the statement in the “matrix view?” --- ## [Visualizing Financial Statement Lines](https://pug.phocassoftware.com/t/visualizing-financial-statement-lines/2089)
**Author:** [@kai](https://pug.phocassoftware.com/u/kai)\ **Replies:** 1\ **Last updated:** [January 18, 2022, 6:08am UTC](https://pug.phocassoftware.com/t/visualizing-financial-statement-lines/2089 "2022-01-18T06:08:53Z")
Hi, Is there a way to visualize several lines in the same graph? If not, this would be a great new feature, as it would make the data more compact on dashboards and would not require several graphs for, say for example… --- ## [Creating a Budget From Multiple Offset Periods](https://pug.phocassoftware.com/t/creating-a-budget-from-multiple-offset-periods/2048)
**Author:** [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\ **Replies:** 1\ **Last updated:** [November 25, 2021, 8:39pm UTC](https://pug.phocassoftware.com/t/creating-a-budget-from-multiple-offset-periods/2048 "2021-11-25T20:39:06Z")
Hey everyone! We are in the process of creating our budget for 2022, and I think we found a pretty cool workaround for an issue that came up. Figured I would share it in case somebody else is looking to do the same… Ou… --- ## [Hiding lines in Financial Statements](https://pug.phocassoftware.com/t/hiding-lines-in-financial-statements/1800)
**Author:** [@mnelson](https://pug.phocassoftware.com/u/mnelson)\ **Replies:** 3\ **Last updated:** [November 24, 2021, 1:24am UTC](https://pug.phocassoftware.com/t/hiding-lines-in-financial-statements/1800 "2021-11-24T01:24:53Z")
Does anyone know if it’s possible to hide lines in a financial statement in the Finance database? We have groups and calculations, but only want to show the calculations and somehow hide the groups that the calculations … --- ## [Financial Ratios](https://pug.phocassoftware.com/t/financial-ratios/1775)
**Author:** [@mnelson](https://pug.phocassoftware.com/u/mnelson)\ **Replies:** 8\ **Last updated:** [October 24, 2021, 8:46pm UTC](https://pug.phocassoftware.com/t/financial-ratios/1775 "2021-10-24T20:46:05Z")
Has anyone had success calculating ratios that use accounts from both P&L and the Balance Sheet? --- ## [Calculation Functions](https://pug.phocassoftware.com/t/calculation-functions/2009)
**Author:** [@kai](https://pug.phocassoftware.com/u/kai)\ **Replies:** 2\ **Last updated:** [October 21, 2021, 5:00am UTC](https://pug.phocassoftware.com/t/calculation-functions/2009 "2021-10-21T05:00:28Z")
Hi, Is there a way to use ‘CASE WHEN’ statements and other more complex methods in the calculation fields? Right no my Gross Profit % for one month is NaN as the last month’s revenue has not been included yet (is 0). T… --- ## [Balance Sheet - Ideas for New Capabilities](https://pug.phocassoftware.com/t/balance-sheet-ideas-for-new-capabilities/1984)
**Author:** [@kai](https://pug.phocassoftware.com/u/kai)\ **Replies:** 1\ **Last updated:** [September 29, 2021, 8:48pm UTC](https://pug.phocassoftware.com/t/balance-sheet-ideas-for-new-capabilities/1984 "2021-09-29T20:48:34Z")
Hey all, Under the Profit and Loss Stream, I really like the ability of comparing various streams and it can be very useful when, for example, you have several companies you want to display next to each other. For us, … --- ## [Ordering of Accounts/Dimensions](https://pug.phocassoftware.com/t/ordering-of-accounts-dimensions/1931)
**Author:** [@Amy](https://pug.phocassoftware.com/u/Amy)\ **Replies:** 1\ **Last updated:** [August 3, 2021, 3:44am UTC](https://pug.phocassoftware.com/t/ordering-of-accounts-dimensions/1931 "2021-08-03T03:44:11Z")
It would be nice if on the financial statements we could put accounts/dimensions in the order we want rather than them being alphabetical/numeric automatically. This is especially important on the balance sheet. --- ## [Formatting of Statement](https://pug.phocassoftware.com/t/formatting-of-statement/1719)
**Author:** [@KRIS\_M](https://pug.phocassoftware.com/u/KRIS_M)\ **Replies:** 2\ **Last updated:** [July 29, 2021, 9:43pm UTC](https://pug.phocassoftware.com/t/formatting-of-statement/1719 "2021-07-29T21:43:42Z")
Any way to format the Calculation lines? The Group headings are in bold but the Calculation headings are not… --- ## [Profit & Loss Statements - not showing previous month and YTD at same time against Budget](https://pug.phocassoftware.com/t/profit-loss-statements-not-showing-previous-month-and-ytd-at-same-time-against-budget/1709)
**Author:** [@Petern](https://pug.phocassoftware.com/u/Petern)\ **Replies:** 7\ **Last updated:** [July 22, 2021, 8:52pm UTC](https://pug.phocassoftware.com/t/profit-loss-statements-not-showing-previous-month-and-ytd-at-same-time-against-budget/1709 "2021-07-22T20:52:53Z")
In a Profit & Loss Statement mode, I cannot seem to show both the previous month (just completed)and the Cumulative YTD figures against Budget and include the Variance. I have Budgets loaded and can show one month at a … --- ## [Sorting sublevel](https://pug.phocassoftware.com/t/sorting-sublevel/1895)
**Author:** [@barb.berg](https://pug.phocassoftware.com/u/barb.berg)\ **Replies:** 1\ **Last updated:** [June 9, 2021, 4:25am UTC](https://pug.phocassoftware.com/t/sorting-sublevel/1895 "2021-06-09T04:25:21Z")
Hi all, How can I sort the “Sublevel” in financial statements? Example, “Group” is “Current assets”, “Sublevel” is “Cash, and cash equivalents”, “Prepaids”, “Other current assets”… The order of the “Groups” can be ad… --- ## [New Phocas Academy videos](https://pug.phocassoftware.com/t/new-phocas-academy-videos/1893)
**Author:** [@anon82048367](https://pug.phocassoftware.com/u/anon82048367)\ **Replies:** 0\ **Last updated:** [June 4, 2021, 3:52am UTC](https://pug.phocassoftware.com/t/new-phocas-academy-videos/1893 "2021-06-04T03:52:48Z")
We are pleased to release some new video material to help with getting to know the various Financial Statement features. You can watch them here https://www.phocassoftware.com/academy/phocas-financial-statements-orienta… [Next page](https://pug.phocassoftware.com/tag/financial-statements/59.md?match_all_tags=true&page=1&tags%5B%5D=financial-statements)