Employee expense reclassification report

Use this report to list paid or partially paid expense reports with changed (reclassified) accounting transactions. In addition, this report lists the users who made the changes (reclassifications).

On the report, reclassified means changes made in Reclassification mode that cause a transaction to repost to the GL. Partial edits don't cause a repost to the GL. You can select any link to drill down to details.

You can find the Employee expense reclassification report by going to Expenses > All > Reports > Reclassification.

What's in this report?

The default Employee expense reclassification report consists of the following columns:

Report Column Heading Description

Employee

The ID and name of the employee

Document number

The number assigned to a document

Type

The type of transaction that was reclassified

Document date

The date on which the document was created

GL posting date

The date on which the reclassified transaction posted to the GL

Reclassification d ate

The date on which the transaction was reclassified

User

The ID of the person who reclassified the transaction

You can select any link to drill down to the details.

View a monthly report

  1. When the report page appears, select View.

    A report showing all results for the month to date appears.

  2. To refine the report, select Customize to return to the main report page, and follow the steps below.

Customize and run

Before running the report, you can select the time period and types of items to include as well as specify how you want the report to appear.

  1. Select the reporting period from the dropdown menu, or enter the start and end dates you want the report to cover. If you do not specify a reporting period, the system generates a report for the current month to date.

    You can specify either the reporting period or the start and end dates, but not both.

  2. Set the filters to get the specific data you want.

    Filters enable you to include or exclude specific types of data in the report, such as supplier and location. As a general rule, to get fewer and more precise results in your report, set more filters.

  3. Format the report.

    Format options vary from report to report. Generally, you can set the layout of the report and/or arrange how to group and display the data contained in the report.

  4. Type a title, subtitle, and footer text for your report.
  5. Do one of the following:

    How to work with reports
    To: Select:

    View the report now, in your browser.

    View

    Display the report in PDF format so you can print it or save it to your local drive.

    Print

    Generate the report and store it for later access. Available formats include HTML, printable (PDF), Excel, CSV (comma-separated value), and Text. Reports can be stored:

    • In Intacct
    • In the My stored reports list
    • Delivered to a cloud storage location, such as Dropbox

    Learn more about processing and storing reports.

    Process and store

    Add the report to your dashboard.

    Add to dashboard

    Memorize (that is, save) the report in the Memorized reports list so that later you can refer back to it or modify and re-run it.

    You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.

    Memorize

    Export the report to a separate file that you can then distribute or save to your local drive.  Available file formats vary among reports.

    Export

    After you run a report, you can either email it to others or return to the Report Settings page to refine the results.

    Share and refine reports
    After running the report, to... Select

    Email the report to others.

    Email

    Return to the main report page and refine the report further.

    Customize

Time period

In the Time Period section, you can specify a time period in the following ways:

  • Use a pre-defined reporting period:
    1. select the Reporting period down arrow, and then select the period you want.
    2. Enter an As of date (the date that will be used as a baseline for the period you select; leave blank for today's date).
  • Create your own reporting period by entering a specific Start date and/or a specific End date.

The following table describes each item in the Time Period section of this report settings page:

If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Sage Intacct generates your report based on the start and end dates. It ignores the As of date.

Time Period Box Notes Limitations

Reporting period

These periods are relative to the As of date.

All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.

Only works with As of date. Does not apply if you select a Start date or an End date.

As of date

Leave this box blank to use today's date.

Only works with Reporting period. Does not apply if you select a Start date or an End date.

Start date, End date

Leave the Start Date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End Date blank to include all information from the start date up to today.

The format must be: MM/DD/YYYY

Prompt on run

Select this checkbox to require you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.

 

Report filters

Use filters to focus the report on specific data. You can set any combination of filters.

In the Filters section:

EITHER

To show results for a specific document, select the Document number down arrow, and then select the number of the document to view.

OR

  1. To show results for a specific employee type, select the Employee type dropdown, and then select the employee type you want the report to include.
  2. To show results for a specific employee or range of employees, use the From employee and To employee dropdowns.
  3. In a multi-entity environment, you can filter by location, department, or both.

  4. To show only transactions reclassified by a specific person, select that person's user ID from the User ID dropdown menu.

The following table describes each item in the Filters section of this report settings page:

Filter Box Notes

Document number

Include reclassified data only from the specified document.

Employee type

Include data only for the type of employee specified. By default this box is blank, which means the report will include all employee types.

From employee, To employee

Includes data only for a specific employee or range of employees. By default these boxes are blank, which means the report will include all employees.

User ID

Include only transactions reclassified by the person with the specified user ID.

Include

Include only the type of reclassified transactions specified.

Formatting

Use this section to specify the sort order and to change the page layout of the report.

  1. To sort the report results, select the Sort by dropdown list, and then select the category to sort by.
  2. To change the page layout, select the Page orientation dropdown list, and then select either Portrait or Landscape.

The following table describes each item in the Format section of this report settings page:

Format Box Notes

Sort by

Date is the default.

Page orientation

Portrait is the default layout.

Portrait: display or print the report pages vertically

Landscape: display or print the report pages horizontally

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

  1. Enter the title in the Report title 1 box.

    • This title displays in large type at the top of the page, directly under your company name.
    • You can enter over any default name that the system might have automatically supplied in this box.
  2. Enter the subtitle in the Report title 2 box.

    This subtitle displays in smaller type, directly beneath the main title.

  3. Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title and subtitle, and footer.

When outputting to PDF, Standard reports automatically include the Created on timestamp and page number at the bottom of the page.