Import Assumptions

Importing Balance Sheet from Xero


When importing a Balance Sheet from Xero, I have specified the last import period end date to be say, 19 March. The mapping page also confirms the period ending date to be 19 March.When it imports, it is importing the balance sheet as at today ie 28 March. I am using a weekly time series.

Xero reports used to only be able to pick up the balance sheet dated end of month but new balance sheet report templates enable mid month dates to produce a balance sheet on any date retrospectively.

Mapping Xero loans

I have some loans in Xero and to get the feeds to come through they are set up as bank accounts in Xero.  When I "import the assumptions" it "wants" to go to the Cash section.  If I map it to the "Debt" section it imports it as a negative number and unbalances the balance sheet.  Does anyone know how to reverse the nature of an account on import or do I just have to amend it after I import?

I've amended the reporting codes in Xero but this didn't help.

Xero import with Tracking Categories

Appreciate not entirely a Modano question, but maybe something that others here have faced: how to import from Xero with Tracking Categories.

I know that pulling data through (into Modano) by individual Tracking Category is possible - and works perfectly where the financials are tracked by Region for example (where number of regions may be relatively simple). But I have a couple of projects that have their PRODUCTS booked as Tracking Categories and wish to model in Modano by Product. And I am talking about dozens (creeping to 100+) of Products.

Import Assumptions into single Category Block without overwriting unmapped items

I'm hitting an issue with an Import from xls -> Modano model, where I have a single category block that I don't want to break up (COGS that is part of a bespoke Inventory arrangement), where I want to import from TWO different xls source files. The problem is that my current experience doing this overwrites the whole Category block, notwithstanding only "adding" to defined lines in each case.

Xero import using Tracking feature?


Has anybody managed to capture the Tracking feature within Xero to integrate with Modano's mapping facility? I'm referring to Xero's relatively limited feature whereby a Tracking Category can be defined, say "Sales Region", with associated Tracking Options of "Northern Division", "Southern Division, "Western Division" - at the Sales/Invoice stage within Xero this is selected and thereafter is a reportable element. This would be fabulous to harness withtin Modano's mapping from Xero....

Managing Fixed Assets import from Xero


I am importing my first set of Xero accounts from a client into my model and finding that Xero is a little untidy in the presentation of Fixed Assets: Computer Equipment, Computer Equipment Additions, Computer Equipment Laptops for example. Has anyone hit this problem before? i.e. potentially 4 or 5 import lines, to feed 1 Category. I don't want to ask client to re-arrange their Xero setup, but then again I don't want to end up with 20 Categories in my Fixed Assets block....

Am I missing something?



Customisation of Modano

Hi All, 

I have reviewed all notes and tested different templates available in the Modano library, however I cannot find notes or tutorials providing guidance re the following customisation:

Import assumptions tool - default header and data column?

How do I set up my source workbook so that the import assumptions tool automatically picks up the correct header column and data columns? I'm using a best-practice, non-modular workbook for the source data, which means there is an 'Up arrow' in column A; is this the cause why the suggested header row in the assumptions input tool is Column A?

Also, I have actual historical data sourced from SAP in a time series format starting in Column J, but the start colum for data import seems to be randomly chosen (starts in column Y)...

Subscribe to RSS - Import Assumptions