Report to Retrieve Daily Sum of Amounts Received By Multiple Modes of Payment

ERPNext Accounting
1

I have implemented ERPNext for a clothing company which has multiple outlets. I am managing outlets by creating separate POS profiles within ERPNext. I am using sales invoices in two ways:

1 . Enabling the 'is_pos' checkbox on the sales invoice, selecting a POS Profile, and then marking the payment status as 'Paid' on the sales invoice itself to record payment.
2 . Disabling the 'is_pos' checkbox on the sales invoice to create a standard sales invoice, and then later processing a separate payment entry to record payment against that invoice.

I need to generate a report that shows the daily amount received via each payment mode (cash, credit card, etc.), broken down by outlet.

Does an existing ERPNext report show this detailed payment data by outlet? Or will I need to build a custom report to get this outlet-specific payment mode breakdown?

2

I am facing a similar issue. Do you have a solution for this?

3

You’ll need to write a custom report for this, but it’s entirely possible. The workflow might be generalizable enough to contribute to ERPNext. Some features worth considering would be to add a reconciliation Journal Entry handle cash drawer over/under and merchant fees. When I was directly responsible for this 15 years ago, we had a merchant services agreement that had a daily fee and needed to reconcile that against the register printouts.