This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package. |
The Bank Deposit report shows all receipt transactions (cash, check, credit, and debit card) included in a single deposit to the bank. EFT's, 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 Depositreport 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.
Accessing the Bank Deposit Report
This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - Alllist, where you can make your selection.
Click Bank Deposit. This opens the Report - Bank Deposit selection form. Make your selections, pull down the File menu and select to:
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page
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 |
|
||||||
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:
|
||||||
Description |
Accept the default description, or enter a new one that describes the report you are requesting. |
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 EFT's (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 |
|
||||||||||||||||||||
GL Date |
The date the receipt item posted to the general ledger. |
||||||||||||||||||||
From |
|
||||||||||||||||||||
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.
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
Inv/Dept |
|
||||||||||||||||||||
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 Totalssection 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.
|
||||||||||||||||||||
ReceiptGLDate |
The date and time the receipt transaction posted to the general ledger. |
||||||||||||||||||||
From |
|
||||||||||||||||||||
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.
|
||||||||||||||||||||
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 here. |
||||||||||||||||||||
Inv/Dept |
The invoice number for a customer receipt. Otherwise, the department short name appears here. |
||||||||||||||||||||
Amount |
The amount of the receipt item. |
||||||||||||||||||||
CheckNo |
When the Receipt TypeisCheck, 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. |
My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com © 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 10:58 PM |