Collector Cash Sales & Collection System

From To

Transactions0Selected period

Gross Revenue₱0.00Before discount

Net Cash Received₱0.00VAT less withholding

Not Deposited0Rows without deposit date

Recent transactions

Latest entries available to your account.

Date	Collector	OR #	Customer	Net Cash

Workbook rules in use

Automated from the uploaded master sheets.

Customer enrollmentUnregistered names are blocked with “Contact Admin.”

Tariff lookupCharge fields, rate, UOM, Cargo Code and Account Title come from the master.

VAT12% of Net Charges, matching the workbook formula.

CSVExports the exact 30 columns from Name of Collector through Account Title.

New collection transaction

Required master-data fields are validated before saving.

Receipt details

OR Date * OR # BOL # Customer * Vessel Voyage No.

Cargo / service

Tariff / service * Unit Quantity * Cargo Charges Cargo Type Charge Type Cargo Description Rate UOM Cargo Code Account Title

Amounts

Discount CM applied Wtax Rate Mode of Payment

Gross Revenue₱0.00

Net Revenue₱0.00

Net Charges₱0.00

VAT₱0.00

Wtax₱0.00

Net Cash Received₱0.00

Deposit / reference

Date Deposited Payment Reference Payment Reference Number Remarks

Transactions

Filter the list, edit records, or export the same filtered rows to CSV.

From To Search

Date	Collector	OR #	Customer	Charge	Qty	Gross	Net Cash	Deposit

Cash count summary

Mirrors the Denomination sheet with cash, checks and fee-count tables.

Count Date

Cash denomination

RO-RO Terminal Fee

Passenger Terminal Fee

Porterage

Checks amount

Counted cash₱0.00

Cash + checks₱0.00

After saving, the system compares Cash + Checks against the day’s Net Cash Received to show Over/Short, matching the Denomination sheet concept.

Saved cash counts

Most recent entries available to your account.

Date	Collector	Cash	Checks	Total	Expected	Over / Short

Collection Summary per Collector

Workbook-equivalent summary of Net Cash Received and Gross Revenue.

From To

OR Date	Collector	Transactions	Net Cash Received	Gross Revenue

System users

Superadmin can manage Admin and User accounts; Admin manages Users.

Username	Role	Collector	Status

Customer master

Seeded from DataVal_Customer.

Customer	Contact	Status

Tariff master

Seeded from DataVal_Charges.

Category	Charge Type	Rate	UOM	Status

Collector Cash Sales & Collection System

Checking system

Database binding required

Create the Superadmin

Welcome back

Dashboard