M.I.G T'ax and Bookkeeping Services

08/05/2026

08/05/2026

Please check our excel macro enable accounting workbook ( auto generated reports with new feature 1701q , 1701MS, 2551q and 2550q computation)
We also had this accounting workbook for small corporation

01/05/2026

Our BIR bagde.
(100% legit and BIR registered tax and bookkeeping services)

20/04/2026

📊 What My Excel + VBA Accounting Workbook Can Do.

Designed for business owners with no accounting background, this automated workbook simplifies your entire accounting process:
✅ 1. Easy Transaction Recording
Input daily transactions in a simple format
No need to know debits/credits—the system handles it
✅ 2. Automatic Journal Entries
Generates:
General Journal (GJ)
Sales Journal (SJ)
Purchase Journal (PJ)
Cash Receipt Book (CRB)
Cash Disbursement Book (CDB)
✅ 3. VAT Handling (PH Setting)
Automatically separates:
Input VAT
Output VAT
Zero-rated / Exempt sales
✅ 4. Financial Reports (Auto-Generated)
Trial Balance
Income Statement
Balance Sheet (Comparative)
Cash Flow Statement (Indirect Method)
✅ 5. Tax Computation Ready
Supports:
8% Income Tax
Graduated Rates
Tracks quarterly tax payments
✅ 6. Monthly & Organized Reports
Transactions grouped monthly
Clean, printable formats
Ready for submission or review
✅ 7. Smart Classification
Categorizes accounts automatically
Handles operating, investing, financing activities
✅ 8. Reduces Errors
Minimizes manual computation
Built-in logic ensures accuracy

💡 How This Helps Business Owners
No need to hire a full-time accountant (ideal for small businesses)

Understand your business performance anytime
Stay compliant with BIR requirements
Save time from manual bookkeeping
Make better financial decisions using real data

🎯 Perfect For:
Freelancers & Professionals
Small Business Owners
Startups
Non-accountants who want control of their finances

20/04/2026

🚀 Simplify Your Accounting—No Experience Needed!
Still struggling with bookkeeping?
What if Excel could do it for you?

My automated Excel workbook (powered by VBA) can:
✔ Record transactions easily (no debit/credit knowledge needed)
✔ Auto-generate journals & reports
✔ Compute VAT & taxes (PH setting 🇵🇭)
✔ Produce Financial Statements instantly
✔ Organize everything monthly & cleanly
💡 Perfect for:
Business owners
Freelancers
Startups

📊 Know your numbers.
💼 Make better decisions.
⏱ Save time.
Message me if you want a demo!

14/04/2026

Extension of filling of ITR for the CY 2025

10/04/2026

For BMBE

For BIR annual filing:
File 1701
NON-VAT
Attach FS (non-audited) + BMBE Certificate
SMR / sworn asset declaration not required
VAT
Attach FS (audited) + BMBE Certificate
SMR - required

For DTI / LGU (BMBE registration/renewal):
COA + FS + Sworn Statement of Assets required

Basis: RA 9178 Sec. 5
References / Legal Basis:
RA 9178 (BMBE Law) – Sections 4, 5, 7
BIR RMC 47-2023 – Tax treatment of BMBEs
BIR Tax Code / Sec. 23 – Filing requirement
DTI Guidelines – Registration & renewal of BMBE

06/04/2026

Our automated Excel workbook runs on VBA code
through a macro-enabled Excel file.
✓ Offline use
✓ Open code
✓ Not Google Sheets, which is restricted and requires internet
✓ Saves as .xlsm
✓ No password protection
✓ Free lifetime updates from time to time

02/04/2026

Bookkeeping trivia # 4️⃣

Basis: BIR Rule on Audited vs. Unaudited FS
Under Bureau of Internal Revenue guidelines, particularly Revenue Memorandum Circular No. 50-2018, the submission of Financial Statements is as follows:
1. Audited Financial Statements (AFS) – Required
Required if:
Gross annual sales/receipts exceed ₱3,000,000
Requirements:
Must be audited by an independent CPA
With:
Independent Auditor’s Report
Statement of Management Responsibility (SMR)
Attached to:
Annual Income Tax Return (BIR Form 1701 / 1702)
2. Unaudited Financial Statements – Allowed
Allowed if:
Gross annual sales/receipts ≤ ₱3,000,000
As clarified in RMC 50-2018:
Taxpayers are not required to submit AFS
Instead, they must submit:
Unaudited Financial Statements
With Statement of Management Responsibility (SMR)
Important Clarifications from RMC 50-2018
The ₱3M threshold follows the VAT threshold under TRAIN Law
Applies to individuals, self-employed, and corporations
Even if books are required, audit is not required if within threshold
FS must still be complete and properly prepared
Simple Summary
Over ₱3M → Audited FS (AFS required)
₱3M and below → Unaudited FS (no CPA audit required)

01/04/2026

Tax trivia # 4️⃣
Who file QAP and SAWT?

QAP (Quarterly Alphalist of Payees)
👉 For withholding agents (remitters of EWT)
👉 This is the list of suppliers/payees from whom you withheld Expanded Withholding Tax (EWT)
👉 Submitted together with BIR Form 1601-EQ

SAWT (Summary Alphalist of Withholding Taxes)
👉 For taxpayers claiming Creditable Withholding Tax (CWT)
👉 This is based on the BIR Form 2307 you received
👉 Submitted as attachment to income tax returns (e.g., 1701 / 1702)

Simple way to remember:
If you withhold and remit EWT → QAP
If you claim the tax credit → SAWT

Payor vs Payee (simple):

Payor → the one who pays
Payee → the one who receives payment

In BIR / EWT context:

Payor (withholding agent)
Pays income (e.g., rent, services)
Withholds EWT
Remits tax to BIR
Files QAP
👉 Example: Lessee (tenant business)

Payee (income earner)
Receives payment (net of EWT)
Gets BIR Form 2307
Claims CWT
Files SAWT
👉 Example: Lessor (landlord)

31/03/2026