Billing to Client per Contract

Navigation: Systems Manual > Construction Contract Management System > Transactions Data Entry >

Billing to Client per Contract - Data Entry

This data entry is used to enter billings to clients on a per contract basis. It shows all the previously entered billings to ensure contracts are billed accordingly.

Step-by-step instructions:

1. Open Cenral Menu. Your Central Menu maybe different from the screenshot below as each user can have different menu and access rights.

2. Select Systems ->Construction Contract Management

3. Double-click Transactions -> Billing to Client per Contract. You will be redirected to Billing tab window.

4.Select ContractNo where you want to encode the billing. The Project Contracts data grid is non-editable. If you want to update or add new ContractNo, open the Construction Contracts Master File and make the necessary update and refresh the app after updating the master file.

5. Enter the billing data for the selected contract in #5. Fill up the columns properly, read the data definition below for details.

6. Click Save to persist changes made to the database.

Data Definition for Billing Invoice

Database Table Name: cm_ContractBilling
Primary Key: DocGuid

Column Name	Sample Value	Description
CoID	T10	Hidden Column. The Company ID that the user is currently log-in
DocType	SI	Hidden Column. The default value is taken from the database default value.
DocGuid	451461051	Hidden and primary key column. Starting version 2, this is system generated instead of using default ContractNo+BillingNo. In case a duplicate DocGuid is generated, unhide the column and change the value manually to any number.
ContractNo	ABC-001	Hidden Column. Child key Column. The value is taken from the parent row
DateProcessed	5/23/2019	The date of the billing.
DueDate	6/22/2019	The date the billing is due. The default value is set to 30 days from the billing date
RefNo/InvNo	00016	If the company is using pre-numbered Billing Invoice, use it as the RefNo number. Otherwise, let the system fill-up this column. This RefNo is necessary when generating journal register and exporting detailed journal entries into the GL system.
BillingNo	1	The sequential billing number for the selected contract. This is different from the company's pre-numbered Billing Invoice, if any. See RefNo/InvNo above.
BillingPeriod		Optional only. The covering period of the billing.
PONo		Optional only.
BillingDesc	DP 20%	Descriptive note of the billing. Usually stating the percentage being billed.
BillingTypeID	DP	The type of billing. Select from the dropdown list: Downpayment, Progress or Retention billing
TransactionID	227	The transaction id to be used in creating the journal entry
TransactionDesc	Downpayment	Hidden column.
VATATC	VB010	VAT ATC. The value will be taken based on the TransactionID
VATRate	12%	Rate in computing VAT
ATC	WC160	Alpha Tax Code to be used. The value will be taken based on the TransactionID
ATCRate	2%	ATC Rate.
TDPercent		ToDatePercent represents the accumulated % billed for progress billing. Leave zero for DP and Retention billings since there is no accomplishment.
TBPercent	20%	ThisBillingPercent represents the % currently beingbilling.
TDAmount		ToDateAmount represents the accumulated billed amount pertaining to progress billing. Leave zero for DP and Retention billings.
TBAmount		ThisBillingAmount represents the amount currently being billed.
VATAmount		Automatically computed based on the billing type setup
WTaxAmount		Automatically computed based on the billing type setup
NetAmount		Formula field: TBAmount - DPRecoupment - RetentionAmount - WTaxAmount - OtherDeductions,0)
DPRecoupment		Recoupment of DP based on the % of progress billing
RetentionAmount		Retention amount to be deducted from the progress billing
OtherDeductions		You may manually enter the amount of deduction such as advances and pentalties here.
PrepaidVAT		This represents the VAT applicable to the recoupment of DP. Automatically computed based on the billing type setup.
DeferredVAT		This represents the VAT applicable to the Retention Amount. Automatically computed based on the billing type setup.
VATPayable		The VAT to be recognized as payable when the billing is collected.
NetPayableAmount		Formula field: TBAmount - DPRecoupment - RetentionAmount - WTaxAmount - OtherDeductions,
AmountCollected		Represents the amount collected for the billing. This is automatically computed based on the data entered on the collection app.
RefNo		Optional only. This may refer to the APV or CV number
Attachment		Optional only. You may enter scan docs here link the approved billing
Remarks		Optional only.
VatableDP, WTaxDP, VatableRB, WTaxRB		Their value is used in computing the Prepaid VAT, Deferred VAT and WT. See Client Billing Types and Proforma Journal Entries for details.
Status	A	A=Active; I=InActive. You can mark inactive vendor category to remove them from the lookup table.
Createdby, DateCreated, Modifiedby, DateModified		These columns are called audit trails. Their values are auto-generated. One who created or modified the app. It is assumed that the current user is the one who created or modified the record.