Create the Income and Expense Day Book report

You can use the Income & Expense Day Book report to view the income and expense you record in your bank accounts. The report shows an overview of each transaction including the type, customer or vendor, net and tax 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 income or expense and it includes money in and money out.

To produce the report

  1. Go to Reports.
  2. Click Income & Expense Day Book.
  3. From the Period drop-down menu choose one of the following options:
    This MonthTo produce the report for the current month, use this option.
    This QuarterTo 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 YearTo 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 MonthTo produce the report for the previous month, use this option.
    Last QuarterTo 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 YearTo 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.

    CustomEnter the report dates you want to run the report from and to.
  4. Open the More drop-down menu and choose the required options:
    • Account: Select All Accounts or a specific bank account.
    • Income/Expense: Select All Types, Income, or Expenses.
    Note:

    To search for a particular transaction, enter the relevant details in the search box. You search by reference, customer or vendor name or value.

  5. To view details of a transaction, click the relevant line. To return to the report, click back on your browser menu bar.
  6. To export the report, click Export and choose CSV or PDF.
    Note:

    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 working while the report downloads.

  7. Once the report has downloaded, from the menu bar, choose the required report.
You've successfully produced the Income & Expense Day Book report.