MENU
    Cash Reconciliation Export
    • 08 Jul 2024
    • 1 Minute to read
    • Dark
    • PDF

    Cash Reconciliation Export

    • Dark
    • PDF

    Article summary

    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.


    1. In the Reports section of the left navigation pane, select My Reports.
      The My Reports screen appears.

    2. At the top of the My Reports screen, select Op.Analysis.
      The screen generates a list of reports in alphabetical order.

    3. Locate the Cash Reconciliation Export.

    4. Select 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.

    Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.

    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 and Location Record: Reporting Categories.

    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.

    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.


    Was this article helpful?