Summary

Trial Balance by Date Report displays the balance of UB customer accounts. The report will display the billings, adjustments, payments and balance forward for each customer account included on the report.

Step by Step

1     Open the Trial Balance by Date report (UB> Reports> Trial Balance by Date report).

2     Configure the report. 

• Select the billing cycles that should be included in the report in the Cycles field.
  • You can select all billing cycles clicking SELECT ALL or by pressing CTRL+A.
  • All billing cycles that have been set up in UB> Maintenance> Cycle Code will display in the Cycles field.
  • You can view the billing cycle attached to a UB customer account in UB> Maintenance> Account> Account tab> Account sub-tab> Billing Cycle field.
• Enter a date in the From Date and To Date to filter the transactions on the report. The type of date used to filter the transactions is selected in the Date Type drop-down menu.
• Select the type of date that will be used to filter the report in the Date Type drop-down menu. This field is used in conjunction with the From Date and To Date fields.
• The Journal Entry Date is the date a transaction is posted to the general ledger. The journal entry date is generally entered during the GL Distribution Report step of most batch processes. You can view the journal entry date of a transaction on a UB customer account in 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.
  • The Transaction Date is generally a user-defined date that is entered when the transaction is created.
    • 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 Report Type from the drop-down menu.
  • The Detail report will display the services attached to every account and the balance of each service on the account. The services will display on the report as service abbreviation, not the service name.
  • The summary reports will only display the balance of the customer account. 
• Check the Include Uncommitted History toggle to include uncommitted transactions on the report.
  • If you are using this report to tie into the GL, you do not want to check this toggle.
  • Do not check this toggle if you selected Post Date in the Date Type drop-down menu. The post date is not assigned to a transaction line item until the transaction is committed.
• Check the Show deleted accounts with no balance forward and no activity in the specified date range toggle if you would like to include those accounts on the report.
• The Trial Balance by Date report will display the customer information, the services on the customer account, beginning balance, billings, adjustments, payments, and balance forward filtered by the selected date range.
  • If you are balancing UB to the GL, the difference between the Beginning Balance and the Balance Forward columns on the report should be equal to the net change of the UB receivable accounts in General Ledger module.

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.