Summary

The Balance by Date report is an auditing report that provides a list of AR accounts with a balance by date based on the journal entry date, the batch posting date, or the transaction date.

Step by Step

1     Open the Balance by Date Report window (AR> Reports> Balance by Date).

2     Configure the report. 

• Select the level of detail you would like in your report from the Report Type drop-down menu.
  • The Summary report will include the Customer Number, Account Number, Customer Name, and Balance for each customer in the fund. Fund and Report totals will also be included.
  • The Detail report will include all of the details in the Summary report as well as Transaction Date, Fiscal Year, Transaction Type, Invoice Number, Description, and Transaction Balance for each transaction included in the customer account.
• Select the Date Type that will determine how the report is filtered.
  • The JE date is the journal entry date specified on any activity included in the report. This date is usually specified during the GL Distribution step of a batch process.
  • The Post date is the actual date a batch is committed. The Post Date is not necessarily the same date as the Journal Entry Date.
  • The Tran date is a user-defined field created when a batch or transaction is first being processed.
    • Transaction dates are entered in the AR> Generate Invoices> Transaction Date field when creating invoices.
• Once a Date Type is selected, enter a date in the Date field to determine when the balance by value will be calculated.
• Filter the funds that display in the report with the Fund From and Fund To fields.
• Check the Show Accounts with Zero Balance toggle to include these accounts in the report.

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.
  • Enter a Date and Time to generate the report and click SUBMIT.