Description
The Receipts By Date Report allows you to look at all transactions that go against the Receipt Journal (cash and accrual) for a particular Date Range.
Data: Receipt Journal (cash and accrual)
Note: This report is run for a date range. You may not see the same figures if you are trying to compare this to an Income Statement or a Balance Sheet that uses a GL Period as a Date Filter.
Prompt
Date Ranges
| • | Start & End Date - Filters the data by the Date Type supplied in the next selection. |
| • | Date Type (Required) - Options are: |
| o | Deposit Date - The Deposit date of the journal entry |
| o | Check Date - The Check date of the journal entry. |
| o | Create Date - Create Date of the transaction |
| o | Modify Date - Modify Date of the transaction |
General
| • | Bank Base Code - Filters to a specific GL Base Code of the Transactions. |
| • | Use Bank Org. Filter - When selected, the Bank Org. Unit selected is used to filter the report. |
| • | Bank Org Unit - Filters to a specific the Organizational Unit related to the GL Base Code of the Transaction. |
| • | Include Org. Children - Includes the Organization Units Children when filtering to a specific the Organizational Unit. |
| • | Is Accrual - When checked, the report looks at the Accrual Journals (Receipts & Disbursements) instead of the Cash Basis Journals (CBReceipts & CB Disbursements). Note: The Cash Basis Journals are populated by running the Cash Basis Conversion Utility. |
| • | Hide Detail - When selected, the detail of the Disbursement Journal is hidden. |
| • | Show Comments - When checked, the report will show the GL Comments from the line-items of the Journals. |
| • | Only Clients - When selected, only Firms that are "Clients" will be returned in the report. |
| • | Currency Type - The Type of Currency to be used when running the report. Options are Base, Company, Project and Transaction. |
| • | Currency Code - The Currency Code to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency |
Sorts
The Sorts section Groups & Sorts the report by Check Date, Check No (Number), Create Date, Modify Date, Payee and Bank (Account).
| • | Sort 2 - Second Level Sort. |
| • | Sort 3 - Third Level Sort |
Report
Report Columns
| • | Bank Account - Bank G/L Account associated with the transaction. |
| • | Check Number - Check number associated with the transaction. |
| • | Payer Name - Name of the Check Payer. |
| • | Check Date - The Check Date Associated with the transaction. |
| • | Amount - Amount of the Receipt Journal Transaction. |
| • | Account - G/L Account associated with the detail of the Receipt Journal Transaction. |
| • | Project - The Project associated with the detail of the Receipt Journal Transaction. |
| • | Invoice Number - The Purchase Journal Invoice Number associated with the detail of the Receipt Journal Transaction. |
| • | Amount - The amount of the line item in the detail of the Receipt Journal Transaction. |
Sample(s)
|