Xero import using Tracking feature?

XeroTrackingMappingImport Assumptions
8 posts / 0 new
Log in or register to post comments.
Last post
6 years ago
#1
X 0
Xero import using Tracking feature?

Hi,

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....

Anybody have success with this? Or is this one for the "list of design requests"....!

thanks

Kevin

6 years ago
Michael Hutchens A+ 162

Hi Kevin,

Modano is accounting package agnostic, we've just added some basic integration with Xero and QuickBooks because they both have APIs which make this quite easy to do. But it's not a primary focus, as the they're both just historical data sources and there's really only marginal benefit from using the APIs rather than simply exporting to Excel and then importing from the exported Excel file.

I'm not a Xero specialist, but I'm assuming that the Tracking feature within Xero is really just the ability to categorise your financial statements data into groups (e.g. regions, business lines, etc.), and that this is often how Modano users would want their historical data from Xero to appear in their Modano model. Let me know if I'm missing something here.

If this understanding is correct, I'd recommend using the following approach to import from Xero including your financial statements including the Tracking feature improvements:

  1. Open the most suitable dynamic template via the Modano tab, New menu, Dynamic Template;
  2. Export your historical financial statements from Xero into Excel;
  3. Open the exported financial statements in Excel.
  4. Activate the historical income statement in your dynamic template and load the Import Assumptions tool;
  5. Select Excel/CSV as the source of assumptions;
  6. Select the exported Xero income statement as the source workbook and range;
  7. Select 'New' mapping file in the mapping criteria step to create a mapping file to automate future imports (e.g. when updating the model each month). When importing from Xero you often also need to check the 'Reverse columns' check box because Xero exports are in newest to oldest order across columns;
  8. Map and reconcile the account as you'd normally do when importing directly from Xero; then
  9. Repeat this process for the historical balance sheet.

Going forward, you just need to export the latest month of income statement and balance sheet data and repeat this process, but it will be very quick because the mapping files you've created will automate the mapping in all future importations.

Here's each step of the Import Assumptions process:

​​​​​​​

Let me know if this workaround works for you. M.
6 years ago
James Longden A+ 87

Good stuff, Jun! 

Is there anything like DataDear for MYOB do you know?

Client with 30 TB's to consolidate...

Cheers. J.