Overview
The Import Assignments feature in Absolute is used as an upload function for the Worksheet A, C, G, and G-3 Assign Lines in the GL Mappings section. This feature allows the user to import a list of line assignments based on defined departments or accounts in the uploaded General Ledger, and automatically maps these departments or accounts to the proper line of the specified Worksheets.
Import Assignments
Automatic Line Assignments can be imported for each of the sections below in Absolute. From the GL Mappings-> Worksheet A, C, G, or G-3 Assign Lines sections, navigate to the upper left-hand corner of the page and select
. The user will then be prompted to browse to the file location where the Import Assignments template is saved. Reference the table below for specifics on how to create the import assignments template for each section.
| Operating Expenses - Assign WS A Lines | In an Excel file, Column A will contain a list of Operating Expense departments in the General Ledger. Column B will show the corresponding Worksheet A Line where that department should be mapped. |
| Patient Revenue - Assign WS C Lines | In an Excel file, Column A will contain a list of Patient Revenue departments in the General Ledger. Column B will show the corresponding Worksheet C Line where that department should be mapped. |
| Balance Sheet - Assign WS G Lines |
In an Excel file, Column A will contain a list of Balance Sheet accounts in the General Ledger. Column B will show the corresponding Worksheet G Line where that account should be mapped. |
| Other/Non-Operating - Assign WS G-3 Lines |
In an Excel file, Column A will contain a list of Other Operating and Non-Operating accounts in the General Ledger. Column B will show the corresponding Worksheet G-3 Line where that account should be mapped. |
Note: Row 1 of the upload templates for the Assign Lines section will contain Column Headers, such as Department/Account and CR Line. See below for an example format for Worksheet A or Worksheet C.
The upload template must contain a complete list of departments or accounts to map, as uploading these line assignments will supersede/replace any existing line assignments. If a department or account exists in the General Ledger, but does not exist in the upload file, these departments or accounts will display as unmapped accounts.
For further information on the GL Mapping section in Absolute, see GL Mappings.