Activate to download all COAs in digital format or download this COA as a single file here.
The COA files are downloadable in .xlsx format.
Import into some ERP systems may require a CSV format.
As the COAs already utilize the comma, instead of saving as CSV in Excel the COA should be saved as tab-delimited text for best results.
Alternatively, install Python (with Pandas and Openpyxl libraries) and download this file Excel-to-CSV.zip.
Rename the COA to 'Excel-TSV-Input.xlsx' and run the script.
Note: conversion to CSV strips the formatting necessary for the scripts on this page to function as designed. Use the Depth column to rebuild the hierarchy, before running these scripts.
Pro view includes additional scripts illustrating how to generate a dynamic hierarchical COA from an Excel source file. It also includes scripts to map the output to balance sheet and P&L in IFRS or US GAAP format (also in Excel).