External Deposits Report

Make the following menu selections to display this page:

Reports—Accounting Reports—External Deposits

The External DepositsReport lists deposits collected within the current month and prints based on the external batch ID instead of the internal batch ID. It is used is used to verify that all transactions posted and cleared by online payments (or any third party product) were received in eSite and assigned an external batch number.

Unlike the Deposit Journal Report, this report is based on property selection and only includes information for those selected properties.

Note

The External Deposit Report is not supposed to print data that comes from eDex Subsidy Housing web methods.

Selection Criteria

Select Properties

Click to select properties from the Select Properties pop-up. The report runs for all selected properties.

Show Property Recap

Accept the unchecked default to exclude a property recap section or check the box to include a recap section at the end of the report.

Detail Level

Accept the marked Summary default or mark another option. Options include:

- Summary—The report prints a grand total for each journal. Individual batches are not listed.

- By Payment—The report prints a total for each transaction header or individual check. This is the level of detail used to print the deposit slip.

- Detail—The report prints a total for each transaction detail. For instance, if one check includes two transactions, then the report prints a line item for each transaction included.

Report Details

Summary

External Batch

The external batch number as assigned by a third-party product such as for online payments.

eSite Batch

The internal eSite batch number.

Rent/Other

Amount posted to the Rent and Other income codes.

Security Deposits

Amount posted to Security Deposits.

Misc

Amount posted to Misc Income.

Return

Amount posted as a return payment.

Totals

Totals are listed for columns as well as for Batch, Bank Book, Property, Grand Total, and External.

Settlement Amount

The date and amount of the external batch. Displays for External batches only.

Variance

The difference between the eSite Batch Total and the External Settlement Amount. Displays for External batches only.

Note

Normally, a variance should not exist between the eSite batch total and the External Settlement amount. They should be the same.

If a variance amount is seen between the eSite Batch Total and the External Settlement Amount, then it is likely that a payment posted by your third party vendor (for online payments for example) has not yet been transferred to eSite. You will need to contact your third party customer representative and use the secure Correct Transaction feature in eSite to enter the payment.

External Batch

The external batch number as assigned by a third-party product such as for online payments.

eSite Batch

The internal eSite batch number.

Unit

The identifying Unit ID. For example, 01-100.

Name

The name of the primary resident whose payment was submitted and posted.

Date

The date of the deposit.

Eff Date

The date the deposit was effective. Typically, the date it was posted.

Rent/Other

Amounts posted to the Rent and Other income codes.

Security Deposits

Amount posted to Security Deposits.

Misc

Amount posted to Misc Income.

Return

Amount posted as a return payment.

Description

A brief description of the batch.

Reference

Reference number used for tracking or auditing purposes. Only displays if you use reference numbers.

Totals

Totals are listed for columns as well as for Batch, Bank Book, Property, Grand Total, and External.

Settlement Amount

The date and amount of the external batch. Displays for External batches only.

Variance

The difference between the eSite Batch Total and the External Settlement Amount. Displays for External batches only.

Note

Normally, a variance should not exist between the eSite batch total and the External Settlement amount. They should be the same.

Detail

External Batch

The external batch number as assigned by a third-party product such as for online payments.

eSite Batch

The internal, eSite batch number.

Unit

The identifying Unit ID. For example, 01-100.

Name

The name of the primary resident whose payment was submitted and posted.

Date

The date of the deposit.

Eff Date

The date the deposit was effective. Typically, the date is was posted.

Code

The income code applied to the payment transaction within the batch.

Rent/Other

Amounts posted to the Rent and Other income codes.

Security Deposits

Amount posted to Security Deposits.

Misc

Amount posted to Misc Income.

Return

Amount posted as a return payment.

Description

A brief description of the batch.

Reference

Reference number used for tracking or auditing purposes. Only displays if you use reference numbers.

Totals

Totals are listed for columns as well as for Batch, Bank Book, Property, Grand Total, and External.

Settlement Amount

The date and amount of the external batch. Displays for External batches only.

Variance

The difference between the eSite Batch Total and the External Settlement Amount. Displays for External batches only.

Note

Normally, a variance should not exist between the eSite batch total and the External Settlement amount. They should be the same.

If a variance amount is seen between the eSite Batch Total and the External Settlement Amount, then it is likely that a payment posted by your third party vendor (for online payments, for example) has not yet been transferred to eSite. You will need to contact your third party customer representative and use the secure Correct Transaction feature in eSite to enter the payment.

To Display the External Deposits Report

From the eSite menu, select Reports—Accounting Reports—External Deposits.
Click Select Properties. Select the properties for which you want to print the report and click Done.
Select the information you want to see on the report (refer to the Selection Criteria for this report).
Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.