Journal Account Mapping
Journal Account Mapping allows you to map the internal accounts used by REVLOCK to the actual account numbers you are using in your ledger package / accounting system.
To understand how entries are created read about our journal posting process
Once you have connected your accounting system you can use the account mapping feature to select the account you want to use from the list pulled from your accounting system.
You can change your account mapping by;
Download your current mapping as an Excel file, change and Upload your new mapping in bulk
Change an individual mapping on the UI
This feature is not supported for account of type Deferred Revenue and Contra Revenue. User should not override Deferred Revenue account or Contra Revenue accounts from what's is set as default at the environment level.
For a simple Ledger configuration you can use the default setup with a single account for each account type, for example a single deferred revenue and revenue account for the company. For more complex setups you can use other fields such as Product Family or Product Type to map entries to specific accounts.
In order to configure your mapping fields go to the settings section for your environment and edit your mapping fields. Note that journal account type is always included in the mapping
Once a field is added it will show up as a field in the journal account mapping fields table.
Account Mappings with additional fields should only be used with Revenue account type.
It is required to configure Journal Account Mapping Fields up front, before any data is loaded into REVLOCK.
If you book by a granular field such as product type you can setup your mapping with a default mapping. This allows REVLOCK to book to a default account if a new product type is introduced and a specific account mapping has not been supplied. Such mappings are considered unverified.
You can go to the mapping screen and find any default unverified mappings, adjust and save them. When you do this they are transitioned to the verified state.
In general it is a best practice to review unverified mappings before closing the accounting period
To understand how entries are created read about our journal posting process
Mapping Accounts
Once you have connected your accounting system you can use the account mapping feature to select the account you want to use from the list pulled from your accounting system.
You can change your account mapping by;
Download your current mapping as an Excel file, change and Upload your new mapping in bulk
Change an individual mapping on the UI
Journal Mapping Fields
This feature is not supported for account of type Deferred Revenue and Contra Revenue. User should not override Deferred Revenue account or Contra Revenue accounts from what's is set as default at the environment level.
For a simple Ledger configuration you can use the default setup with a single account for each account type, for example a single deferred revenue and revenue account for the company. For more complex setups you can use other fields such as Product Family or Product Type to map entries to specific accounts.
In order to configure your mapping fields go to the settings section for your environment and edit your mapping fields. Note that journal account type is always included in the mapping
Once a field is added it will show up as a field in the journal account mapping fields table.
Account Mappings with additional fields should only be used with Revenue account type.
It is required to configure Journal Account Mapping Fields up front, before any data is loaded into REVLOCK.
Verified vs Unverified Mapping
If you book by a granular field such as product type you can setup your mapping with a default mapping. This allows REVLOCK to book to a default account if a new product type is introduced and a specific account mapping has not been supplied. Such mappings are considered unverified.
You can go to the mapping screen and find any default unverified mappings, adjust and save them. When you do this they are transitioned to the verified state.
In general it is a best practice to review unverified mappings before closing the accounting period
Updated on: 23/06/2021
Thank you!