Diary Report

Diaries make it possible to keep a sequential log of general ledger entries in their database. If the active company is set up to assign transactions to diaries, use the Diary report to review general ledger transactions by diary.

If you use diaries, the diary numbers are assigned to transactions along with the standard transaction reference numbers (voucher numbers, check numbers, invoice numbers, and so on). The diary numbers are linked to the debit and credit entries made to the general ledger for the transaction.

Generate the Diary report in a detail or summary version by selecting or clearing the Transaction Detail option in the Grouping and Sorting section on the Columns & Groups tab:
  • By default, Transaction Detail is selected, and the report includes transaction detail rows.
  • If you do not select Transaction Detail, the report only displays group totals, and any transaction detail columns on the report are blank.

The PSA module does not include the diary feature, so this report is not available if that module is activated.

Settings

To activate diaries, you set up automatic numbering for the active company in the Diary Auto Numbering Options section on the Transaction Settings form (Settings > Accounting > Transactions). If automatic numbering for diaries has not been set up, the Diary report does not display in the list of General Ledger reports.

Transaction Selection

Use the fields on the Options tab to filter the transactions included on the report by any of the following:

  • Diary code
  • Diary type
  • Diary number
  • Fiscal period or transaction date

For this report, you do not select records on the lookup that displays from the Record Selection column in the Reports grid.

Drill Down Option

If the report includes transaction detail, you can click the link in the Posting Sequence report column for a transaction to drill down to the Posting Log report.