Use this workflow to map General Ledger (GL) accounts that exist in your Accounting system but not in ProfitSword.
When accounts are mapped here, the data will successfully import into the existing master account in ProfitSword.
Prerequisites:
- Permissions: Requires access to the Corporate Level dashboard, the Admin menu, and Ledger Mapping.
- Knowledge: You must know which Chart of Accounts (COA) you need to map to the ProfitSword COA.
- Example: Balance Sheet Accounts - 101000 Main Core Cash Account, 101000.123 Cash Account for a Specific Entity. We need to map the Cash Account of 101000.123 to the Core Cash Account 101000.
The Steps:
- Navigate to the Corporate Level menu and select Admin > Ledger Mapping.
- Select the Hamburger menu under the Actions column for the Balance Sheet Department you would like to map
Note: If you have multiple Chart of Accounts, select the specific class you need. Do NOT select the "Standard COA." If an account needs to be added to the COA, please create a support ticket to have the account added by the ProfitSword Team.
Click the Action Icon that corresponds with the Ledger Class you would like to map.
- Select the Add Icon at the bottom of the screen.
- Fill in the Label with the name of the Account as you want it to appear
- Click the Edit Icon in the Type Column next to the Account you are mapping.
- Change the dropdown in the Type column from A (Amount) to S (Stat) if you are mapping a statistical account.
- Select the Edit icon under the Account Column to assign the Core Account
- Click the Save icon to apply your changes.
The Result:
- Success: The new GL account is mapped, and future data will automatically import into the assigned ProfitSword core account.
Troubleshooting:
- Out of Balance Errors: If you are out of balance on your Import Accounting Actuals screen because of the account you just mapped, you must reimport the accounting actuals for the affected period and property to pull the new mapping through.
Comments
0 comments
Article is closed for comments.