Receipts By Date

Top  Previous  Next

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:
oDeposit Date - The Deposit date of the journal entry
oCheck Date - The Check date of the journal entry.
oCreate Date - Create Date of the transaction
oModify 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 1 - Top Level Sort
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)