Get only cash payments showing on the Sales Ledger export for a given date.
- Vend for Mac or PC
- Open Office
- Go to Sales Ledger
- Select the desired date
- Apply any other filters such as Outlet, Register etc.
- Click Update
- Click Export CSV
- Open the file in Open Office
- Find the Details column
- Select the whole Details column
- Click Data
- Select Filter > Auto-filter
- Click on the arrow next to the Details column
- Select Cash from the drop-down
Voided sales are by default included in the CSV export of Closed Sales. Make sure to delete them from the file for accurate results.