Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

Accountants Enterprise with Practice Manager only

You can import employee budget data from a Microsoft Excel workbook (.xls) or from a comma separated file (.csv).

you You must enter the data in the correct format. For this reason, we recommend that you:

  • export the data for 1 a single employee
  • update the export file in Excel, adding details for other employees
  • save the changes, using File > Save As and select the type of Excel Workbook (*.xls) or comma separated file (*.csv) and
  • import the updated data into AE.
UI Expand
expandedtrue
titleTo import employee budgets from a Microsoft Excel workbook
  1. From the main menu, go to MaintenanceEmployee > Employee Budget Import. The Employee Budget Import window opens.

  2. At the Excel workbook to import field, click the ellipsis. The Open window opens.

  3. Locate the file name you want to import. The data in the selected .xls/.csv file displays in the content area.

  4. At the First row contains column names checkbox, either:

    1. select the checkbox if the workbook or .csv file contains column names. The import will then include the column names as the first row or

    2. deselect the checkbox if no column names are present.
  5. In the content area, deselect any rows you want to exclude from the import.

  6. Click Import. The Employee Budget Import window displays advising the import was successful.

  7. Click OK.
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Charge rate type

Employee benefit type

Employee categories

Employee category timetables

Employee leave type

Employee budget export

Over time type

Employee