Summary

The Transactions by Date Report displays a list of committed or uncommitted transactions filtered by a date range, batch and/or transaction type. Each transaction line item included on the report will display as a separate item on the report.

The transactions that will display on the Transaction By Date Report is affected by the selection of the Charge For Deposit toggle in the Setup window (UB> Utilities> Setup> General tab). When a deposit is generated, there are three transaction line items created: a Billing line item to record the obligation of the customer to pay the deposit amount, the Payment line item to record the payment of the deposit amount and the Deposit line item to record the obligation to refund the deposit amount. If the Charge for Deposit toggle on the Setup window is not checked the Payment and Billing transaction lines attached to a deposit type transaction will not be included on the report. If the toggle is checked, the payment and billing transaction type associated with the deposit will display on the report.

Step by Step

1     Open the Transactions by Date window (UB> Reports> Transactions by Date).

2     Configure the report.

• Select the billing cycles you would like to include in the report in the Cycles field.
  • Press CTRL+A to select all billing cycles. Press SPACE to check or uncheck the highlighted toggles.
  • Hold down SHIFT to select a range of billing cycles. Press SPACE to check or uncheck the highlighted toggles.
• Check the toggles in the Adj Types field to select the adjustment types to include in the report.
  • The Adj Types field will only be active if the Adjustment toggle is checked in the Tran Types field.
  • Press CTRL+A to select all adjustment types. Press SPACE to check or uncheck the highlighted toggles.
  • Hold down SHIFT to select a range of adjustment types. Press SPACE to check or uncheck the highlighted toggles.
• Enter a date in the Tran Date From and Tran Date To field to filter the transactions that display in the report.
  • The date type that will be used to filter the report is selected in the Date Type field.
• The Batch Number field is used to filter the transactions included in the report by a committed batch. Select a process in the drop-down menu and then click the Batch Number field label to filter the report by the transactions in a batch. This will open the Batch Selection window.
  • Only committed batches will display in the Batch Selection window.
  • If you do not select a batch number, the process selected in the drop-down menu (Adjustments and Fees, New Billing, etc.) will not affect the transactions that are included in the report.
• Select a Date Type from the drop-down menu.
  • The Journal Entry Date is the date a transaction is posted to the general ledger. You can view the journal entry date of a transaction on a UB customer account (UB> Maintenance> Account> History tab> JE Date field).
  • The Post Date is the date that a transaction is committed. The Post Date can vary from the journal entry date since in many UB processes the journal entry date is manually entered.
    • If the transaction has not been committed, it will not have a post date.
  • The Transaction Date is generally a user-defined date that is entered when the transaction is created. When transactions are generated, this date generally defaults to the current date.
    • The Transaction Date of a transaction on a UB customer account can be viewed in UB> Maintenance> Account> History tab> Transaction Date field.
• Select the Transaction Types you would like to include in the report.
  • You can select all transaction types by pressing CTRL+A. Once all the transaction types have been selected, you can check or uncheck a toggle and the selection will be applied to all the toggles.
  • You can select a range of transaction types by holding down the SHIFT key. When selecting a range, make sure to click on the transaction type description.
  • If you check the Payment toggle the report will include any payments created in the Central Cash/CR module, and Utility Billing> Adjustments and Fees.
  • If you check the Interest toggle, interest transactions created by factoring interest on deposit amounts (UB> Adjustments and Fees> Factor Deposit Interest). If you check the Deposit toggle and you apply the factored interest to the deposit amount (the interest factored on a deposit increases the deposit amount rather than lower the UB customer account balance), the report will also display the increase in the deposit amount. For example, if you factor $15 of interest on a deposit, apply that interest to the deposit amount, and check both the Interest and Deposit toggles on the report, the $15 will display once on the report to create the interest amount (the interest transaction) and once to increase the balance of the deposit (the deposit transaction).
• Select how you would like the report to sort in the Sort By drop-down menu.
  • Select Adj Type, Cycle, Account Number if you would like to group the transactions by adjustment type, cycle code and the UB customer account number.
  • Select Cycle, Adj Type, Account Number if you would like to group and sort the transactions on the report by cycle code, adjustment type and then the UB customer account number.
• Check the Display payments as negative toggle to display the net effect of payments in the report totals.
  • For example, assume the report includes $100 in billings and $50 in payments:
    • When this toggle is NOT checked, all transactions will be added to together and the transactions total will be $150.
    • When the toggle is checked, the payment transactions will display as a negative and the transactions total will be $50.
• The report will display customer number, customer name, transaction type, transaction date, currency (check or cash), transaction line number, amount and services. The report will be sorted by transaction date and will be grouped by fee code.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).