12 · By task
How to go from spreadsheet to real accounting
A spreadsheet works for longer than expected—until it suddenly does not, usually at the first serious year-end close or when a second person needs to edit it.
- Inventory what you haveList clients, sales invoices, expenses, and opening balances for the financial year.AndCompta does it
- Bring it acrossUse spreadsheet templates, or ask us to import it when the volume justifies the work.AndCompta does it
- Check that it balancesReview opening balances and invoice-series numbering before accepting the migration.AndCompta does it
- !Make the jump on a clean dateIdeally, move at the start of a financial year or IGI filing period.You do it
01
As is usually done
One workbook with many tabs, formulas nobody remembers, and a copy named "final_v3". It works only while one person controls it.
With AndCompta
The same figures now sit behind enforced double-entry, gap-free numbering, and a trace from each entry to its source document. What used to be a formula becomes a journal entry that either balances or is not saved.
You do this part: You choose the cut-off date, and it is an accounting decision. Moving in the middle of a busy season means carrying balances across and makes the first close more complex.
02
The modules involved
- Accounting — Immutable double-entry bookkeeping, manual journal entries, period locks and financial statements.
- Invoicing — Invoices and credit notes with IGI, numbering by series and immutable PDFs.
Verified contacts412
Verified invoices and credit notes3.986
Attachments with verified file hashes3.986
Payments without associated document1
Ambiguous matches to review4
Cannot yet be promoted to productionBlocked
Test it with your own case.
Download the import template and try it with a quarter.