Qvinci offers a number of templates for the Standard Chart of Accounts, but it might be more ideal to use your own, custom SCoA. It is possible to create your entire SCoA from within Qvinci by using the Manage SCoA workflow, but it can be time consuming depending on the complexity of the chart.
A simpler solution is to send your SCoA to your Qvinci Account Executive via email, or to one of our Implementation Specialists by emailing Support@Qvinci.com. If you send us your custom SCoA, we will upload it to your Qvinci Account. Be sure to tell us the name of the Client/Company you'd like it uploaded for.
QuickBooks Desktop Export
If you have multiple files you wish to sync, and you wish to use the chart of accounts from one file as the standard in Qvinci, the quickest way to have it uploaded to Qvinci is to export it directly from QuickBooks. Qvinci's Implementation Specialists have an internal tool which will parse the exported file and format it in a manner that can be used in Qvinci.
- Finding the .IIF export function in QuickBooks
- Select only Chart of Accounts
And that's it! Send the exported .IIF file to Qvinci and we will happily upload it to your Qvinci Account. Be sure to tell us what Client/Company it is for. Some email clients may not allow you to email a file of this format, in which case you may ZIP the file into a compressed folder before sending it. After we have uploaded the SCoA for you, you may edit it more using the Manage SCoA workflow.
QuickBooks Online Export
The Process for exporting a chart of accounts from QuickBooks Online is similar to Desktop, but a normal Excel file will be exported rather than an IIF file. The steps for exporting for the report are as follows:
- Click the Company settings in the top right
- Choose Chart of Accounts
- Click Run Report in the top right
- Use the export icon to choose Excel
Manual SCoA Creation
In some cases, you might not wish to use an exact copy of the CoA from QuickBooks. In this case, you can simply list out the accounts in an Excel file and send it to us. This method will result in a longer wait for Qvinci's Implementation Specialists to upload the SCoA to your Qvinci Client/Company, but you can reduce the delay by making the account type, parent, and children accounts easily identifiable.
The Qvinci SCoA requires that accounts be formatted with colon delimiters to differentiate parents from children, as seen below.
Qvinci uses the same account types as QuickBooks, with exception to the additional account type called "Current Liability" which is utilized in Xero's accounting platform:
It is not necessary to use every account type, but identifying the accounts in Excel using the account types above will speed up the upload process.
Once completed please send the SCoA to Support@Qvinci.com and request it be uploaded for the corresponding Qvinci Client/Company in the account.