Daily Accounting Report with Totals by Payment Type

Problem Statement

The client currently uses the Pelcro Total Report to retrieve accounting information. While the report contains the necessary data, it is not optimized for daily accounting workflows.

Their accounting team needs to run the report daily, then manually:

• Filter or sort transactions by day

• Group results by title

• Group further by payment type

• Calculate totals per payment type

This requires manual manipulation of the exported report, making the process time-consuming and error-prone.

User Story

As an accounting or finance user,
I want a daily accounting report that is already grouped and summarized,
so that I can quickly reconcile transactions without manual sorting and calculations.

The client has provided an example report to illustrate the expected format.

The file will be attached to this task for the Pelcro team to review internally to better understand the required report structure and layout.

Link:https://docs.google.com/spreadsheets/d/1z6TOhVLFNc12tJLXc38bat98nXbLSYPP/edit?usp=sharing&ouid=107973340733417770971&rtpof=true&sd=true