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
Top 10 most powerful countries in the world by military strength in 2024: Where does India rank?
How do I cancel a hotel reservation? - BCD Travel
Www.paystubportal.com/7-11 Login
Repentance (2 Corinthians 7:10) – West Palm Beach church of Christ
Trabestis En Beaumont
Wizard Build Season 28
Chalupp's Pizza Taos Menu
Dr Klabzuba Okc
Mylaheychart Login
Puretalkusa.com/Amac
Victoria Secret Comenity Easy Pay
10000 Divided By 5
Publix 147 Coral Way
Call Follower Osrs
Grace Caroline Deepfake
Scenes from Paradise: Where to Visit Filming Locations Around the World - Paradise
St Maries Idaho Craigslist
Forum Phun Extra
ZURU - XSHOT - Insanity Mad Mega Barrel - Speelgoedblaster - Met 72 pijltjes | bol
Culver's Flavor Of The Day Taylor Dr
Craigslist Pearl Ms
Dallas Mavericks 110-120 Golden State Warriors: Thompson leads Warriors to Finals, summary score, stats, highlights | Game 5 Western Conference Finals
Doublelist Paducah Ky
Gina Wilson Angle Addition Postulate
Best Boston Pizza Places
Poochies Liquor Store
Skidware Project Mugetsu
The Powers Below Drop Rate
Vadoc Gtlvisitme App
2487872771
Leland Nc Craigslist
Craigslist Org Sf
No Hard Feelings Showtimes Near Tilton Square Theatre
Ljw Obits
Whitehall Preparatory And Fitness Academy Calendar
Mydocbill.com/Mr
Myfxbook Historical Data
Felix Mallard Lpsg
Überblick zum Barotrauma - Überblick zum Barotrauma - MSD Manual Profi-Ausgabe
Wlds Obits
Search All of Craigslist: A Comprehensive Guide - First Republic Craigslist
Gopher Hockey Forum
Martha's Vineyard – Travel guide at Wikivoyage
20 Mr. Miyagi Inspirational Quotes For Wisdom
Hello – Cornerstone Chapel
Server Jobs Near
Stoughton Commuter Rail Schedule
Craigslist Marshfield Mo
Ics 400 Test Answers 2022
Guidance | GreenStar™ 3 2630 Display
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.