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 IAC-EZ Accounts
· Log in to IAC-EZ.
· From your Import/Export Center tab. select "SurePayroll Center" from the menu.
· From the Export Center, click on the "Export Payroll Categories" link.
You will be prompted to open or save your file.
· Select where you would like to save your account list file on your computer, such as on your desktop or in a specific folder.
· In the “File name” box, enter a name for your account list file. The default name is “surepayroll_categories.txt,” but for reference, it is recommended you include in the file name the date you exported the file. Do not delete or change “.txt” at the end of the file name. This is the required extension for your file.
· Click on “Save.”
· A popup window will open to confirm your data exported successfully. Click on “OK” to close the window when the download is complete.
The IAC-EZ Integration Video offers more quick tips. Download the Product Guide for step-by-step instructions with screenshots.
How to Export Your Sage 50 (formerly "Peachtree") 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 first four fields to include in your export file.
· “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 “Export Options” section, select “Include 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.”
How to Export Your Intuit QuickBooks Chart of Accounts
For step-by-step instructions with screenshots, refer to the Intuit QuickBooks Product Guide.
· Open your QuickBooks software.
· Select “File” then “Utilities” and then “Export.”
· An export window will appear.
· In the export window, select the box next to “Chart of Accounts” and click on “OK.”
· You will be asked where you would like to save your chart of accounts file. Choose a location you will easily remember such as your desktop or a new folder.
· In the “File Name” box, name your chart of account file. We recommend using “accounts” in the name followed by the date you exported your chart of accounts.
· Click on “Save.” The file must retain its “*.iif” extension specifically for QuickBooks software.
How to Export Your AccountEdge Chart of Accounts
Your chart of accounts is your “accounts list” in AccountEdge products. To export your accounts list:
· From your AccountEdge product, select “File” > “Export Data,” > “Accounts” > "Account Information.”
· In the "Export File”" window, click on “Continue.”
· In the “Export Data” window, click on “Match All” and then “Export.”
· In the “Save As” window, add a “*.txt” file extension (no quotes) to the end of the file name if it hasn’t already been added.
· Choose a location, such as a specific folder or your desktop, to save your accounts list, and click on “Save.”
For step-by-step payroll integration instructions with screenshots, refer to the AccountEdge Full-Service Payroll Product Guide.