Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview:

Output Based billing is used by jobs that are assigned to a Charge Type with a Billing Type of Output Based. New invoices can be created through Job Sales Invoices for these jobs.

This billing type collects all Job Outputs up to the Invoice Trans To Date field. This facilitates "Cost Plus" and "Do & Charge" style jobs. If your job includes the selling of Input Transactions as well, the Input and Output Based billing type is more appropriate.

Surcharges and Discounts - Additional charges or discounts can be added at the time of billing. These can be a % of the sales value which is derived from the sales value at the time of billing or as a fixed Rate. Common uses for this can be applying discounts, adding Fuel charges, or a very particular scenario for Equipment Hire businesses where a Limitation of Liability can be charged. See details of how to configure this here.

Screen Guide:

Header
Expand
title
Image Removed
HEADER
expand
Image Added
  • Job Code is the job this invoice relates to.

  • Client is the client Company of the invoice.

  • Invoice Title is the billing title, defaulting to the job description, but can be modified here or the default in Job Maintenance.

  • Invoice Format determines what type of report is generated when sending the invoice to the client.

  • Billing Address defaults to the job's default, but can be changed to any address for the Client Company.

  • Billing Contact defaults to the job's default, but can be changed to any person listed under the Client Company.

  • Email Option can be chosen from the following, where Company Postal is the default Postal Address in the Client Company:

    • To Billing Contact Only

    • To Billing Contact, CC Company Postal

    • To Company Postal, CC Billing Contact

    • To Company Postal Only

  • Invoice Number is automatically generated based on the Setting "Next Job Invoice Number". This setting can be altered to produce different ranges of invoices based on FinCo, Location, Profit Centre, or Global.

  • Claim No is used in conjunction with Output Schedules of the Output Claim type in Contract Claims.

  • Invoice Date defaults to today's date but should be updated to reflect the intended date of the invoice/claim.

  • Year/Period results from the Invoice Date selection.

  • Invoice Status can be one of the following:

    • Entered means that it has been created, but not yet approved. It may or may not need additional data before being approved.

    • Approved means that an authorised approver has clicked approved for this document, indicating that it is ready to be sent to the client. It can be unapproved at any time and edited.

    • Sent means that the document was finalised and implies that the invoice was actually sent to the client. It can be unfinalised, but a copy of each sent invoice will be attached.

    • Updated means that the invoice has been exported with its batch to the financial software. The invoice cannot be edited to retain consistency with the financial software.

    • Cancelled means that someone clicked

Cancel
    • Cancel in the invoice, removing all data but leaving a record of the cancelled claim.

  • Invoice Trans To Date determines the last date that Outputs will be included in the billable list in Get Sales. It defaults to the end of the current period but can be changed.

Expand
Details
title
Image Removed
DETAILS
expand
Image Added
  • Comment is a free text area to include messages or notifications on the invoice. This is visible to the client in standard reports.

  • Due Date is determined by the Client Company's payment settings, but can be manually changed.

  • Job Status is usually set in Job Maintenance, but can be updated here. This is useful if completing the final invoice for the job or if you have custom Statuses.

  • Claim Reference is an optional text field for any useful references.

  • Billing Type is determined by the Job Maintenance settings.

  • Bill POs is used in 

717619249
  • Output Based for situations where you want to bill the client the value of unprocessed Purchase Orders.

  • Batch displays the AR Invoice batch number that this invoice is located in, and is populated automatically after the invoice has been finalised.

  • Prepayments is the net balance of the Prepayment Sales Code for the parent Job Code and all sub jobs.

Dates
Expand
title
Image Removed
DATES
expand
Image Added
  • Job Value is derived from the Job Maintenance field of the same name and is used when billing Quoted jobs the value will be populated when Get Sales is clicked. Otherwise this is a reference-only field.

  • Order No is derived from the Job Maintenance field of the same name and can be manually entered/updated here. This is the Client Company's PO number given to you.

  • FC Rate is the Foreign Currency rate.

  • Currency is the Currency derived from the client Company.

  • Created By is the User that created this AR invoice.

  • Approved By is the User that approved this AR invoice.

  • Approval Required By is the current User assigned to approve this AR invoice. The user must have appropriate Permissions to approve AR invoices.

  • Created Date is automatically populated when the invoice is created, and is not necessarily the same as the Invoice Date.

  • Edited Date is the last date that this invoice was edited.

  • Printed Date is currently unused.

  • Approved Date is the date that the Approved By user approved this invoice.

  • Claim Submitted Date is an optional manual entry to track when Contract Claims are submitted, as opposed to the final invoice.

  • Updated Date mirrors the Edited Date field.

  • Cancelled Date logs the date that the X Cancel Invoice button was clicked.

  • Job Completed Date tracks when the Job was marked as completed.

  • Job Finalised Date tracks when the Job was marked as finalised.

Expand
Body
title
Image Removed
BODY
expandexpand
Image Added

This section will be populated as a result of the Get Sales process, but you can make manual additions using + New Line outside of that process.

  • Derived shows how the line was derived:

    • - Contract Claims

    • - Input Based

    • - Output Based

    • - Manually Created (automated retention lines show as M)

  • Job is the job this invoice line relates to in the instance of subjob billing.

  • Sales Code is the Sales Code that this line uses, directing the General Ledger codes to the correct place.

  • Description is usually defaulted to the Sales Code but can be modified.

  • Work Centre is used if you are employing Work Centre-level revenue tracking, otherwise it can be left blank.

  • Quantity is derived automatically from the Get Sales process.

  • Rate is the combination of all output lines.

  • Value is the combination of all output lines.

  • GST is calculated based on the GST Type.

  • Total is the GST-inclusive amount of the line.

  • GST Type uses the GST Type settings from the Sales Code. This can be manually adjusted if needed.

  • Details can be added here.

  • The Bin icon cannot be used to delete derived lines, only manual lines. Instead, go back to Get Sales and modify/uninvoice the lines.

Buttons

Image Removed

expand
Expand
titleBUTTONS
Image Added
  • Perform:

    • Import opens the import dialogue that allows you to import invoice lines from a document. The fields must match exactly to the template provided.

    • Report Text allows you to select from predefined Header and Footer Report Text Templates that will appear in the report document.

    • Debt Management opens Debt Management screen for this specific invoice where notes can be added against this Job invoice, to be able to track any communication with the client or reasons why the invoice is still outstanding.

    • Attach Supplier Invoices will add AP invoice PDF files associated to any AP Invoice lines that are being billed on this Job Invoice as an attachment to send to the client together with the Job Invoice pdf.

      This is to support the "Open book" contract arrangements that are increasingly common these days with escalating project costs, where instead of a fixed contract price, the client is billed for costs plus an agreed margin.

      AP invoice & AP Credit files will be zipped into a file named [Invoice Number]SupplierInvoices.zip with a File group of “AR Invoice Auto Attach”. The .zip file is attached in Job Invoice attachments. It is also automatically attached to the email when sending the Job invoice to the client. This supports AP invoices originated from Purchase Orders (not from Dockets). Note that AP Invoice & AP Credit PDFs related to Written Off transactions will not be included in the .zip file.

    • Apply Surcharges and Discounts, opens the list of Discounts or Surcharges that might be available for the Job being invoiced. See here for more details.

  • Print will open the default report, or you can click the button to open a list of available reports. The report can then be sent to the appropriate person or printed.

  • Workflow | Messages button will only display when approvals of the Job invoices are being done using Workflow Schemas for approvals (Control Parameter Job Invoice Approval Process = Workflow). It will display the workflow history and any messages sent using the workflow functionality.

  • Attachments opens the attachment window, allowing you to attach files to this document.

  • + Retention Line can be used to make manual retention lines. This withholds the specified amount from payment until an agreed time or milestone is met.

  • + New Line is used to create manual lines.

  • Cancel Invoice will convert the invoice to a cancelled state but retaining the Invoice Number. Consider whether reusing/repurposing an invoice is more appropriate than cancelling.

  • Approve / Unapprove will change depending on the state of the invoice. Assign an approver in the Dates section, or submit the document through a Workflow. Approving an invoice locks it from being edited, but it can be unapproved to make changes. This cannot be done once the invoice has been finalised.

  • Final Invoice / Unfinalise can be done once the approver has approved the invoice. Finalising immediately opens the print window with the invoice ready to send to the client and locks the invoice. The invoice can be unfinalised by a user with appropriate Permissions, but only if the invoice has not been exported to your financial system.

  • Get Sales navigates you to the output billing screen. See the next section for more information.

  • Save commits any changes to the database. Be sure to save before navigating away from this page.

  • ← To Invoice List returns you to the Job Sales Invoices screen.

Get Sales View

Unbilled Transactions Tab

Image Removed

Expand
titleTRANSACTIONS TAB
Image Added

This tab contains all unbilled outputs for this job up to the Invoice Trans To Date setting, including previously deferred outputs but not previously written off ones. As this area contains quite a few columns, you may need to scroll horizontally or minimise the left side menu to see all fields.

  • Include Future will display transactions on the job beyond the Invoice Trans To Date setting.

  • Bill POs makes it possible to bill uninvoiced/outstanding Purchase Orders.

  • Filter options are available to help narrow down the desired transactions.

  • Type can be one of the following, and identifies the origin of the line:

    • JT - Job Transaction

    • JTAD - Adjustment Transaction

    • JTDI - Disbursement Transaction

    • JTDO - Docket Transaction

    • JTPL - Plant Issue Transaction

    • JTPU - Purchase Transaction

    • JTST - Stock Issue Transaction

    • JTTI - Time Transaction

    • PO - Purchase Order

    • JO - Job Output

    • EBA - Payroll Transaction

  • Date is the date of the original output.

  • Activity/Output is the Activity or Output used for the line.

  • Work Centre is the original Work Centre of the line and can be blank. This is used for Work Centre-level revenue reporting.

  • Reference automatically inserts the unit of measurement of the line.

  • Quantity is the number of units for the line.

  • Rate is the selling or retail rate per Quantity of the line.

  • Amount is the product of the Quantity and Rate fields.

  • Invoice marks this line to be included in the current invoice when the Save - Generate Billing button is selected.

  • Defer marks this line to be excluded from the current invoice but not be written off. The intention is that you plan on billing deferred lines at a later date.

  • Write Off marks this line as unbillable, reducing the sell rate to zero. You can preemptively write off transactions in bulk using Write Off Transactions.

  • Future shows that this line is in a future date, activated by ticking Include Future. These lines can then be included in the invoice.

  • Details may come from the outputs themselves or you can manually adjust them here. This field is displayed in the standard invoice, so it is important to moderate any comments that are not meant to be client facing.

  • View Details shows additional details from the output.

  • Retail is the original retail or selling amount of the output before any adjustments to the Quantity or Rate fields.

  • Cost is the cost to the job of the original transaction. Outputs have no cost associated with them.

  • Revert causes all invoiced transactions to be reverted to being uninvoiced (the Invoice radio button is selected), and any Deferred or Written Off transactions will be unchanged.

  • Save - Generate Billing saves all changes and populates the invoice with the resulting lines.

  • Back to Invoice navigates you back to the invoice screen.

Billed Transactions This Invoice Tab

Image Removed

Expand
  • Uninvoice is ticked when you want to manually remove lines from being invoiced to either defer or write off the transaction. Click the Save button to complete the process. All transactions can be uninvoiced by clicking the Revert button.
  • Type can be one of the following, and identifies the origin of the transaction:
    • JT - Job Transaction
    • JTAD - Adjustment Transaction
    • JTDI - Disbursement Transaction
    • JTDO - Docket Transaction
    • JTPL - Plant Issue Transaction
    • JTPU - Purchase Transaction
    • JTST - Stock Issue Transaction
    • JTTI - Time Transaction
    • PO - Purchase Order

    • JO - Job Output

    • EBA - Payroll Transaction

  • Date is the date of the original transaction.
  • Activity/Output is the Activity or Output used for the line.
  • Work Centre is the original Work Centre of the transaction, but can be modified here for billing purposes.
  • Reference automatically inserts identifying or extra information based on the Type of the line, from the Plant Item to the Employee Class and Time code of a Timesheet line.
  • Quantity is the number of units for the line and can be edited here.
  • Rate is the selling or retail rate per Quantity of the line and can be edited here.
  • Amount is the product of the Quantity and Rate fields.
  • Details may come from the transactions themselves or you can manually adjust them here. This field is displayed in the standard invoice, so it is important to moderate any comments that are not meant to be client facing.
  • View Details shows additional details from the original transaction.
  • Retail is the original retail or selling amount of the transaction before any adjustments to the Quantity or Rate fields.
  • Cost is the cost to the job of the original transaction. Outputs have no cost associated with them.
  • Status shows whether the line is being invoiced or written off.

Summary This Invoice Tab

Image Removed

Expand

This tab includes a summary line for each Sales Code. The following acronyms are used:

  • JT - Job Transactions
  • PO - Purchase Orders
  • JO - Job Outputs
    Expand
    titleSUMMARY THIS INVOICE TAB
    Image Added

    This tab includes a summary of the Schedule of Rates with an overview of what has been claimed so far.

    Next Steps:

    Once the claim has been populated, assign an approver or approve it yourself if appropriate. Once approved, click Final Invoice and send the invoice produced to the client.


    FAQs:

    Filter by label (Content by label)
    showLabelsfalse
    showSpacefalse
    cqllabel = "outputs" and space = "KB"

    Process Flow: