Batch Totals Report Tab

NOTE that this report is run from eFinancials and the report shows data from all modules that have the Batches menu item.

The Summary report provides, for each batch, Total from Batch, Total Entered, and difference, as well as the batch approval status and date. It also breaks out dollar amounts for each batch by invoices, checks, billings, receipts, journal entries, and inventory.

The Detail report provides this same information broken out by transaction. In addition, the detail report includes transaction date, document source and number, vendor name (if appropriate), propertycompany ID, and Post To expense code for each transaction.

If you select to print the Detail report, an Additional sort becomes available, with these options:

You can also print the detail version of this report from the Batches General Tab as either the Batch Proof Report or Batch Audit Report.

Batch Information

The following batch information appears for each batch included on the report.

Batch

The Batch ID, the date it was opened, and the User Name of the person who opened the batch.

Status

The approval status for the batch. If the status is Approved, this includes the approval date and the User Name of the person who approved it.

Detail Information

The following fields appear on the Batch Totals Detail report, the Batch Proof Report, and the Batch Audit Report reports only. This information is sorted by Document Type and ID or Data Entry Order based on your selection for Additional sort. These fields and sort options do not appear on the Batch Totals Summary report.

Document

Identifies the document associated with the transaction. For example, PY-012345678 indicates a payment (PY) and the associated check number (0123456789).

Tran Date

The transaction date.

Acct Date

The accounting date for the transaction.

Pd/Year

The period of the transaction.

EntityCompany

The entitycompany associated with the journal entry.

Account No.

The account number associated with the credit or debit (for journal entries).

PropertyCompany

The propertycompany associated with the allocation for the invoice.

Expense Code

The Post To expense code of the allocation for the invoice.

Description

The expense code Description.

Vend/Cust

The vendor or customer associated with allocation for the invoice.

Void

The dollar amount of the void, if any.

Debits

The dollar amount of the debit, if any.

Credits

The dollar amount of the credit, if any.

Summary Information

The following summary information appears on the Batch Totals Summary, the Batch Totals Detail report, the Batch Proof Report, and the Batch Audit Report.

PropertyCompany Totals

The propertycompany totals for Billing, Void Billing, Receipt, Void Receipt, Invoice, Void Invoice, Payment, Void Payment, JE Debit, and JE Credit. This totals appear on the Batch Proof Report only, and only if you selected the Subtotal Batch Proof Report by PropertyCompany? check box on the Batches General Tab.

Batch Totals

The batch totals for Billing, Void Billing, Receipt, Void Receipt, Invoice, Void Invoice, Payment, Void Payment, JE Debit, and JE Credit.

Transaction Totals

The transaction totals for Billing, Void Billing, Receipt, Void Receipt, Invoice, Void Invoice, Payment, Void Payment, JE Debit, and JE Credit.

Difference

The difference between the batch and transaction totals for Billing, Void Billing, Receipt, Void Receipt, Invoice, Void Invoice, Payment, Void Payment, JE Debit, and JE Credit.

From the eFinancials menu, select Reports—Common Reports—Batch Totals.
From the From Batch and Thru Batch fields, enter a Batch ID range for the report.
To print a summary report, select the Summary button. Or, to print a detailed report, select the Detail button.
Only if you selected the Detail report type, you may select Additional sort option(s):
Document Type and ID
Data Entry Order
Subtotal Batch Proof Report by Company
Include Job Information - The option appears only when at least one entitycompany is set to track jobs, and is unrelated to the permissions of user or entitycompany access.
To print the report for unapproved batches only, select the Unapproved Batches Only check box.
To subtotal the report by PropertyCompany, check the Subtotal by PropertyCompany box. Otherwise, leave the box unchecked.
Select one of the following report printing options:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.

Create Spreadsheet: Prints the report in an Excel spreadsheet.

Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

CO: Batch Totals Report Tab