Open topic with navigation

Expenses Report

This report provides details of staff expenses incurred within the selected date range.

1. To open the report setup screen, open the Reports view in the left-hand pane.
2. Click Employee in the left-hand pane.
3. Click Expenses in the left-hand pane.

4. The report setup window opens in the main desktop. Specify the relevant report options.

   Report Option	Description
   From/To Date	These fields enable you to define the span of time that the report will cover.`
   Expense Type	These radio buttons enable you to show all relevant expenses, or only approved ones, or only unapproved ones.
   Details to Show: All	Select this radio button to include all expenses in the report individually, with full details of each.
   Details to Show: Selected	Select this radio button to group expenses into categories. use the checkboxes to select the categories you want to be included in the report. For example, if you select Show Employee, Show Project and Show Date, the report will group using employee, project and date as grouping criteria. A Nett Charge (Base) total is displayed for a group of expenses with the same employee, project and date.
   Expenses Summary	When you select this option, an Expense Summary section is appended to the report.
   Expense Sign-Off	When you select this option, sections are added to the report enabling a supervisor to physically sign approval. For instance, if you click the Employee column in the generated report to sort the items by employee, the report contains a separate sign-off section for the expenses of each employee.
   Report Filters tab	These filters enable you to restrict the data included in the report on the basis of expense type, currency, payment type, client, employee and employee analysis group.

5. Click Submit to generate the report.

Report Columns

Column	Description
Employee	The employee who raised the expense.
Client	The client to whose project the expense relates.
Project	The project to which the expense relates.
Expense	The expense type.
Expense Ledger Code	The expense may be assigned a ledger code. This can be useful, for example, when accountants want to use the expense data in other systems.
Date	The date to which the expense relates. (NOT the date when the expense was recorded.)
Units	The number of units of the expense. For example, in the case of mileage the number of units would be the number of kilometres or miles. In the case of accommodation, a unit might be a night's stay in a hotel.
Unit Cost	The cost to the business of a unit of the expense.
Nett Amount	Nett Amount = Unit Cost x Number of Units This is the nett cost to the business of the expense.
Gross Amount	Gross Amount = Nett Amount + VAT (if applicable) This is the nett cost to the business of the expense with any applicable VAT amount added.
Currency	The currency in which the expense amounts are expressed.
Exc Rate	The exchange rate of the expense currency against your Coretime system's base currency.
Gross Cost (Base)	The Gross Amount expressed in the base currency. This differs from the Gross Amount only if the expense was expressed in a different currency.
Nett Charge Paid (Base)	The charge paid by the client for the expense. The client may be invoiced for an amount higher than the Gross Cost.
Receipt Number	The number of the receipt issued to the client for the expense payment.

See also

Employee Reports

Go to top