Never trust a downloaded spreadsheet blindly. Run a small test case with basic numbers to ensure the math aligns with actual BIR computation guidelines.
Begin by inputting your audited financial figures into the Excel breakdown sheets. Populate (Sales) and Schedule 2 (Cost of Sales) first to establish your basic gross profit margins. Step 2: Itemize Deductions or Apply OSD
: It avoids mathematical disparities between complex schedules (e.g., NOLCO or Itemized Deductions) and the main summary sheets.
BIR Form 1702-RT (version January 2018 ENCS) is the Annual Income Tax Return used by corporations, partnerships, and other non-individual taxpayers that are subject to the . Key characteristics include: bir form 1702 rt version 2018 excel format
This is the summary sheet where the final numbers converge. It calculates your Net Taxable Income, applies the applicable corporate tax rate, deducts creditable withholding taxes (Form 2307), and arrives at the . Detailed Schedules
The BIR provide a direct “.xlsx” file for download on its main website (bir.gov.ph). However, they provide the PDF version and the eBIRForms Offline package that contains an underlying XML schema.
"I think the macros aren't calculating the Gross Income correctly, Mang Pedro," Arthur said, his fingers flying over the keyboard. "The formula in cell F45 is supposed to pull from Schedule 1, but it's showing zero." Never trust a downloaded spreadsheet blindly
Enter all tax credits, including quarters 1 through 3 payments and creditable withholding taxes.
Official BIR Excel files are generally used for Summary Lists of Sales/Purchases (SLSP) or eFPS uploads . Third-party platforms like JuanTax often provide tools that handle the Excel-to-XML conversion for you.
Arthur continued his review. The beauty of the Excel format was in the auto-calculation, but the danger was in the override. One wrong keystroke in a protected cell, and the whole sheet could corrupt. He checked the financial statements against the Excel file. Populate (Sales) and Schedule 2 (Cost of Sales)
Excel spreadsheets can be easily shared among accounting staff, external auditors, and management for review, comment, and sign-off before official submission. Key Sections of BIR Form 1702-RT Version 2018
Includes TIN, RDO Code, Registered Name, Address, and Date of Incorporation.
"Payment?" she asked.
Tax laws are dynamic. Ensure your Excel templates are regularly updated to reflect modifications in corporate tax rates, minimum corporate income tax (MCIT) rules, or changes in deduction parameters.
A general professional partnership (GPP) or taxable partnership. An estate or trust engaged in trade or business.