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.
  • Click the toggle next to the field title to select all billing cycles.
• 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.
  • Click the toggle next to the field title to select all adjustment types.
• 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> Account History sub-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> Account History sub-tab> Transaction Date field.
• Select the Transaction Types you would like to include in the report.
  • You can select all transaction types by clicking the toggle next to the field title.
  • 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.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon   next to the Print button in order to schedule the report to generate at a later date and time.
  • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button   on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.