How to Extract GL Opening Balnce from other Accounting Systems

Overview:

QNE AI Cloud Accounting offers a seamless solution for users transitioning from other accounting software. One of the standout features is the ability to directly import your extracted General Ledger Opening Balances without needing a pre-filled QNE template, ensuring a smooth and efficient migration process.

Disclaimer:

This guide is intended to assist users in migrating to QNE from their existing accounting systems. References to third-party systems, including screenshots, are for illustrative purposes only and may be outdated if the third-party software has changed its processes. Users should consult their provider's help documentation for the most current information. All trademarks and product names are the property of their respective owners. QNE does not claim any rights to the systems mentioned.

Scenario:

Export General Ledger Opening Balance from SQL Accounting, UBS, Autocount Cloud Accounting, Autocount Desktop, Xero, Quickbooks Desktop, and then import it into QNE AI Cloud Accounting.

Solution:

Extract GL Opening Balance from Other Systems

SQL Accounting 

1. Upon logging in to SQL Accounting, go to GL > Maintain Opening Balance.

2. Once redirected to the Maintain Opening Balance screen, click on the Printer icon > Export to CSV File.

3. On the Export to CSV pop-up click OK.

4. Enter your chosen file name, and change the Save as type to CSV (Comma-delimited). Once you're finished, click Save.
 

UBS 

1. Upon logging in to UBS Accounting, go to Reports > Trial Balance.
 

2. Once redirected to the Reports pop-up, click Trial Balance > OK.

3. On the Trial Balance pop-up click Excel.

3.1 On the Export To Excel pop-up click Excel.

4. Save and open the Excel File. Navigate to File > Save As, then enter your chosen file name, and change the Save as type to CSV (Comma-delimited). Once you're finished, click Save.

Autocount Cloud Accounting

1. Upon logging in to Autocount Online, go to Settings > Opening Balance.

2. On the Opening Balance List View screen, click Print Report, then OK on the pop-up.

3. Once redirected, click the Arrow icon > CSV.

4. Save and open the Excel File. Navigate to File > Save As, then enter your chosen file name, and change the Save as type to CSV (Comma-delimited). Once you're finished, click Save.

Autocount Desktop

1. Upon logging in to Autocount Desktop, go to Settings > Opening Balance.

2. On the Edit Opening Balance screen, right-click column header > Export to Excel.

3. Enter your chosen file name and then Save.

4.  Reopen the Excel file, go to File > Save as type to CSV (Comma-delimited). Once you're finished, click Save.

Xero

1. Upon logging in to Xero, go to Accounting > Reports.

2. Under Taxes and balances, click Trial Balance.

3. Once redirected to the Trial Balance screen, click the Export > Excel.

4. Save and open the Excel File. Navigate to File > Save As, then enter your chosen file name, and change the Save as type to CSV (Comma-delimited). Once you're finished, click Save.

Quickbooks Desktop

1. Upon logging in to Quickbooks, go to Reports > Accountant & Taxes > Trial Balance.
 

2. On the Trial Balance pop-up screen, click Excel > Create New Worksheet.

3. On the Send Report to Excel pop-up, click Create new worksheet > in new workbook > Export.
 

4. Save and open the Excel File. Navigate to File > Save As, then enter your chosen file name, and change the Save as type to CSV (Comma-delimited). Once you're finished, click Save.

Application: 

Users can now import the downloaded CSV files to QCA.

Note: Make sure to make the file format in CSV format instead of Excel format.