JUAN PRACTICE KIT
Free templates for Philippine accountants and tax practitioners, from https://juan.tax/resources/
Built 2026-11-16. Each file names its sources; check the page for updates before relying on a rate or date.

E-invoicing readiness check (RMC 98-2026)
  Page: https://juan.tax/resources/e-invoicing-readiness-check/
  - e-invoicing-readiness-check/e-invoicing-readiness-checklist.csv: E-invoicing readiness checklist (CSV)

Bookkeeping fee quote builder
  Page: https://juan.tax/resources/bookkeeping-quote-builder/
  - bookkeeping-quote-builder/bookkeeping-pricing-worksheet.csv: Pricing worksheet with formulas (CSV)

SSS, PhilHealth, Pag-IBIG and withholding tax calculator
  Page: https://juan.tax/resources/payroll-contributions-calculator/
  - payroll-contributions-calculator/contribution-tables-2026.csv: SSS, PhilHealth and Pag-IBIG tables 2026 (CSV)
  - payroll-contributions-calculator/payroll-register-2026.csv: Payroll register with formulas, 20 employees (CSV)

13th-month pay calculator 2026
  Page: https://juan.tax/resources/13th-month-pay-calculator/
  - 13th-month-pay-calculator/13th-month-pay-worksheet-2026.csv: 13th-month pay worksheet for 30 employees (CSV)
  - 13th-month-pay-calculator/de-minimis-benefits-2026.csv: De minimis benefit caps 2026 (CSV)

BIR penalty calculator
  Page: https://juan.tax/resources/bir-penalty-calculator/
  - bir-penalty-calculator/bir-penalty-worksheet.csv: BIR penalty worksheet with formulas (CSV)
  - bir-penalty-calculator/bir-compromise-schedule.csv: Compromise penalty schedule (CSV)

VAT and percentage tax calculator
  Page: https://juan.tax/resources/vat-percentage-tax-calculator/
  - vat-percentage-tax-calculator/vat-percentage-tax-workbook.csv: Quarterly VAT and percentage tax workbook (CSV)

EWT rates and ATC codes, with a calculator
  Page: https://juan.tax/resources/ewt-rates-atc/
  - ewt-rates-atc/ewt-rate-card.csv: EWT rate card (CSV for Excel)
  - ewt-rates-atc/form-2307-tracker.csv: Form 2307 tracker (CSV for Excel)

BIR month-end close checklist
  Page: https://juan.tax/resources/bir-month-end-close-checklist/
  - bir-month-end-close-checklist/bir-month-end-close-checklist.csv: Month-end checklist (CSV for Excel or Sheets)
  - bir-month-end-close-checklist/client-close-summary-template.txt: Client close-summary email template (.txt)

BIR year-end checklist 2026–2027
  Page: https://juan.tax/resources/bir-year-end-checklist/
  - bir-year-end-checklist/bir-year-end-checklist-2026.csv: Year-end checklist 2026–2027 (CSV for Excel or Sheets)

Chart of accounts templates
  Page: https://juan.tax/resources/chart-of-accounts-philippines/
  - chart-of-accounts-philippines/chart-of-accounts-ph-services.csv: Services and agencies (CSV)
  - chart-of-accounts-philippines/chart-of-accounts-ph-trading.csv: Trading, retail and wholesale (CSV)
  - chart-of-accounts-philippines/chart-of-accounts-ph-food.csv: Restaurants and food (CSV)
  - chart-of-accounts-philippines/chart-of-accounts-ph-practice.csv: Professional practice (sole proprietor) (CSV)

Client onboarding kit
  Page: https://juan.tax/resources/client-onboarding-kit/
  - client-onboarding-kit/client-onboarding-documents.csv: Document request list (CSV)
  - client-onboarding-kit/client-information-sheet.csv: Client information sheet (CSV)

Philippine tax glossary
  Page: https://juan.tax/resources/philippine-tax-glossary/
  - philippine-tax-glossary/philippine-tax-glossary.csv: Glossary for staff training (CSV)

Juan Accounting runs books, BIR returns, eFiling and ePayment for every client in one place: https://www.juan.ac/
Questions: help@juan.ac
