Chang Pile · User Manuals
📕 Web App User Manual · Volume 4

ERP Studio — Construction Management System

Projects · Documents & contracts · BOQ · Finance, accounting & tax · Ledger & financial statements · Approvals · PDPA · Procurement · Equipment · Workforce · Site control
Used with page: erp-studio.html
Intended for: contracting business owners, project managers, site supervisors, project administrators, procurement staff and accounting staff
Reading time: about 45 minutes · First-time setup: about 1 hour
Last updated: 1 November 2569
Anyone can view the sample data Adding/editing data requires a VIP or staff account The whole team works on one data set
Open ERP Studio

First-time setup in 6 steps

Follow this order, because the later modules all refer to the project name created in the first steps
  1. Sign inYou need a VIP account or an approved staff account
  2. Set up the company profileEnter the company name, address, tax ID and logo before issuing your first document · set the opening cash and the books start date (section 4)
  3. Create a projectIn the Projects menu, enter the name, location, budget and time frame
  4. Lay out the work phasesSplit the contract work into phases, each with a value and a due date
  5. Set up the BOQEnter the work categories and the budget per category so costs are under control from day one
  6. Issue your first documentPress Create document, make a quotation and submit it for approval — the approver must be someone other than the creator

1What the system does

ERP Studio brings a building contractor's back-office work together in one place — from issuing quotations and construction contracts, controlling the budget against the BOQ, ordering materials, logging equipment hours, paying wages and controlling site work, to issuing tax invoices, keeping the books and closing the financial statements. Every module refers to the same project name, so you see the cost and progress of each job straight away, and the whole team works on one data set.

ASales, documents and contracts

Quotations, construction contracts per the 2569 standard form, purchase orders, invoices, progress-payment claims and RFIs, with VAT, discounts and withholding tax calculated automatically

BCost and performance control

BOQ by category comparing budget with actual cost, site cost by project, and CPI/SPI performance indices that show which project is spending more than its progress or running behind schedule

CSupport work and site control

Procurement and inventory, equipment and maintenance plans, workers, wages and social security, site diaries, variations, quality inspection and safety — the figures flow into project cost without being keyed in twice

DFinance, tax and accounting

Payables, receivables, cash flow, full tax invoices, credit/debit notes, 50 Tawi certificates, escalation (K), a journal that posts itself, the trial balance and financial statements per TFRS for NPAEs

EInternal control and personal data

Multi-step approval by amount, a change log that cannot be deleted, accounting period close, and tools for the Personal Data Protection Act

2Permissions and data storage

User statusCanCannot
Not signed inView the sample data in every moduleAdd or edit any data
General customer (signed in)View onlyAdd/edit projects, documents and BOQ
Lifetime VIP memberFull use + company logo on document headers—
StaffFull use · approve documents at step 1 (ones they did not create)Approve their own items · approve at step 2
AdministratorFull use · approve at step 2 · edit the approval amount rules · reopen closed accounting periodsApprove their own items
⚠ One device at a time One member account cannot be used on two devices at the same time. To move to another device, press Log out on the old device first, then sign in on the new one · if you closed the browser without logging out, there is no need to wait — the sign-in page on the new device shows a Log out the other device and use this one button that you can press right away (this rule does not apply to staff and administrators)
⚠ The account must be approved If you signed up for VIP but have not paid yet, or you are a staff member still awaiting approval, the system still treats you as view-only

Where the data is stored

  • Stored on your account — when the database is reachable, data is saved to the system and loaded back every time you open the page. Open it from another computer or a phone and you see the same data set
  • Updates instantly when someone else edits — if a colleague is editing at the same time, the figures on your screen refresh by themselves
  • Keep working even if the connection drops — the system keeps a copy in the browser and sends it up once you are back online
  • The whole team works on one data set — the procurement, equipment, workforce, finance and site control modules and the construction contract text are stored record by record in a shared table, so two people can edit different records at the same time without overwriting each other · the first time after the administrator switches on the shared table, a blue bar Move to the shared table appears so you can move the data previously kept in your account into it (the original data is kept as a backup)
  • Every edit is logged — who changed what, from which old value to which new value, can be seen in the Approvals & history menu (section 11); the log cannot be edited or deleted
  • Nothing left on the device after logging out — the system clears the browser cache copy every time, so a shared computer is safe to use
💡 No need to save each table Every cell in the site support module tables saves as soon as you edit it · the document work has separate Save draft and Save & submit for approval buttons

Confirmation pop-up before deleting or overwriting

Every button that makes data disappear or be replaced always shows an “Are you sure you want to…” pop-up first. The pop-up states the item name, number and how many records will actually be lost; read it before pressing — there is no undo button after you confirm

What you seeMeaning
Red button + trash-can iconDelete or clear data
Blue button + swap-arrows iconOverwrite, import or restore — the existing data is replaced with a new set
Orange box in the pop-upThings to know before pressing, e.g. this item is linked to other data, or a backup is available to restore
“Cancel” button · press Esc · click outside the boxCloses the pop-up without changing anything
💡 Deleted values can still be viewed If you pressed by mistake, the previous values of deleted data can be viewed under Approvals & history → Change log · accounts without edit rights get a permission message instead of the pop-up

Besides every delete button (projects, documents, contracts, purchase orders, escalation K, workforce, equipment, site records, etc.), the pop-up also appears first in these cases:

  • Cancelling a tax invoice / credit-debit note from the status field — once cancelled it cannot be reverted; the safe-side button reads Keep it
  • Reopening an accounting period — the trial balance stored at period close will be cleared
  • Deleting a line in a journal voucher or an escalation (K) record · deleting a stage-of-completion adjustment · deleting a custom account
  • Closing a document or contract form that has been filled in but not yet saved (an empty form closes straight away)
  • Buttons in the contract form that overwrite what you typed — pull the project's work phases · split the price evenly · use our company details

3Tour of all 12 menus

The left-hand menu has 3 groups — Main menu · Head office · Site support · The orange number on a menu item is the count of outstanding items waiting for you

GroupMenuUsed forNumber on the menu
Main menuProjectsProject list, overall Gantt schedule and contract work phases (section 5)—
DashboardOverview of actual cash in and out, operating results, tax and filing deadlines, internal control, site and safety, outstanding items, cost and performance by project (section 16)—
Documents6 document types including construction contracts (section 6)Number of documents
BOQ & costBill of quantities by category, comparing budget with actual cost (section 7)—
Head
office
Finance, accounting & taxPayables · Receivables · Tax invoices · Escalation (K) · Cash flow · Tax & billing (section 8)Documents overdue for payment/collection
Ledger & statementsJournal · Journal vouchers · Ledger · Trial balance · Statements · Stage of completion · Period close (section 9)Vouchers still in draft
Personal dataPDPA records of processing and data past its retention period (section 10)Items due for review
Approvals & historyApproval queue · Approval history · Change log · Exceptions · Amount rules (section 11)Items waiting for your approval
Site
support
Procurement & inventoryPurchase requests · Purchase orders · Site receipts & issues · Site material stock (section 12)PRs awaiting approval
Equipment & plantRegister · Usage log · Maintenance plan · Depreciation (section 13)Machines due for maintenance
Workforce & wagesWorkers · Timesheets & wages and social security · Subcontracts (section 14)Timesheet periods not yet paid
Site controlSite diary · Variation orders (VO) · Quality inspection (IR/NCR) · Safety (section 15)Open NCRs

At the top of every page there is a Search documents, projects… box and a Create document button you can press from anywhere · the bottom-left corner has links to this manual, the privacy policy, the terms of service and your user profile · switch between Thai and English with the TH/EN button at the top

↔ Tables wider than the screen Tables of documents, accounts, inventory, etc. with so many columns that they overflow the screen can be scrolled left–right in 3 ways — a floating scrollbar at the bottom of the screen appears by itself while the bottom edge of the table is still below the screen (as wide as the table, draggable straight away, with ⤒ ⤓ ⇤ ⇥ buttons to jump to the table top/table end/first column/last column, and it disappears once the table's real scrollbar is in view) · the scrollbar under the table · or hold Shift and turn the mouse wheel

4Settings before going live

This takes about 15 minutes, but it makes every document, tax invoice and accounting figure issued from then on correct from the very first one

  1. Fill in the user profile and company information

    Click the profile picture in the bottom-left corner → Edit user information · fill in full name, position, department, email, phone, company name, company address, 13-digit tax ID and office/branch no. — this data appears as the seller on tax invoices, the payer on 50 Tawi certificates and the data controller in the PDPA record of processing

  2. Upload the company logo

    Click the picture to attach a file · a file of 1.5 MB or less is recommended (large files make saving slow or fail, so shrink the image first) · this logo appears at the top of every PDF document

  3. Set the opening cash and the books start date

    Menu Finance, accounting & tax → tab Cash flow: enter the opening cash · menu Ledger & statements → tab Chart & close: set the books start date (normally the first day of the accounting year) — the system uses these two values to calculate the brought-forward balances

  4. Check the social security rate

    At the bottom of the timesheet tab in the Workforce & wages menu — the default is 5% with a wage ceiling of 17,500 THB/month; change it when the Social Security Office announces a new rate

  5. (Administrator) Check the approval amount rules

    Menu Approvals & history → tab Approval rules — the amounts that require management as step 2, by document type; set them to match your company's approval authority

  6. Check that documents come out correctly

    Create one test quotation and press Preview / download PDF to check that the company name, address, tax ID and logo all appear

🚫 Do not skip this step The header of a document already issued is not updated retroactively, and an issued tax invoice cannot be edited — always complete the company information before issuing real documents

5Projects and work phases

Create a project

In the Projects menu, press Add project and fill in

  • Project name and Location — this name is used as the reference in every module, so keep it short and easy to remember
  • Project code — set automatically by the system; you can edit it in the Code field on the project card (see Project code below)
  • Status — Started · Under construction · Near handover · Completed · On hold
  • Budget · Actual cost · Disbursed · Progress
  • Colour of the project — used to tell the bars apart on the overall schedule

Drag the handle icon at the top of a card to reorder projects so the jobs being pushed hardest are on top

Project code

A project code must be unique across the whole system — including projects of other accounts you cannot see — so the system assigns codes in two ways depending on the account type

AccountExample codeOrigin
Staff · AdministratorPRJ-005The next number after the highest number of all projects in the system (staff already see every project)
VIP memberPRJ-001-7F3AThe next number after your own projects, followed by a 4-character account short code — the short code comes from the account ID, and the chance of two accounts getting the same short code is very low, so it practically never clashes with another account's projects

This applies when you press Add project, duplicate a project or add the sample project set · the running number counts only codes in the PRJ-### format; other codes you set yourself, such as CP-2569-014, do not make the number jump

⚠ A code you edit yourself must not duplicate any project in the system If the code you type duplicates another project — even one belonging to another account you cannot see — the database will reject it and show the message “Not saved — the project code duplicates another project in the system” · VIP members should keep the short code at the end, e.g. change PRJ-001-7F3A to SITE-A-7F3A

Overall schedule (Gantt)

Each project has its own task bars. Press + Task to add a work phase, then set the start and end dates — the system works out the number of months from the date range, and the Gantt bar moves with it immediately

This schedule is a phase-level overview for management. If you need detailed planning down to activity level with the critical path, use CPM Planner alongside it

Contract work phases

Press Add work phase to break the contract value down into phases; each phase has

FieldUsed for
No.Phase reference number
Installment detailsThe work to be delivered, e.g. “Foundation + 1st-floor slab”
Partner / clientThe party you will bill for payment
Value (baht)The amount of that phase
DueDue date for delivery or collection
StatusDraft · Awaiting approval · Approved · Paid

The work phases entered here appear on the Tax & billing page so you can see which phases have not been billed yet

6Documents and construction contracts

6 document types

TypeUsed when
QuotationQuoting a job to a client, with a price-validity date
ContractsFormally engaging the work — fill it in per the latest 2569 standard form of construction contract, then print the full contract (see the section below)
Purchase orderOrdering materials or engaging services from a vendor
InvoiceBilling for the agreed amount
Progress-payment claimClaiming payment according to the progress of a work phase
RFI / drawingRequesting further information or sending drawings for the designer to answer

Creating a document step by step

  1. Press Create document

    The system assigns the document number automatically; you do not need to enter it

  2. Choose the document type and project

    Link it to the right project, because the amount is counted into that project's cost or income

  3. Enter the partner/client and the dates

    Enter the partner name, document date and Payment due / price validity — this due date drives the “overdue documents” alert on the dashboard

  4. Choose the price mode

    Price excl. tax or Price incl. tax — choose whichever was agreed with the client; the system works out the VAT the right way

  5. Add items

    Press + Add item and fill in Description · Qty · Unit · Unit price · the system calculates the amount automatically

  6. Check the totals at the foot of the document

    Go through Subtotal → Discount → Price after discount → VAT 7% → Total amount → Withholding tax → Net payable

  7. Enter notes / terms

    For example, “Price valid 30 days · 30% deposit before work starts · this price excludes work beyond that specified”

  8. Save

    Save draft keeps it for further editing · Save & submit for approval sends it to the approval queue

Construction contract (latest 2569 standard form)

Choose the type Contracts and press Create document. The system opens a full-screen contract form divided into 10 steps following the government standard form of construction contract (clauses 1–23 and practice notes (1)–(24)). Fill it in step by step, or jump between steps from the left-hand bar

  1. Choose the price mode and your company's role

    Lump sum paid in installments · Unit price paid monthly on the actual quantities of work — the system inserts the text of clause 4 version (A) or (B) for you · choose whether our company is the contractor or the employer, then press Use company details in the parties step to pull the name, address and signatory from the profile

  2. Enter the contract price and payment installments

    Enter the contract price including VAT and the system separates out the VAT · for the installments, press Replace instalments (pulls the project's work phases from the BOQ & cost page) or Split evenly; the installments must add up exactly to the contract price

  3. Switch optional clauses on or off

    Advance payment · Retention · Use of Thai vessels · Workmanship standards · Additional terms — switch a clause off and the following clause numbers move up by themselves, and cross-references in the text (e.g. “per clause 20”) update to match

  4. Look at the “Contract check” panel on the right

    It checks against the practice notes at the end of the standard form, e.g. a warranty of at least 2 years · a subcontracting penalty of at least 10% · a daily penalty of 0.01–0.10% · a security of 5% · a 13-digit national ID number — click an item to go to the step that needs fixing · You can submit for approval once no red items remain, while Save draft is available at any time

  5. Preview, print or download Word

    Preview contract shows the whole contract in Thai numerals (can be switched off in the first step); fields not yet filled in appear as dotted lines for handwriting · Print / save as PDF gives A4 with page numbers · Download Word gives a .doc file to keep editing during negotiation

For older contracts created before this form existed, open them and press Edit contract; the system first drafts the data from the document (parties, value, the project's work phases) · this contract form is based on the government standard form; if you use it for private-sector work, have your legal team review it before signing

Document status cycle

Draft → Awaiting approval → Approved → Paid

A document past its due date but not yet closed gets an Overdue label and is counted in the “Documents pending” card on the dashboard

⚠ Approval has rules Press Approve document on the preview page, or change the status in the table to “Approved”, and the system sends it into the approval workflow (section 11) — the creator cannot approve their own document · amounts reaching the threshold must pass the administrator as step 2 · it cannot jump to “Paid” until approved · these rules apply to staff work; VIP members working alone can change the status themselves

Print and send to the client

Press Preview / download PDF to see a preview before printing, showing the company header, the item table, the amounts, the amount in words and the signature blocks for both the Proposer / authorized signatory and the Approver / client · then press Print / save as PDF

7BOQ and cost control

The BOQ & cost menu is the tool that tells you where your profit is leaking

  1. Choose a project

    The BOQ is kept per project, so choose the project to view first

  2. Add work categories

    Press Add work category and name it, e.g. Piling & foundation work · RC structural work · Architectural work · Electrical & communication systems · Sanitary & fire-protection systems · Labor & site management · Contingency

  3. Enter the budget per category

    The total of all categories should equal the contract value less the planned profit

  4. Track the actual cost

    The system compares the budget with the actual cost and shows the Variance and a Budget usage bar as a percentage

💡 Read it together with site cost The dashboard has a Site cost by project card that separates Materials from Labour / sub, pulled directly from the procurement and workforce modules — use it to check whether the BOQ figures match what is actually happening on site
📥 Receiving totals from BOQ Studio If you did the quantity take-off and cost estimate in BOQ Studio, press Send to ERP on the BOQ Studio price summary page — choose the target project or create a new one; the system sends the totals per work category here as the BOQ, and can optionally create work phases from the payment installments and an initial quotation as well, with no re-keying

8Finance, accounting and tax

The Finance, accounting & tax menu handles money in and out and the tax documents of every project · the journal, trial balance and financial statements are in the Ledger & statements menu (section 9), which posts itself from the documents in this menu

6 tabs — Payables (AP) · Receivables (AR) · Tax invoices · Escalation (K) · Cash flow · Tax & billing · the orange button in the top-right corner changes with the open tab (New payable · New billing · New credit note · New K record)

Payables (AP) — money we have to pay

Press New payable, or use the Book payable from… button to pull from purchase orders that are approved but have no payable booked yet — the system splits out the tax base automatically

Fill in Doc no./ref · Supplier · Project · Tax base · WHT % · Payment due · Paid · Status (Draft · Awaiting payment · Partially paid · Paid · Cancelled)

The reference number determines the expense account — a purchase order reference (PO-…) posts to materials · a subcontract reference (SC-…) posts to subcontractor costs · anything else posts to other construction costs — you can change the account in the journal (section 9), e.g. choose account 1210 for an equipment purchase

Receivables (AR) — money the client has to pay us

Press New billing and fill in Doc no./instalment · Project owner · Value · Retention % · Collection due · Received · Status (Draft · Billed · Partially collected · Collected · Cancelled) · an increase billing from escalation (K) shows as “K increase” instead of an installment number

Net amount = tax base + 7% VAT − withholding tax − retention
The retention is released once the contractual warranty period ends

Cash flow

  • Opening cash — the brought-forward balance used as the calculation base; entered once by hand
  • Cash on hand = opening + cash received to date − cash paid to date
  • Expected in / Expected out — forecast from the due dates of outstanding billings and payables
💡 Reading the forecast table correctly Items already past due are folded into the current month, and the highlighted row is this month — if a month's net figure is strongly negative, speed up collections or negotiate extended credit in advance

Tax & billing

FigureSource
Output VATFrom tax invoices issued that month + debit notes − credit notes
Input VATFrom payables booked that month
Net VAT payablePP.30 = output VAT − input VAT
WHT to remitPND.3 / 53 — tax we withheld from vendors/subcontractors · the amount withheld by clients is shown separately below the figure

Tax invoices · credit notes · debit notes

The Tax invoices tab is the register of full-form output tax invoices under Section 86/4 · construction work is a service, so the tax invoice is issued when payment is received (Section 78/1), not at billing

  1. Issue from a billing that has been paid

    Enter the “Received” amount in the Receivables tab, then press the → Issue tax invoice from AR-… button; the system creates a draft. A partial receipt calculates the tax base in proportion to the money actually received · the buyer's name, address, tax ID and branch are pulled from the previous tax invoice of the same buyer

  2. Check the buyer's details

    It must have the name, address, 13-digit tax ID and head office/branch · if anything is missing an orange label says so, and the status cannot be changed to “Issued”

  3. Issue and print

    Change the status to Issued and press 🖨 — you get the original and a copy, showing withholding tax and retention as deductions, so the net received equals the money actually received

⚠ Once issued, it cannot be edited or deleted Numbers run consecutively with no gaps · if an issued invoice is wrong, change it to Cancelled (the system asks for confirmation first, because it cannot be reverted · the original is kept) and issue a new one, or issue a credit note (Section 86/10) when the value decreases / a debit note (Section 86/9) when the value increases, referring to the original invoice and choosing the legal reason · only drafts can be deleted

Output VAT in the tax tab is calculated from tax invoices issued in the month + debit notes − credit notes; press 🖨 Output VAT report to print the monthly output tax report under Section 87 to support the PP.30 filing · e-Tax Invoice by Email — enter the buyer's email, then press ✉ Email (e-Tax) on the preview page; the system opens your email program with a copy to the ETDA time-stamping system (attach the PDF yourself). This works once you have registered for the service with the Revenue Department

Withholding tax certificate (50 Tawi)

The Withholding tax certificates (50 Tawi) card in the tax tab shows payables with tax withheld that were paid in the selected month (counted by actual payment date) · enter the 13-digit tax ID and the address of the payee, check the filing form (PND.53 for juristic persons / PND.3 for individuals — the system guesses from the name first), then press Print 50 Tawi to get the certificate on the Revenue Department form in two copies (copy 1 attached to the return · copy 2 kept as evidence) · a payer who does not issue a certificate is liable to a penalty under Section 35 of the Revenue Code · remit the tax by the 7th of the following month (the 15th when filing online)

Below is the Progress billing by instalment table, which pulls the work phases from every project and matches them against the billings already issued — any phase not yet billed can be turned into a receivable in one click

⚠ The tax figures are a preparation aid, not a filing Always use them as starting data for your bookkeeper to check before the actual filing

Escalation (K) — price-adjustable contracts

The Escalation (K) tab calculates the increase/decrease in construction payments under the Cabinet resolution (letter NR 0203/W 109 dated 24 August 2532), with all 35 formulas in 5 groups (building · earthwork · highway · irrigation · utilities). It is used for public-sector contracts and for private contracts that agree to use the same formulas

  1. Enter the monthly price indices

    Press + Add month and enter the indices published by the Ministry of Commerce (price.moc.go.th) — enter them once and every contract uses them · the table shows only the indices used by the formulas in your contracts; press Show all 13 indices to see them all · orange cells are indices a contract needs but that are still blank

  2. Open a K record for the contract

    Press + New K record, choose the project, and enter the contract number, the employer, the Bid opening month (o) and the contract end month

  3. Enter the installments

    One line per work type per installment — choose the formula, the delivery month (t) and the work value Po of that type in that installment · an installment containing both building work and piling must be split into two lines, because they use different formulas

  4. Check the results and print

    Hover over a K value to see the calculation index by index · press 🖨 to print the worksheet to attach to the payment claim letter · press → Bill increase and the system creates a draft receivable billing for just the amount not yet billed (with VAT taken out, because the contract work value already includes VAT)

RuleHow the system handles it
3 decimals, no roundingIt first divides the delivery-month index by the bid-month index, truncates to 3 decimals, then multiplies by the coefficient and truncates again
Only the part beyond 4% is adjustedK above 1.04 earns Po × (K − 1.04) · K below 0.96 refunds Po × (0.96 − K) · no adjustment in between
Late delivery through the contractor's faultFor an installment delivered after the contract end month, the system calculates K for both months and uses the lower one · if time was extended for reasons that are not the contractor's fault, change the contract end month to the new month
Claim within 90 daysEnter the final delivery date and the system shows the deadline and the days remaining · with 30 days or less left and not yet billed, it appears in the outstanding items list on the dashboard
⚠ Always check against the contract terms The indices in the sample set are made-up figures, not real indices · each contract may specify different formulas or conditions; follow the contract and the latest announcements of the Comptroller General's Department/Bureau of the Budget before submitting a real claim

9General ledger and financial statements

The Ledger & statements menu is a double-entry accounting system per TFRS for NPAEs (Thai Financial Reporting Standard for Non-Publicly Accountable Entities, revised 2565) — most journal entries post themselves from documents the team already keeps, with no re-entry

Source documentThe system posts
Payable (AP)Dr expense by reference number (PO = materials 5110 · SC = subcontractor 5130 · other 5190) + input VAT / Cr payables — the account can be changed on the first line in the journal
PaymentDr payables / Cr bank deposit + withholding tax payable + retention payable · for services, undue input VAT is transferred to input VAT when payment is made
Billing (AR) · ReceiptDr receivables / Cr construction revenue + undue output VAT · on receipt: Dr bank deposit + tax withheld + retention receivable / Cr receivables
Tax invoice · credit/debit noteTransfers undue output VAT to output VAT (Section 78/1) · adjusts revenue and output VAT by the difference
Paid wagesDr wages + employer social security contribution / Cr bank deposit + social security payable
Equipment registerStraight-line depreciation at every month end · machines bought before the books start date go into the opening balances
  1. Set the books start date

    Tab Chart & close — normally the first day of the accounting year · the opening balances are calculated automatically from the opening cash, documents before that date and the equipment, with the difference going to retained earnings · other opening balances (registered capital, loans) are recorded with a journal voucher

  2. Record items that have no document in the system

    Press + New journal voucher, e.g. interest, office expenses, remitting tax/social security, corporate income tax · it can be posted once debits equal credits; once posted it cannot be edited — if wrong, press ↺ Reverse

  3. Adjust revenue by stage of completion

    Tab Stage of completion: enter the total contract revenue, the estimated total cost and the measurement method (survey of work performed, or cost incurred ÷ total cost), then save at period end (chapter 20)

  4. Check and print the statements

    Trial balance · statement of financial position · income statement · statement of changes in equity, in the chapter 4 format · export the journal as CSV for your bookkeeper

  5. Close the period

    Once closed, vouchers in that period cannot be edited and the system stores every account balance; if someone edits a source document afterwards, a warning appears with the accounts that changed · only an administrator or the account owner can reopen a period, and the system asks for confirmation first, because the balances stored at close will be cleared — when you finish the corrections, close the period again

⚠ Statements from the system are drafts They must be checked by your bookkeeper before filing with the Department of Business Development and the Revenue Department, and a limited company must also have them audited by a certified public accountant · wages are posted only when the status is “Paid” · the “Checks” tab compares the control accounts with the receivables, payables and equipment registers and with output VAT not yet invoiced

10Personal data (PDPA)

The ERP holds personal data of outside parties — workers, contract parties (including national ID numbers and bank accounts), buyers, vendors and subcontractors · your business is the data controller under the Personal Data Protection Act B.E. 2562, while Chang Pile is the processor on your behalf (Terms of Service, clause 7/1) · the Personal data menu helps you carry out the controller's duties

PartUsed for
Record of processing (ROPA)A table under Section 39 built from the data actually held in the ERP, with record counts · press 🖨 to print it and keep it for data subjects and the regulator's inspection · review it against your actual operations before use
Data past its retention periodFormer workers whose last working day was over 2 years ago (Labour Protection Act, Section 114) and individual buyers on tax invoices older than 5 years (Revenue Code, Section 87/3) · press “Anonymise” and the system replaces the name with a pseudonym while the wage and accounting figures stay intact
⚠ A breach must be reported within 72 hours A tax invoice sent to the wrong person, a lost device still signed in, or an account accessed by someone else — report it to the Office of the Personal Data Protection Committee within 72 hours of becoming aware of it (Section 37 (4)) · requests from data subjects (to access, correct or erase) must be answered within 30 days · always log out when sharing a device; the system clears the cached data for you

11Approvals and change log

The Approvals & history menu under Head office is the internal control for document work — the number on the menu is the count of items waiting for your approval · if the menu says it is not switched on yet, tell your administrator

Covers quotations, contracts, purchase orders, invoices, progress-payment claims (not RFIs), plus purchase requests, purchase orders and variations in the modules · Default thresholds: quotation 2,000,000 · contract/invoice/progress claim 1,000,000 · purchase order 200,000 · purchase request/variation 100,000 THB

TabUsed for
Awaiting approvalItems set to “Awaiting approval” · add a comment and press ✓ Approve or Reject (a reason is required; the item goes back to draft for the creator to fix) · if you cannot press it, the system gives the reason under the button
Approval historyWho approved/rejected which step, when, with comments
Change logWho changed what, from which old value to which new value, across documents, projects, BOQ and every module · filter by system area or search · the log cannot be edited or deleted
ExceptionsItems created already in approved status with no approval record — for a manager or auditor to review
Approval rulesThe amounts that require management as step 2, by document type · only an administrator can edit them
⚠ Rules the system enforces The creator cannot approve their own items · amounts reaching the threshold must pass the administrator as step 2, who must be a different person from step 1 · changing the status in the table from “Awaiting approval” to “Approved” runs it through the approval workflow automatically, while jumping to a later status (e.g. Paid) is not possible until approved · applies to staff work — VIP members working alone are not bound by it

12Procurement and inventory

This module has 4 tabs that work one after another like a conveyor belt

Purchase requests (PR) → Purchase orders (PO) → Site receipts & issues → Site material stock

1 · Purchase requests (PR)

Press New purchase request and fill in PR no. · Project/site · Material item · Quantity and unit · Requested by · Required by · Estimated value

The status runs from Draft → Awaiting approval → Approved → PO issued (or Cancelled) · changing it to “Approved” goes through the approval workflow; the requester cannot approve their own request (section 11)

2 · Purchase orders (PO)

For a purchase request that is Approved, press the Issue PO from… button to carry the items straight into a PO, then fill in the vendor name and the Delivery due date

The Goods receipt field has three values — Not received · Partially received · Fully received · once the delivery due date has passed, chase the vendor

3 · Site receipts & issues

Press Log receipt / issue every time goods arrive on site or are issued out, and fill in Date · Type (Received/Issued) · Material · Quantity · PO or issue slip no. · Receiver/requester

4 · Site material stock

On hand = opening balance + received − issued
The received/issued figures are pulled automatically from the Site receipts & issues tab · any material whose balance falls below its reorder point gets a warning label prompting you to raise a purchase request (Below reorder · Running low · Sufficient)

Summary figures at the top

  • PRs awaiting approval · Open purchase orders · Materials below reorder point · Stock value on hand

13Equipment management

4 tabs — Equipment register · Usage log · Maintenance plan · Depreciation

Equipment register

Press Add equipment and fill in Code · Equipment name · Type (Excavator · Pile driver / rig · Truck · Mobile crane · Site tools · Generator) · Current site · Status (In service · Idle · Under maintenance · Held for disposal)

Usage log

Log every day the machine works, filling in Date · Equipment · Hours · Fuel (litres) · Operator · Work done

Accumulated hours = opening hours + logged hours — this figure drives both the maintenance-interval alerts and the depreciation calculation, so log it completely

Maintenance plan

Press Add maintenance plan and fill in the maintenance task (e.g. engine oil change) · Interval (hrs) · Last at (hrs) · Last service date

Due at = hours at last service + maintenance interval
The system compares this with the actual accumulated hours and shows a Due soon label when 10% or less of the interval is left, and Overdue once the interval has passed

Depreciation

Fill in Purchase cost · Purchase date · Useful life (years) · Salvage value, and the system does the calculation

Straight-line basis: annual depreciation = (purchase cost − salvage value) ÷ useful life
Accumulated depreciation follows the actual holding period from the purchase date and never exceeds the depreciable amount · the remainder is the Book value

14Workforce and wages

3 tabs — Workers & subcontractors · Timesheets & wages · Subcontracts

Worker register

Press Add worker and fill in Full name · Position (Foreman · Steel fixer · Mason · Formwork carpenter · Electrician · Plumber · Equipment operator · General labourer) · Affiliation · Site · Wage/day · OT/hr · Status (Active · On leave · Left)

⚠ The “Affiliation” field matters more than you think It separates the company's own workers from a subcontractor's crew — you must type the subcontractor name exactly as it appears in the Subcontracts tab for the system to count the crews correctly

Timesheets & wages

Press Log timesheet and choose Period date · Worker · Days · OT hrs

Gross pay = (days worked × daily wage) + (OT hours × OT rate per hour)
Net pay = gross pay − employee social security contribution
The wage rates are pulled automatically from the worker register · the status runs from Pending review → Awaiting payment approval → Paid

Social security and statutory overtime

  • Social security, Section 33 — tick the SSO box in the worker register only for people the company employs directly (subcontractor crews have contributions deducted by their subcontractor). The system deducts 5% of wages, accumulating per person per month so the ceiling is not exceeded · the rate and wage ceiling (default 17,500 THB/month) can be changed at the bottom of the timesheet tab when the Social Security Office announces a new rate · the employer contributes the same amount and remits it with form SPS 1-10 by the 15th of the following month
  • Overtime — Labour Protection Act Section 61 requires OT on working days of at least 1.5 times the hourly wage (daily wage ÷ 8) · an OT/hr value below the minimum turns red, with a warning bar stating each person's minimum rate

Subcontracts

Press Add subcontract and fill in Contract no. · Subcontractor name · Scope of subcontracted work · Contract value · Claimed · Retention (%) · Status (Draft contract · In progress · Nearing completion · Completed · Suspended)

Remaining = contract value − claimed · the retention figure is calculated from the amount already claimed and held back until the contractual warranty period ends

15Site control

Brings together in one menu the work that site supervisors and project engineers do every day; the number on the menu is the count of open NCRs

TabUsed forReference
Site diaryDate · weather · manpower · work done · problems · recorded by · sent to the supervisor for endorsement — “heavy rain, work stopped” days serve as evidence for requesting a time extension or waiver of penaltiesThe “waiver or reduction of penalties” clause of the standard form (notify within 15 days)
Variation orders (VO)Additions/omissions, value, extension days and the instruction letter number · the Revised contract value table combines the contracts in document work with approved VOs and warns when the change exceeds ±10%The “extra work and changes” clause · FIDIC clause 13
Quality (IR / NCR)Request an inspection before covering up work that will no longer be visible, e.g. rebar before the concrete pour · if it fails, change it to an NCR, set a correction date, then close it when the re-inspection passes · overdue items get a red label and go into the outstanding items on the dashboardISO 9001 clauses 8.6–8.7
SafetyToolbox Talk · safety inspection · near miss · first aid · lost-time injury (LTI) · property damage, with corrective actions · a card counting days without lost-time injury, and LTIFR calculated from the working hours in the site diaryMinisterial Regulation on construction work safety B.E. 2564 · ISO 45001
💡 What is LTIFR? The lost-time injury rate per 1 million working hours = number of lost-time injuries × 1,000,000 ÷ accumulated working hours — use it to compare safety statistics between projects or with other companies; the more completely manpower is recorded in the site diary, the more accurate the figure

16Reading the dashboard

Section shownHow to read it
Cash in this month / Cash out this monthMoney actually going in and out of the cash and bank deposit accounts this month, pulled from the same journal as the Ledger & statements menu (receipts from receivables, payments to payables, wage payments and journal vouchers), excluding brought-forward balances and transfers between cash and bank · compared as a percentage with the previous month; green means the good direction
4 finance cardsReceivables · Payables · Cash on hand · Net VAT this month — click a card to go to that tab in the Finance, accounting & tax menu
Results this yearNet profit (loss) from 1 Jan (or the books start date) to today, with revenue, construction cost, gross profit, margin and other expenses — the same figures as the income statement · the last row tells you whether revenue has been adjusted by stage of completion; if not, revenue equals the billed amount
Tax and filing deadlines this monthThis month's accumulated amounts to be filed next month, with due dates and days remaining: net VAT PP.30 (the 15th · the 23rd online) · withholding tax PND.3/53 and the number of 50 Tawi certificates (the 7th) · social security contributions (the 15th) · cash received but no tax invoice issued yet (must be 0) · K increases nearing the 90-day limit
Internal controlItems waiting for your approval (and all items awaiting approval) · draft journal vouchers · period-close status — red means a document was edited retroactively after the period was closed · personal data past its retention period that must be anonymised
Site, quality and safetyThe big number is the count of working days without a lost-time injury, with LTIFR · open NCRs (and those overdue for correction) · variations awaiting approval and the net approved amount · open safety items and near misses · the latest site diary
4 site cardsPRs awaiting approval · Materials below reorder point · Maintenance due · Wages payable
Remaining work valueWork in hand not yet delivered — an indicator of how long the company's workload will last
Documents pendingThe number of outstanding documents, and how many of them are overdue
Cash flow — actual receipts and paymentsMonthly chart of cash in and cash out from the journal, with a net cash line (cash in − cash out) · choose the year and a 3 / 6 / 12-month range · the figures always match the finance cards below
Document statusThe share of documents in each status, showing where the bottleneck is
Project progressProgress bars for every project in progress
Site cost by projectSeparates materials from labour/subcontract, compared with the budget
Outstanding itemsEverything outstanding across the system in one place; click a row to jump straight to that item
Project overviewOne row per project — progress, budget, actual site cost, billing and collection, and outstanding debts on both sides · click a row to open the project page
Recent documentsThe most recently created or edited documents; click to open one straight away
CPI / SPI (under the progress bar)Earned value indices (Earned Value per the PMI standard) · CPI = earned value ÷ actual cost; below 1.00 means spending more than the work achieved · SPI = earned value ÷ planned value; below 1.00 means behind schedule · green ≥ 1.00 · orange 0.90–0.99 · red < 0.90 · hover to see PV, EV, AC and the estimate at completion (EAC)
💡 Start the working day with one card If you only have 5 minutes a day, the Outstanding items and Tax and filing deadlines this month cards are enough · every row in these cards can be clicked to go straight to the related tab · the first card already gathers PRs awaiting approval, POs past their delivery date, materials below reorder point, machines due for maintenance, wages payable, open subcontracts, variations awaiting approval, NCRs overdue for correction, open safety items, overdue billings and payables, K increases nearing the claim deadline, and overdue documents

17Daily, weekly and monthly routines

CycleWhat to do
Every day Write the site diary · log material receipts and issues on site · log equipment hours · clear the outstanding items card on the dashboard · approve items in the Approvals & history queue
Every week Approve pending purchase requests · chase goods from POs past their delivery date · log timesheets and approve wages · close NCRs that have been corrected · update project progress · issue tax invoices for billings that have been paid
Every month end Check the stock against what is physically there · check machines due for maintenance · close the AP/AR balances · print the 50 Tawi certificates and remit PND.3/53 by the 7th (the 15th online) · remit social security by the 15th · print the output VAT report and review the PP.30 summary · enter the month's K indices · review the BOQ for categories over budget
Accounting period close Record pending vouchers (interest, accrued expenses) · record the stage-of-completion adjustment · make sure the checks tab is all green · print the trial balance and financial statements for your bookkeeper · press 🔒 Close
Every work phase Issue a progress-payment claim once the phase is fully delivered · bill from the table of phases not yet billed · track the retention held back · for price-adjustable contracts, calculate the K for the installment
Every year Review data past its retention period in the Personal data menu · print and keep the current ROPA record · check that the approval amount rules match your company's approval authority

18Frequently asked questions

I added a project and it disappeared, with the message “Not saved”

The database did not accept that project, and the message already gives the reason — Duplicate project code: change the code in the Code field on the card and save again (see Project code) · The account does not have permission yet: you must be a VIP member who has paid and been approved; if you have been approved, tell the administrator · The database replied …: try again; if it still does not save, send that message to the administrator · if you saw the old message “The database does not accept projects yet… run supabase/vip-projects.sql”, press Ctrl + F5 (Mac: Cmd + Shift + R) and add the project again — this was fixed on 30 September 2569

Why does my project code have characters at the end, e.g. PRJ-001-7F3A?

It is the short code of your VIP member account — project codes must be unique across the whole system, but you only see your own projects. Without the suffix, every account would get PRJ-001 and they would clash · projects created earlier keep their codes, and you can edit codes yourself as you wish

After signing in, it says this account is in use on another device

The system allows one account on one device at a time · if it really is still open on another device, go and press Log out on that device first, then come back and sign in again · if it is your own previous device where you closed the browser without logging out, just press the Log out the other device and use this one button below the warning, with no need to wait · the message also tells you what kind of device is still signed in (e.g. Windows · Chrome) so you can be sure it is your own

I was logged out by myself in the middle of working

It means someone signed in to the same account from another device and confirmed taking over the session · if it was not you, change your password immediately at Member page → User profile and tell our team, because it means someone else knows your password · every takeover is logged, and the administrator can review it afterwards

A blue bar asks me to press “Move to the shared table” — should I?

Yes — data in the various modules previously kept separately in your account is moved into the shared table so the whole team sees the same set; records that duplicate existing ones are skipped, and the original data is kept as a backup · if several people in the team hold the same data, the person with the master set should press it first · press “Don't move” if the data in your account is the sample set

I cannot change the status to “Approved”

Items you created yourself must be approved by someone else · amounts reaching the threshold need the administrator's approval as step 2 · later statuses (e.g. Paid) must wait for approval first — see the reason under the button in the Awaiting approval tab of the Approvals & history menu

A tax invoice was issued wrongly — how do I fix it?

An issued invoice cannot be edited or deleted under the Revenue Code · if the details are wrong, change the status to Cancelled and issue a new one · if the value changes later, issue a credit note or debit note referring to the original invoice

Someone edited documents retroactively after the period was closed

The system stores every account balance at the time of closing. If a source document in a closed period is edited, the Ledger & statements page shows a red warning bar, and the Chart & close tab lists the accounts whose balances changed, with the amount at close and the amount now — check who made the edit in the change log, then reverse it or record an adjustment in the current period

Receivables in the general ledger do not match the receivables register

This is usually caused by credit/debit notes not yet reflected in the billing, or by balances brought forward from before the books start date · tab Chart & close → Checks shows the figures on both sides for comparison

I cannot add data, and a bar says I am viewing the sample

You need a lifetime VIP, staff or administrator account in approved status · check your account status on the Member page

Issued documents still show the sample data in the header

The company profile has not been filled in yet · click the profile picture in the bottom-left corner → Edit user information and enter the company name, address and tax ID, and attach the logo (1.5 MB or less recommended)

The material stock does not match what is actually on site

The balance is calculated only from opening balance + received − issued. If it does not match, it is usually because some goods received or issued have not been logged in the Site receipts & issues tab · log the missing entries retroactively, or adjust the opening balance to match the actual stock count and start counting again from that date

The system does not count my subcontractor crews

The name in a worker's Affiliation field must be spelled exactly, character for character, like the Subcontractor name in the Subcontracts tab. If it is typed differently, even by a single space, the system counts it as a different firm

A machine shows the overdue-maintenance label even though it was just serviced

After servicing, you must also go back and update the Last at (hrs) and Last service date fields in the maintenance plan; only then does the system move the next interval forward

What is the difference between ERP Studio and CPM Planner?

ERP Studio handles money and materials — documents, costs, materials, equipment, wages, tax and accounting

CPM Planner handles time — activities, relationships, the critical path and progress reports

One project can use both systems side by side; give the project the same name in both for easy reference

Can several people work at the same time?

Yes. The whole team works on one data set and the screen updates by itself when someone else edits · the modules save record by record, so two people can edit different records at the same time without overwriting each other · if the same record is edited at the same time, the value saved last wins, and you can look back at it in the change log

I deleted an item by mistake — can it be restored?

The system has no recycle bin for one-click restore · that is why every delete button always asks for confirmation first · but the previous values of a deleted item are still in Approvals & history → tab Change log, which you can use to key it back in · issued tax invoices and posted vouchers cannot be deleted in the first place

A cookie notice bar appears at the bottom of the screen — what should I press?

Choose whichever suits you — Accept all, Reject all or Cookie settings to choose category by category · the program still works fully if you reject, because sign-in, language and the data the program needs to work are in the Necessary category, which is always on · your choice applies to every page on that device for 12 months; change your mind at any time with the Cookie settings link at the end of this manual or at the bottom of the home page · details are in the Privacy Policy, section 6

19Glossary of system terms

TermFull nameShort meaning
Project codeProject codeA code that must be unique across the whole system · staff PRJ-005 · VIP member PRJ-001-7F3A (suffixed with the account short code)
BOQBill of QuantitiesA list of work quantities and prices, by work category
PRPurchase RequestA purchase request from the site, not yet committed to a vendor
POPurchase OrderA purchase order formally issued to a vendor
APAccounts PayablePayables — money the company has to pay out
ARAccounts ReceivableReceivables — money clients have to pay the company
VATValue Added TaxRate 7% · output VAT less input VAT is the amount to remit
PP.30VAT returnFiled monthly = output VAT − input VAT
PND.3 / PND.53Withholding tax returnsPND.3 for payments to individuals · PND.53 for payments to juristic persons · remit by the 7th of the following month
50 TawiWithholding tax certificateThe document a payer must issue to the person whose tax was withheld
Full tax invoiceRevenue Code, Section 86/4For services, issued when payment is received · once issued it cannot be edited or deleted
Credit note / debit noteCredit note / Debit noteAdjusts the value of an original tax invoice when the value decreases or increases
K valueEscalation factorAdjusts the work price by price indices; only the part beyond ±4% is adjusted
VOVariation OrderAdditions/omissions to the original contract, with value and extension days
IR / NCRInspection Request / Non-Conformance ReportRequest to inspect work before covering it up · report of non-conforming work with a correction deadline
LTIFRLost Time Injury Frequency RateLost-time injuries per 1 million working hours
CPI / SPICost / Schedule Performance IndexCost and time indices from earned value; below 1.00 means over budget/behind schedule
Journal / journal voucherJournal / Journal voucher (JV)Double-entry accounting entries · vouchers are for items with no document in the system
Trial balanceTrial balanceThe balances of all accounts; debits must equal credits
Stage of completionPercentage of completionRecognising revenue according to the work actually completed (TFRS for NPAEs chapter 20)
Period closePeriod closeLocks the accounting entries of a finished period against editing
ROPARecord of Processing ActivitiesThe record of personal data processing activities under PDPA Section 39
Withholding taxWithholding TaxTax the payer deducts before paying
RetentionRetentionMoney held back from claimed amounts until the warranty period ends
Work phaseInstalment / Milestone paymentSplitting the contract value into installments according to progress
Reorder pointReorder pointThe stock level below which a purchase request must be raised
Straight-line depreciationStraight-line depreciation(Purchase cost − salvage value) ÷ useful life
Book valueBook valuePurchase cost less accumulated depreciation

+Other manuals in this series

© 2569 Chang Pile Co., Ltd. — CHANG PILE CO., LTD. All rights reserved.