ReportExecutive Reconciliation Mode

ReportExecutive's Reconciliation Mode allows organizations to easily align monthly expense reports with their corporate credit card statement cycles. This article shows Emburse Professional Administrators the differences between the standard ReportExecutive report logic and the Reconciliation Mode report logic, as well as how to enable Reconciliation Mode for your organization.

Reconciliation Mode is an optional setting of ReportExecutive, our automatic expense-report builder that allows you to build reports for your users on your schedule. Reconciliation Mode changes the default ReportExecutive report-creation logic to ensure only corporate credit card transactions are included in the automatically created expense reports.

You may use the custom build-day scheduling already available in ReportExecutive to automatically generate expense reports that mirror the exact dates of your organization’s corporate credit card statement date range, ensuring perfect alignment between expense reports and credit card statements.

ReportExecutive Default Settings vs. Reconciliation Mode

Enable Reconciliation Mode

1. Click Configuration in the upper right corner of Emburse Professional.

2. Under Company Policy > Travel and Expense Policy, click ReportExecutive Settings.

3. If one is not already configured, select a ReportExecutive build date. Additional settings are required to ensure ReportExecutive builds expense reports as expected. To learn more and view best practices, see ReportExecutive Configuration.

4. Toggle on Reconciliation Mode to enable the functionality.

5. Use the drop-down to select whether credit card transactions should be included based on their Transaction Date or their Posting Date.

An expense report date range based on your ReportExecutive schedule will be automatically generated for each automatically created expense report. Whether you select Transaction Date or Posting Date will determine if a credit card transaction will be included on this month’s or next month’s ReportExecutive report.

• Transaction Date: Emburse Professional will use the date on which the card was swiped to determine whether the transaction should be included in the report.
• Posting Date: Emburse Professional will use the transaction’s posting date (if it is supplied by your credit card provider) to determine whether the transaction should be included in the report.

Example

ReportExecutive is configured to build on the 24th of the month, with a three-day buffer period. The June expense report will be built on the 24th, with an expense report date range spanning May 22nd to June 21st.

The credit card transaction in a user’s wallet has a Transaction Date of June 20th and a Posting Date of June 23rd.

• • If Reconciliation Mode is configured to add expenses to the report based on Transaction Date, the transaction in question will be included on the June report.
  • If Reconciliation Mode is configured to add expenses to the report based on Posting Date, the transaction in question will be added to the July report.

6. Click Save at the bottom of the page.

With Reconciliation Mode enabled, future ReportExecutive expense reports will only include corporate credit card transactions and the receipt images merged with those transactions.

Receipt images that do not merge with a credit card transaction will remain in the user’s Wallet, ensuring the ReportExecutive expense report contains only the transactions that appear on your organization’s monthly credit card statement.

Personal credit card transactions will also be excluded from the report, keeping the report exclusive to your company credit card transactions.