BIR reports for a Kumon center, without the spreadsheet panic
1701Q every quarter. 1601-C every month if you have staff. 2550Q every quarter if you’re VAT-registered. Kumon Ops keeps the numbers ready so you copy them onto eBIRForms, file, and move on.
Every form, numbers ready to copy.
Pick your tax status once (8% flat above the ₱250k exemption, OR graduated brackets on net of expenses, OR VAT-registered which forces graduated). The Taxes page shows quarter-by-quarter taxable income, tax due, prior payments, and the net amount to remit. Numbers tie back to actual invoices + payments, so the audit trail is real.
Output VAT from invoices issued in the quarter (accrual basis, matching what BIR expects). Input VAT from expenses with vat_amount tagged. Payable = output − input. A negative payable means you have a carry-over input VAT credit; the report shows that clearly.
Sum of bir_withholding across all payslips for the month, broken down by employee. Use this when filing your monthly withholding return. Late-filing flag if you haven't ticked 'filed' on the previous month.
Settings → Tax lets you toggle between 8% flat, graduated, or VAT-registered. Switching mid-year recomputes historical quarters under the new regime so you can compare. The toggle is also surfaced as a warning on the dashboard when your trailing 12-month gross hits 80% of the ₱3M VAT threshold.
Kumon HQ royalty is tracked as a separate expense category, configurable rate. The 1701Q report shows gross revenue minus royalty minus other expenses = taxable income. Royalty doesn't quietly disappear into 'misc'.
When you file a quarter, log it: form, period, gross / taxable / tax due, status (filed / paid), reference number. The taxes log lives forever - when BIR asks for proof in two years, you have it.
What it doesn’t do (yet)
- eBIRForms direct submission. BIR doesn’t have a public API. You still log into eBIRForms / eFPS and type the numbers. We make sure the numbers are right.
- 2551Q percentage tax for non-VAT graduated is supported but with the 1% post-CREATE rate hard-coded. If BIR flips the rate again, update the setting and historical quarters recompute.
- BIR-compliant Official Receipts. Print receipts are casual right now. Sequential numbering + Authority to Print integration is on the roadmap for centers that actually undergo a BIR audit.
Tax season without dread
Try the trial. The demo data includes a full quarter of invoices + expenses so the 1701Q numbers show realistically.