Your general ledger stores information related to your company’s financial activity. In your accounting software, transactions are posted to accounts that compose your general ledger. These accounts are called your “chart of accounts” or simply “accounts.”
How to Export Your Chart of Accounts
For step-by-step instructions with screenshots, refer to the Product Guide.
· Open your Sage 50 software.
· Go to the “File” menu and click on “Select Import/Export…”
· Select “General Ledger” from the list on the left.
· Click on “Chart of Accounts List” in the box on the right.
· Click on the “Export” button at the top of the Select Import/Export window. You will see your “Chart of Accounts List” control box.
· In the “Report Order” dropdown, select “General Ledger ID.” Do not click on the “OK,” “Cancel,” or “Save” buttons.
· To include accounts with “zero” balances, make sure you select to “Include Accounts with Zero Amounts.”
· Click on the “Fields” tab. Select the fields to include in your export file. Fields that will be included in your export file will show a checkmark in the “Show” box to the far left of their lines.
· “Title” and “Column Break” should be included in your export file and will be selected by default. If they do not appear selected with checkmarks, select them.
· If you make changes under your “Filter” tab or “"Fields” tab, do not click on the “OK,” “Cancel,” or “Save" buttons yet.
· Click on the “Options” tab. In the “Options” section, do not select “Include Headings.” Do not select “First Row Contains Headings.”
· Click on the right-facing arrow and select where you want to save your chart of accounts export file. It is recommended that you rename your file to something such as the export date, but this is not required. The file extension must remain “*.csv.”
· Under “If Export File Exists,” select your preference for the chart of accounts export. Integration is not affected by your choice to overwrite or append your previous chart of accounts file. If you rename your export file, the system will not overwrite your previous file because the file names will be different.
· After selecting where you want to save your export file and renaming the file, click on “Open.” You will be returned to the “Select Import/Export” window. Click on “Close.”