Activate to download this COA in digital format.
A COA may be incorporated into reporting structure in many ways. Nevertheless, Excel remains the lingua franca of accounting.
On the other hand, some ERP implementation professionals require data structured as CSV or TSV. To accommodate this requirement, read this.
First, ensure you have a functioning version of Python with the Pandas and Openpyxl libraries installed. Next, download the zip file that contains the script Excel-to-CSV.zip. Place both the COA and the script into the same folder. Rename the COA exactly Excel-TSV-Input.xlsx and run the script.
To convert the TSV back, simply copy Excel-TSV-Output.csv to Excel and use the Text to Columns function. Leave the delimiter set to the default Tab. Please be aware, this will strip all formatting, so the Depth column is critical for retaining COA's hierarchy.
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).
