Tag: Transactions Report

  • Understanding Accounts Receivable Transactions Reporting

    Understanding Accounts Receivable Transactions Reporting

    The Client Transactions Report gives you the ability to generate a list of all outstanding transactions via a variety of different criteria and fields contained within your SapphireOne Client data profiles.

    The Client Transactions Report in SapphireOne allows you to generate a detailed list of client transactions using a wide range of criteria and data fields stored within your client records. This report is particularly useful for reviewing outstanding transactions, auditing activity, and managing allocations.

    This article forms part of our Accounts Receivables Reporting Tutorials, which explore each of the six Accounts Receivables reports available in SapphireOne.

    Accounts Receivables Reporting Overview

    SapphireOne provides six Accounts Receivables reporting options, each designed to support different operational and financial needs:

    1. Details
    2. Balances
    3. Transactions
    4. Statements
    5. Show Reports
    6. Dashboards

    In our previous tutorials, we covered the Client Details Report and the Balances Report. This article focuses on the Transactions Report, the third reporting option within Accounts Receivables.

    The Transactions Report

    The Client Transactions Report enables you to generate a list of client transactions based on multiple selection criteria, including posting status, allocation status, currency, and transaction type.

    When selecting the Transactions Report, a print dialog window is displayed, allowing you to define the structure and scope of the report before printing or exporting.

    Continue reading to learn more about when and how to use the Accounts Receivables Transactions Report, and stay up-do-date on all reporting functionalities available with SapphireOne.

    Transaction Report Types

    When Printer is selected from the Print Destination drop-down menu, the Transaction Report Type menu gives you the ability to create 8 different transaction report types depending on your specific reporting requirements.

    When Printer is selected from the Print Destination drop-down menu, the Report Type menu provides eight Transaction Report formats, allowing you to tailor the report to your specific requirements:

    • Plain Paper – A single-page report designed primarily for receipts.
    • Transaction Audit – Displays transaction tracking details and values, including sub-lines showing allocation details.
    • Discount Due – Shows discounts due for each transaction, including discount days, percentage, and dollar value.
    • One Line FX – Displays tracking details and values for foreign currency transactions.
    • Audit FX – Expands on the One Line FX report by including sub-lines showing allocation details for foreign currency transactions.
    • One Line Transaction – Provides a concise, single-line view of transaction tracking details and values.
    • Wide Transaction Audit – A landscape version of the Transaction Audit report, offering increased visibility of transaction data.
    • Credit Memo – Allows the creation of a Credit Memo directly from the report when required.

    Report Selection Options

    SapphireOne has six different Accounts Receivables reports options, including the Transactions Report, each allowing you to report dynamically on client data for many different purposes.

    The Report Selection drop-down menu allows you to further refine which transactions are included in the report:

    • Unposted Only – Displays transactions that have been entered but not yet posted or transferred to the General Ledger.
    • Allocatable and Less Than 100% – Displays transactions that have not yet been fully allocated.
    • All Records – Prints all client transactions, including those with a zero balance.

    These options allow you to produce highly targeted reports for reconciliation, allocation review, and auditing purposes.

    Printing and Output

    Once you have selected your report type and selection criteria, choosing Print gives you the option to:

    • Open the report as a PDF, or
    • Print the report directly from SapphireOne

    In the next article of our Accounts Receivables Reporting Tutorials, we will explore the Statements Report, which focuses on client-facing statements and communication.

    For more information on Accounts Receivables Reports, or to learn how how you can get the most out of your SapphireOne application, please contact us or book a call with a member of our Support Team. We love hearing from you!