---
title: "Cash Reconciliation Export"
slug: "cash-reconciliation-export"
description: "Export cash flow data (deposits, paid ins, paid outs) as NDJSON for importing into third-party systems."
updated: 2026-09-15T15:34:41Z
published: 2026-09-15T18:02:41Z
canonical: "docs.restaurant365.com/cash-reconciliation-export"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Cash Reconciliation Export

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 type of file when importing data into third-party systems.

> [!NOTE]
> **Missing Locations and Dates**
> 
> A location only appears on this report after the system polls that location and date’s Daily Sales Summary (DSS). If a location is missing, or the report shows no data for a date, check the [Daily Sales page](/doc/docs/daily-sales-page) to confirm the DSS for that location and date has polled before troubleshooting further.
> 
> DSS are not created for future dates, so future dates will not appear on the report.

---

## Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

1. Open the **Reports** app.
2. Navigate to **My Reports**.
3. Enter all or part of the report name in the **search bar**.
4. The **Results** tab will open with the list of search results.
5. 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.

![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png)

---

## Report Parameters

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-GCQ70TBA.png)

| **Field** | **Description** |
| --- | --- |
| Filter By | Location reporting category by which to filter the report. > Options in the Filter By menu are configurable and specific to your organization. For more information, see [System Preferences: Location Reporting Categories](/doc/docs/system-preferences-location-reporting-categories) and [Location Record: Reporting Categories](/doc/docs/legal-entities-location-record). |
| 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. For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category. > Options that appear in the Filter menu are configurable and specific to your organization. For more information, see [System Preferences: Location Reporting Categories](/doc/docs/system-preferences-location-reporting-categories) and [Location Record: Reporting Categories](/doc/docs/legal-entities-location-record). |
| 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. For more information about these controls, see [My Reports: Using My Reports](/doc/docs/my-reports-using-my-reports#report-views). |
| Run | Generates the report. |

---

## Report Properties

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(600).png)

| **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. |