Receipts & Payments Day Book report

You can use the Receipts & Payments Day Book report to view the different banking transactions on one report. The report shows an overview of each transaction including the type, customer or supplier, net and VAT amounts. You can view this for a specific date range for all transactions or, for certain transaction types.

You can produce the report for either receipts or payments and it includes the following transaction types.

Receipts

  • Customer receipts
  • Supplier refunds
  • Other receipts
  • Bank receipts
  • VAT refunds

Payments

  • Supplier payments
  • Customer refunds
  • Other payments
  • Bank payments
  • Staff payments
  • Revenue payments
  • VAT payments

To produce the report

  1. Reporting > More… > Cash Reports > Receipts & Payments Day Book report.
  2. From the Period drop-down list choose one of the following options:
This Month To produce the report for the current month, use this option.
This Quarter To produce the report for the current quarter, use this option. For example, if the current month is June, the date range is 01/04/2015 to 30/06/2015.
This Year To produce the report for the current year, use this option.
This Financial Year This option only appears if you enter your Year End Date in Financial settings.
The report dates default to a 12 month period, based on the day and month you entered for your Year End Date.

Note: This produces the report for the current year regardless of the year set in Financial settings.
Last Month To produce the report for the previous month, use this option.
Last Quarter To produce the report for the previous quarter, use this option. For example, if the current month is June, the date range is 01/01/2015 to 31/03/2015.
Last Year To produce the report for the previous year, use this option.
Last Financial Year This option only appears if you enter your Year End Date in Financial settings. The report dates default to a 12 month period for the last financial year, based on the day and month you entered for your Year End Date.

Note: This produces the report for the previous year regardless of the year set in Financial settings.
Custom Enter the report dates you want to run the report from and to.
  1. More > choose the required options:
  • Account > choose the required bank account.
  • Type > choose the type of transaction you want to search for. Alternatively to search for all transaction types, leave this as All.
  • Receipt/Payment > choose whether you want to run the report for your receipts or payments.

To search for a particular transaction, enter the relevant details in the search box. You search by reference, customer or supplier name or value. If you want to search for a credit note by value, this must be a negative amount.

  1. To view details of a transaction, click the relevant line > to return to the report, click back on your browser menu bar.
  2. To export the report > Export > choose CSV or PDF.

The report automatically downloads and when it’s ready a message appears on your menu bar. The amount of time the report takes to download depends on the amount of data you’re exporting. You can continue to work while the report downloads.

  1. Once the report has downloaded, from the menu bar, choose the required report.

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

  • CSV – Depending on your Internet browser, the file automatically downloads to your Downloads folder or you’re prompted to save the file > browse to where you want to save the file > Save.
  • PDF – The PDF opens in a new window or tab. Open your browser File menu then choose to print or save the report.

You’ve successfully produced the Receipts & Payments Day Book report.