|
There are usually three types of billings as follows:
1. Downpayment = refers to the first billing upon signing of the contract and it is to be recouped for every progress billing made. Contracts usually provides 20% downpayment as an assurance that the contract will be paid.
2. Progress Billing = refers to billings for the accomplishment made during the duration of the construction.
3. Retention Billing = refers to deduction from the progress billing to ensure that future repair works will be done and that the contract will be completed by the contractor. Contracts usually provides 10% retention fee. Upon completion and turn-over of the contract, the accumulated retention fee will be billed and paid.
For construction companies, the VAT is remitted on every collection made. Therefore, downpayment is subject to VAT even if there's no revenue is recognized yet. The system is initially setup based on this requirement but you can modify the setup based on your requirements as follows:
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 System->Contractuion Contract Management. This master file is also accessible from other systems. An update here will also reflected on the other systems.
3. Double-click Master Files -> Construction Contracts (Clients and Subcon). You will be redirected to Construction Contracts tab window.
4. Set the parameters based on the existing tax regulations so that the system will compute VAT and EWT properly
5. Set the TrasactionID to be used in generating journal entries to be exported to the GL System. See Transaction Proforma Journal Entries for details.
6. Click Save.
The above setup will result to the following journal entries:
Given data:
Contract Amount: 112.00
Downpayment: 20%
Accomplishment: 100%
1st Progress Billing: 50%
2nd Progress Billing: 50%
Retention Fee: 10%
To simplify the entry, the Final VAT for government project is not taken into account but the system is capable to compute this tax.
|
Account Title
|
Debit
|
Credit
|
|
1. Payment of Downpayment (20%)
|
|
Input Tax
|
2.40
|
|
|
Advances to Subcontractors
|
20.00
|
|
|
CIB*
|
|
22.40
|
|
|
|
|
|
2. Progress Billing 50% (Setup of A/P)
|
|
Direct Labor or CIP Labor
|
50.00
|
|
|
Deferred Input VAT
|
6.00
|
|
|
A/P
|
|
39.20
|
|
Retention Payables
|
|
5.60
|
|
Deferred Input VAT
|
|
1.20
|
|
Advances to Subcontractorts
|
|
10.00
|
|
3. Payment of Progress Billing (50%)
|
|
A/P
|
39.20
|
|
|
Input Tax
|
4.20
|
|
|
CIB
|
|
38.20
|
|
EWT
|
|
1.00
|
|
Deferred Input VAT
|
|
4.20
|
|
4. Progress Billing 100% (Setup of A/P)
|
|
Direct Labor or CIP Labor
|
50.00
|
|
|
Deferred Input VAT
|
6.00
|
|
|
A/P
|
|
39.20
|
|
Retention Payables
|
|
5.60
|
|
Deferred Input VAT
|
|
1.20
|
|
Advances to Subcontractorts
|
|
10.00
|
|
5. Payment of Progress Billing (100%)
|
|
A/P
|
39.20
|
|
|
Input Tax
|
4.20
|
|
|
CIB
|
|
38.20
|
|
EWT
|
|
1.00
|
|
Deferred Input VAT
|
|
4.20
|
|
6. Payment of Retention Fee
|
|
Retention Receivable
|
11.20
|
|
|
Input Tax
|
1.20
|
|
|
CIB
|
|
11.20
|
|
Deferred Input VAT
|
|
1.20
|
|
*If you want to deduct 2% on Downpayment, set the value of DP for WTaxDP to Yes. A credit to CWT will be added in the journal entry.
|
Data Definition:
Database Table Name: cm_BillingTypeAR
Primary Key: BillingTypeID
|
Column Name
|
Sample Value
|
Description
|
|
ApplicationID
|
CM
|
Don't change the default value of CM.
|
|
BillingType
|
DP
|
Type of Billing
|
|
BillingTypeDesc
|
Downpayment
|
Description of the BillintType
|
|
VatableDP
|
Y
|
Yes, if the downpayment is subject to VAT. As of this writing, tax regulation states that DP is subject to VAT
|
|
WTaxDP
|
N
|
We simple put N. Since the payee/client controls this if he/she will deduct withholding tax.
|
|
VatableRB
|
Y
|
Yes, if the Retention Billing is subject to VAT. As of this writing, tax regulation states that RB is subject to VAT upon collection
|
|
WTaxRB
|
N
|
We simple put N. Since the payee/client controls this if he/she will deduct withholding tax.
|
|
TransactionID
|
218
|
The proforma journal entries to be used when creating journal entries
|
|
TransactionDesc
|
Advances to
|
Description of the TransactionID
|
|
ATC
|
WC160
|
Select from the dropdownlist. But this is usually has the value of WC160
|
|
ATCRate
|
2%
|
Withholding tax rate
|
|
VATATC
|
VB010
|
VAT apha tax code
|
|
VATRate
|
12%
|
VAT rate
|
|
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.
|
|
