How to build an accounting or invoicing app: key features and common mistakes

Accounting software looks simple until the edge cases arrive. Here are the features that matter and the mistakes to avoid.

By the AvrioBooks team · · 8 min read

How to build an accounting or invoicing app: key features and common mistakes

Plenty of teams start with “it is just invoices and totals” and meet the hard parts later: rounding, tax, corrections and audits. This guide is for developers and founders considering a build. It is general guidance, not legal or tax advice.

Should you build at all?

Build when accounting is part of your product, for example a marketplace or vertical tool that needs ledger-backed invoicing. If you only need to record invoices from your own app in a normal set of books, integrate with accounting software through an API instead. AvrioBooks has a REST API for this. See the developers page and API documentation.

Core features

  1. A double-entry ledger. Every transaction is a set of debits and credits that balance. Reports are views over the ledger, not separate tables. See what is double-entry bookkeeping.
  2. A chart of accounts. Assets, liabilities, equity, income and expenses, editable by the user. See the chart of accounts.
  3. Invoices, bills and credit notes with sequential numbering, line items and statuses.
  4. Tax rates per line, with correct rounding and reporting.
  5. Payments and allocation against invoices, including partial payments.
  6. Bank import and reconciliation. See bank reconciliation explained.
  7. Multi-user access with roles and permissions.
  8. An audit trail of who changed what and when.
  9. Period locking so closed periods cannot change.
  10. Export and reports: profit and loss, balance sheet, trial balance and ageing.

Common mistakes

  • Using floating-point numbers for money. Use integers (minor units) or a decimal type, and define your rounding rule up front.
  • Editing posted entries. Correct with a reversing entry or a credit note, not by overwriting. History must stay intact.
  • No audit trail. You will need it the first time a customer asks why a figure changed.
  • Gaps or duplicates in invoice numbers. Generate numbers inside a transaction, and decide how voids are handled.
  • Tax rounding per document instead of per line (or the reverse), without checking which rule your jurisdiction expects.
  • Time zones and date boundaries. A sale just before midnight can land in the wrong period. Store dates deliberately.
  • Multi-currency as an afterthought. Store the original currency, rate and base-currency amount, and plan for revaluation. See foreign currency gains and losses.
  • Weak tenant isolation. One customer must never see another’s data. Test this explicitly.
  • Skipping lock dates. Someone will edit last year’s numbers after the accountant has finished.
  • Underestimating tax and regulation. Rules such as Making Tax Digital for VAT change, and some jurisdictions require specific invoice content.

A sensible build order

  1. Ledger and chart of accounts, with tests that every entry balances.
  2. Invoices and payments.
  3. Tax and reporting.
  4. Audit log, roles and period locks.
  5. Bank import, then reconciliation.

If you integrate instead

AvrioBooks provides a REST API, and the app is built by Qodexify. See about AvrioBooks. We would still suggest checking whether the API covers your use case before committing to either route.

Frequently asked questions

Should I build my own accounting software?

Only if accounting is core to your product. Otherwise integrate with existing software through an API.

Why not store money as floats?

Floating-point numbers cause rounding errors. Use integers in minor units or a decimal type.

How should I handle corrections?

Use reversing entries or credit notes so history stays intact, rather than overwriting posted transactions.

Does AvrioBooks have an API?

Yes. There is a REST API. See the developers page and API documentation.

Written by the AvrioBooks team. We build cloud accounting software for small businesses, freelancers and their accountants, from Qodexify. This article is general information, not tax, legal or financial advice. Check GOV.UK or ask an accountant about your own situation.
Try AvrioBooks free Start a 30-day free trial with everything in Premium, no card needed. Start free trial
Newsletter

Accounting tips, tax dates and product news

Practical bookkeeping, VAT and Making Tax Digital guidance for freelancers and small businesses, plus AvrioBooks updates.

By subscribing you agree to receive emails from AvrioBooks. Unsubscribe at any time. See our privacy policy.

Sign up freeContact us