Switching from JuanTax to Akauntants: Philippine Business Migration Guide

JuanTax serves a specific purpose very well: it helps Philippine businesses prepare and file BIR tax returns. It's not a full accounting system. It doesn't record transactions, maintain a general ledger, or produce a balance sheet. Many businesses use JuanTax alongside Excel or a bookkeeping system — JuanTax handles the filing, the other tool handles the books.

Moving to Akauntants is a different kind of migration than moving from Xero or QuickBooks. You're not replacing like-for-like. You're consolidating: Akauntants does both the full accounting and the BIR compliance, replacing whatever combination of tools you were using before.

This guide explains what to preserve from JuanTax, how to set up Akauntants as your new complete system, and how to handle the transition if you're a CPA managing multiple client files.

Understanding What JuanTax Does (and Doesn't Do)

JuanTax does:

• Prepare BIR tax returns (1701Q, 2550M, 2550Q, 2551Q, 1601-C, 1601EQ, etc.)
• Maintain a filing history per taxpayer
• Generate alphalists for withholding tax reporting
• Provide a repository of filed returns and acknowledgment receipts
• Allow manual input of income and expense totals for return computation

JuanTax does not:

• Maintain a chart of accounts or general ledger
• Record individual transactions (sales, purchases, bank entries)
• Generate a balance sheet or profit & loss from the books
• Track accounts receivable or accounts payable aging
• Compute payroll from employee records

This means your "books" during the JuanTax period likely lived somewhere else — a spreadsheet, a separate bookkeeping system, or in your accountant's own tools. Understanding this gap is important because moving to Akauntants means building a full accounting layer that you didn't have before.

What to Keep from JuanTax

Historical Tax Returns — Keep Everything

Before anything else, download and archive all of your filed returns from JuanTax. These are your compliance records and BIR may ask for them during an audit.

Download from JuanTax:

• All filed returns (PDF format) — organize by year and quarter
• Acknowledgment receipts (the eFPS or eBIRForms confirmation)
• Alphalists (1604-CF, 1604-E) for each year
• Any supporting schedules attached to returns

Store these in a folder structure like:

JuanTax Archives
├── 2023
│   ├── Q1 — 2550M Jan, Feb, Mar + 2550Q + 1701Q
│   ├── Q2 — ...
│   ├── Q3 — ...
│   └── Q4 — 2550M Oct, Nov, Dec + 1701 Annual
├── 2024
│   └── [same structure]

Keep these for a minimum of 10 years (BIR retention requirement). You will not be re-importing these into Akauntants — they're archival records.

Your Source Data from the Bookkeeping System

If your bookkeeping was done in Excel, a separate tool, or by your accountant in their own system, gather the same data you would gather for any Excel-to-software migration:

• Trial balance as of your migration date
• AR aging (outstanding customer invoices)
• AP aging (outstanding supplier bills)
• Bank reconciliation balances
• Fixed asset register
• Inventory valuation (if applicable)

This source data — not the JuanTax filing history — is what you'll use to establish opening balances in Akauntants.

When to Migrate

Because JuanTax is a filing tool and Akauntants includes BIR compliance built in, the transition doesn't need to be all-at-once. Two approaches work:

Approach A: Clean break at financial year start (recommended)

• Continue using JuanTax for all filings until December 31
• Start Akauntants on January 1 with clean opening balances
• All Q4 filings (due January 25) for the prior year: file via JuanTax as usual
• Q1 of the new year: file via Akauntants

This is cleanest because your JuanTax records cover one complete fiscal year.

Approach B: Mid-year transition with parallel quarter

• Start Akauntants at the beginning of a quarter
• File the prior quarter's returns in JuanTax (the ones you've already prepared)
• File the current quarter's returns in Akauntants
• Run one quarter in parallel (record in Akauntants, verify against JuanTax-style manual totals)
• Cancel JuanTax after the parallel quarter confirms Akauntants is producing consistent results

Step 1: Set Up Akauntants Completely

Since JuanTax doesn't have a ledger to export, your Akauntants setup is a greenfield implementation, not a data migration.

Business Profile

Enter your BIR registration details exactly:

• Registered name (as on COR)
• TIN
• RDO
• Tax type registration (non-VAT or VAT-registered)
• Financial year start

Chart of Accounts

Start with Akauntants' Philippine default COA. Customize based on your industry:

• If you're a service business (freelancer, consultant): focus on service revenue accounts, professional expense accounts
• If you're a retail/product business: add inventory and COGS accounts
• If you're an online seller: add marketplace-specific accounts (see the online store COA guide)

Tax Configuration

This is the core of what JuanTax handled. In Akauntants:

• Set your VAT rate (12%) or percentage tax rate (3%)
• Configure EWT rates for your vendor payment types
• Set withholding tax rules for employee compensation

Bank Accounts

Connect or configure each bank account and e-wallet. If Akauntants supports your bank's feed, connect it now. Otherwise, configure for monthly CSV import.

Step 2: Enter Opening Balances

Use your trial balance as of the migration date (from your Excel or bookkeeping system). Enter opening balances in Akauntants.

If your "bookkeeping" was minimal (just income and expense tallies in a spreadsheet), your opening balance may be simple:

• Cash: bank account balance
• Any outstanding invoices (AR)
• Any unpaid bills (AP)
• Any loans
• Equity: the difference

If your books were more complete, use the full trial balance method described in the Excel migration guide.

Step 3: Run One Quarter in Parallel

During the first quarter on Akauntants:

1. Record all transactions in Akauntants throughout the quarter
2. At quarter end, let Akauntants generate the tax return (e.g., 2551Q or 2550Q)
3. Manually verify the return figures against your records (the same way you would have done for JuanTax)
4. File via Akauntants

This parallel process is more about gaining confidence in Akauntants' tax computation than about matching a previous system, since JuanTax relied on your manual inputs anyway.

For CPAs: Moving Client Files

If you're a CPA who has been using JuanTax to manage filing for multiple clients, and you're moving those clients to Akauntants, the transition process is slightly different.

Client-by-Client Assessment

Not all clients migrate on the same timeline. Assess each client:

• When is their financial year end?
• Are their books in a state that allows proper opening balances in Akauntants?
• Do they have a bookkeeping system that Akauntants is replacing, or just JuanTax?

Prioritize clients with:

• Simple structures (sole proprietors, non-VAT)
• Clean Excel books or an existing accounting system
• Financial year end aligning with your preferred migration date

Download Client JuanTax Data

For each client, download their complete JuanTax filing history before their account is cancelled or access is removed. This is your compliance archive for audit purposes.

Set Up Client Organizations in Akauntants

Akauntants supports CPA firm accounts with multiple client organizations. Set up each client as a separate organization. You can switch between clients from a single login.

For each client organization:

• Set up their business profile and BIR details
• Configure their COA (use industry-appropriate template)
• Enter opening balances
• Connect bank accounts (if client consents to bank feed access)

Transition Client Filing One Quarter at a Time

If you have 20 clients, migrating all of them simultaneously is risky. Batch them: migrate 5 clients in Q1 of the new year, 5 more in Q2, and so on. This staggers the effort and reduces the risk of errors during the learning curve with the new platform.

What Akauntants Replaces in Your JuanTax + Excel Workflow

The summary: JuanTax handled the last step of a mostly manual process. Akauntants handles the entire process, from transaction recording through filing, automatically.

Common Questions About Leaving JuanTax

"Can I still use JuanTax for historical reference?" Yes — keep your JuanTax account active (or at least exported) for the period you were using it. You don't need to access it regularly, but having the filing history available for an audit query is useful.

"What about clients whose CPA insists on JuanTax?" If your CPA uses JuanTax for their workflow, you can use Akauntants for your bookkeeping and share reports with your CPA for them to use as inputs for JuanTax. Alternatively, many CPAs are open to using Akauntants directly once they see it generates the same return figures. Let the first quarter's parallel results make the case.

"Can Akauntants file directly, without eBIRForms?" Akauntants generates the data and pre-fills the BIR return formats. Filing is done through eBIRForms or eFPS — the same channels as before. The difference is that Akauntants prepares the return for you; you just review and submit.

"Will my existing JuanTax filing history carry over?" No — and it doesn't need to. Your JuanTax PDFs are your record. Akauntants starts fresh with your opening balances and generates new filings going forward.

Transitioning from JuanTax to Akauntants is less of a data migration and more of a systems upgrade. You're not just changing where you file — you're gaining a complete accounting foundation that generates the filing data automatically. For most businesses, the effort of the first month's setup pays for itself many times over in reduced manual work and improved accuracy.