GL Account Mapping

The General Ledger Account Mapping screen allows users to custom map Crunchtime General Ledger accounts with partner system codes for our managed accounting integrations. This ensures seamless outbound movement of data from Crunchtime to the partner accounting system(s).  

 

1. Under the Corporate menu, click General Ledger.
2. Select the Account Mapping tab.  {Note}: This tab will be visible when the Company User Defined Attribute for XX_INTEGRATION_ENABLED = 'true' for a supported partner system (where XX = the abbreviation for that system). Currently this is available only for Workday.
3. Below that, select the tab for the related partner system.
4. For each relevant GL Account, enter one or more values as needed for the integrated partner system:  {Note}: All active Crunchtime GLs will be available for mapping.

Workday  

• Spend Category – Enter a Category ID value associated with the line items of a Journal transaction (Inventory Delta, Location Transfer and Sales from Crunchtime).
• Ledger Account – Enter the Workday ledger account ID associated with the Crunchtime general ledger account.
• Sales Worktag – Enter one or more Workday worktag values for those tied to a sales journal GL, using the following format - "worktag # | worktag value id". Can include multiple entries, separated by a #.  {Example}: worktag1 | R_750 # worktag2 | CO_700.
• AP Worktag – Enter one or more Workday worktag values for those tied to an accounts payable GL.  {Note}: All of the work tags will be defined in the Company setup screen. The corresponding worktag ID values must entered in these fields.
• Journal Worktag – Enter one or more Workday worktag values for those tied to a journal GL.
• Workday FAQs

• Q: What happens when a new GL Account is added?  A: You should add a corresponding Account Mapping entry if needed.
• Q: What happens when you delete an Account Mapping record?  A: You cannot delete an Account Mapping record but you can removed (blank out) the entered values.
• Q: Can you delete a GL Account if there is an Account Mapping defined?  A: No, the GL record cannot be deleted when it has corresponding Account Mapping entries.

5. If editing an existing row, the Circular Left Arrow (Undo Edits) icon will reverse all entries without saving. To delete an entry in a row, click the Circular Right Arrows (Clear) icon.
6. To save your changes, click on another row.
7. To download and print these settings, click the Printer (Export) icon and select the desired options.
8. When finished, click the Home (Dashboard) icon to exit the screen.