Receipts and payments reports

How much came in and went out in a period, through which payment mode and account, and which documents make it up.

Open Reports›Receipts & Payments and pick a report:

ReportWhat it shows
Receipts SummaryMoney received in the period by payment mode, by account and by document type.
Receipts DetailsEvery receipt: date, number, customer, payment mode, account, reference and amount.
Receipts by Day & ModeEach day of the period with the amount received in each payment mode.
Payments SummaryMoney paid in the period by payment mode, by account and by document type.
Payments DetailsEvery payment and expense: date, number, vendor, payment mode, account, reference and amount.
Payments by Day & ModeEach day of the period with the amount paid in each payment mode.

The receipts reports need the Receipts Report right and the payments reports the Payments Report right (see User groups and rights).

What is counted

SideDocument types
ReceiptsCustomer Receipts, Cash Sales Received (cash invoices), Post-dated Cheques Received, Refunds Received from Vendors
PaymentsVendor Payments, Expenses, Post-dated Cheques Issued, Refunds Paid to Customers
  • Amounts are in the base currency. A document in a foreign currency also shows its own amount under it.
  • A post-dated cheque is counted on the date it was received or issued. Its account is shown once the cheque is cleared.
  • Net takes bank charges into account: for receipts it is the amount less bank charges (what reached the account), for payments the amount plus bank charges (what left the account).
  • These are the same documents as the receipts and payments in Period summary and day book, with expenses on the payments side.

Filters

Choose the Date Range (or From and To), and if needed the Branches, a Payment Mode and a Document Type. In the details reports, Search finds a document by number, name or reference.

From the summary to the documents

The summary has three sections, By Payment Mode, By Account and By Document Type, each with the number of documents, the amount, bank charges, the net amount and its share of the total. Click a line to open the details report with just those documents, and click a document number there to open the document.

Can't find what you need? Write to info@exlerithub.com or chat with us on WhatsApp.
Chat on WhatsApp