Billing Templates (2024)

  • Billing Templates
    • Get Billing Template Object Definition
    • Query and List Billing Templates
    • Query and List Billing Templates (Legacy)
    • Get Billing Template
    • Get Billing Template by ID
    • Create Billing Template
    • Update Billing Template
    • Delete Billing Template
  • Billing Template Details
    • Get Billing Template Detail Object Definition
    • Query and List Billing Template Details
    • Query and List Billing Template Details (Legacy)
    • Get Billing Template Detail

A billing template defines the schedule to invoice the flat/fixed amount for a contract line over the contract term.

Billing Templates

Get Billing Template Object Definition

lookup

List all the fields and relationships for the billing template object:

<lookup> <object>CONTRACTBILLINGTEMPLATE</object></lookup>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE

Query and List Billing Templates

query

List the record number and description for each billing template:

<query> <object>CONTRACTBILLINGTEMPLATE</object> <select> <field>RECORDNO</field> <field>DESCRIPTION</field> </select></query>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE
filter Optional object Filter expression to limit the response to only objects that match the expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
select Required sequence The names of the fields that you want included in the response, and an optional aggregate function such as count or sum. Returning all fields is not supported.
orderby Optional object Provide an order element with a field name and choose an ascending or descending sort order, for example:
<order>
<field>RECORDNO</field>
<descending/>
</order>
options Optional object Query options:
  • Set the caseinsensitive element to true for a case-insensitive query
    <caseinsensitive>true</caseinsensitive>
  • In a multi-entity company, set the showprivate element to true to query data in private entities:
    <showprivate>true</showprivate>
  • Specify the returnformat for the response: xml (default), json, or csv
    <returnformat>json</returnformat>
pagesize Optional integer Maximum number of matching objects to return in the response, between 1 and 2000 items (Default: 100)
offset Optional integer Point at which to start indexing into records (Default: 0)

Query and List Billing Templates (Legacy)

readByQuery

<readByQuery> <object>CONTRACTBILLINGTEMPLATE</object> <fields>*</fields> <query></query> <pagesize>100</pagesize></readByQuery>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query Fields

Name Required Type Description
STATUS Optional string Status. Use T for Active, F fo Inactive

Get Billing Template

read

<read> <object>CONTRACTBILLINGTEMPLATE</object> <keys>1</keys> <fields>*</fields></read>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE
keys Required string Comma-separated list of billing template RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. To return all fields, omit the element or provide * for the value.
For best performance and predictability, limit the number of fields.
returnFormat Optional string Data format for the response body:
  • xml (default)
  • json
  • csv

Get Billing Template by ID

readByName

<readByName> <object>CONTRACTBILLINGTEMPLATE</object> <keys>Contract Billing Template</keys> <fields>*</fields></readByName>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE
keys Required string Comma-separated list of billing template NAME to get
fields Optional string Comma-separated list of fields on the object to get. To return all fields, omit the element or provide * for the value.
For best performance and predictability, limit the number of fields.
returnFormat Optional string Data format for the response body:
  • xml (default)
  • json
  • csv

Create Billing Template

History

Release Changes
2019 Release 1 Added METHOD and SOURCE

create

Creates a billing template with predefined percentages:

<create> <CONTRACTBILLINGTEMPLATE> <NAME>40-30-20-10AA</NAME> <DESCRIPTION>Declining percentages at 2, 4, 6, and 8 months</DESCRIPTION> <METHOD>Predefined percentages</METHOD> <CONTRACTBILLINGTEMPLATEENTRIES> <CONTRACTBILLINGTEMPLATEENTRY> <PERIODOFFSET>2</PERIODOFFSET> <PERCENTBILLED>40</PERCENTBILLED> </CONTRACTBILLINGTEMPLATEENTRY> <CONTRACTBILLINGTEMPLATEENTRY> <PERIODOFFSET>4</PERIODOFFSET> <PERCENTBILLED>30</PERCENTBILLED> </CONTRACTBILLINGTEMPLATEENTRY> <CONTRACTBILLINGTEMPLATEENTRY> <PERIODOFFSET>6</PERIODOFFSET> <PERCENTBILLED>20</PERCENTBILLED> </CONTRACTBILLINGTEMPLATEENTRY> <CONTRACTBILLINGTEMPLATEENTRY> <PERIODOFFSET>8</PERIODOFFSET> <PERCENTBILLED>10</PERCENTBILLED> </CONTRACTBILLINGTEMPLATEENTRY> </CONTRACTBILLINGTEMPLATEENTRIES> </CONTRACTBILLINGTEMPLATE></create>

Creates a billing template for project percent complete:

<CONTRACTBILLINGTEMPLATE> <NAME>Proj est. hrs</NAME> <DESCRIPTION>Project percent complete - based on estimated hours</DESCRIPTION> <METHOD>Project percent complete</METHOD> <SOURCE>Estimated hours</SOURCE> <STATUS>active</STATUS></CONTRACTBILLINGTEMPLATE>
Parameters
Name Required Type Description
CONTRACTBILLINGTEMPLATE Required object Object to create

CONTRACTBILLINGTEMPLATE

Name Required Type Description
NAME Required string Billing template name
DESCRIPTION Optional string Description
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive (Default: active)
METHOD Optional string Template type. Use Predefined percentages, Project percent complete, or Task percent complete. (Default: Predefined percentages)
SOURCE Optional string When creating Project percent complete, or Task percent complete templates, specifies whether to base the percentages on Estimated hours, Observed % completed, or Planned hours. Budgeted hours is also available for Project percent complete. (Default: Estimated hours)
CONTRACTBILLINGTEMPLATEENTRIES Optional CONTRACTBILLINGTEMPLATEENTRY[0...n] Template detail when using predefined percentages. Percent to bill’s must add up to 100.

CONTRACTBILLINGTEMPLATEENTRY

Name Required Type Description
PERIODOFFSET Required integer Number of months offset
PERCENTBILLED Required decimal Percent to bill

Update Billing Template

History

Release Changes
2019 Release 1 Added METHOD and SOURCE

When updating template details, you are providing a complete new set of entries (existing entries are deleted).

update

<update> <CONTRACTBILLINGTEMPLATE> <NAME>40-30-20-10AA</NAME> <DESCRIPTION>Hello world</DESCRIPTION> </CONTRACTBILLINGTEMPLATE></update>
Parameters
Name Required Type Description
CONTRACTBILLINGTEMPLATE Required object Object to update

CONTRACTBILLINGTEMPLATE

Name Required Type Description
RECORDNO Optional integer Record number of object. Required if not using NAME.
NAME Optional string Billing template name. Required if not using RECORDNO.
DESCRIPTION Optional string Description
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive (Default: active)
METHOD Optional string Template type. Use Predefined percentages, Project percent complete, or Task percent complete. (Default: Predefined percentages)
SOURCE Optional string When creating Project percent complete, or Task percent complete templates, specifies whether to base the percentages on Estimated hours, Observed % completed, or Planned hours. Budgeted hours is also available for Project percent complete. (Default: Estimated hours)
CONTRACTBILLINGTEMPLATEENTRIES Optional CONTRACTBILLINGTEMPLATEENTRY[0...n] Template detail when using predefined percentages. Percent to bill’s must add up to 100.

CONTRACTBILLINGTEMPLATEENTRY

Name Required Type Description
PERIODOFFSET Required integer Number of months offset
PERCENTBILLED Required decimal Percent to bill

Delete Billing Template

delete

<delete> <object>CONTRACTBILLINGTEMPLATE</object> <keys>112</keys></delete>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATE
keys Required string Comma-separated list of billing template RECORDNO to delete

Billing Template Details

Get Billing Template Detail Object Definition

lookup

List all the fields and relationships for the billing template detail object:

<lookup> <object>CONTRACTBILLINGTEMPLATEENTRY</object></lookup>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATEENTRY

Query and List Billing Template Details

query

List the record number and percent billed for each billing template detail:

<query> <object>CONTRACTBILLINGTEMPLATEENTRY</object> <select> <field>RECORDNO</field> <field>PERCENTBILLED</field> </select></query>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATEENTRY
filter Optional object Filter expression to limit the response to only objects that match the expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
select Required sequence The names of the fields that you want included in the response, and an optional aggregate function such as count or sum. Returning all fields is not supported.
orderby Optional object Provide an order element with a field name and choose an ascending or descending sort order, for example:
<order>
<field>RECORDNO</field>
<descending/>
</order>
options Optional object Query options:
  • Set the caseinsensitive element to true for a case-insensitive query
    <caseinsensitive>true</caseinsensitive>
  • In a multi-entity company, set the showprivate element to true to query data in private entities:
    <showprivate>true</showprivate>
  • Specify the returnformat for the response: xml (default), json, or csv
    <returnformat>json</returnformat>
pagesize Optional integer Maximum number of matching objects to return in the response, between 1 and 2000 items (Default: 100)
offset Optional integer Point at which to start indexing into records (Default: 0)

Query and List Billing Template Details (Legacy)

readByQuery

<readByQuery> <object>CONTRACTBILLINGTEMPLATEENTRY</object> <fields>*</fields> <query></query> <pagesize>100</pagesize></readByQuery>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATEENTRY
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

Get Billing Template Detail

read

<read> <object>CONTRACTBILLINGTEMPLATEENTRY</object> <keys>1</keys> <fields>*</fields></read>
Parameters
Name Required Type Description
object Required string Use CONTRACTBILLINGTEMPLATEENTRY
keys Required string Comma-separated list of billing template detail RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. To return all fields, omit the element or provide * for the value.
For best performance and predictability, limit the number of fields.
returnFormat Optional string Data format for the response body:
  • xml (default)
  • json
  • csv

Provide feedback

Billing Templates (2024)

FAQs

How do you simplify billing process? ›

Digitize Your Billing and Invoicing Documents

The first step to simplifying how you bill or invoice clients is to eliminate paper documents whenever possible. Sending bills or invoices via snail mail is not only time-consuming or tedious, it also increases the likelihood of delayed or missed payments.

What is an example of a friendly payment reminder message? ›

Hope you are doing well. This is just a friendly reminder that payment for your unpaid invoice [INVOICE #] is due on [PAYMENT DUE DATE]. I've reattached the invoice for your reference. Please feel free to contact me if you have any questions about the invoice, or if you'd like to arrange your payment.

How to professionally ask for payment from clients template? ›

Professional Payment Request Email Templates

I know I sent the invoice at a busy time and want to ensure you received it. I've attached the original invoice to this email. You can send payment by check or pay by direct transfer. Please let me know if you have any questions about the invoice.

How do you fill out a billing statement? ›

A billing statement format typically includes the customer's name, address, and account number at the top, followed by a summary of charges and payments, an itemized list of charges, and customer service information at the bottom.

What is the billing procedure answer? ›

Billing process. The billing process is a set of steps that a business follows to create and send invoices to its customers for the products or services provided. It typically involves gathering customer and product/service information, generating an invoice, sending it to the customer, and tracking payment.

How to streamline billing process? ›

5 Strategies to Streamline Your Job Invoicing Process
  1. Embrace Digital Transformation with Electronic Invoices. ...
  2. Equip Your Technicians with a Mobile Application. ...
  3. Minimize Billing Times. ...
  4. Automate Payment Reminders. ...
  5. Choose Comprehensive Job Management Software.

How do I write a gentle reminder message? ›

Start with the niceties. Since your goal is to write a gentle reminder email, start with a friendly message. It's best to be specific and reference something appropriate that you know about the person, such as an upcoming milestone or a big project they've been working on.

How do you politely remind clients of payment terms? ›

Dear [Client Name], We at [Business Name] appreciate your business and look forward to working with you in the future. At this time, I'm writing about your past due balance of [Amount], which we expected to receive on [Date]. Please let me know whether you received the detailed invoice sent on [Date].

How to bill your client format? ›

A client billing solution involves creating detailed invoices with itemized goods and services, provided along with the unit price, quantity sold, and total amount due. Depending on the jurisdiction of your business, the process may include computing and adding relevant taxes, fees, or discounts.

How do you politely ask for payment on a message? ›

I hope you're doing well. I'm reaching out to you to remind you that your payment of [payment total] for invoice [invoice number] with us is [number of days] overdue. According to our records, you should've received the invoice I'm referring to in the mail on July 5, 2022.

How to politely ask for an invoice payment? ›

Calling your client to ask for payment
  1. Introduce yourself and explain why you're calling,
  2. Be concise and polite,
  3. Try not to use slang words and expressions,
  4. Don't make direct accusations about the client not paying you,
  5. Maintain a polite tone that gives your client the benefit of the doubt, and.

What is a sample sentence for billing? ›

His billing system was chaotic and often generously discounted. Delivery address must be the same as the billing address. But advertisers do not get top billing merely by paying more than their rivals. There is usually a problem if the warm-up act is more popular than the star billing.

What is the basic billing statement? ›

It is a list of payments made and the balance due to be paid. The typical billing statement refers to an ongoing business relationship of clients who are provided with a summary of their financial activities with a certain company.

How do you simplify bill payments? ›

Selecting the same due date for multiple bills can help simplify your recurring payments schedule by making it easier to keep tabs on. Selecting multiple dates can help you spread payments out each month to ensure you have the funds available to cover each bill.

How can we simplify the process? ›

Here are six tips for simplifying your own processes to improve the participant experience and achieve greater results.
  1. Give simple, short, and clear instructions. ...
  2. Clarify the context. ...
  3. Focus on one thing at a time. ...
  4. Reduce the amount of information available at once. ...
  5. Take an invitational approach.
Mar 22, 2022

How do you simplify accounting process? ›

7 Ways to Simplify Accounting in Your Business
  1. Keep Track of Your Accounts Payable. ...
  2. Create an Expense Tracking System. ...
  3. Maintain a Separate Business Bank Account. ...
  4. Eliminate Manual Data Entry. ...
  5. Choose the Right Accounting Software. ...
  6. Regularly Reconcile Accounts. ...
  7. Hire a Professional.

What is simple billing system? ›

A billing system is a procedure used by a company to charge and invoice clients, to put it simply. It's a software that automates the process of taking payments and sending out regular invoices. As well, tracking expenses and tracking invoices are frequently included in billing systems.

Top Articles
How Much House Can I Afford? | Bankrate
How to Reset SSD to Factory Settings Completely without Hurting It?
Katie Pavlich Bikini Photos
Gamevault Agent
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Free Atm For Emerald Card Near Me
Craigslist Mexico Cancun
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Doby's Funeral Home Obituaries
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Select Truck Greensboro
How To Cut Eelgrass Grounded
Pac Man Deviantart
Craigslist In Flagstaff
Shasta County Most Wanted 2022
Energy Healing Conference Utah
Testberichte zu E-Bikes & Fahrrädern von PROPHETE.
Aaa Saugus Ma Appointment
Geometry Review Quiz 5 Answer Key
Walgreens Alma School And Dynamite
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
Dmv In Anoka
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Pixel Combat Unblocked
Umn Biology
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Rogold Extension
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Weekly Math Review Q4 3
Facebook Marketplace Marrero La
Nobodyhome.tv Reddit
Topos De Bolos Engraçados
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Holzer Athena Portal
Hampton In And Suites Near Me
Stoughton Commuter Rail Schedule
Bedbathandbeyond Flemington Nj
Free Carnival-themed Google Slides & PowerPoint templates
Otter Bustr
San Pedro Sula To Miami Google Flights
Selly Medaline
Latest Posts
Article information

Author: Ray Christiansen

Last Updated:

Views: 6388

Rating: 4.9 / 5 (49 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Ray Christiansen

Birthday: 1998-05-04

Address: Apt. 814 34339 Sauer Islands, Hirtheville, GA 02446-8771

Phone: +337636892828

Job: Lead Hospitality Designer

Hobby: Urban exploration, Tai chi, Lockpicking, Fashion, Gunsmithing, Pottery, Geocaching

Introduction: My name is Ray Christiansen, I am a fair, good, cute, gentle, vast, glamorous, excited person who loves writing and wants to share my knowledge and understanding with you.