Creating New Expenses from the Reconciliation and Accrual Workbench

Creating New Expenses from the Reconciliation and Accrual Workbench

The Reconciliation and Accrual Workbench holds credit card transaction data from corporate credit card feeds. This report can be helpful to reconcile and find transactions that were either deleted or did not import into a user's Emburse Professional Wallet.

This article shows you, a Emburse Professional Accountant, how to create new expenses for employees from the Reconciliation and Accrual Workbench. 

  1. On your Emburse Professional homepage, click Reporting. 

    Emburse professional navigation menu with reporting highlighted.

  2. Open the Reconciliation and Accruals Workbench, underneath Integration and Data Feeds.

    Reconciliation and Accruals Workbench with Integration and Data Feeds selected. 

  3. Use the search parameters to filter your results.

    Use the search parameters to filter your results.

  4. The report will not only detail credit card expenses that imported to employees' wallets correctly, but it will also detail deleted expenses, as well as expenses that did not import correctly.
    • Deleted expenses will be highlighted in red.
    • Unmatched (did not import) expenses will be highlighted in yellow.

    Columns include:

    • Credit Card Date: The date of the transaction
    • Credit Card Posting Date: The posting date of the transaction
    • Card Number: Last four digits of the credit card number
    • Cardholder Name: The cardholder name
    • Transaction ID: The transaction ID from the credit card transaction
    • Credit Card Amount: The amount from the credit card transaction
    • Credit Card Currency: The currency from the credit card transaction
    • Credit Card Orig Amount: The original amount from the credit card transaction
    • Credit Card Orig Currency: The original currency from the credit card transaction
    • Credit Card Vendor: The vendor from the credit card transaction
    • Credit Card Location: The location from the credit card transaction
    • P-Card Program: The P-Card Program the file is tied to
    • Match Status: This will contain one of 3 values:

    --> MATCHES TO -->: if there is a matching expense in Emburse Professional

    *** NO MATCH ***": if there is no matching expense in Emburse Professional

    *** DELETED ***": if the expense was in Emburse Professional but has since been deleted

  5. Use the Create Expense link next the unmatched (yellow) or deleted (red) expense.

    Create Expense on Emburse Professional.

  6. In the new window, select whether to create a single expense or up to 50 at once.

    In the new window, select whether to create a single expense or up to 50 at once.

  7. You will see a confirmation page when the expenses have been created. Refresh the report if necessary.

    Confirmation page after creating expenses from the reconciliation workbench.

If an expense is created from the Reconciliation and Accrual Workbench, an email will automatically be sent to the user that the expense was created for. 

Was this article helpful?