Subcon Billings - Data Entry

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

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

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 -> Subcontractors Billing v3. You will be redirected to Billing tab window.

4.Select ContractNo where you want to encode the billing. The Subcon Contracts data grid is non-editable. If you want to update or add new ContractNo, open the Subcon 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_SubConBilling
Primary Key: CoID, ContractNo, SeqNo

Column Name	Sample Value	Description
CoID	T10	Hidden Column. The Company ID that the user is currently log-in
DocGuid	ABC-001-1	Hidden and primary key column. This is system generated using ContractNo+BillingNo as the default value. In case a duplicate DocGuid is generated, unhide the column and adjust the value manually.
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/07/2019	The date the billing is due. The default value is set to 15 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.
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-ISNULL(VATAmount,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 payment made using the GL system.
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.