Enhanced interface

Adjusted available cash report

The Adjusted available cash report includes true balances for all bank accounts by including all pending transactions.

Immediately after you complete the pay bills process, you can run this report to view your available bank balance. The cash balance reflects the bills that you paid and any other applicable pending transactions that have yet to hit the bank (beginning balance - pending transactions = ending balance).

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

Subscription	Cash Management
User type	Business, Project Manager, Employee
Permissions	Adjusted available cash: Run

View a monthly report

Go to Cash Management > All > Reports > Adjusted available cash.
On the report settings page, select View.

The report includes all results based on the default As of date.
To refine the report, select Customize.

Customize and run

The Adjusted available cash page gives options for filtering and formatting the report. You can set the time period, checking account, location, department, and more to meet your reporting output needs. You can also format the report to show only the level of detail you want to see, grouped, and totaled in a way that makes sense for you.

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 As of date from the dropdown menu.
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 location and department. 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 arrange how to group and display the data contained in the report.
Enter a title, subtitle, and footer text for your report.

View, process, memorize, export, or customize the report or add it to the dashboard by selecting 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 (that is, 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

Set the report time period

Use the default date, or enter a date in As of date.

This date determines the beginning bank balances and pending transactions to include in the report. Only transactions that have an earlier date than, or an equal date to, the As of date are included.
Select Show all pending transactions to override the As of date and include all pending transactions, including those with payment dates later than the As of date.

Report option	Description
As of date	Accept the default date, or select another date for reporting on beginning bank balances. The report includes all pending transactions that have a date earlier than or equal to the As of date.
Show all pending transactions	Include transactions that have payment dates greater than the As-of date.

Report filters

You can set up any combination of filters to isolate and assemble the data you want in your report.

Filter the report

Select the appropriate Checking account.

Only active checking accounts appear. You can also select to run the report for All checking accounts.

At the top level, this dropdown list includes all active checking accounts, including entity-level accounts.

At the entity level, this dropdown list includes all active checking accounts available at the entity level.
To run this report at the top level for companies with multiple base currencies, select a Location.

The location you specify determines the appropriate currency.
Optionally, filter by Department.
To include certain locations regardless of what you select as the Location, use the Show for field.
- All locations: Include data for all locations regardless of the entity that you're currently using.
- This location: Include data only for the entity that you're currently using.
- Child locations: Include data only for locations that are child locations of your current entity.
  
  For example, your current entity is California, and you have child locations for San Francisco and Los Angeles. Use this option to include data only for Los Angeles and San Francisco.
Select Show details to output the report in detail mode.

See what information is included in detail mode.
Select Hide back accounts with no transactions to reduce clutter in the report output by hiding back accounts that have no transactions for the period.

Report option	Description
Checking account	Select from a dropdown list of all checking accounts in Sage Intacct, including entity-level accounts. Only active checking accounts appear for selection.
Location	Filter transactions by location. Columns are displayed in the report for location. For multi-entity shared companies with multiple base currencies: Reports that you run at the top level require a location to determine the appropriate currency.
Individual report	By default this checkbox is clear, which means the information is summed in a single report. However, if you select this checkbox, each department and 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	If selected, when you run the report, Sage Intacct prompts you to enter a location or department before running the report.
Show for	Include certain locations regardless of what you select as the Location. All locations: Include data for all locations regardless of the entity that you're currently using. This location: Include data only for the entity that you're currently using. Child locations: Include data only for locations that are child locations of your current entity. For example, your current entity is California, and you have child locations for San Francisco and Los Angeles. Use this option to include data only for Los Angeles and San Francisco.
Department	Filter transactions by department. Columns are displayed in the report for department.
Show details	Select to show the following: payment date vendor bank account currency payment method payment status adjusted available cash balance Leave this checkbox blank to see the following columns for the summary level report: bank account currency balance as of date total amount of unconfirmed payment requests adjusted available cash balance
Hide bank accounts with no transactions	Includes only bank accounts with transactions. This option removes clutter from the report by hiding bank accounts that have no transactions for the period.

Formatting

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

Format the report

Use the Group by option to set how you want the information in the output to be grouped.
- None: display no grouping within the report.
  
  This is the default, and is useful for outputting just the raw data for easy manipulation.
- Bank account ID: display information outputs grouped by bank account ID.
- Bank name: display information outputs grouped by bank name.
If you set the Group by option to a value other than None, you can use the Subtotals dropdown to display subtotals for the specified groups.
- None: display no subtotals within the report. This is the default.
- Payment method: display subtotals by payment method.
- Payment status: display subtotals by payment status.
- Payment method and payment status: display any nested subtotals in this specific order.
  - Display first-level subtotals based on payment method.
  - Display second-level subtotals based on payment status.
Use Sort by to select options to control the sorting of data in the report output.
- Payment date
  
  This is the default sorting method.
- Amount
- Payment method
- Payment status
- Vendor ID
- Vendor name
- Employee ID
- Employee name

Format option	Description
Group by	Select options for grouping the report information output. None: Default. No grouping of output, which is useful for outputting just the raw data, for easy manipulation. Bank account ID: Group output by bank ID. Bank name: Group output by bank name.
Subtotals	Select options for how to display subtotals in the report when Group by is not None. None: Default. Display no subtotals. Payment method: display subtotals by payment method. Payment status: display subtotals by payment status. Payment method and payment status: display any nested subtotals in this specific order. Display first-level subtotals based on payment method. Display second-level subtotals based on payment status.
Sort by	Sort by Payment date, which is the default, or select another sorting type. Amount Payment method Payment status Vendor ID Employee ID Employee name
Page orientation	Layout for the report. Portrait is the default. 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 Adjusted available cash report in summary mode (Show details is unchecked) consists of the following columns.

Report column heading	Description
Bank ID and bank name	The Bank ID and the bank name of the account from which the payment was drawn.
Currency	For multi-currency companies. The currency set for the bank account.
Balance as of date	The balance of the account based on the As of date.
Total unconfirmed payment requests	The amount in pending payment requests. These are payments that have not yet been completed.
Adjusted available cash	The beginning cash balance in the account and the adjusted cash balance. The adjusted cash balance is the beginning balance less the pending transactions that have yet to hit the bank.

The Adjusted available cash report in detail mode (Show details is checked) includes the following columns.

Report column heading	Description
Payment date	The date the bill is to be paid. This date is set on the Pay bills page.
Vendor or Employee	The vendor ID and name, or the employee ID and name, for the payment.
Bank	The bank account from which the payments were drawn.
Currency	For multi-currency companies. The currency set for the bank account.
Payment method	How the payment is to be made, such as Printed check, ACH, and so on.
Payment status	Status of the payment. Selected: amounts for bills selected for payment and for which there is a payment request created Approved: all approved payments Partially approved: payments that are not yet approved by all required approvers Rejected: all payments that were declined by an approver Unconfirmed check: printed, but unconfirmed checks Delivered: ACH file generated
Amount	The amount of the payment.
Totals	The beginning cash balance in the account and the adjusted cash balance. The adjusted cash balance is the beginning balance less the pending transactions that have yet to hit the bank.