Report: Bank Deposit

The Bank Deposit report shows all receipt transactions (cash, check, credit, and debit card) included in a single deposit to the bank. EFTs, also referred to as wire transfers, received by your bank must be recorded in AMS360. Designating the receipt as an Electronic Transfer automatically creates a separate bank deposit.

The Bank Deposit report shows full general ledger detail for the receipts included in the deposit.

Use the Deposit Slip report as a listing of cash, check, credit and debit card transactions, to accompany your physical bank deposit to the bank.

Report Selections

When the report is accessed from a Quick Reports menu, some selections are pre-filled by default. You can change default entries as needed.

Report Selections

What is this?

Bank

Defaults to the bank selected as the Default Operating Bank in the Bank Center. If incorrect, select the desired bank from the list. The list contains the bank name and general ledger account number.

The list displays only those banks for which you have appropriate security.

Deposit Date Range

Group/Field

What is this?

Current Month

Use this option (default) so all deposits for the current fiscal month appear in the Bank Deposit list. Click Refresh, if necessary.

Select Dates

Use this option to include all deposits in the Bank Deposit list for a specific date range.

Once the date range is selected, click Refresh to display all deposits for the selected date range.

Bank Deposit

Displays all deposits, posted or unposted, for the selected date range. Select the desired deposit from the list.

Posted deposits in the list display:

Deposit Date
Deposit Type (bank deposit or EFT payment).
Amount of the Deposit.
User ID of the person who posted the deposit (if unposted, blank).
Deposit Status (posted or unposted).

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Report Fields

This report shows full general ledger detail for all receipts included on a single deposit, and is reported in separate sections for each receipt type. If there is no data for a section, the section does not print.

Cash
Check
Credit Card
Debit Card

When posted, receipts for EFTs (Electronic Fund Transfer), automatically create a bank deposit for this single transaction.

Report Fields

Description

Report Title

Bank Deposit.

GL Date

Deposit date.

Bank Name

Prints the name of the bank on the deposit.

Account Number

The account number assigned by your bank, as entered in Bank Setup.

General Information Section

General Information

What is this?

Description

Descriptions that apply:

Description	What is this?
Bank Deposit	When the deposit includes receipts for cash, check, debit card, and credit card transactions.
EFT Payment	When the deposit is for a single electronic fund transfer transaction.

Bank GL

General ledger account number for the bank account on the deposit.

Status

Status of the general ledger posting (posted or unposted).

Posting Date

Displays the date the deposit was posted to the general ledger. For an unposted deposit, this area is blank.

Posted By

Displays the login name of the person who posted the deposit. For an unposted deposit, this area is blank.

GL Date

The date the receipt item posted to the general ledger.

From

Received From Code	What is this?
Broker	Broker
BrkgCo	Brokerage Company
Employ	Employee
FinCo	Finance Company
InsCo	Insurance Company
Insured	Insured
Other	Any payee other than the specific types listed in this table.
FeeCo	Fee Company
Vendor	Vendor

Name

The name of the person or business the receipt is from ( payor).

Cust#

The customer number associated with a customer receipt.

Type

Indicates the system account associated with the receipt. If no system account is involved, prints Other.

Type	What is this?
Insured A/R	Insured Accounts Receivable
DB Deposit	Direct Bill Deposit
Fin Co A/R	Finance Company Accounts Receivable
Broker A/R	Broker Accounts Receivable
Comm Stmt	Commission Statement (Employee or Broker)
A/C Stmt	Account Current Statement (Insurance or Brokerage)
Pay Stmt	Fee Company Accounts Payable
DB Comm	Direct Bill Commission (Insurance or Brokerage)

GL #

The general ledger number associated with the receipt item.

Subledger

The Short Name of the associated subledger entity. If the receipt is associated with a customer account, Customer appears in this report field.

Policy/Div

Policy/Div	What is this?
Customer Receipt	Prints the policy # associated with the receipt.
Non-Customer Receipt	Prints the short name of the division associated with the receipt.

Inv/Dept

Inv/Dept	What is this?
Customer Receipt	The invoice number associated with the receipt transaction.
Non Customer Receipt	The department associated with the receipt transaction.

Amount

The amount of the receipt item.

Bank #

The Bank # as entered in receipt data entry.

Deposit

The total amount deposited for the receipt transaction.

Example

One check may be applied to multiple invoices.

Totals

The total deposit subtotaled by Cash, Checks, Credit Cards, and Debit Cards, followed by the Total Deposit amount.

Electronic fund transfer deposits do not have a Totals section because the deposit is for a single transaction.

CSV Columns

Description

BankName

Bank Name

BankAcct#

The account number assigned by your bank, as entered in Bank Setup.

BankGL#

General ledger account number for the bank on the deposit.

DepositGLDate

Displays the date and time the deposit was posted to the general ledger. For an unposted deposit, this field is blank.

Description

Deposit description.

Status

Status of the general ledger posting (posted or unposted).

Posted Date

Displays the date and time the deposit was posted to the general ledger. For an unposted deposit, this field is blank.

Posted By

Displays the login name of the person who posted the deposit. For an unposted deposit, this field is blank.

Section

The receipt type section in which the receipt transaction is reported.

Cash
Checks
Credit Cards
Debit Cards
EFT

ReceiptGLDate

The date and time the receipt transaction posted to the general ledger.

From

Received From Code	What is this?
Broker	Broker
BrkgCo	Brokerage Company
Employ	Employee
FinCo	Finance Company
InsCo	Insurance Company
Insured	Insured
Other	Any payee other than the specific types listed in this table.
FeeCo	Fee Company
Vendor	Vendor

Name

The name of the person or business the receipt is from ( payor).

Cust No

The customer number associated with a customer receipt.

Description

The description of the receipt transaction.

Type

Indicates the system account associated with the receipt. If no system account is involved, prints Other.

Type	What is this?
Insured A/R	Insured Accounts Receivable
DB Deposit	Direct Bill Deposit
Fin Co A/R	Finance Company Accounts Receivable
Broker A/R	Broker Accounts Receivable
Comm Stmt	Commission Statement (Employee or Broker)
A/C Stmt	Account Current Statement (Insurance or Brokerage)
Pay Stmt	Fee Company Accounts Payable
DB Comm	Direct Bill Commission (Insurance or Brokerage)

GL#

The general ledger number associated with the receipt item.

Subledger

The Short Name of the associated subledger entity. If the receipt is associated with a customer account, Customer appears in this field.

Policy/Div

The policy number for a customer receipt. Otherwise, the division short name appears.

Inv/Dept

The invoice number for a customer receipt. Otherwise, the department short name appears.

Amount

The amount of the receipt item.

CheckNo

When the Receipt Type is Check, the check number associated with the receipt, if entered.

BankNo

The Bank # as entered in receipt data entry.

Deposit

The total amount of the receipt in the deposit.