The Cash Reconciliation Export allows users to export cash flow data, such as deposits, paid ins, and paid outs, as a .NDJSON file. Users might require this time of file when importing data into third-party systems.
Navigation
The My Reports search bar can be used to search R365's entire catalog of reports.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- From beneath the report name, click Run to run the report with the selected report view.
-OR-
Click Customize to adjust the report parameters and run the report.
Report Parameters
Field | Description |
---|---|
Filter By | Location reporting category by which to filter the report.
|
Filter | Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report.
|
As Of | Date for which to run the report. The report displays sales data ranging from the selected date to today's date. |
View options | Provides the user with options to select, save, edit, or delete a report view. |
Run | Generates the report. |
Report Properties
Property | Description |
---|---|
store_number | Location number where the transaction occurred. |
date_time | Date and time of the transaction. |
transaction_type | Indicates whether the transaction is a deposit, paid in, or paid out. |
amount | Amount for the transaction. |