Best BIR Excel Uploader Alternative for Real Estate Lessors With Multiple Tenants

For a real estate lessor receiving BIR Form 2307 certificates from many tenants, the best BIR Excel Uploader alternative is one that checks each SAWT row against the certificate it’s supposed to represent, not just the DAT file’s formatting. A commercial landlord with a dozen units, or a residential lessor renting to several business tenants, can end up reconciling ten, twenty, or more separate 2307 certificates every quarter — each from a different tenant withholding at a different pace. A basic Excel-to-DAT converter turns a spreadsheet into a valid file; it doesn’t tell you whether that spreadsheet still matches the paperwork sitting in a folder on your desk.

This guide covers why lessors accumulate so many certificates to reconcile, what a generic converter leaves out for a multi-tenant landlord specifically, and how the SAWT module in BIR Online Tools is positioned to close that gap.

Why do lessors end up with so many 2307 certificates to reconcile? #

Every business tenant that pays rent above the withholding threshold is legally required to withhold tax and issue its own BIR Form 2307 to the landlord — so a lessor with multiple tenants doesn’t get one certificate per quarter, they get one per tenant, each on its own schedule and sometimes with its own formatting quirks.

Under Revenue Regulations (RR) No. 11-2018, which amended Section 2.57.2 of RR No. 2-98, a business tenant leasing real property must withhold 5% expanded withholding tax (EWT) on the gross rental it pays, once the accumulated rental paid to the same lessor exceeds or is reasonably expected to exceed ₱10,000 within the year. Each tenant that withholds is required to issue the landlord a BIR Form 2307 documenting the amount withheld. A lessor leasing to ten commercial tenants can therefore receive up to ten separate certificates in a single quarter — from ten different accounting departments, each with its own timing and its own habits for filling out the form.

What does RR No. 11-2018 actually say about the rate? #

The regulation sets the rental withholding rate at five percent (5%) on gross rental for real property used in business, once the accumulated payment to the same lessor crosses the annual threshold:

“[T]he accumulated gross rental or lease paid by the lessee to the same lessor exceeds or is reasonably expected to exceed ₱10,000 within the year, in which case the lessee shall withhold the five percent (5%) withholding tax on the rental payments.” — RR No. 11-2018, amending Section 2.57.2 of RR No. 2-98, as summarized in tax alerts covering the regulation

That 5% is withheld by the tenant, not paid separately by the landlord — it reduces the rent actually remitted, and the certificate is the landlord’s proof that the amount was in fact withheld and will eventually be remitted to the BIR by the tenant.

Why can’t the landlord just claim the 2307 amounts directly? #

A creditable withholding tax certificate isn’t automatically applied to a lessor’s income tax due — it has to be summarized and attached to the return through SAWT, the Summary Alphalist of Withholding Tax at Source, required under RR No. 2-2006 whenever a taxpayer claims creditable withholding tax as a tax credit. Each 2307 certificate the lessor received during the period becomes one row in that SAWT file: the tenant’s TIN, the ATC used, the income amount, and the tax withheld. If a row doesn’t match the certificate behind it — wrong ATC, a rounding difference, a certificate left out entirely — the credit that row represents is at risk of being questioned or disallowed later.

Where does a generic BIR Excel Uploader fall short for a multi-tenant lessor? #

A generic converter turns a completed spreadsheet into a properly formatted DAT file, but it has no way to know whether the numbers typed into that spreadsheet actually match the certificates a lessor is holding in hand.

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

• No check that the ATC entered for a tenant’s row matches the ATC printed on that tenant’s actual Form 2307
• No check that the rental amount and tax withheld tie back to the certificate received, as opposed to what a rent roll or lease schedule assumes should have been withheld
• No flag when a tenant’s certificate for the period is missing from the spreadsheet entirely — easy to miss when certificates arrive on ten different schedules
• No shared record connecting a lessor’s own tenant-by-tenant rent roll to the certificates actually received, so the reconciliation happens manually, tenant by tenant, every quarter

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

A certificate-aware alternative validates ATC codes against the row entered, keeps a lessor’s Form 2307 certificates and SAWT entries inside the same account instead of two separate files, and carries each quarter’s data forward instead of starting from a blank template every filing period.

A worked example #

A commercial landlord leases eight units to eight VAT-registered business tenants. In Q3, six tenants withhold and issue a BIR Form 2307 for ₱50,000 monthly rent each at the standard 5% EWT rate — ₱2,500 withheld per tenant per month, or ₱7,500 for the quarter per tenant. A seventh tenant, mid-negotiation on a rent adjustment, withholds on ₱45,000 instead of ₱50,000 for one month without telling the landlord’s accounting team. An eighth tenant simply forgets to send its certificate before the SAWT is due.

Built from a rent roll instead of the certificates themselves, the SAWT would show ₱7,500 withheld for all eight tenants — overstating the seventh tenant’s credit and including a credit for the eighth tenant that has no certificate behind it yet. Built against the certificates actually received, the mismatch on the seventh tenant’s row and the missing eighth certificate are both visible before the file is generated, not after the return is filed and the shortfall surfaces on review.

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

A basic BIR Excel Uploader may be enough if you:

• Lease to one or two tenants and can manually check each certificate against the SAWT by hand
• Only need the file to pass the BIR’s structural DAT validation, not a certificate-level reconciliation
• File SAWT infrequently, with little risk of a certificate arriving late or going missing

A certificate-aware alternative fits better if you:

• Lease to multiple tenants who each withhold and issue their own BIR Form 2307 on their own schedule
• Want ATC and amount mismatches caught before the SAWT is generated, not after
• Prefer certificates and SAWT entries kept in one place instead of cross-checking a folder of PDFs against a spreadsheet by hand

Frequently asked questions #

Why does a lessor with multiple tenants get so many BIR Form 2307 certificates? #

Each business tenant that withholds tax on rent paid is separately required to issue the landlord a BIR Form 2307 for the amount it withheld, so a lessor’s certificate count scales with its number of withholding tenants, not with the number of properties owned.

What withholding tax rate applies to rental income under RR No. 11-2018? #

RR No. 11-2018, amending Section 2.57.2 of RR No. 2-98, sets the rate at 5% expanded withholding tax on gross rental for real property used in business, once the accumulated rental paid by the tenant to the same lessor exceeds or is reasonably expected to exceed ₱10,000 within the year.

Why doesn’t a clean SAWT DAT conversion guarantee an accurate CWT credit? #

A DAT file can pass the BIR’s structural validation while still listing an ATC, rental amount, or tax-withheld figure that doesn’t match the Form 2307 certificate it represents — structural validity and certificate accuracy are different checks, and a basic converter typically only performs the first.

Does BIR Online Tools check SAWT entries against a lessor’s actual 2307 certificates? #

The SAWT module in BIR Online Tools validates TIN format, required fields, and ATC codes during upload, and because it sits alongside the platform’s Form 2307 generator, certificates issued or received through the same account are available for side-by-side reconciliation rather than kept in a separate file.

Is SAWT required even if a lessor only has one or two tenants? #

Yes — RR No. 2-2006 requires SAWT whenever creditable withholding tax is claimed as a credit, regardless of how many certificates support it. The reconciliation burden scales with tenant count, but the filing requirement itself doesn’t depend on it.

Summary #

A generic BIR Excel Uploader converts a completed spreadsheet into a valid DAT file, but for a lessor juggling certificates from multiple tenants, the harder part isn’t the conversion — it’s making sure every SAWT row still matches the Form 2307 sitting in the folder it came from. See SAWT for Real Estate Lessors: Claiming Creditable Withholding Tax on Rental Income for the full filing walkthrough, Withholding Tax on Rent: How to Complete BIR Form 2307 for Lessors for how the certificate itself is completed, and Best BIR Excel Uploader Alternative for SAWT Filing for the broader SAWT comparison.