Community Forum

Topic Replies Activity
Re-order (multiple copies) Module links in Precedent Module Links pa... by Khang Normal topic
Hi Everyone, I am hoping there is an easy solution I might not be aware of. I have multiple mirrored copies of a...
0 1m
HC
parent child hierarchy module as category by Hengjia Chen Normal topic
Hi Modano team, I am looking for solution for following scenario. To build a parent child hierarchy revenue module,...
4 1m
Disable auto-Category Block Merging by Khang Normal topic
Hi Brains Trust, I have once ticked the box "do this for all future occurrences" for when the prompt window pops up to...
1 1m
PA
Consolidation Query by Patrick Arnfield Normal topic
Hi Modano Team,  I am building a consolidated 3-satement cashflow model for a client of mine with two operating...
1 1m
AZ
Total Monthly Figures to Quarter and Year by Aaron Zhou Normal topic
I have the Modano spreadsheets built by month, from Jan 2019 to Dec 2024, 60 months. I want at the end of each quarter...
6 2m
Adding Multiple Categories Groups by Jun Yan Normal topic
Hi all, Been a while, a lot of awesome updates coming through in the latest versions. One seemingly small thing, but...
3 2m
SD
Contra Capital Assets for Accumulated Depreciation by STEVEN DOBESH Normal topic
I'm working on an account that uses Asset Accounts to record capital and intangible assets and then credits an expense...
0 2m
TK
Using Excel Version History by Tarjei Kirkesaether Normal topic
Hi Modano team, What is the official advise on using the Version History in Excel (which is avaliable when saving to...
1 2m
Make Cell Trigger to Reset Assumptions by Khang Normal topic
Hi Brains trust, Is it possible to make a cell trigger to reset assumptions to the active module component/cell block...
1 3m
HC
Troubleshoot module as category by Hengjia Chen Normal topic
I am looking for method to troubleshoot an existing error from module as category setup. The category is the summary...
10 3m
IC
How do I insert a Freeform worksheet? Help! by Irene Chu Normal topic
2 3m
Bl
Alternative income statement layouts by Blake Gavin Miller Normal topic
Hi Modano team - Loving release 11 well done - tool is looking very slick    One suggestion - having an income...
2 3m
Intercompany Dividend Eliminations by James Longden Normal topic
Attached is a workbook that steps through the eliminations required for removing intercompany dividends between a...
3 4m
Cash Bridge Chart Module by James Longden Normal topic
We recently had a client looking to get a better visual representation of their forecast closing cash and key movements...
2 4m
HC
ChatGPT by Hengjia Chen Normal topic
As a holiday project I created a custom GPT named Ask Modano. I am trying to use it to answer questions like a FAQ...
2 5m
MT
Revenue & Expense Modelling around School Terms by matt.tapps Normal topic
Hey all, I'm wondering if anyone has any module examples for modelling revenue that is generated on a school term...
1 6m
BM
Weekly cash flow forecast for a monthly time series historical and f... by blakem Normal topic
A while back I am sure James posted about Monthly to weekly cash flow forecasting?  What was the name of the post -...
5 6m
GM
Changing Multiple Allocations at once by gmajor Normal topic
Hi All, Is there a shortcut way of changing (say) all the Expenses Allocations for Creditors from "None (Cash)" to "...
2 6m
Wi
Change the Color of Historical Data by William Thomson 1 Normal topic
How does one change the color of historical data...for example, how can I change the color of the text circled in red.....
3 7m
Export financials in database format table by Josh B Normal topic
Hi I have only just started using Modano and already see massive benefits. I was able to build a 3-way model in hours...
9 8m
YS
Best way to add custom named range by Yury Suturin Normal topic
What is the best way to add custom non Modano Named range defined in memory? Name Manager in Modano book is replaced...
2 8m
HC
Multi workbook and Memory Consumption by Hengjia Chen Normal topic
I bump into a problem this week with a multi workbook setup 14 workbooks, three tiers with parent, child and grandchild...
3 8m
CT
Forecasting assumptions is yearly but need monthly for modelling... by Cornell Tsiang 1 Normal topic
Hello I am using the single entity model (COA4) with budgeting and scenario. Historical data is very limited, only 2...
3 8m
CFO Dashboards by James Longden Normal topic
Hi Team. This content is aimed at reporting for CFOs, key stakeholders and decision-makers.  The aim of a CFO...
6 8m
YS
Learning material questions by Yury Suturin Normal topic
Since I am going through the training modules - thought it may be useful to discuss some items which look to me like...
0 8m

Pages

Tags

32-bit64-bitAccruals vs. Cashalert checksAmounts & Growth Ratesannual assumptionsAnnual BudgetAPIAsset RevaluationsAsset Salesassumption stylesATPauditingauto-recoverAutoSavebackupBalance SheetBeginnerbowtiebudget balance sheetBudget Income Statementbudget variance analysisBusiness UnitsCalendar YearCapexCapital IQCapital structurecareers in modellingCash Flow StatementCash Forecastcash payment delaysCash SweepCategoriescategories within categoriesCategory Blockscategory layout sectionCell BlocksChange Versionchart of accountsChartscircular referencesclassifications Multi Business Unitscluster IDCo-AuthoringCOGSCollaborationcolorsColumn WidthcompatibilityConsolidationsContentContents SheetContra Accountconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorsCreditors CategorycustomCustom Formulascustom modulescustom themesDashboardsDataData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdiscussiondividendsdocument management systemsDrop Down Boxesdrop downsDuplicatedynamic textEliminationsEquityerror checksExample ModelsExcel File FormatsExcel PerformanceexportExport Modulesfactoringfailure to openfilteringFinancial Modeling World CupFixed AssetsFontsforecastformulasFreeformfreeform formulasFreeze PanesFund Managementfunds managementGANTTGantt ChartgearingGraphics AccelerationGraphsGridlineshardwareheadingsHide ColumnsHistorical Data MappingHyperlinksImport Assumptionsincome statementInputsInsert ColumnInsert CommentIntercompanyInvalid PrecedentsinventoryIRRkeyslanguagelaptopsLarge FilesLarge WorkbooksLast historical monthLBOLearning & AssessmentlibrariesLinked WorkbookslinksListed companiesLookup TableslookupsM&AMacMacromanufacturingMappingmemoryMemory LimitsMergeMergingMirrormirroringModano XModule As CategoryModule componentsModule Content ReportModule LinksModule Namesmodulesmodules as categoriesMove AssumptionsMulti Business UnitsMulti-Business Unit PerformanceMulti-WindowmultilingualMultiple Periodicitiesmultiple time seriesMultiple WorkbooksNamed Formulasnon-financeOneDriveOptimize ModanoOptimizingother expensesother revenueOther RevenuesOutputsOverview SheetPanel Boardpartially linked modulesperiodicitiespinch pointPowerQueryPrepaid ExpensesPresentationsProject ManagementPropertyProperty FeasibilityProperty Feasibility assumptionsProtected Sheetsrange namesRange Namingrecover filesredundant categoriesRegionsRevenue DebtorsRevenue driversReverse Time SeriesreviewrevolverRibbonrolluprough calculationsSaaSsalaries & wagesScenario AnalysisScenariossearch & repairSeasonalitySensitivitiesSharePointSharingSheet NamesSheet Namingshort term assetshort term liabilitysimple taxsimulationspecificationsStart-Upstylessubtotalstabstaxteam membersTeamsthemestime framestime seriesTime Series AssumptionsTime Series Sheet Columnstime series; monthlyTop 5 Expenses DashboardTotal Row On TopTrackingtracking categoriesTransfer AssumptionstranslationUI Runtime ErrorValuationVariable DriversVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly cashflowweekly time seriesWindows 11Windows DefenderWorkbook StructureWorkbook ThemeWorking CapitalXeroXLSBXML metadata write errorYtd
New posts
No new posts
Hot topic with new posts
Hot topic without new posts
Sticky topic
Locked topic
Subscribe to RSS - Community Forum