↓Skip to main content

Best BIR Excel Uploader Alternative for Cooperatives Filing RELIEF, SAWT, and QAP

A BIR Excel Uploader converts a filled spreadsheet into a Bureau of Internal Revenue (BIR)-compliant DAT file, but a cooperative’s RA 9520 income tax exemption creates a specific risk with that kind of tool: treasurers and finance officers sometimes assume the exemption means no DAT filing at all, when RELIEF, SAWT, and QAP each turn on VAT registration and withholding-agent activity — facts the income tax exemption never touches. A generic converter doesn’t flag that assumption; it simply converts whatever the cooperative hands it.

File Your Cooperative's RELIEF, SAWT, or QAP FREE →

This guide covers why a CDA-certified cooperative still owes these filings despite its exemption, what makes the compliance load harder for a cooperative’s typical finance structure, and how a certificate-aware alternative like BIR Online Tools is positioned to help.

Why does a tax-exempt cooperative still have DAT filing obligations? #

A cooperative’s RA 9520 exemption covers its own exempt income; it does not cover RELIEF, SAWT, or QAP, because each of those three filings is triggered by a fact separate from income tax status. This is already established on this site in general terms in BMBE and Cooperative Income Tax Exemption: Still Must File RELIEF, SAWT, or QAP? — RELIEF attaches to VAT registration, SAWT attaches to a payee’s own CWT-credit claim, and QAP attaches to withholding-agent activity.

Commentary summarizing the Joint Rules implementing Articles 60, 61, and 144 of RA 9520 states the withholding-agent point directly:

“All cooperatives, regardless of classification, are considered withholding agents on all income payments subject to withholding pursuant to Revenue Regulations No. 2-98, as amended.”

Source: commentary summarizing the Joint Rules implementing RA 9520, as quoted in this site’s coverage of BMBE and cooperative filing obligations. That means a cooperative paying a contractor to repair a warehouse, a supplier delivering farm inputs, or an external auditor reviewing its books withholds expanded withholding tax and issues BIR Form 2307 exactly as any taxable business would — and that activity feeds QAP the same way.

What makes this harder for a cooperative’s finance team specifically? #

A cooperative often spreads withholdable transactions across several branches, chapters, or lending/marketing windows, while the people responsible for BIR compliance are frequently board-elected officers or a small bookkeeping staff, not a dedicated commercial finance department. A multi-purpose cooperative might run a consumer store, a lending window, and an agricultural marketing arm under one CDA registration, each generating its own supplier and contractor payments that all roll up into the same cooperative-wide 1604-E alphalist.

Pressures specific to this setting:

  • Officer turnover tied to election cycles, not hiring decisions — a treasurer elected for a term may hand off mid-filing-year to a successor with no background in ATC codes or DAT formatting.
  • Multiple operating windows, one CDA registration — a lending window’s service-fee payments and a marketing arm’s input-supplier payments both feed the same cooperative’s QAP and 1604-E, even if the windows otherwise operate separately.
  • A standing assumption that “we’re exempt” extends further than it does, since the cooperative’s own members and leadership are used to the exemption applying broadly to the cooperative’s operations.
  • Infrequent large payments — an annual external audit fee or a one-time facility repair — that are easy to miss in a quarter’s filing when they don’t arrive on a predictable schedule.

Where does a generic BIR Excel Uploader fall short here? #

A plain converter turns a completed spreadsheet into a valid DAT file without asking whether the filer understood the underlying obligation correctly in the first place — it has no way to catch a treasurer who left a payment off the spreadsheet because “the coop is tax-exempt.”

Gaps common to a plain Excel-to-DAT converter, from a cooperative’s perspective:

  • No guidance distinguishing the cooperative’s own income tax exemption from its separate withholding-agent duty
  • No shared record linking certificates issued across a cooperative’s different operating windows under one CDA registration
  • No carryover of filing history across officer turnover tied to election cycles rather than hiring
  • No link between a BIR Form 2307 already issued and that same payee’s entry on the annual 1604-E alphalist

How does a certificate-aware alternative handle this differently? #

Typical BIR Excel UploaderCertificate-aware alternative (BIR Online Tools)
Distinguishing exemption from withholding dutyNot addressed — filer must already understand the distinctionCertificate generator proceeds from the payment itself, independent of the cooperative’s own tax status
Multiple operating windows, one registrationOne flat spreadsheet, no window-level groupingPayee and certificate records sit in one account, filterable by payee
Officer turnover across election cyclesFiling history lives with whoever built the last spreadsheetPrior certificates and filings stay on the account regardless of who’s logged in
Link between 2307 issuance and 1604-E alphalistTwo unrelated files to reconcile by handSame account used for certificate generation and alphalist/DAT history

Worked example: a multi-purpose cooperative’s Q3 payments #

A fictional multi-purpose cooperative, Kaagapay Multi-Purpose Cooperative (TIN 234-567-890-000), pays a feed supplier for its agricultural marketing window and engages an independent accounting firm for its annual external audit, both within the same quarter — despite being fully exempt from income tax under RA 9520 on its own operations.

PaymentPayee typeRateATC codeAmount withheldBIR Form 2307 required?
Feed and input supplies, ₱180,000Corporate goods supplier1%WC160₱1,800.00Yes
External audit fee, ₱60,000Accounting firm10% (cumulative gross income from coop exceeds ₱3M)WC010₱6,000.00Yes

Both certificates feed Kaagapay’s Q3 QAP and, at year-end, its 1604-E alphalist — neither payment is affected by Kaagapay’s own RA 9520 exemption, because the cooperative is the withholding agent, not the income earner, in both transactions.

Which should a cooperative use — a basic uploader or a certificate-aware alternative? #

A basic BIR Excel Uploader may be enough if you:

  • Have one stable bookkeeper, not an elected officer, handling BIR filings year over year
  • Run a single operating window with few, predictable withholdable payments
  • Only need the DAT file to pass structural validation, with no certificate-level reconciliation needed

A certificate-aware alternative fits better if you:

  • Run multiple operating windows (store, lending, marketing) under one CDA registration
  • Rely on elected officers who rotate on an election cycle, not a hiring cycle
  • Want BIR Form 2307 certificates, QAP filings, and the 1604-E alphalist tied to one organizational account instead of separate files to reconcile by hand each election cycle

Frequently asked questions #

Does a cooperative’s RA 9520 tax exemption remove its RELIEF, SAWT, or QAP filing obligations? #

No. A CDA-certified cooperative’s income tax exemption under Republic Act No. 9520 protects its own exempt income from tax. It does not touch RELIEF SLSP (triggered by VAT registration), SAWT (triggered by claiming a creditable withholding tax credit as a payee), or QAP (triggered by withholding-agent activity when the cooperative pays suppliers, contractors, or professionals) — each of those turns on a different fact the income tax exemption doesn’t reach.

Is a cooperative considered a withholding agent even though it’s tax-exempt? #

Yes. Commentary on the Joint Rules implementing RA 9520 states that all cooperatives, regardless of classification, are considered withholding agents on income payments subject to withholding under Revenue Regulations No. 2-98, as amended. A cooperative’s own exemption runs to income it receives, not to its duty to withhold on income it pays out.

Why is this harder for a cooperative than for an ordinary business? #

A cooperative’s structure often spreads withholdable payments across multiple branches, chapters, or lending windows that each generate their own contractor, supplier, and professional-fee transactions, while the finance team handling BIR compliance is frequently smaller and less specialized than a comparable commercial entity’s, with board-elected treasurers and officers rotating more often than hired finance staff would.

What rate applies when a cooperative pays its external auditor? #

A cooperative paying an individual auditor or accounting firm for professional services withholds under the professional/talent-fee bracket: 5% if the payee’s cumulative gross income from the cooperative for the year is ₱3,000,000 or less, and 10% above that threshold, under Revenue Regulations No. 11-2018 — the cooperative’s own RA 9520 exemption has no bearing on this rate.

Summary #

A cooperative’s RA 9520 exemption is real but narrow: it covers the cooperative’s own income, not its RELIEF, SAWT, and QAP obligations, which turn on VAT registration and withholding-agent activity instead. What makes compliance harder for a cooperative specifically is its structure — multiple operating windows under one CDA registration, and officers who rotate with election cycles rather than hiring decisions. See BMBE and Cooperative Income Tax Exemption: Still Must File RELIEF, SAWT, or QAP? for the underlying rule, and BIR Excel Uploader Alternative: Why BIR Online Tools Covers More of Your BIR Workflow for the broader platform comparison.