POS Transaction report - Deposit Worksheet : Windward Software Customer Care

The system uses the data gathered in the POS Transaction Report to create a Deposit Worksheet.

You can modify the values for the Deposit amount for each of the Tender Types and can enter the actual amount of each tender type that is actually on hand after the deposit. The data in the Deposit Worksheet can then be used to build a Journal Entry based on templates you have designed.

The Deposit Wizard displays all of the information for you to review and finally displays a preview of the ledger entry that will be created.

Figure 1: POS Transaction Report - Deposit Worksheet Tab

Columns	Description
Opening Bal	Balance (carry forward) from previous POS report. This column displays the value in Column E from the previous day's transaction report.
Received Today	Total Tender of the day. This column displays a calculated value representing the total brought in for the day for each specific tender.
Deposit Amount	The amount to be tendered. This column will contain the amount being deposited for the specific tender.
Total	The calculated total column is the result of Column A + Column B – Column C. It displays the total remaining amount after deposit.
Actual Amount	This column will be manually entered. This displays the actual amount left out of the deposit. This is primarily used for Cash and represents the opening Balance for the next days transaction file.
Over/Short	This column is calculated by subtracting column D (calc total) from Column E (Actual) to determine if the remaining cash is over or short from what should have been left remaining.

Table 1: POS Transaction Report Deposit Worksheet Tab Columns

Editing a closed POS report will display the values in the bank deposit worksheet as it was when the POS report was finalized.

As a journal entry will be automatically generated from the detailed content of the deposit worksheet, any changes made to auto generated journal entries will adjust the deposit worksheet for the corresponding day.
The journal entry is created from the deposit worksheet, and any changes made to the auto generated journal entry will update the deposit worksheet.

After a POS report is finalized, changes to the deposit worksheet cannot be made manually, and will only change if the auto generated journal entry is changed.

Button	Description
Re-calculate	Click [Re-Calculate] to check or confirm previous computation.
View Journal	[View Journal] will be enabled when there is a Journal entry associated with the Deposit Worksheet. Click the button to open the Journal Entry. Changes that are made to the Journal Entry are reflected on the Deposit Worksheet. If a Journal Entry is deleted, the Deposit Worksheet is also deleted and the next time you view that specific Close File number the system will be ready to create a new Deposit based on the data collected by the system. Once the Ledger Entry is created, either posted or un-posted, you can no longer make changes to the deposit worksheet. There are information labels along the bottom to inform you of the limitations and instruct them on how to edit the data.
Setup	The [Setup] button opens a dialog that allows you to create, edit, delete and even clone Deposit Templates as required. There must be at least one bank deposit template in order to create a bank deposit. Once you have created a template, you can specify to auto create a deposit. Note: This checkbox currently assumes that the first template is the template that has auto create deposit enabled. When the option is checked, clicking the [Prepare Bank Deposit] button will automatically proceed to prepare a deposit based on the first template in the list, if there is more than one. In order to use one of the other templates, you must cancel the automated deposit and select a different template. See also Deposit Entry Setup
Prepare Bank Deposit	Click [Prepare Bank Deposit] to launch the Deposit/Template Options Window.