How to handle Cash deposits in Retail Point Of Sale as one lump sum banked -Undeposited Funds Workflow for Cash Transactions in Readysell Retail Point of Sale
READYSELL
Undeposited Funds – Cash Tender
Feature Guide & Setup Procedures
Document Information This feature is only used and set up for sites that actually have Retail Point of Sale. |
1. Overview
This document describes the new Undeposited Funds workflow for cash (Money) tender transactions processed through Readysell Point of Sale. The feature introduces a dedicated GL account to hold cash collected at POS until it is physically deposited at the bank, at which point a bank transfer is automatically created to move the funds from Undeposited Funds GL Account to the correct Commonwealth Bank GL trading account.
1.1 Why This Change?
Previously, all POS cash transactions were posted directly to the main bank trading account (eg 11501). This created a mismatch between the daily banking entries in Readysell and the actual bank statement dates and values, because cash collected across several days is often deposited as a single lump sum by date by site. The new process mirrors standard accounting practice: cash sits in an Undeposited Funds holding account until it is banked, then a bank transfer clears it to the main account.
1.2 Key Benefits
Bank reconciliation lines now match the actual deposit date and value, not the individual transaction dates and value for each site.
A single bank transfer per deposit run replaces multiple individual banking entries.
Auto-matching by value, date, site and reference number (referencing back to the site) reduces manual reconciliation effort at month-end.
Clear audit trail from POS shift through to bank statement.
1.3 High-Level Flow Diagram
POS Cash Sale → Shift Count → Undeposited Funds (GL) → [Store creates deposit run in POS] → Bank Transfer (auto-created by Readysell) → from eg 11555 Undeposited Funds to eg 11501 Main Bank Account → Bank Statement Import → Auto / Manual Match |
2. Key Concepts
2.1 Tender: 1 MONEY (Cash)
The '1 MONEY' tender is the POS cash tender. Under the new setup:
It is linked exclusively to the Undeposited Funds GL account (e.g. account 11555SUP-Undeposit Funds).
It must NOT be used for Sales Order payments from the web (as the payment is actually made on the website, the store is not receiving the physical cash )or any non-POS purpose eg manually bank deposit or manual bank payments.
Transaction types (CUSPAY, CBKDEP, CBKPAY etc.) must be removed from this tender and placed on the separate non-POS cash tender.
2.2 Undeposited Funds GL Account
A new GL bank account (asset class) is created specifically to hold cash received at POS before it is deposited. Example account code: 11555SUP-Undeposit Funds.
2.3 Non-POS Cash Tender (New)
A second, separate tender is created for non-POS cash transactions (e.g. customer payments, bank payments, bank deposits etc processed through Readysell client). This tender:
Has 'Available on POS' turned OFF.
Points to the main bank account (11501).
Carries for all relevant transaction types (CUSPAY, CBKDEP, CBKPAY, etc.).
2.4 Deposit Run
A deposit run is the act of physically taking collected cash to the bank, potentially covering multiple days of POS shifts. Staff select the shifts to include, Readysell calculates the total, and a single bank transfer is automatically created with a unique reference number for each site that will appear on the bank statement and the workstation for each date for each site is stamped with that bank transfer date.
3. Initial Setup (Administrator / Readysell Support)
⚠️ IMPORTANT: The cut-over to the new Undeposited Funds tender must occur on a Sunday night after the last shift of the week has been closed and all prior shift-line deposit dates have been flagged in the database. Do NOT change the tender mid-week. |
Step 1 – Create the Undeposited Funds GL Account
In Readysell, navigate to General Ledger > Chart of Accounts.
Create a new bank-type account in the Current Assets section.
Suggested code: 11555 | Description: Undeposited Cash Funds.
Ensure that the account is marked as a Bank Account and is active.
Save and note the full Account Site code (e.g. 11555SUP-Undeposit Funds).
Step 2 – Verify Tender 1 MONEY Usage
Navigate to Tenders and open the '1 MONEY' tender.
Confirm whether this tender is referenced in any Sales Order payment types from the web store.
⚠️ ACTION REQUIRED: If '1 MONEY' is used for web Sales Order payments, those payment types must be migrated to the new non-POS cash tender (Step 4) before proceeding. |
Step 3 – Reconfigure Tender 1 MONEY
Open the '1 MONEY' tender in Administration > Tenders.
Change the Account and Account Site fields to the new Undeposited Funds account (e.g. 11555SUP-Undeposit Funds).
Change the Reconciliation Method to 'Reconcile by site'.
Remove all Transaction Types from this tender (e.g. CUSPAY, CBKDEP, CBKPAY). These will be assigned to the new non-POS tender.
Ensure 'Available on POS' remains ticked.
Count Required remains Ticked
Save.
Step 4 – Create the New Non-POS Cash Tender
In Administration > Tenders, create a new tender.
Set Tender Method: Cash.
Set Account Site: 11501 (Main Bank Account – Trading) or equivalent main bank.
Uncheck 'Available on POS' — this tender must NOT appear on POS.
Add the required Transaction Types: CUSPAY, CBKDEP, CBKPAY (and any others previously on 1 MONEY).
Save.
Step 5 – Configure System Reference (Cashbook)
Navigate to Advanced >System Types> Cashbook settings.
Set the Deposit Account to the main bank account (11501 or equivalent).
Save.
Step 6 – Database Migration for Existing Shift Lines
Before the cut-over Sunday night, Readysell Support must flag all existing 1 MONEY tender shift lines with a dummy Deposited Date so they are not included in future deposit runs.
Database Action: UPDATE shift lines WHERE Tender = '1 MONEY' AND DepositedDate IS NULL → SET DepositedDate = '2000-01-01'. This dummy date signals that these lines pre-date the new workflow and has already been handled under the old process. |
Step 7 – Confirm Cut-Over Date
Agree on the cut-over Sunday night date with the site (store) before proceeding.
Confirm no shifts are open at the time of the change.
Apply configuration changes after the last shift of the week is closed.
Notify Head Office finance team of the exact cut-over date so they can account for the transition period in bank reconciliation.
4. Daily Procedure – Store Staff
4.1 End-of-Day Cash Count
This procedure is unchanged from existing practice.
At the end of each trading day, store staff perform a cash count at each Retail POS workstation for all tenders.
Enter the counted cash amount in Readysell POS and submit the count to the server.
Readysell creates a shift-line/Shift-Detail/Banking record against the Undeposited Funds GL account for the counted value.
The cash remains physically at the store (in the safe or till) until the cash deposit run is performed.
ℹ️ Note: Staff do NOT need to record a reference number or deposit date at this stage. The deposit reference is assigned when the deposit run is created. |
4.2 What Readysell Creates Automatically
System Action | Details |
Shift Line | One line per workstation per day, Tender = 1 MONEY, Value = counted amount |
GL Posting | The bank transfer will create two transactions. A Bank payment to stand for the total value of cash being paid out of the undeposited gl account and ready to be bank and the other transaction is a Bank Deposit to stand for the total value of cash transferred into the main bank account for the same value. Both values are the same. A contra gl account is used on both transactions which negates to $0 |
Bank Rec Entry | Entry appears in the Main bank account by site by date of value. |
5. Deposit Run Procedure – Store Staff
A cash deposit run is performed when store staff take the accumulated cash to the bank. This may cover multiple days of shift counts and cash takings. The deposit run can be performed on any day — it does not need to match the transaction dates.
5.1 Creating a Deposit Run in POS
In Readysell POS, Click on the action button Cash Deposit Run module.
The screen displays all undeposited shift lines for the site, grouped by date and workstation. Example: Mon 1 Jan $100.00 | Tue 2 Jan $50.00 | Wed 3 Jan $25.00
Select the shift lines to include in this deposit. You may select all or a subset.
POS calculates the total deposit value automatically by combining all selected workstation amounts per date.
Enter the bank deposit Reference Number (provided by the bank or generated internally, e.g. 777714).
Confirm and submit the deposit run.
ℹ️ Example: Selecting Mon 1 Jan (WBCHA1E: $76.00 + WBCHA2E: $99.90) and subsequent days produces a combined deposit total. The system reconciles per site per date automatically. |
5.2 What Readysell Creates Automatically
Readysell creates a Bank Transfer (type: CBKTRN – Miscellaneous Cashbook Transfer):
From Account Site: 11555SUP-Undeposit Funds
To Account Site: 11501 Main Trading Account (or configured main bank)
Date: Date the deposit run is submitted
Value: Total of all selected shift lines
Payment Reference: The reference number entered in step 5 above (e.g. 777714)
The bank transfer appears in the Banking module and in the bank reconciliation for 11501.
The shift lines are marked as deposited and will not appear in future deposit runs.
Bank Transfer Field | Value |
Type | CBKTRN (Miscellaneous Cashbook Transfer) |
Date | Date of deposit run (physical bank deposit date) |
From Account Site | 11555SUP-Undeposit Funds |
To Account Site | 11501 CBA Trading Account |
Value | Sum of all selected shift lines |
Payment Reference | Reference number entered during deposit run (e.g. 777714) |
Site | SUP (or relevant site code) |
6. Month-End Bank Reconciliation – Head Office Finance
6.1 Importing the Bank File
At month-end of the month or week, Head Office imports the bank statement file for the 11501 CBA Trading Account in Readysell Bank Rec as usual.
During the transition period following cut-over, account 11501 will contain two types of transactions:
Transactions from before the cut-over date (old process – direct POS banking entries).
Bank Transfer entries generated by the new deposit run process (new process).
Reconcile each type using the appropriate method described below.
6.2 Automatic Matching
Readysell will attempt to auto-match bank statement lines to bank transfer records using three criteria:
Match Criteria | Description |
Value | Total deposit value must equal the bank statement line amount exactly. |
Date | Bank transfer date must match the deposit date on the statement. |
Reference | Payment reference (e.g. 777714) must match the bank statement reference. |
✅ Best Practice: Ensuring store staff always enter the correct bank deposit reference number when creating the deposit run is critical to achieving high auto-match rates. |
6.3 Manual Matching
Where auto-matching fails (e.g. reference mismatch, timing differences), finance staff can manually match lines:
In the Bank Rec screen, use the Statement Lines panel on the right.
Identify the unmatched bank statement line.
Locate the corresponding bank transfer entry in the left-hand panel.
Select both lines and click 'Match Selected'.
6.4 Transition Period Guidance
During the transition period, 11501 will show both old-style POS banking entries and new bank transfer entries. Old entries should be matched against the corresponding historical shift lines as per the previous reconciliation process. New entries should be matched against auto-generated bank transfers as described above. The transition period ends once all pre-cut-over shift lines have been reconciled. |
7. Setup & Beta Testing Checklist
Use this checklist to verify all configuration steps have been completed before going live.
# | Task | Status |
1 | Create new GL bank account for Undeposited Cash in the assets area (e.g. 11555SUP-Undeposit Funds). | ☐ Pending |
1b | Verify whether Tender '1 MONEY' is used for Sales Order payments from the web. Migrate if required. | ☐ Pending |
2 | Change Tender '1 MONEY' Account Site to point to the new Undeposited Funds GL account (Head Office). | ☐ Pending |
2b | Remove all Transaction Types from Tender '1 MONEY'. | ☐ Pending |
3 | Create a new cash tender at Head Office for non-POS cash transactions (Readysell client). | ☐ Pending |
4 | Add appropriate Transaction Types to the new tender (e.g. CUSPAY, CBKDEP, CBKPAY). | ☐ Pending |
5 | Confirm 'Available on POS' is UNCHECKED on the new non-POS cash tender. | ☐ Pending |
6 | Set new non-POS tender Account Site to point to 11501 main bank. | ☐ Pending |
7 | Set System Reference (Cashbook > Deposit) to the main bank account. | ☐ Pending |
8 | Confirm cut-over date (must be Sunday night; no open shifts at time of change). Agree with site. | ☐ Pending |
9 | Run database migration to set dummy Deposited Date (2000-01-01) on all existing undeposited shift lines. | ☐ Pending |
10 | Apply configuration changes after the last shift of the week is closed. | ☐ Pending |
11 | Notify Head Office finance of cut-over date and transition period guidance. | ☐ Pending |
12 | Conduct end-to-end test: POS cash sale → shift count → Cash Deposit run → bank transfer → bank rec match. | ☐ Pending |
8. Quick Reference Summary
Account & Tender Configuration
Item | Old Configuration | New Configuration |
Tender 1 MONEY – Account Site | 11501SUP (Main Bank Account- Trading) | 11555SUP-Undeposit Funds |
Tender 1 MONEY – Transaction Types | CUSPAY, CBKDEP, CBKPAY etc. | None (POS only) |
Tender 1 MONEY – Available on POS | Yes | Yes (unchanged) |
Non-POS Cash Tender | N/A | New tender → 11501, Not on POS |
Reconciliation Method (1 MONEY) | — | Reconcile by site |
Role Responsibilities
Role | Responsibility |
Readysell Support | Initial setup, GL account creation, database migration, cut-over coordination. |
Store Staff | Daily cash count & shift submission; deposit run creation when cash is banked. |
Head Office Finance | Month-end bank file import, auto-match review, manual matching of exceptions. |
Store Manager | Agree cut-over date; ensure staff are trained on deposit run procedure. |
Key Terms
Term | Definition |
Undeposited Funds | GL holding account for cash collected at POS but not yet physically deposited at the bank. |
Deposit Run | The process of selecting accumulated shift lines and creating a bank transfer for a physical bank deposit. |
Bank Transfer (CBKTRN) | Automatically-created Readysell transaction moving funds from Undeposited Funds to the main bank account. |
Cut-over Date | The Sunday night on which the tender configuration is changed to the new process. |
Shift Line | A record created by Readysell when a POS cash count is submitted, linked to a workstation and date. |
Payment Reference | A unique identifier (e.g. 777714) entered during the deposit run and used for auto-matching at bank rec. |
End of Document