My accountCartFree DemoRequest a quote
Back to blog
Guide6 min readBy

Year-end closing: the Dolibarr checklist for a clean set of accounts

Unreconciled invoices, unvalued stock, pending entries: the Dolibarr checklist to reach your accountant with clean accounts at the end of the financial year.

Desk with sorted folders, a calculator and a year-end calendar, ready for the accounting close

Start with documents left in draft

A closing is prepared several weeks before the end of the financial year. First step: list everything that is not validated. Signed quotes never turned into orders, delivered orders never invoiced, customer invoices left in draft, supplier invoices entered but not validated. These documents do not exist in the books, so your revenue and your expenses are wrong. In Dolibarr, each list (invoices, orders, shipments) can be filtered by status. Filter on draft, open each document and decide: validate, delete or keep for next year. Do the same for delivered orders that were not invoiced. This is the most costly oversight, because it delays a payment on top of distorting the result. If you bill subscriptions, also check that the recurring invoices for the period were generated. Do this review as a team, document by document, with the person who knows the customer file.

  • Filter customer invoices in draft status and decide on each one.
  • Spot orders that were shipped but not invoiced.
  • Validate or delete supplier invoices waiting for complete entry.
  • Check that all recurring invoices for the year were issued.

Reconcile payments and deal with unpaid invoices

An invoice that was paid in reality but is still open in Dolibarr inflates your receivables and blurs the aged balance. Go through the unpaid customer invoices: for each one, check whether a payment exists on the bank account. If so, record the payment and classify the invoice as paid. Run the same check on the supplier side, where payments that have already left the account are often not entered. The safest method remains bank reconciliation, because it forces you to support each statement line with a document. If you need a refresher, our article on bank reconciliation in Dolibarr explains the process. For invoices that are truly unpaid and old, decide with your accountant what happens next: reminder, dispute or doubtful receivable. Record these decisions in the customer record, not in a separate file, so the history stays readable next year.

  • Compare each open invoice with the bank statements.
  • Record the missing customer and supplier payments.
  • Finish the bank reconciliation up to the last day of the financial year.
  • Isolate old receivables and document the decision in the third-party record.

Value and count your stock

Stock is an asset: a wrong quantity or a missing value directly distorts the result. Start with a physical count, warehouse by warehouse, then compare it with the quantities in Dolibarr. Correct the differences with explicit stock movements and a clear label, rather than with silent edits. Then check that each stocked product has a consistent cost price, because an item with a zero value disappears from the valuation. Also check supplier receipts: goods that arrived but were not received in the tool are missing from stock, and a receipt entered without an invoice leaves an expense to be matched. If you manage several sites, our guide on multi-warehouse stock in Dolibarr helps make quantities reliable. Keep the signed count sheets: your accountant will ask for them in case of an audit.

  • Carry out the physical count and compare it with the displayed quantities.
  • Post correction movements with an explicit label.
  • Check that no stocked product has an empty cost price.
  • Match goods receipts with supplier invoices.

Check the accounting before the transfer

If you use the accounting module, closing goes through the binding step (ventilation), which assigns each line to an accounting account. First check that all sales and purchase lines are assigned to an account: lines still pending are exactly the forgotten entries we mentioned. Then check the accounts for products, services and third parties, and the VAT rates applied, especially for intra-community transactions, covered in our article on intra-community VAT and reverse charge. Once the assignment is complete, generate the entries in the general ledger, review the trial balance and look for abnormal balances: a customer account in credit, a supplier in debit, a bank account that does not match the statement. If the basic settings have never been checked, start with the accounting settings to configure before the first entry. Only freeze the financial year after your accountant has approved the trial balance.

  • Assign all pending sales and purchase lines to accounts.
  • Generate the entries, then review the trial balance account by account.
  • Hunt for abnormal balances on customer, supplier and bank accounts.
  • Have the accountant approve the trial balance before freezing the period.

Catch up on end-of-period operations

Some entries have no triggering document and are only made if someone thinks of them. Prepaid expenses, accrued invoices not yet received, income to be received, leave to be provisioned, expense reports for the last month. Draw up the list with your accountant, who will tell you what they handle themselves and what you must provide. On the Dolibarr side, think about expense reports still in draft, fixed assets bought during the year, and supplier invoices received in early January that relate to the year just ended. For these, both the invoice date and the accounting date matter: ask what applies to your case rather than guessing. A simple rule: everything that belongs to the financial year must be entered before locking, even if the document arrives later. Keep a dated note of these decisions. It will serve as an audit trail next year.

Back up, freeze and prepare the accountant's file

Before locking anything, make a full backup: database and documents folder. Store it separately, with a name that shows the financial year. If you host Dolibarr yourself, check that restoring really works. Our guide on in-house or managed hosting lists the points to check. Then close the accounting period in Dolibarr to prevent any retroactive change. Finally, prepare the file: export of entries, trial balance, aged balance for customers and suppliers, valued stock report, reconciled bank statements. Send everything with a short note listing your assumptions and open points. If you want an expert to review your settings before closing, contact Dolicraft: we go through your lists, your settings and what is still to be regularised.

Need help with Dolibarr?

Our team of Dolibarr experts is available to support you in your projects: implementation, migration, custom module development and training.