The latest update to FloQast Flux brings exciting new accountability and efficiency to your Flux Analysis process! You may now assign ownership of the explanation for each specific account on your Reports, much like you assign your Reconciliations to individual preparers on your team. With the help of Flux Assignments, your entire team will know exactly what explanations are expected and required.
You still have the ability to assign a top-level Flux Reviewer for the entire Report. Read more about this final review here.
What do Flux Assignments look like?
An "Assignee" column will be added to your Flux Report, along with a familiar sign-off toggle.
In the Assignee column, you will see the profile picture and the name of the person responsible for leaving that Flux Explanation. Note that only accounts with a material fluctuation amount will display a preparer. If someone has been assigned to an account but no material fluctuation exists for that account, the assignee and the associated sign-off will NOT be present for that period.
The sign-off toggle should be marked "complete" when the assignee wants to signal that their explanation is final. This toggle will not automatically sign off when an explanation is left since you may draft your explanations and then revise/remove them. Once the sign-off has been completed, the explanation for that account cannot be modified or deleted. The sign-off would need to be undone if an explanation required further editing.
What Controls are in place for Flux Assignments?
There are some new controls that you may opt into when you utilize Flux Assignments. A full overview of all Flux Controls is available here.
How do I add Assignees to my Flux accounts?
You can assign a specific team member to each account using your Flux Grouping Template. Each account may have one preparer added.
1. Navigate to the Settings for the Flux Report that you'd like to add assignees to.
2. Export your current Grouping Template to Excel.
3. Your template will have a new column titled Preparer. Just like the other settings templates in FloQast, you will enter your assignees using their email address.
You do not need to add a preparer to every account. You may leave some unassigned if desired, or assign all accounts.
4. Save your changes on the Excel template and re-upload to FloQast using the Upload button.
5. Click "Back to Report" to return to your main Flux screen. You will be prompted to "Run Report" since you have changed the settings. Your new Flux Assignments will take effect when your report finishes running!
NOTE: If you have multiple reports that share a Grouping Template, your assignments on this single template will be applied to all. You will not need to export/upload the template multiple times for reports that already share a Grouping Template.
How can users find their assignments?
In addition to the notifications highlighted in the next section, users can find their specific accounts using additional filters that have been added.
Assigned To Me will filter the Flux Report to show only accounts assigned to the current user.
Incomplete will filter the Flux Report to show all accounts with outstanding sign-offs, or any accounts with open Review Notes.
Combining the two filters above will therefore show an action-list for a given user!
How will notifications work?
There are email notifications available to keep preparers informed of their Flux assignments. The notifications available include:
Preparer Notification: NEWLY-MATERIAL FLUCTUATIONS NEED SIGN-OFF
There is a material fluctuation that needs an explanation and sign-off on an account that a user is assigned to. This notification will be sent to the assigned preparer when there is a material fluctuation recognized (based on your materiality threshold), which may occur the first time that a Report is refreshed or upon a subsequent refresh.
Preparer Notification: MATERIAL FLUCTUATIONS HAVE CHANGED SINCE SIGN-OFF
There was a change to the amount of a fluctuation since it was signed off. This notification is sent to the Preparer (and the person that completed the sign-off if not the assigned Preparer) when both conditions below are true:
- An account with a material fluctuation has already been signed-off, AND
- The amount of a material fluctuation changes at all (whether or not the new fluctuation amount is material or immaterial)
Report Reviewer Notification: THE REPORT IS READY FOR REVIEW
This notification is sent to the Report Reviewer only when both conditions below are true:
- All material fluctuations on a report have been signed-off, AND
- All Review Notes have been closed.
NOTE: If there is not a Preparer assigned to an account with a material fluctuation, then the Report Reviewer will receive Preparer notifications on that account’s fluctuation activity.
Q: My report is showing some assignees as blank/unassigned even though I added an assignee to all accounts. Where are the preparers for these accounts?
A: Assignments will only be visible when the fluctuation amount is material for that account (based on your materiality threshold). Accounts with an immaterial fluctuation will have the assignee "hidden" so that your team spends their valuable time only on the accounts that truly need explanations and sign-offs. An explanation may certainly still be left on an immaterial fluctuation if there is something noteworthy that you'd like to document.
Q: I changed the preparer assignments using the Grouping Template, but only some of them applied. Why do some accounts still show the old preparer?
A: The assigned preparer will NOT be updated if an account has already been signed-off. This account is considered complete, and the assignee will be locked in place. Future reports (where the account is still incomplete) will reflect the new assignee.
Q: I tried to upload my Grouping Template to add Assignees, but I got an error that indicated certain accounts do not exist. How do I correct this error?
A: This error indicates that one or more accounts on your Grouping Template no longer exist on your Chart of Accounts. When your template is uploaded, all accounts listed are validated against your COA to ensure accuracy. If an account is not being recognized, please verify that this account has not been modified/removed from your COA in Netsuite or Intacct, or that this account is not missing from your Chart of Accounts file supplied here in your Cloud Storage folders: FloQast > FQ - Entity Name > Chart of Accounts. If you find this account missing from your COA, you may re-add it and try your upload again. If you decide that this account is no longer required on your Flux Report, you may simply delete the row from your Grouping Template and upload again.