The Bank Deposit form is used to record the depositing of funds, from any source, to a Bank Account.  The Bank Deposit form pulls any Undeposited Transactions from the GL Account assigned to the 'Undeposited Funds' field in System Preferences: Default Accounts


Manual Deposits can also be created using the Bank Deposit form. Bank Deposits are used when auto-matching uploaded Bank Activity and when performing a Bank Reconciliation.



Create a Bank Deposit



Hover over the ‘Banking’ menu in the Top Ribbon and select ‘Deposit’.  The Bank Deposit form will load in a new tab


Field

Description

1

Number

The auto-generated number for the bank deposit. Starting numbers and prefixes can be adjusted on the autonumbering page.

2

Date

The Date of the Bank Deposit. Will default to the Current Date.

3

Checking Account

Select the Checking Account where the Deposit will be recorded.

4

Check Memo

Enter a check memo for the deposit. Check memos can be used in auto-matching Bank Rules in Bank Activity.

5

Location

The location of the bank deposit. Will default to the user's default location.



Undeposited Payments tab


The contents of this tab comprise all Cash Receipts that have yet to be deposited. This tab can be used to group the deposits together for a more streamlined 'auto-match' when uploading Bank Activity.




Field

Description

1

Balance

The checking account balance of the account selected in the Checking Account field. 

2

Export to Excel

Exports the bank deposit records listed to excel. This button applies to the selected tab only. When on Undeposited Payments, this will export the list of undeposited payments. When on the Adjustments tab, the list of adjustments will export. 

3

Increase/Decrease Size

Increases (+Size) or decreases (-Size) the size of the deposits grid. 

4

Checkbox

When selected, individual payments that are to be included in the Bank Deposit.

5

Date

The date the payment was received.

6

Amount

The dollar amount of the received payment.

7

Transaction

A hyperlink to the record that created this payment.

8

Location

The Origin Location of the Payment.

9

Payment Method

The Payment Method of the Payment.

10

Received From

The customer that the payment was received from (used in conjunction with customer records when receiving AR payments).

11Exclude

This button will permanently Exclude this Deposit from appearing in the Undeposited Payments tab on the bank deposit form. Once this button has been clicked, the screen should be refreshed to remove the deposit from the list.


Note: Excluded payments cannot be re-included. Do not click this unless certain of desired exclusion. 


12
Totals

The sum total of all selected payments (checkbox = checked) and the total deposit amount (includes any adjustments).



Note: If grouping payments together, click on the ‘Payment Method’ column to sort the data in the grid by Payment Method or click on the small triangle to the right of the word to restrict the view to a specific Payment Method. This is very helpful when grouping together deposits of a similar method across multiple days.



Adjustments Tab


Adjustments can be made to the selected Deposits from the 'Undeposited Payments' tab or new Deposits can be entered without any Undeposited Payments.



Adjustments with Undeposited Payments


There are several reasons a Deposit Amount actually deposited doesn’t tie directly to the amount of the Daily Sales Summary or AR Payment. Regardless the reason, the easiest way to account for the discrepancy is to record the difference on the ‘Adjustment’ tab after selecting the payments to be deposited. The Deposit Amount can be adjusted to increase or decrease the total Amount.



To enter an adjustment, select the Adjustment GL Account (this may be ‘Over/Short’ or a specific expense/income account if we know the reason for the difference), then the Amount, add an optional comment, then select the Location. Click ‘Add’ to add the Adjustment Detail line. Enter a Positive number for an Increase adjustment or a Negative number for a Decrease adjustment.




New Deposit - Adjustments without Undeposited Payments


The 'Adjustments' tab can also be used to record miscellaneous Deposits not related to any previously received payments.



To manually create a Deposit, select the Payment Source GL Account (this may be ‘Over/Short’ or a specific expense/income account), enter the dollar Amount, add an optional comment, then select the Location. Click ‘Add’ to add the Deposit Detail line.



Distribution Tab


Upon saving or approving either type of Deposit, the 'Distribution' tab will appear where we can see the Deposit distribution, including any adjustments that were entered.