Invoice Time Details Report

Overview

For service-based businesses, you may now record the time and expenses spent on customers and then invoice accordingly.  This enables you to better manage the productivity of collaborative teamwork and track the profitability associated with each customer. 

Invoice Time Details Report

The ‘Invoice Time Details Report” will generate the report of the time-related transaction for your business. To generate the report for a particular period select the date range. You can also generate the report customer wise. Select the customer by using the look up button.

Please note before you generate the report ensure that the ‘Open Time Invoice Details Report’ is checked from the User Access Browse. Otherwise, the system will not allow generating the report.

To generate the report select Reports » Time and Expenses » Invoice Time Details Report the following screen will appear.

The ‘Time Invoicing Details Report’ will generate the report of the time-related transactions you have entered in your business. To generate the report for a particular period select the date range. You can also generate the report customer wise.

After the report generation, the following information will appear on the report.

Date

The Invoice Date will appear in the Date column.

Type

Type will either be time or expenses.

Ref No

If there is any reference number already inserted during the time of the transaction will appear on the report.

Code

The customer code appears under this column.

Customer

Once the code is selected the customer name will appear automatically.

Hours

The total hours billed for the customer will appear under the Hours column.

Net

The net amount of the transaction will appear under the Net column.

VAT

The VAT charged for the transaction will appear under this column. Please note VAT will only be chargeable if the expense type is only expenses. Because VAT is only applicable for the expenses not for the types. 

Gross

The Gross amount is the total value of Net and VAT amount.

Written off

Any amount which has been written off from the billed amount will appear under the written off column.

Work

The type of the job (work/ project) appears under the work column.

Notes

If there are any notes entered while transaction will appear under the notes column.

User

The logged on user is the default staff.

Invoiced

The total invoice amount appears under the invoiced column.

Outstanding

The outstanding amount of the invoice appears under the outstanding column.

VAT Code

The VAT code appears under the VAT column. VAT codes like Standard ‘A’, Reduced “B’, not applicable ‘X’ will be shown under the VAT Code.

Advanced

By selecting the ‘Advanced’ Settings the Advanced window will appear on the screen.

Customisation and Sort option for Time / Expense Details Report

To customise the Time and Expense Details report select the Advanced option. By selecting the ‘Advance Option’ the column chooser will appear. This includes customer code, customer name, Project name, Time posted, Expense posted, Expenses Invoiced, Outstanding amount, Project code, User Name, Time Written off, Expenses Written off, Hours posted, Hours Invoiced, Hours Written off.

The Report can be sorted by user name, user code, and project description. The report can be sorted by the by the outstanding invoices only. This includes the non-customer entries as well. To include or exclude column use the column chooser.

If outstanding only and include non-customer entries are checked then in the report the outstanding invoices will appear on the report.

For more Details see the below screenshot:

Invoice_Time_Details_Report_Image_I.jpg

Use the column chooser to include or exclude columns in the report from the advanced settings. Use the column chooser as marked in the above screenshot. The report can be sorted by the user code, username /account manager.

The report can be sorted out by the outstanding invoice. By selecting the projects select the breakdown by projects. The report can also be sorted for a particular period, by selecting the date range, Transaction Type, Customer wise, and user wise.

The transaction type is either time or expenses. To select the report customer wise by selecting the look up button. Select the user from the drop-down. To sort the reports use the drop down arrow from the sorting drop-down.

From the ‘Advance’ Settings select the ‘Advance Setting” pop-up will appear on the screen. Select the advanced option from the include the non- customer entries. By using the column chooser the column can be included or excluded.

Features: The report can be sorted by outstanding invoicing only. To include the non-customer receipt selects the checkbox from the feature option.

To display the total amount of the transactions select the total check box.           

Customer

The customer name is displayed here.

Code

The customer code is displayed here.

Outstanding

The outstanding amount of the invoice is displayed here.

Current

The current outstanding amount is displayed here.

Periodic Changes

The periodic outstanding report will generate here. The total amount periodic wise like monthly, bimonthly, quarterly will appear as outstanding.

Go to top   uparrow.png

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk