TEI AFS-i — Accounting & Finance

Working…

Dashboard

Open sales invoices

Open supplier bills

Unreconciled bank lines

Sales Invoices

New Sales Invoice (EOPT: the INVOICE is the primary document for goods AND services)

Customer Date Due date VAT class Remarks

Item	Description	Income account	Qty	Rate	Amount
					{{ php(it.qty*it.rate) }}

Net: {{ php(siNet) }}

VAT 12%: {{ php(siVat) }}

Grand total: {{ php(siNet+siVat) }}

Purchase Invoices (Supplier Bills)

New Purchase Invoice

Supplier Date Due date Supplier invoice no. Supplier invoice date VAT class Input VAT type ATC (EWT) Remarks

Item	Description	Expense account	Qty	Rate	Amount
					{{ php(it.qty*it.rate) }}

Net: {{ php(piNet) }}

Input VAT: {{ php(piVat) }}

EWT withheld: ({{ php(piEwt) }})

Payable: {{ php(piNet+piVat-piEwt) }}

Payments

{{ pe.payment_type==='Receive' ? 'Receive Payment from Customer' : 'Pay Supplier' }}

{{ pe.payment_type==='Receive' ? 'Customer' : 'Supplier' }} Date Mode Bank/Cash account Reference no. Reference date

Allocate against open documents

	Document	Date	Total	Outstanding	Allocate
	{{ r.name }}	{{ r.posting_date }}	{{ php(r.grand_total) }}	{{ php(r.outstanding_amount) }}

Customer withheld CWT (they gave you a BIR 2307)

CWT amount 2307 cert no. Period (e.g. 2026Q3)

Posts Dr 1070 CWT (SAWT-claimable)

EWT was already withheld on the supplier bill (apply_tds) — the payable being settled is net of EWT. Extra deductions (e.g. bank charges) can be added after cutover.

Allocated: {{ php(peAllocated) }}

CWT: {{ php(pe.withCwt?pe.cwtAmount:0) }}

{{ pe.payment_type==='Receive' ? 'Cash in' : 'Cash out' }}: {{ php(peCash) }}

Journal Entries

Type Date Remark

Account	Party type	Party	Debit	Credit

Dr: {{ php(jeDr) }}

Cr: {{ php(jeCr) }}

Banking & Reconciliation

Date Bank account Deposit Withdrawal Reference Description

Line	Date	Description	Ref	Deposit	Withdrawal	Status	Match to voucher
{{ r.name }}	{{ r.date }}	{{ r.description }}	{{ r.reference_number }}	{{ php(r.deposit) }}	{{ php(r.withdrawal) }}	{{ r.status }}

Fixed Assets (finance books)

Asset name Category Store code Purchase date Gross amount Useful life (months) Salvage value

Registers the asset for the books. Physical registry & preventive maintenance remain in the CRMD ERPNext Asset module (framework Section B). Capitalize the purchase itself via a supplier bill to account 1120.

Financial Reports

Account	Root	Debit	Credit	Balance
{{ r.account }}	{{ r.root_type }}	{{ php(r.debit) }}	{{ php(r.credit) }}	{{ php(r.balance) }}
TOTAL		{{ php(sum(rpt.data,'debit')) }}	{{ php(sum(rpt.data,'credit')) }}	{{ php(sum(rpt.data,'balance')) }}

Income

Total Income{{ php(rpt.data.total_income) }}

Expenses

Total Expenses{{ php(rpt.data.total_expenses) }}

NET INCOME{{ php(rpt.data.net_income) }}

{{ sec }}s

Total{{ php(rpt.data.totals[sec]) }}

Current period earnings{{ php(rpt.data.current_earnings) }}

Check (A − L − E − earnings){{ php(rpt.data.check) }}

Document	Party	Date	Due	Total	Outstanding	Days	Bucket
{{ r.name }}	{{ r.party }}	{{ r.posting_date }}	{{ r.due_date }}	{{ php(r.grand_total) }}	{{ php(r.outstanding) }}	{{ r.days }}	{{ r.bucket }}
Nothing outstanding 🎉

BIR Compliance Center

Encoding-ready summaries — file through eBIRForms/eFPS. Books of accounts live in the Google Sheet (BIR_* tabs). {{ boot.company }} · TIN {{ boot.tin }} · RDO {{ boot.rdo }}

Deadline: within 25 days after quarter close. Attach SLSP (both lists). Capital-goods input VAT credited outright (CREATE).

ATC	Income payments	Tax withheld
{{ k }}	{{ php(v.income) }}	{{ php(v.tax) }}
TOTAL DUE (less 0619-E remitted)		{{ php(bir.data.total_tax_withheld) }}

0619-E for months 1–2 of the quarter; 1601-EQ + QAP by the last day of the month after quarter close. Issue 2307s within 20 days of quarter close.

TIN	Registered name	ATC	Nature	Income	Rate	Tax withheld
{{ r.payee_tin }}	{{ r.registered_name }}	{{ r.atc_code }}	{{ r.nature_of_payment }}	{{ php(r.income_payment) }}	{{ (r.ewt_rate*100).toFixed(0) }}%	{{ php(r.tax_withheld) }}

Date	Payor TIN	Registered name	2307 cert	Period	Income	CWT
{{ r.date }}	{{ r.payor_tin }}	{{ r.registered_name }}	{{ r.cert_2307_no }}	{{ r.period }}	{{ php(r.income_payment) }}	{{ php(r.tax_withheld) }}

TIN	Registered name	Address	Exempt	Zero-rated	Vatable	VAT	Gross
{{ r.tin }}	{{ r.registered_name }}	{{ r.address }}	{{ php(r.exempt) }}	{{ php(r.zero_rated) }}	{{ php(r.vatable) }}	{{ php(r.vat) }}	{{ php(r.gross) }}

{{ viewer.doctype }} · {{ viewer.doc.name }}

{{ pretty(viewer.doc) }}

{{ boot.address }}
VAT Reg. TIN: {{ boot.tin }}

SALES INVOICE

No.: {{ printDoc.d.name }}
Date: {{ printDoc.d.posting_date }}

SOLD TO: {{ printDoc.d.customer }} · TIN: {{ printDoc.custTin }}
Address: {{ printDoc.custAddr }} · Business style: {{ printDoc.custStyle }}

Item	Description	Qty	Unit price	Amount
{{ it.item_code }}	{{ it.description }}	{{ it.qty }}	{{ php(it.rate) }}	{{ php(it.amount) }}

VATable sales	{{ printDoc.d.custom_tei_vat_class==='Vatable'\|\|printDoc.d.custom_tei_vat_class==='Government'?php(printDoc.d.net_total):'0.00' }}
VAT-exempt sales	{{ printDoc.d.custom_tei_vat_class==='Exempt'?php(printDoc.d.net_total):'0.00' }}
Zero-rated sales	{{ printDoc.d.custom_tei_vat_class==='Zero-Rated'?php(printDoc.d.net_total):'0.00' }}
12% VAT	{{ php(printDoc.d.total_taxes_and_charges) }}
TOTAL AMOUNT DUE	{{ php(printDoc.d.grand_total) }}

Per RA 11976 (EOPT) this INVOICE is the primary document for the sale of goods and services. This document is system-assisted; ensure your BIR-registered invoice series/Authority to Print or CAS registration covers issuance. Not valid for claim of input tax unless issued through a BIR-registered means.

CERTIFICATE OF CREDITABLE TAX WITHHELD AT SOURCE

BIR Form No. 2307 · Period: {{ printDoc.d.period }}

PAYEE: {{ printDoc.d.payee.name }}
TIN: {{ printDoc.d.payee.tin }}
{{ printDoc.d.payee.address }}
Business style: {{ printDoc.d.payee.business_style }}

PAYOR: {{ printDoc.d.payor.name }}
TIN: {{ printDoc.d.payor.tin }}
{{ printDoc.d.payor.address }}

ATC	Nature of income payment	Amount of income payment	Tax withheld
{{ printDoc.d.atc }}	{{ printDoc.d.nature }} (Ref: {{ printDoc.d.pinv }} / {{ printDoc.d.bill_no }})	{{ php(printDoc.d.income_payment) }}	{{ php(printDoc.d.tax_withheld) }}

Payor / Authorized representative:

______________________________
Signature over printed name

Date signed: ______________

Issue to the payee within 20 days after the close of the taxable quarter, or upon request. Encode in the QAP attached to 1601-EQ.