Expense Listing Report

Expense Listing Report (#313)

To run this report from the main menu select Section|Reporting and press the Supplier button. Double-click on Expense Listing from the list of choices.

This report lists the expenses that have been assigned/coded against supplier and cash book transactions.

From Expense Code

The first expense code to list. Leave blank to start from the first code.

To Expense Code

The last expense code to list. Leave blank to end with the last code.

Account Type

Specify the account type if you wish to limit reporting to standard/regular accounts or internal accounts.

Reporting Basis

Specify whether accrual (based on invoices) or cash (based on payments).

See Cash and Accruals for more information on this topic.

Include Zero Balances

Tick this option to include all accounts on the report, even if the balance of the account is zero.

The next two options are only applicable if CAPITAL GL Controller is not activated:

Include Budget

Lists the budget total that has been assigned to this expense account.

If CAPITAL's general ledger is active, the more powerful budgeting system supplied with that program replaces the simple budget system provided with CAPITAL Office. This option then becomes unavailable.

For information on entering budgets see the topic: Expense Codes.

List All Accounts

Accounts marked as "excluded" via the Expense Table in INSTALLATION Workshop are not normally listed on this report. Tick this option to include them.

If CAPITAL's general ledger is active, the Expense Account Listing Report will list all expense codings anyway--this option will not be available.

CAPITAL Office is an accrual based accounting system and expense reports should normally be printed on the accrual basis, which is the default printing option.

If you need information on accrual versus cash basis reporting see the topic: Cash and Accruals.

Hints & Tips

The message *** Transaction missing appearing on the report may indicate that your data has been damaged by a network or computer failure, especially if the report is for a relatively recent period.

The message *** Balance Error indicates that the expense allocation does cross match the transaction total for the period reported. This suggests that a computer failure may have corrupted data. Perform a Supplier Account Recalculation and a Cash Management Recalculation to check the integrity of your data files. These utilities are found on the Diagnose menu of INSTALLATION Workshop.

If you wish to export this report to a data file or transfer it to Microsoft Excel, you must select the summary version of the report.

____________________________