View the General Ledger report

Use the General Ledger report to produce a summary or detailed view of your transactions for your accounts.

Note: To view details of which transactions make up each of the values on the report, click the relevant line. You can then view the details of each transaction by clicking the relevant line.
  1. Go to Reporting.
  2. Select More.
  3. Click General Ledger Report.
  4. From the Period drop-down menu, choose one of the following options:
    This MonthTo produce the report for the current month.
    This QuarterTo produce the report for the current quarter. For example, if the current month is June, the date range is 01/04/2016 to 30/06/2016.
    This YearTo produce the report for the current year.
    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.
    Last QuarterTo produce the report for the previous quarter. For example, if the current month is June, the date range is 01/01/2016 to 31/03/2016.
    Last YearTo produce the report for the previous year.
    Last Financial YearThis 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 date range for which you want to run the report.
  5. Click More to view filtering options:
    • Category: If required, choose the ledger category you want to run the report for, for example Expenses.
    • Ledger Account: To view the activity of one particular ledger account, select the relevant account.
    Note:

    If you use analysis types, to run the report for a particular type or category, choose the relevant options.

  6. To search for a particular transaction, enter the reference or the value of the transaction in the search box.
  7. Choose either Export Summary or Export Detailed.
    • Summary indicates the account, opening balance, total debits and credits, and closing balance.
    • Detailed provides a breakdown of the transactions recorded against any single account, for a date range of your choice. It shows the date, reference, type of transaction and whether it's a debit or credit value.
  8. Choose to export as CSV or PDF.
    • CSV. Depending on your browser, the file is saved to your Downloads folder or you're prompted to save the file.
    • PDF. The PDF opens in a new window or tab.

You've successfully produced the General Ledger report.