The cash movement report allows you to view and filter all recorded cash movements across selected registers and outlets over a specified time period. This enables quick review and export for reconciliation and analysis, and is especially useful if you're a high-volume retailer operating multiple registers and locations.
You can track cash movements for individual registers by using the register closure report.
Viewing the cash movements report
Admin and Manager roles can view this report by default. To enable this report for other roles:
-
Navigate to Setup > Users and click the Roles tab.
- Click the role you want to enable viewing the cash movements report for.
-
In the Reporting section, make sure the View register closures checkbox is enabled.
- Click Save changes.
To access the cash movements report, navigate to Reporting > Cash movement report.
Click Format results to select if you want the report to Show totals only or arrange rows By cash movement, then click Apply.
Filtering the cash movements report
You can filter the cash movements report to create a snapshot of your cash movements within specific parameters.
Type
Use the Type dropdown to filter by type of cash movement. Available options include:
- Cash in: Adding cash to the cash drawer, such as adding to a float.
- Cash out: Removing cash from the cash drawer for tip-outs or safe drops.
- Petty cash in: Adding back removed petty cash, such as change from store expenses.
- Petty cash out: Removing cash from the cash drawer for store expenses.
Once you've selected your type(s), click Search.
Date range
Set the date range for your report using the Date range dropdown. You can choose to Specify period, which allows you to select a specific timeframe, or Specify date, which allows you to pick a specific date or date range.
Once you've chosen your date range, click Apply and then click Search.
The maximum amount of time you can filter by at once is 25 months.
Cash movement note
You can use the Cash movement note field to enter a specific note attached to cash movements.
Once you've typed in a note's keyword, click Search.
Filter by outlet, register, or user
Click More filters to display the Filter by outlet, register or user field.
Use the Include and/or Exclude options to include or exclude specific parameters. When you've finished, click Search.
Exporting the cash movements report
Click Export Report... to download your data in XLSX or CSV format, which is compatible with spreadsheet applications like Excel or OpenOffice. Saving customized reports requires a Plus plan or the advanced reporting module.
Saving your report
You can save your customized report to Retail POS for future reference.
Saving a customized report is only available to merchants on Advanced or Enterprise plans, or those that have purchased the advanced reporting module.
Sharing your report
You can share and schedule your report to be shared using Retail POS's scheduling reports function.
What's next?
Saving customized reports
Tailor sales, inventory, payments, and tax reports to your needs and save them for easy access.
Scheduling reports
Discover how to automate your reporting process by scheduling reports for efficient stakeholder updates.