Export SCoA Mapping Report
Admins, Business Managers, and Contributors can export the company's/client's SCoA to Excel. These users will be able to view a mapping report in Excel that notates where all the native accounts in the accounting file(s) are mapped within the Qvinci SCoA.
Admins, Business Managers and Contributors can export this report by visiting Tools > Map to SCoA. The button to export the mapping is found in the top right corner of the Map to SCoA page, as show below.
This Excel report will contain not only accounts in the Qvinci SCoA but also all native accounts found in the accounting file(s) that have financial data synced within Qvinci. This may include old native accounts that have been deleted within the accounting file but still have data for previous years, or even inactive accounts. For this reason, you may wish to use Excel's Sort & Filter function for different columns to obtain the desired data.
View Only Qvinci SCoA
To see the accounts listed in the Qvinci SCoA, you would sort and filter the "Standard Account Type" column as show below. Once the account types are in alphabetical order, you can delete any rows with the Standard Account Type "Unmapped", and remove duplicates. You will then see the Qvinci SCoA.