Deposits register report

The Deposits register report shows your deposits in report form, as compared to the list of deposits you can view on the Deposits page. This report allows you to specify a report by bank, and then filter the deposits by date or reporting period. You can also view the individual receipts within that deposit.

Treasurers, accountants, and controllers who need to see the deposits to your accounts.

Subscription

Cash Management

User type

Business, Project Manager, Employee
Permissions

Deposits Register Report: Run

View a monthly report

  1. Go to Cash Management > All > Reports > Registers > Deposits.

  2. On the report settings page, select View.

    The report displays all results for the default reporting period.

  3. 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 as well as 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.

  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. For this report, you specify the bank for the report and whether to view individual receipts within each deposit. 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. Enter a title, subtitle, and footer text for your report.

  5. 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 (that is, save) the report in your company 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.

  • 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 boxes (that is, if you fill in the Reporting period and As of date boxes in addition to the Start date and End date boxes), the system bases your report only on the specified start and end dates. It ignores the Reporting Period and As of Date specified.

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

Time period 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.

  1. To select a particular bank account, select the Bank dropdown list, and then select the bank 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.

  2. To show individual receipts within each deposit, select the Show receipts checkbox.

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

Filter Description

Bank

Include deposits from the selected bank account.

Show receipts

This option shows individual receipts within each deposit.

By default this checkbox is unchecked, which means the report will not include any details.

Formatting

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

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

Sort by

Deposit 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).

  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 type over any default name that the system may have automatically supplied in this box.  

  2. Enter the subtitle in the Report title 2 box.

    • The 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, subtitle, and footer.

What's in this report?

The default Deposits register report consists of the following columns:

Report column heading Description

Date

The date on which the deposit was made.

Deposit ID

The ID associated with the deposit.

Description

A description of the deposit.

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.

Base currency

For multi-currency, multi-entity companies only. The value of the transaction in your base currency, at the time the transaction took place.

Amount

The amount of the deposit in your base currency.

Reconcile date

The date on which the deposit is reconciled.

If the deposit hasn't yet been reconciled, it is considered In transit.

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