{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/5799c1a17b4c4d949b00a2591e7c5b5d\" frameborder=\"0\" width=\"1728\" height=\"1296\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1296,"width":1728,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1296,"thumbnail_width":1728,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/5799c1a17b4c4d949b00a2591e7c5b5d-0dfe97a86d8808e4.gif","duration":698.488,"title":"Xero SCOA import","description":"This Loom explains how to export the chart of accounts from Xero and import it into Franmetrics. The author notes that Xero’s export cannot be filtered between P and L and balance sheet accounts, and that there are no sub-accounts, so the CSV must be cleaned to exclude balance sheet items, tax code, and unused columns, keeping mainly account number, name, type, and description. They then match account naming and types to QuickBooks Online, aligning direct costs and revenue categories such as Cost of Goods Sold, Expenses, Income, and Other income. Finally, they import the CSV into Franmetrics, correct ordering issues, re-import to wipe prior entries, and enable the P and L view since Xero P and L reports do not show unless the accounts are present in the chart of accounts."}