Skip to content
logo Knowledgebase
Page Language

How to create the Receipts and Payments Day Book report

Created on  | Last modified on 

Summary

How to view an overview of different banking transactions in one report with Sage Accounting.

Resolution

Use the Receipts and Payments Day Book report to view different banking transactions in one report. The report shows an overview of each transaction, including the type, customer or vendor, net, and tax amounts. View information for a specific date range and for all transactions or certain transaction types.

Run the report for either receipts or payments. The report includes the following transaction types:

Receipts

  • Customer receipts
  • Vendor refunds
  • Other receipts
  • Bank receipts
  • Tax payments

Payments

  • Vendor payments
  • Customer refunds
  • Other payments
  • Bank payments
  • Staff payments
  • Revenue payments
  • Tax payments

To view the report

  1. Go to Reporting.
  2. Under Cash Reports, click Receipts and Payments Day Book.
  3. To search for a particular transaction, enter the details in the Type to search field. You can search by reference, customer, vendor, or value. To search for a credit note by value, enter a negative amount.
  4. From the Period menu, select one of the options, such as This Month or This Year.
  5. Click More to filter the report by account and transaction type. You can further filter by receipts and payments.
  6. To view details of a transaction, click the transaction's row. To return to the report, click your browser's Back button.
  7. To save or print the report, click Export and then select CSV or PDF.

When the report is ready, a message appears on the menu bar. The time needed to generate the report depends on the amount of data you're exporting. You can continue working while waiting.

After you generate the report, click the Reports menu button on the toolbar, and select the report.

Depending on how you choose to export the report, one of the following happens depending on your browser:

  • CSV files download automatically, or you're asked to save the file.
  • PDF files open in a new window or tab. Use your browser's toolbar options to print or save the report.