AP Reclassification report
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.
To generate this report, go to Accounts Payable > All > Reports > Reclassification. The AP Reclassification Report page appears.
| Subscription | Accounts Payable |
|---|---|
| User type | Business, Employee |
| Permissions | Reclassification Report: Run |
View a monthly report
- When the report page appears, select View.
- A report showing all results for the month to date appears in your browser.
- To refine the report, select Customize to return to the main report page, and follow the steps in Customize and Run This Report in the next section.
Some of your customized settings persist from session to session, but others do not.
When you return to this page again, the following settings retain previously made changes:
- All fields in the Format section
- All fields in the Titles section
- Check boxes 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
- Dropdown in the Filters section
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.
-
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.
-
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
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), Sage 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:
| 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 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.
What's in this report?
The default AP Reclassification report consists of the following columns:
| Report 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.