How do I correct incorrect Journal Account mappings in RevRec?

Problem Statement

RevRec shows a banner that Journal Account mappings for the current period are incorrect, and accounting period close stays blocked until you correct them. A mapping can be missing, have a blank account number, or use an account whose type does not match the mapping key.

Solution

You need the Admin role in RevRec to download and upload Journal Account mapping files.

Review the mappings for the current period and correct any missing mappings, blank account numbers, or account type mismatches. Follow these steps:

1. Download the file containing the Journal Accounts and Journal Account Mappings sheets:

   • Click Review on the banner, or navigate to your RevRec site and go to Accounting > Incorrect Mappings.
   • Locate the option to download the file containing these sheets from the Grid.

   The downloaded file contains two sheets: Journal Accounts and Journal Account Mappings. Only flagged mapping rows appear on the mappings sheet, together with the full accounts list.

2. Open the downloaded file:

   • Use a spreadsheet application such as Excel or Google Sheets to open the file.

3. Review and correct the mappings:

   • In the Journal Account Mappings sheet, review the mappings for the current period and check for:
     • Missing mappings: Add a row for the mapping key and period, then fill in the account number.
     • Blank account numbers: Fill in the appropriate account number.
     • Incorrect account types: Select an account whose account type is valid for that mapping key.

4. Save the changes:

   • Ensure all changes are saved in the spreadsheet application.

5. Re-import the file into RevRec:

   • Go to your RevRec site and select Accounting > Upload Data.
   • Select the updated file and use the import function to upload it.

6. Verify and save the corrections:

   • Go to Accounting > Upload response > Journal Account Mappings.
   • Click Confirm and Save. This action is available only when the upload summary shows 0 errors and 0 duplicates.

   You will see a pop-up displaying "Journal Account mapping successfully uploaded!"

Once all flagged mappings are corrected and saved, the banner should disappear automatically.

7. Regenerate journal entries for the open period, then close the period again. The incorrect-mappings banner is gone, and period close uses the corrected accounts.

Important Notes

• Double-check the account numbers and account types to prevent further mapping issues.
• RevRec evaluates Journal Account mappings for the accounting period you are closing.
• Confirm and Save is available only when the upload summary has 0 errors and 0 duplicates.
• Journal entries already generated for open periods keep the previous accounts until you regenerate them. Validate the new journal entries before you close the period again.
• Regularly update and review your journal mappings to maintain accurate financial records.