Deposit Register

Owned by Stephen Juliano (Unlicensed)
Last updated: Mar 04, 2022 by Colleen Juliano
6 min read

Overview

This screen replaces the old POS Register Deposit screen, but also opens up the ability to control your deposit dates for all funds collected by your company. Cash use to tie directly into the Bank Account GL as soon as it was collected in features like Cash Receipts, Customer Deposits and Non-AR Cash, however, with the new Cash Flow changes, all cash will now rest in your Undeposited Funds account. It can be reviewed in this screen and officially deposited into your Bank Registry at the amount you need in order to easily reconcile with your Bank Statements. Non-On Account terms are also a part of this feature, but are handled in more detail than cash.

Detail

There is an “Open Register Total” near the top that displays the total amount of all funds sitting in your open registers. The “Total Undeposited Funds” field includes the Open Register Total plus all of the available transactions in this screen and this total should reconcile with your Undeposited Funds account balance. The Open Register Total is separated because even though they are technically undeposited funds, they do not appear for deposit until the register has been closed.

Search Criteria

This section of the screen is how you will search and select the transactions you wish to group together into a batch for deposit. There is a Start and an End Date option along with a filter for the various transaction types. If branch management is turned on, you will see that as an option. It is important that your transactions are accurately assigned a branch. To help locate transactions that were never assigned to a branch, there is a “Missing Branch” option in the Branch filter. This is a means for us to work together to recognize and resolve any areas of the program that may not be recording the branch properly.

The Preload POS button is supposed to help users who were used to using the old Deposit Registers screen. It will grab all POS Transaction within your Date Range and pre-select and save them into various batches per terms type.

Cash On Hand

Your Cash on hand is recorded on a ledger that simply keeps track of cash transactions in and cash transactions out. There are 5 ways to adjust the Cash you have on hand: POS (Sales, Returns, Cash Outs), Cash Receipts, Customer Deposits, Refunds and Non-AR Cash Receipts. The amount for your Cash on Hand is displayed for each cash type terms you may have. It is a summary total and is not effected by any of the Trans Date or Trans Type filter options. It will separate by Branch.

To add Cash to your batch, just enter a lump sum amount to pull from your Cash on Hand. This is essentially a deposit screen, so you are virtually removing cash from your undeposited funds and officially depositing it into your bank account. As you adjust your deposit amount, the Unsaved Total will adjust accordingly.

Non-Cash Transactions

Non-On Account terms types, such as Credit Card and Check, are recorded in the Non-Cash Transaction section and are in greater detail than your Cash on Hand. The transactions are grouped in batches under the same transaction date and type of transaction. When clicking into a record on the left, the smaller window labeled “details” will show all of the relevant transactions under that summary.

To add these details to your current batch, just check the box. As you check/uncheck the boxes, your Unsaved Total will adjust accordingly.

Saving Batches

In order to save a batch, you have to enter a Deposit Date and a Bank Account for the batch. An optional description field is available for you to use if there is a common denominator for your deposit that you wish to help make it standout later during the Reconciliation process, otherwise, it will default to the Batch Number, which is an automated sequence. Once the batch is saved, the totals from Unsaved will move into the Saved Totals and the saved details for that batch will appear in the list on the right had side under “Current Batch”. When finalizing your deposit, the current batch is what will be processed. A multi-batch processing option will come later.

Saved Batches

If a batch was saved and left unprocessed, it will appear in the “Saved batches” section in the lower right corner. You can double-click on a saved batch to pull it up and set is as your “current batch.” If you already have a batch open or have unsaved details selected, you will be given the option to save your current work before loading the new batch or will even be able to merge the two together.

Processing

Using the lightening bolt will finalize your current batch and create entries in the Bank Registry. You can then reconcile these batch deposits as you were prior in the Bank Reconciliation feature. They will be identified by their Description and will have a sub-list for each of the details for easy review.

Corrections

If you are missing transactions, or need to make correcting transactions, we added the “Edit Funds” tab.

 

  • Register - Selects the POS station the transaction will run through. This affects which Cash On Hand is changed.

  • Description - The description that will be on the Bank Transaction

  • Terms - Which type of undeposited Fund is affected

    • CC, Check, Other Term Types - If the Term is a CC, Check, or Other term, it will create a transaction you will need to reconcile

    • Cash Term Type - Using Cash Term will affect the “Cash On Hand” Total. The Register selected will determine which Cash On Hand is affected

  • Trans Date - The Date of the transaction

  • Amount - The amount of your transaction. This can be positive or negative, depending on the goal

User Guide

Feature Overview

  • The Following Screens No Longer Post To The Bank

    • Cash Receipts

    • Customer Deposits

    • POS Register Deposits

    • Non-AR Cash Receipts

  • The Following Screens Post To The New Screen

    • Cash Receipts

    • Customer Deposits

    • POS Register Deposits

    • Non-AR Cash Receipts

  • New Screen To Manage Deposits To The Bank

Undeposited Funds Screen (UDF) Step 1

  • Set Bank For Deposit

  • Select Deposit Date

  • Enter Deposit Description

UDF Screen – Selecting Non-Cash

  • Select Items For Deposit

    • Note: You can select either an entire batch or individual details from that batch

  • Save Your Batch

UDF Screen – Selecting Cash

  • Clear The Screen To Start A New Batch

    • Note: You will need to select a bank, deposit date, and description again

  • Enter Cash Value For Deposit

  • Save Batch

UDF Screen – Depositing Batches

  • Select Batches For Deposit

  • Click The Lightning Bolt

UDF Screen – End Result (Bank Rec.)

  • Note: To see the batch detail click the plus sign

UDF Screen – Extras – Selecting Everything

  • Enter a Bank

  • Click Preload All

  • Select The Deposit Dates

UDF Screen – Extras – Preloading POS

  • Enter A Bank And Deposit Date

  • Click Preload POS

UDF Screen – Extras – Important Totals

  • Open Till Total: Total of Tills Across All Open Registers For That Branch

  • Open Register Total: Total Amount In All Open Registers For That Branch

  • Total Undeposited Funds: Should Match The G/L Value For That Branch