Case study · Tax and corporate compliance

From QuickBooks to ERPNext: How ACE Advisory Runs VAT and Tax Compliance for 100+ Companies

A firm that keeps the books for a hundred companies has two jobs that never stop. Every client's data must stay private, and every return must match the NBR format exactly. We built both into one ERPNext system.

ERPNext logoERPNextCustom development by Invento · Live since July 2026

Laptop showing the ERPNext Tax Center built for ACE Advisory, with tax advice, AIT, sales tax, TDS and VDS management
100+client companies
27NBR-format reports
1shared ERPNext system
12record types moved from QuickBooks
The situation

A hundred companies. One team. One tax authority.

ACE Advisory is a tax and corporate advisory firm in Bangladesh. It keeps the accounts and files the returns for more than 100 client companies, and it used to do all of it on QuickBooks Online.

Access

Everyone worked in one shared system, with no way to control which staff member could open which client's books.

Compliance

VAT, TDS, VDS and AIT work had no home in QuickBooks, so it was tracked outside the books.

Communication

Advisory notices and statements went out one client at a time.

The decision

Why ACE left QuickBooks for ERPNext

QuickBooks kept the ledgers. It could not hold the rules a Bangladeshi tax practice runs on.

ERPNext could. It gives full ownership of the platform, a multi-company accounting core and a framework designed to be extended. So instead of managing access and compliance around the accounting system, we built them into it, as the only Frappe partner listed for Bangladesh in Frappe's partner directory.

Laptop showing the ERPNext app launcher with the Ace Advisory and Tax Center workspaces beside Accounting, Buying, Selling and Stock
Ace Advisory and Tax Center sit inside ERPNext, beside Accounting, Buying and Selling. One login, one database.
The migration

Moving the books from QuickBooks to ERPNext

Before any new feature could help, every client's history had to arrive in ERPNext intact. For a firm that files returns for more than 100 companies, one wrong opening balance becomes a wrong return.

We started from an open-source QuickBooks connector first written in 2016 and rebuilt it for this job. It now signs in to QuickBooks Online securely and manages many companies from one place, each with its own sync settings and a full activity log.

Then we moved ACE's companies across one at a time, checking the numbers on both sides before each one went live.

The import log and a reconciliation check from the migration tool. Shown on QuickBooks sandbox data.

What came across from QuickBooks

  • Chart of accounts
  • Customers
  • Suppliers
  • Employees
  • Items
  • Opening balances
  • Sales invoices
  • Purchase invoices
  • Payments
  • Journal entries
  • Fixed assets
  • Inventory adjustments

Tax codes mapped per company

Each company's QuickBooks tax codes are mapped to ERPNext tax templates, with checks that stop an entry importing under the wrong rate.

Numbers compared on both sides

Balances are compared account by account and party by party, so any difference shows up before anyone files from it.

Safe undo and redo

A migration run can be rolled back and run again, so fixing a mapping never means cleaning up entries by hand.

Tested on real figures

The accounting logic was checked against real ledgers before a single client depended on it.

Quickbooks Master Sync, on the Frappe Cloud Marketplace

The master data part of this connector is available as a free app for ERPNext versions 15 and 16. It moves the chart of accounts, customers, suppliers, items, tax rates, payment terms and opening balances, and compares balances between the two systems. Firms that need their full transaction history moved can get the transaction sync from us.

See the app
What we built

Four additions to ERPNext, each one visible in the system ACE uses every day

Every addition is built into ERPNext itself, on the same accounts, the same users and the same data. Nothing sits in a separate tool.

Access control

Every staff member sees only their own clients

ConstraintA hundred companies in one system only works if each client's data stays with the people assigned to it.
We addedA central access layer that limits each staff member to their assigned companies, across every screen and report.
NowACE assigns a client once. The wall follows the data everywhere.
Staff 1 Staff 2 Staff 3

Hover or tap a staff member to see their clients

Tax Center

VAT and tax settlement in one place

ConstraintSettling VAT and tax meant payment proofs in one place and accounting entries in another.
We addedA Tax Center covering tax advice, AIT, sales tax, TDS, VDS, tax and VAT payments, compliance and reporting. Upload the challan or receipt and the accounting entry posts itself.
NowPayments, proofs and the books stay in step.
Challanuploaded Settlementrecorded Journal entryposted automatically Reportsup to date
Tax advice

Tax advice with the law written in

ConstraintEvery supplier payment carries its own TDS and VDS rate, set by the type of service and the section that applies.
We addedA tax advice generator that works out TDS and VDS line by line and writes the Income Tax Act 2023 section and VAT reference into each comment.
NowClients get advice they can act on, with the basis stated.
Tax advice · Client A LtdGenerated in ERPNext
SupplierCustomer B Ltd
ServiceIT enabled service (ITES)
Invoice৳3,150
TDS · income tax
৳3,000 × 7.5% = ৳225

Section 90 (Rule 4), Income Tax Act 2023

VDS · VAT at source
৳3,000 × 5% = ৳150

VAT SRO for IT enabled services

Withheld৳375
Net payable to supplier৳2,775
Comment written by the systemCustomer B Limited is providing IT enabled service (ITES). Hence, tax shall be deducted at the rate of 7.5% under Section 90 (Rule 4), professional service, of the ITA 2023.
NBR returns

The Mushak forms, straight from the books

The 27 reports follow the official Mushak formats, from 6.1 and 6.2 to 6.3, 6.6 and 6.10, so every return comes from the same entries as the bookkeeping. No retyping, no second spreadsheet. How VAT compliance works in Bangladesh.

Mushak 6.3 tax invoice

Every sales invoice can be downloaded as a Mushak 6.3 tax invoice, including returns and credit notes, filtered by client and period.

From posted sales invoices

Mushak 6.6 VDS certificate

Withholding certificates are generated per vendor and period, in the NBR layout, and can be regenerated after a change.

From VAT deducted at source

Mushak 6.10

Purchases and sales above 2 lakh taka, listed in the NBR layout with challan numbers, dates and amounts.

From purchase and sales invoices

Mushak 6.2 sales register

The sales accounts book with every column of the official form. Its purchase counterpart, Mushak 6.1, works the same way.

From posted sales

Also in the set: the Mushak 6.1 purchase register, VAT challans, VAT payable summaries and other NBR forms, all from the same entries.

Alongside the forms, bulk email and document tools send advisory notes and statements to many clients at once instead of one by one. ACE also publishes guidance on each form, such as its Mushak 6.3 page.

The reports

27 reports, grouped the way a tax practice works

Tax advice and communication

Advisory notes, tax and VAT payment tracking, tax invoices.

VAT compliance

VAT challans, Mushak 6.1 and 6.2 registers, VAT payable summaries.

TDS and VDS monitoring

Management views and topsheets for both.

AIT management

AIT tracking and monthly deduction summaries.

Trackers and ledgers

Outstanding challans, document status and trade-specific ledgers.

The build

Built in stages, still growing

From Sep 2025

Foundation

Companies and clients set up in ERPNext, and each company's QuickBooks history moved across.

Next

Access

The access layer applied across the whole platform.

Then

Compliance

27 reports built one at a time against the official forms.

1 July 2026

Go live

ACE moves its daily work for every client onto ERPNext.

Today

Still extending

Permissions reorganised for long-term upkeep, quality checks on every update, new features still added.

A dedicated team of four to five people has worked on the platform continuously since September 2025, and ACE has run on it every day since going live. It is the same approach behind our Import and Export LC work: keep ERPNext as the core, add the layer Bangladesh needs.

Compliance belongs in the books, not beside them.

Running the books for many companies?

Tell us how your practice or group works today. We will show you how ERPNext would handle your clients, your access rules and your returns.

Questions firms ask us

Can ERPNext generate a Mushak 6.3 tax invoice?
Yes. In ACE Advisory's system every sales invoice can be downloaded as a Mushak 6.3 tax invoice, built from the posted invoice rather than typed separately. ERPNext provides the invoicing and tax engine; the Mushak layout is part of the Bangladesh layer we added.
How is a Mushak 6.6 VDS certificate issued in ERPNext?
The certificate is generated for a vendor and a date range from the VAT deducted at source on posted payments. If an entry changes, the certificate can be regenerated.
Is there VAT software in Bangladesh that works for firms with many clients?
ACE Advisory runs more than 100 client companies in one ERPNext system. Each staff member sees only the companies assigned to them, and 27 reports cover VAT, TDS, VDS and AIT in the NBR formats.
Can an accounting firm move from QuickBooks Online to ERPNext?
Yes. ACE Advisory moved its client companies from QuickBooks Online into a single ERPNext system. We moved the chart of accounts, parties, items, opening balances and transactions company by company, mapped each company's tax codes and compared balances in both systems before going live. The master data part of our connector is available as a free app, Quickbooks Master Sync, on the Frappe Cloud Marketplace.