Accounts

Which three fields are required in a load file for premapped balances?. Reconciliation Account ID. Currency Code. Amount. Currency Bucket. Period. Entity.

What happens if you load balances to a reconciliation with status Closed or Open with Reviewer, and the balance is different from what was already certified?. The status reverts to pending. The imports fails. The status reverts to Open with Preparer. The status is unchanged but a notification is send to the related users.

Which transaction matching method is used to match transactions between two systems if period-end reconciliation is not the objective?. Transaction Matching Only. Selected Matching. Selected and Transaction Matching. Matching.

Which two attributes can be added as columns in transaction matching?. Amount. Date. Currency. Employees.

Which two reconciliation methods can be used for transaction matching?. Balance Comparison. Account Analysis. Service Comparison. Account Balance.

Which two reconciliation methods can be used for transaction matching?. Debit and Credit Matching. Transaction Matching. Comparison Matching. Balance Matching.

A transaction matching period ending reconciliations displays an unexplained difference other than zero. Which are two possible explanations?. Currency exchange rates are out of date. Journal adjustments created were not posted. You do not have security access to all the transactions. The data load for transactions was incomplete.

Which reconciliation method is used for reconciliations with account analysis format?. Account Analysis. Business Rules. Comparison Analysis. Accountability.

An error occurs during an import transaction job for a match type – what is the result of the job?. The transactions are not imported, the match type is locked, and the job status it set to Failed and Locked. Successfully imported transactions are committed to the system, failed transactions are logged, and the job status is set to Competed with Errors. The entire import is rolled back, and the job status is set to Failed. The job deletes all match type transactions, and the job status is set to Failed and Deleted,.

Which three types of reconciliations are suitable for the transaction matching feature?. Reconciliations with a single data source, like a clearing account. Reconciliations that are typically zero balance accounts with low activity. Reconciliations that have amortizing transactions. Reconciliations with 2 or more data sources, like a cash or accounts receivable account. Accounts with high volumes of data.

You want to load balances for both the entered currency bucket and the functional currency bucket in a single data load – which tool should you use?. Data Management. ‘Import pre-mapped balances’ option in the Periods page. Smart View. Supplemental Data Management form.

You are a preparer with User role and you are going on vacation. How can you assign responsibility for reconciliations currently open with you to the backup preparer?. Select a backup preparer in the Workflow tab of the reconciliations. Change your status to Out of Office in User Preferences. Request Reassignment from the Actions menu of the reconciliations. Release the reconciliation to another team member by clicking the Release button.

Which two tasks can be performed using EPM Automate?. Set period status. Import premapped data. Export balances. Export journals.

Which expression do you include in the Expression field of the Amount column in an import format to ensure that zero balances are loaded?. Source System. NZP. 0. Include Null.

Which two statements are true about importing and exporting match types? (Choose two.). Match types are exported to a .zip folder. Import can update match types with Pending status only. Match types are exported to comma-separated (CSV) files. Import can update match types with Approved status only.

Which two statements are true about Group reconciliations? (Choose two). Group reconciliations include other individual reconciliations as children. You cannot use Data Management to import balances for group reconciliations. The format for the reconciliation must be enabled for Group Reconciliation. The Group Detail tab shows data for the group reconciliation sub segments. You can import balances into periods are pre-mapped data.

Which two statements are true about reconciliation compliance filters?. They can control the records that you see in the list views. They can be used by the rules engine. They allow you to save columns to view records on the screen. You can apply them against unmatched transactions.

Which two statements are true about match types with Pending status?. You can edit the data sources attributes. You can load data to Pending reconciliations for the match type. You can perform matching on reconciliations for the match type. You cannot edit the matching rules.

Which two auto-reconciliation methods for reconciliation use the Account Analysis formats?. Balance is zero. No transactions. Unexplained difference is zero. Balance is normal. Zero activity.

How can you configure a profile for reconciliation compliance to show the variance between a current period balance and a prior period balance in a separate workflow from the reconciliation?. On the currency tab, enable a currency buckets for that prior period balance. Add a rule to the Rules tab. Select a format with the Variance Analysis reconciliation method for the profile. Create a calculated attribute to compare the prior period balance to the current period balance and add it to the profile.

A profile's properties have been modified and the changes saved. Which statement is correct?. Existing reconciliations that use the profile are not updated. Existing reconciliations with Pending or Open With Preparer status that use the profile are updated with the changes. Existing reconciliations that use the profile are updated after approval by a system administrator. Existing reconciliations with Pending status that use the profile are updated with the changes.

For which scenario would a match type with a single data source be appropriate?. Matching credits and debits for a clearing account. Intercompany matching. Matching bank and point-of-sale transactions. Variance analysis for current and prior period balances.

What happens when you load balances to a reconciliation with the status Closed or Open With Reviewer and the balance is different than what was already Certified?. The status reverts to Pending. The import fails. The status reverts to Open to Pending. The status is unchanged but a notification is sent to the related users.

Which two steps must you perform when configuring for reconciliation?. Map journal columns to data source attribute columns. Create journal columns. Define data source filters. On the balance explanation tab of the prepare expense reconciliation you want to include transactions and attachments for the prior period and the current period.

Which statement is FALSE about reconciliations that use the Transaction Matching Only reconciliation method?. They display in both the Reconciliations list and the Matching list. They do not participate in period-end compliance workflow. They do not need to be created for periods. You must create profiles for them.

What results if you load balances using Data Management to a period to which you previously imported pre- mapped balances?. The Data Management data load fails. You are prompted whatever to overwrite the pre-mapped balances. The balances loaded through Data Management overwrite the pre-mapped balances. The reconciliation takes the balances loaded through Data Management and the balanced loaded through Data Management and the balance load, and totals them pre-mapped.

Which statements is FALSE about the review process in reconciliation compliance?. Reviewers are sent notifications. You can have up to seven levels of review. You can assign backup reviewers. You can assign a team as reviewer.

A team has been assigned as the preparer for a reconciliation, and one team member is designated as the primary user. What characterizes the primary user?. The system automatically re-assigned the reconciliation to the primary user when the current preparer is out of the office. The primary user must approve the reconciliation before the preparer submits the reconciliation. The primary user can edit the reconciliation properties. The system automatically claims the reconciliation for the primary use when the reconciliation status changes to Open (with preparer).

Which statement is FALSE about the profile segments?. You cannot change the profile segments after you have loaded profiles. The profile segments control the mapping of balances to reconciliations. The profile segments are configured as part of the system attributes. The profile segments specify the level at which the organization reconciles account balances.

Which ability does NOT belong to users with the Power User role?. Edit formats to which they are assigned access. Prepare reconcilaitons. Review reconciliations. Edit profiles to which they are assigned access.

You are using EPM Automate commands to automate data load to Account Reconciliation. In which scenario should you use EPM Automate to load the data through Data Management rather than directly into Account Reconciliation?. Your data includes fields with blank values. You are loading data to the reporting currency bucket. You are loading more than 1000 transactions. You want to import one concatenated field from the source file, rather than two separate fields.

Which two are tasks you can perform when confirming suggested matches with adjustments in the Suggested Matches list? (Choose two). Select the data source to adjust. Select an Adjustment Type. Enter an adjustment amount. Enter a data for the adjustment.

When can you run auto-matching for a transaction matching reconciliation?. After you load transactions to the reconciliation data sources. After the period end date is reached. After the reconciliation meets its start date. After the reconciliation status changes to Open With Preparer.

Which statement about journals in transaction matching is FALSE?. You create separate journal column mappings for adjustments and transactions. For transactions, you can apply a data source filter to the export. You create separate journal columns for each match type. For adjustments, the variance amount is exported to the Amount column.

Which statement about journals in transaction matching is FALSE?. You create separate journal column mappings for adjustments and transactions. For transactions, you can apply a data source filter to the export. You create separate journal columns for each match type. For adjustments, the variance amount is exported to the Amount column.

Which is NOT an attribute type for reconciliation compliance attributes?. Yes/No. True/False. Number. Location.

Which statement is true about saved filters?. Any user can publish a saved filter that they created. Saved Filters are public by default. Only power users and service administrators can publish filters. Only service administrators can publish filters.

Which statement is FALSE about calendars?. Calendars are associated with periods and organizational units. One period may have many calendars to reflect different date configurations for the periods. An organizational unit can be assigned many calendars to enable reconciliations for different financial dates. Calendars set the dates and frequencies for each period.

Which two attribute type are required for each data source?. Key Field. Accounting Date. Calculation. Balancing Attribute.

Which statement about loading pre-mapped balances is FALSE?. You can drill back to the ERP from the reconciliation screen. You must selected a currency bucket for the import. You must selected a period to which to load the balances. You can import from either tab separated or comma separated files.

A profile’s properties have been modified and the changes saved. Which statement is correct?. Existing reconciliations that use the profile are not updated. Existing reconciliations with Pending or Open With Preparer status that use the profile are updated with the changes. Existing reconciliations that use the profile are updated after approval by a system administrator. Existing reconciliations with Pending status that use the profile are updated with the changes.

In which row does an unmatched transaction with an accounting date of April 30th display in the period-end reconciliation for May 31?. It is excluded from the report. Unmatched Supported. Matched in Transit. Unmatched.

Which is true when you reopen a reconciliation?. It reopens to the service administrator. It reopens to the last reviewer. You select the role to which it reopens to. It reopens to the preparer.

Which ability does NOT belong to users with the Power User role?. Edit formats to which they are assigned access. Prepare reconciliations. Review reconciliations. Edit profiles to which they are assigned access.

You want the holidays to be skipped when scheduling due dates for reconciliations for an organizational unit. What should you do?. Edit the due date in the reconciliations for the organizational unit. Create a holiday rule and assign it to the organization unit. Create a calendar and assign it to the organization unit. Add a rule to the Rules tab of the profiles for the reconciliations.