AP Reclassification report
Related information
Related topics
The Accounts Payable (AP) Reclassification report displays a list of documents with data that was reclassified from one account to another in the past month and the names of those who reclassified them.
Use this report to reclassify expenses from one account to another and 1099 categories.
Accountants and controllers, those responsible for managing the company’s financials. You can use this report as an audit trail.
For information on terms that may differ in your location, see Terminology across locales.
| Subscription | Accounts Payable |
|---|---|
| User type | Business, Employee |
| Permissions | Reclassification Report: Run |
Generate a report
-
Go to Accounts Payable > All > Reports > Reclassification.
View a monthly report
- Generate the report.
-
On the report settings page, select View.
A report showing results for the default reporting period appears in your browser.
- Optionally, to refine the report, select Customize.
Some of your customized settings persist from session to session, but others do not.
When you return to this page, the following settings retain previously made changes:
- All fields in the Format section
- All fields in the Titles section
- Checkboxes and option buttons in the Filters section
For example, if you enter My latest report into the Report title 1 field, the next time you run this report the Report title 1 box displays My latest report.
The following fields display default settings every time you return to this page to run this report. If you changed any of these settings the last time you ran this report, you have to change them again. These fields do not retain changes:
- Time period section
- Dropdowns in the Filters section
Not all reports include all of the above sections.
Customize and run
Before running the report you can select the time period and types of items to include, and specify how you want the report to appear.
-
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.
-
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 vendor and location. As a general rule, to get fewer and more precise results in your report, set more filters.
-
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.
- Type a title, subtitle, and footer text for your report.
-
To view, process, memorize, export, or customize the report or add it to the dashboard, select one of the following options:
- View: View the report now, in your browser.
- Print: Display the report now, in printable PDF format.
- Process & store: Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.
- Add to dashboard: Add the report to your dashboard.
-
Memorize: Memorize (that is, save) the report 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.
- Export: Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.
- Customize: After you run the report, return to the main report page and refine the report further.
- Email: After you run the report, email to others.
Some options are only available if you access the report from the Reports center.
Time period
You can use one of the pre-defined reporting periods available from the Reporting period and As of date boxes, or create your own reporting period using the Start date and End date boxes.
In the Time period section, do one of the following:
- Use the Reporting period dropdown list to select the reporting period. Either enter a date in the As of date field or use the calendar tool to select a date.
- Enter a specific Start date, End date, or both. Alternatively, use the calendar tool to select the desired dates.
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), Intacct generates your report based on the start and end dates. It ignores the As of date.
The following table describes the fields in the Time period section.
| Field | Description |
|---|---|
|
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. |
|
As of date |
The date that Intacct will use as a baseline for the reporting period you select. Defaults to today's date. |
|
Start date |
Leave the Start date blank to include all information from the earliest date of your Intacct data up to and including the end date. |
|
End date |
Leave the End date blank to include all information from the start date up to today. |
|
Prompt on run |
Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report. |
Filters
Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. 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
- To show results for a specific vendor type, select the Vendor type dropdown, and then choose the vendor type you want the report to include, such as consultants or distributors.
- To show results for a specific vendor or range of vendors, use the From vendor and To vendor dropdowns.
-
To filter the report by geographic location, either enter the name of the region, country, state or territory, or city in the Location dropdown list. Or, select the location from the list.
Enter or select a location if you want to run this report at the top level. The system uses the location that you specify to determine the appropriate currency.
- To filter the report by department within the company, enter the name of the department in the Department dropdown list. Or, select the department from the list.
-
If you want the report to cover certain locations regardless of what's selected in the Location dropdown list, use the Show for dropdown list to select the locations for the report:
- All locations: To include data for all locations regardless of the entity that you're currently using.
- This location: To include data only for the entity that you're currently using.
- Child locations: To include data only for the locations that are child locations of your current entity. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.
- To show only transactions reclassified by a specific person, select that person's user ID from the User ID dropdown menu.
- Select the type of transactions to include in this report:
- Bills only: include only bills that were reclassified
- Adjustments only: include only adjustments that were reclassified
- Purchases only: include only transactions from purchases that were reclassified
- All: include bills, adjustments, and transactions from purchases that were reclassified
In a multi-entity environment, you can filter by location, department, or both.
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. |
|
Vendor type |
Include data only for the type of vendor specified. By default this box is blank, which means the report will include all vendor types. |
|
From vendor, To vendor |
Includes data only for a specific vendor or range of vendors. By default these boxes are blank, which means the report will include all vendors. |
|
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.
-
To sort the report results, select the Sort by dropdown list, and then select the category to sort by.
The abbreviation "desc" after an option means "Descending order", such as reverse alphabetical or reverse numerical order.
- 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:
| Field | Description |
|---|---|
|
Sort by |
Date is the default. |
|
Page orientation |
Portrait: display or print the report pages vertically. Portrait is the default layout. Landscape: display or print the report pages horizontally. |
Titles and a 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.
-
Enter the title in the Report title 1 box.
This title appears in large type at the top of the page, directly under your company name,
You can type over any default name that might have been supplied automatically in this box.
-
Enter the subtitle in the Report title 2 box.
This subtitle appears in smaller type, directly beneath the main title.
- Enter the footer text in the Footer text box. Footer text appears at the bottom center of the report.
You can use up to 80 characters, including spaces, in each title, subtitle, and footer.
What's in this report?
The default AP Reclassification report consists of the following columns:
| Column heading | Description |
|---|---|
|
Vendor |
The ID and name of the vendor |
|
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 date |
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.
