Enhanced interface

Receipts register report

The Receipts register report lists your receipts and enables you to perform the following actions:

Drill down to the invoices to which the receipts were applied.
Drill down to the customer's information from this report.
Reverse transactions.
Find payments that have not been fully applied, where the amount received is greater than the amount applied.

You can view the report in greater or lesser detail, and restrict it to receipts that have not yet been deposited.

Multi-entity shared users can reverse a transaction when they are at the top level of the company or in the entity that created the transaction. Otherwise, the option to Reverse is disabled.

For information on terms that may differ in your location, see Terminology across locales.

Subscription	Cash Management
User type	Business, Project Manager, Employee
Permissions	Receipts Register Report: Run

View a monthly report

Go to Cash Management > All > Reports > Registers > Receipts.
On the report settings page, select View.

The report includes all results for the default reporting period.
To refine the report, select Customize.

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.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page. Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

Customize the report

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, Sage Intacct 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 bank and customer. Generally, 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.
Enter 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:

To...	...select
View the report now, in your browser.	View
Display the report now, in printable PDF format.	Print
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.	Process & Store
Add the report to your dashboard	Add to Dashboard
Memorize (save) the report so that later you can refer back to it or modify and re-run it.	Memorize
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.	Export
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.

Set the time period

In the Time period section do one of the following:
- Select the Reporting period down arrow, and then select the time period you want.
- Enter an As of date (the date that the system will use as a baseline for the period you select. Leave blank for today's date).
OR
- Enter a specific Start date and/or a specific End date.

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 each item in the Time period section of this report settings page:

Time period box	Description	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	The date used as a baseline for the reporting period you select. 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 force the system to wait for you (or anyone using this report) to enter a time period before it runs the report.

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.

Filter the report

To select a particular bank account, select the Bank dropdown list, and then select the account you want the report to include.

Administrators can pre-set a default bank in the Configure Cash Management page. For multi-entity shared companies, you can set a default bank on an entity-by-entity basis.
To show results for a specific customer, use the Customer dropdown list.
The following filter options display only if you work in a multi-currency and multi-entity environment:
1. To select transactions of a specified currency, use the Transaction Currency dropdown list. This option appears only if your company uses foreign transaction currencies. If you do not make a selection, the report contains transactions of all currencies. However, the report itself is in base currency.
2. To filter the report by geographic location, enter the name of the region, country, state or territory, or city in the Location box, or select the down arrow, and then select the location you want from the list that appears.
  
  You must enter or select a location if you want to run this report at the top level. The location you specify determines the appropriate currency.
3. To filter the report by department within the company, enter the name of the department in the Department box, or select the down arrow and then, from the list that appears, select the department you want.
4. If you want the report to cover certain locations regardless of what you select in the Location box, use the Show For field. To do this, in the Show For field, select the down arrow and then select the locations you want the report to cover:
  - If you want the report to include data for all locations regardless of the entity you're currently using, select All Locations.
  - If you want the report to include data only for the entity you're currently using, select This Location.
  - If you want the report to include data only for locations that are child locations of your current entity, select Child Locations. 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 San Francisco.
Select the Show details checkbox if you want the report to add a second line of data, which includes Account, Account Label, Invoice No., Location, Department, and Memo.
Select the Undeposited receipts only checkbox if you want the report to include undeposited receipts only. Otherwise, it displays all receipts that meet the filter criteria.

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

Filter	Description
Bank	The bank account you want to include in the report.
Customer	The customer you want to include in the report.
Location, Department, Individual Report, Prompt On Run, and Show For	Appears only for multi-entity shared companies. Enables you to limit report results to a specific location and/or department. Individual report. If this checkbox is cleared, the data is summed in a single report. If this checkbox is selected, each department and/or location combination has its own report page. The order you shuffle the groups determines the order in which their pages are printed. Due to their potentially large size, reports with departments and locations on individual pages can be run offline only. Prompt on run. Select this checkbox to force the system to wait for you (or anyone using the report) to enter a location/department before it runs the report. Show for. Enables you to display transactions for certain locations regardless of the location selected in the Location dropdown list. All ocations: Display the data of the location/entity you selected and its children. This location: Only display the data of the location/entity you selected and not of its children. Child locations: Only display the data of the children of the location/entity you selected.
Show details	Select this checkbox if you want a second line of data, which includes Account, Account label, Invoice No., Location, Department, and Memo. By default this checkbox is cleared, which means the report will not include any details.
Undeposited receipts only	Select this checkbox to include undeposited receipts only.

Formatting

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

Format the report

To change how the report results are sorted, select the Sort By dropdown list and then select either Receipt date or Amount.
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	Description
Sort by	Receipt 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

Format

Description

Sort by

Receipt 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 .pdf version of this report. (Select Print to get the .pdf version).

What's in this report?

The default Receipts Register report consists of the following columns:

Report Column Heading	Description
Receipt date	The date you received the payment.
Customer	The customer who made the payment.
Payment method	Method used to make the payment.
Transaction number, Transaction date	Information about the payment.
Txn currency	For multi-currency, multi-entity companies only. The currency in which the transaction was paid.
Txn amount	For multi-currency, multi-entity companies only. The amount of the bill in the currency preferred by the vendor.
Amount	The amount paid by the customer in your base currency.
Amount applied	The amount of the payment that has already been applied to invoices. It might or might not equal the amount of payment. If you have not applied all of the payment, the number in this column is less than that in the Amount column. Consequently, one function of this report is to find any payments that have not been fully applied.
Deposited on	The date you deposited the payment.
Bank account	The bank account where you deposited the payment.
Invoices	Drill down to view transaction details.
Reverse	Reverse the entry.

Reverse a transaction

Find the entry you want to reverse in the receipts register, and select Reverse at the end of the entry.

The Transaction Reversal Date page appears.
Select the date for reversing the transaction.

The reversal date is usually the original transaction date or a later date.
Select Submit.

The Receipts register page removes Reverse and tags the entry as Reversed. Intacct adds an additional balancing entry, which it tags as Reversal.

Why can't I undo a reversal?

Undoing a reversal isn't in accordance with accounting best practices. Instead of undoing a reversal, perhaps one that was done by mistake, re-enter the original transaction, correcting any errors.

This ensures that the original transaction, reversal, and new transaction provide a valid audit trail and are compliant.