/
Amending/Exporting Chart of Accounts in Excel

Can't find what you're looking for? Still have questions? Contact customer support (smile)

Amending/Exporting Chart of Accounts in Excel

Like most windows in Eclipse, you can export the Chart of Accounts window into Excel, make necessary changes and re-import back into Eclipse.

 

1. Highlight the specific rows you would like to export or tick Select All.  Then right-click in the window and select Excel

 

2. Make the necessary changes or additions in Excel.  Then highlight the data cells (cells with data in them, no headers or footers).  Right-click and select Copy.

  • Only copy Data Rows (No Header or Footer)

  • Only copy Columns A to L

Notes:

  • You cannot use this method to delete cost codes.

  • Amending or Inserting a code in Excel will add a new Code into Eclipse. Read this guide Chart of Account Structure to understand how to edit accounts correctly in Excel.

 

3. In Eclipse, right-click in the Chart of Accounts window and select Paste

 

4. If you get errors when attempting to paste in:



Related content

Eclipse Report Printing workarounds - print to PDF
Eclipse Report Printing workarounds - print to PDF
Read with this
Export/Import Budget Worksheet in Excel
Export/Import Budget Worksheet in Excel
More like this
Restricting Amendments on Vendor Details
Restricting Amendments on Vendor Details
Read with this
Insert/Edit Chart of Account Codes in EzyPO via Excel
Insert/Edit Chart of Account Codes in EzyPO via Excel
More like this
DPF - System Defaults
DPF - System Defaults
Read with this
Manual Budget Upload
Manual Budget Upload
More like this