Xero Import & Cash Flow Statement

This is specific for Xero because I haven't had a chance to encounter the situation in main ERP yet.

In Xero a transaction could be marked as cash or accrual basis. When import into Modano the import is based on accrual basis.

Despite opening and closing balance will tie, assume a situation the cash flow statement is very different in Xero vs Modano.

How could I add supporting calculation to bridge the gap?

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.

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.

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?



Subscribe to RSS - Xero