In the menu section 'Ledger', you'll find an overview of all general ledger accounts. Here, you can also add new accounts and modify data.
Adding General Ledger Accounts
At the top of the general ledger account overview, you'll find the 'Add' button. Clicking on this button allows you to add a new general ledger account.
- Start by entering the account number for the new general ledger account. Then, provide the corresponding name for the account.
- If product groups are active in your environment, you can choose a product group from the list to link to the general ledger account.
- If you set the 'status' to passive, the general ledger account won't be selectable.
- Upon 'Save', you can also choose to set up a coding matrix directly for the added general ledger account.
Import General Ledger Accounts
At the top of the general ledger account overview, you'll find the option 'Import General Ledger Accounts'. Here, you can directly import general ledger accounts from the financial system or, if that's not possible, upload a CSV file containing all the general ledger accounts you want to use in Spend Cloud.
With an import, all data of existing general ledger accounts will be overwritten. After clicking on 'Import General Ledger Accounts', you can upload a file with the accounts. You can export this list of general ledger accounts from your financial system and save it as a CSV file. By clicking on 'Show mapping', you can see the format the CSV file needs to have for correct reading. Always import the complete list of general ledger accounts for proper synchronization.
Click 'Import' at the top to upload the list to Spend Cloud.
You can also add general ledger accounts per administration. If this option isn't available in your environment but you wish to do so, contact our Support department.
Import General Ledger Account - Product Group
If your Spend Cloud environment utilizes product groups, you can import the link between general ledger accounts and product groups using the "General Ledger Account - Product Group" button. Linking general ledger accounts and product groups allows you to get an overview of expenses per product group in the Analysis module. For more information on product groups, click here.
Import General Ledger Account - Workflow
You can set up a workflow for each general ledger account individually. Alternatively, you can use an import to assign workflows to multiple general ledger accounts. To do this, click on "Import General Ledger Account - Workflow." Then, select the corresponding import definition. Once selected, you can upload the CSV file with fields matching the import definition. If the import definition "General Ledger Account (Workflow)" doesn't exist, contact our Support department.
Link Coding Subcategories to General Ledger Accounts
For each general ledger account, you can determine which subcategories are allowed and whether a restricted list of subcategories applies. You can do this in the section Application Management / General / Ledger. Then, by clicking on the three dots on the right, you can create the links.
If you want to make the same links for multiple general ledger accounts, you can use the "Copy" button to determine which variable fields should be copied to the other accounts.
Setting Up Workflow
By setting up a workflow, you can initiate an automation process. For instance, you can determine that when general ledger account 441200 is selected, it should default to Organizational Unit "ICT" with the action "To assess" by Manon.