Payments report by payment method: View network and cash transactions

This guide explains the payment reports in the System: their types, filters, what they include and exclude, and how to print and export them. It also answers a common question: how do I see all card network (mada / card) transactions?

How do I see all card network (mada) transactions?

Card network transactions are shown by the Payment Method recorded on each payment. So the card network (or mada) must be a payment method added to your account and chosen when you record payments. See Adding the card network as a payment method.

1. From the main menu, click Reports, then Sales Reports.
2. In the Payments Segmented Reports section, choose Payments by Method, then click Details to see each transaction, or Summary to see the total for each method.
3. In Payment Method, choose your card network method (the name you gave it, such as mada).
4. Set the period in the date field. The default is the last month, and the filter uses the payment date, not the invoice date.
5. Click View Report.

The result is a list of all card network payments in the period: the invoice number, date, client, transaction Ref No and amount, with the grand total at the bottom.

Available payment reports

In Reports › Sales Reports, you’ll find two groups of payment reports. Each report has two buttons: Details (each payment separately) and Summary (the total of each group).

Section	Report	Groups payments by
Payments Segmented Reports	Payments by Client	Each client
	Payments by Entered By	The employee who created the invoice
	Payments by Method	Payment method (cash, card network, bank transfer…)
	Advance Payments	Advance payments from clients
Payments Periodic Reports	Daily Payments / Weekly Payments / Monthly Payments / Yearly Payments	Day, week, month or year

Under Clients Reports there’s also the Clients Payments report, which has more flexible filters.

Payments by Method report

Filters

Filter	Description
Payment Method	One method or All. It lists the active methods, methods used in the past, and Client Credit.
Date	The report period, by payment date.
Client / Client Category	Payments of a specific client or client category.
Invoiced By / Collected By	The employee who created the invoice or who collected the payment (multiple selection). They appear for users with permission to view or edit all invoices.
Currency	Appears if you use more than one currency: all amounts converted to the account currency, or All (Separated).
Branch	Appears when branches are enabled.
Order Source	Appears when you use order sources.

Details or Summary?

• Details: each payment on its own line, grouped under each payment method, with a Subtotal after each method and the grand total at the end.
• Summary: one line per payment method with its total. Useful for comparing the card network total with cash for a period.

Clients Payments report

Open it from Reports › Clients Reports › Clients Payments. It offers:

Filter / option	Description
Payment Method	Multiple selection, such as card network + mada + credit card together.
Treasury	Payments of a specific treasury or bank account (such as the bank linked to the card terminal).
Date From / Date To	The report period.
Client / Category / Staff Member	Filter by client, client category or the responsible employee.
Grouping	By client, treasury or payment method.
Sorting	By date or number, ascending or descending.
Show details	Show each payment, or the totals only.

Report content, printing and export

Columns of the Details view in the payments report:

Column	Content
ID	The payment number.
Invoice No	A link to the invoice. Returns and debit notes are marked.
Date	The payment date.
Client	The client’s name.
Invoiced By	The employee who created the invoice.
Method	The payment method.
Ref No	The transaction reference number (such as the card transaction number), if it was entered when the payment was recorded.
Total	The payment amount. Negative amounts (returns) appear in red.

• A payments chart appears, plus a Payment Methods pie chart when you group by something other than payment method and more than one method is used.
• Print prints the report.
• Export Options: CSV, Excel, PDF, or PDF without the chart.

What is included in the report and what isn’t?

Included	Not included
Completed payments only	Incomplete, pending review or failed payments
Payments on non-draft invoices, and client payments without an invoice	Payments on draft invoices
POS payments	Clients’ Opening Balance
Payments on returns and debit notes (returns as negative amounts)	Client Credit, unless you choose it in the Payment Method filter
Advance payments (when enabled)

The payments list

A quick alternative to the report: open Payments (under Invoices & Subscriptions), click advanced search, then choose Payment Method = your card network method and set the date.

• It has filters the report doesn’t: Transaction ID (to find a card transaction by its number), Payment No., amount, status and POS Pos Shift.
• It shows no total and has no file export. For totals and export, use the report.

Card network transactions in POS

To see the card network transactions of a specific session, open the session from POS, then Session Details:

• Summary by Payment Methods: for each payment method, the Expected, Counted and Difference amounts, so you can compare the card network amount with the bank terminal settlement.
• Sales details by Payment Methods: paid, refunded and net for each method.
• The Client Payment tab shows the payments recorded in the session.

To list all card network payments in a session, open Payments and filter by Pos Shift and Payment Method. For several sessions or a whole period, use Payments by Method; POS payments appear in it like any other payment.

Supplier payments

Open Reports › Purchases Reports › Payments Periodic Reports. They have a Payment Method filter to show supplier payments by card network or bank transfer, and they show completed payments only.

Adding the card network as a payment method

“Card network” and “mada” aren’t built-in payment methods in the system, so you add them as custom payment methods:

1. From the settings, open Payment Methods, then Add Payment Method.
2. Enter the method’s name (for example: mada), choose the Treasury (the bank account where card payments are deposited), and enter any fees.
3. Save, then choose this method whenever you record a card payment, and enable it in POS.

FAQ

How do I see today’s total card network (mada) transactions?

Open Daily Payments or Payments by Method (Summary), choose the card network in Payment Method, and set today’s date.

How do I find a card transaction by its reference number?

In Payments, open advanced search › Transaction ID.

Why don’t some card network payments appear in the report?

• The payment isn’t completed, or it’s on a draft invoice.
• The payment date is outside the report period (the filter uses the payment date, not the invoice date).
• The payment was recorded with another payment method.
• The user doesn’t have permission to view all invoices.
• The branch or currency filter excludes it.

Does a deduction from the client’s credit appear in the payments report?

No, unless you choose Client Credit in Payment Method, because it isn’t a new collection.

Can I export the report to Excel?

Yes, from Export Options › Excel.