Playbook20 min read

Month-end reconciliation: invoices, payments and Peppol in OrdoGrid

Close a month in OrdoGrid: lock the invoice and credit note list, tie each balance to the bank in Brussels time, explain rounding and clear Peppol exceptions.

Updated
Content owner
Financial control
For
Financial controllers · Accountants and bookkeepers · Small business owners · Integration owners

At a glance

Close one company, one currency and one period in Brussels time, in three separate passes: the documents issued, each invoice's settlement against the bank, and Peppol delivery. OrdoGrid shows today's balance and stores payment times in UTC, so rebuild the cut-off position from the movement history and give every difference an owner and a date.

Before you begin

  • Owner or Administrator access to each OrdoGrid company you close (Viewer is enough to read)
  • Bank statements or CODA files and card payout reports for the period
  • Last month's list of open invoices and unresolved differences
  • For an API extraction: a key with invoices:read, credit_notes:read and peppol:read

What you will achieve

  • A complete list of the period's invoices and credit notes, with every gap in the numbering explained
  • A receivables roll-forward that ties OrdoGrid, the bank and your ledger to the cent
  • A register of open differences and Peppol exceptions, each with an owner and a date, ready before the VAT return deadline
On this page

A month-end close answers three separate questions for one company and one period: is every invoice and credit note in the list, does each invoice's balance match money that really moved, and did each document reach the customer? No single status answers all three. Traité (processed) on Peppol means network delivery, not payment, and a Payée (paid) label on an older invoice may have no recorded payment behind it.

This playbook is for controllers, bookkeepers and accountants who close OrdoGrid companies, and for small businesses that want a short monthly check. What to send your accountant is in hand over invoices, Peppol files and payments to your accountant; recording one payment is in follow up an invoice and record a partial payment.

Three reconciliations, three different answers

QuestionWhere OrdoGrid shows itWhat it does not prove
Is every document there, once?Factures (Invoices) and Notes de Crédit (Credit Notes)That anything was paid or delivered
Does each balance match real money?The invoice's Settlement panel and Movement historyDelivery or acceptance
Did each document reach the customer?Peppol → Outbox badgesAcceptance or payment

Work in this order: documents, then money, then delivery, with a separate exception list for each. A payment never closes a delivery problem, and a delivered invoice can still be unpaid.

What sets the close: law, practice and product

What the law requires

  • An invoice must be issued by the 15th of the month after the chargeable event (art. 4 §1 Royal Decree no. 1). October supplies not yet invoiced at the close must be invoiced by 15 November 2026. VAT on an advance payment becomes chargeable when you collect it, and its invoice must be issued by the 15th of the following month.
  • The monthly VAT return for October 2026 is due on 20 November 2026; the quarterly return for Q4 2026 on 25 January 2027 (FPS Finance VAT calendar). Since January 2026, quarterly filing is open up to €2,500,000 annual turnover excluding VAT.
  • A credit note's VAT is regularised in the return for the period in which the cause of the VAT restitution arises (art. 5 §1 Royal Decree no. 4), in practice the credit note's period, whatever the date the money is paid back. You do not reopen the original return.
  • Since 1 January 2026, the structured e-invoice is the legal invoice for Belgian B2B invoices in scope of the obligation. If the customer cannot technically receive one, you must still issue the invoice in another form, such as a PDF.
  • Invoices are kept seven years from 1 January of the year after issue (art. 60 VAT Code, as amended by the Law of 18 December 2025).
  • As of October 2026, no invoice data is reported to FPS Finance (the Federal Public Service Finance); the e-reporting preliminary draft law approved by the Council of Ministers on 18 July 2026 is not yet law.

What we recommend: close each OrdoGrid company and each currency separately, in Europe/Brussels time, within the first five working days. Never move the cut-off to make a difference disappear: record the real date and explain it.

What OrdoGrid does: it stores payment times in UTC and shows each invoice's position today, with no "balance as at" date. Invoice total includes the Arrondi (rounding) line, which can be positive or negative. OrdoGrid prepares no VAT return or listing, converts no currencies and does not net balances across invoices.

Choose your route

Your situationRoute
One company, a few dozen invoices a month, no integrationThe 20-minute check below
Several companies, a webshop, POS or ERP integration, a shared-service teamThe full close, plus the API extraction if you use one
Your accountant keeps the booksThe 20-minute check, then the accountant handover

The 20-minute check for small businesses

  1. Open Factures (Invoices). In the top-bar date selector, choose Mois dernier (last month).
  2. Click the Number column header and scan the series: every missing number needs a reason, such as a deleted draft.
  3. Set Statut (status) to Brouillon (draft): finish or delete drafts that should not exist.
  4. Set Statut back to All statuses and check every invoice not marked Payée or Annulée against your bank statement. For each one that was paid, open it and click Record payment in Settlement.
  5. Open Notes de Crédit (Credit Notes). For each credit note whose invoice was already paid, open that invoice: Refund due in Settlement means you still owe the customer money.
  6. In Peppol → Outbox, click Actualiser (refresh) and deal with any Erreur (error) or Pas sur Peppol (not on Peppol), as in step 5 below.
  7. Select the month's invoices and click Download, do the same in the Outbox (check that the ZIP contains the XML files), and file both with your bank statement. Note anything unresolved, with a date.

The full close, step by step

Example calendar for the October 2026 close of a monthly filer:

DayDateWorkOwner
1Monday 2 NovemberScope and cut-off, chase missing payments, extractsController
2Tuesday 3 NovemberDocument list and gapsAccounting
3Wednesday 4 NovemberSettlement and bankAccounting with treasury
4Thursday 5 NovemberPeppol and archive exceptionsOperations
5Friday 6 NovemberReview, sign-off, handoverController and reviewer

1. Fix scope, cut-off and time zone

Write down the company (name and enterprise number), currency, document types, period and time zone. One OrdoGrid company is one entity: switch with Changer d'entreprise (switch company) in the profile menu and close each one separately.

State the cut-off in Brussels time and in UTC. Summer time ends on 25 October 2026, so 31 October 23:59:59 in Brussels is 22:59:59 UTC; for September (UTC+2) it was 21:59:59 UTC. Before extracting, ask everyone to record the period's payments and refunds and to warn you before creating another invoice dated in the period.

2. Lock the document list

  1. Open Factures. In the top-bar date selector, set Date de début (start date) and Date de fin (end date) one day wider than the period, then check the first and last rows of the Date column. The list only shows documents in that range, the last 90 days by default.
  2. Sort by Number and read the series from the last number of the previous close. OrdoGrid commits a number when a document is first saved, even as a draft, and does not enforce gap-free numbering. The law requires sequential numbering, so every gap is yours to explain.
  3. List drafts (Brouillon) separately: a draft is not an issued invoice. A mistaken draft can be deleted only while it has no payment, payment link, Peppol transmission or linked or converted document, and was not created through the API with an external_id; otherwise leave it as a draft and explain it in your document list.
  4. Repeat in Notes de Crédit; each credit note shows its Facture d'origine (original invoice). An invoice shown as Annulée (fully credited) stays in your list with its credit note.
  5. Select the period's issued documents, click Download and count the PDFs in the ZIP against your list.
  6. Compare net, VAT per rate and Arrondi with your sales journal. For integrations, match on source external_id and integration_id, then on OrdoGrid id and number: equal counts can hide one duplicate and one omission of the same value.

3. Bridge each invoice's settlement

Open every invoice issued in the period and every invoice open at the previous close, and read Settlement:

LineMeaningWatch out
Invoice totalNet + VAT + Arrondi, frozen at issueCan be a cent away from net + VAT
PrepaymentsDeposits recorded when the invoice was createdAlready inside the next line
Payments (including prepayments)Confirmed money received, net of reversalsNever add Prepayments again
CreditsLinked credit notes, counted onceReduce the debt; no cash moved
Completed refundsMoney returned, net of reversalsRecorded after it left your bank
Outstanding / Refund dueOwed by the customer / owed back by youToday's values
Outstanding = max(0, Invoice total − Credits − Payments + Completed refunds)
Refund due  = max(0, Payments − Completed refunds − (Invoice total − Credits))

The warning Legacy payment evidence needs reconciliation. appears on invoices marked paid or partially paid before OrdoGrid recorded payments as movements. The list still shows Payée or Partiellement payée, but the panel counts no payment and shows the full amount outstanding. Find the bank or till evidence and record the payment with its real date; without evidence, log a difference. Never record a payment just to clear the warning. The warning stays visible afterwards, so note the resolution in your register.

Receivables roll-forward
Open at the previous cut-off + invoice totals issued − credit notes − money received + refunds paid = open at this cut-off, per company and currency. Every invoice open at the cut-off is in the closing figure, and nothing else.

4. Match the money to the bank

  1. Find each bank credit, debit and card payout in the matching invoice's Movement history: same amount, reference and date.
  2. Missing? Click Record payment (Owner or Administrator), fill in Amount, Method, Occurrence time (UTC) and Reference (the bank reference), and tick I confirm this money has already been received or refunded. One movement per invoice: a transfer paying two invoices is two movements. A payment above Outstanding is refused, so record the invoice's part and list the excess.
  3. A refund left your bank? Click Record refund; it shows only while Refund due is above zero.
  4. A wrong movement? In Movement history, click Reverse payment or Reverse refund, tick I confirm this movement failed or was recorded in error. and record the right one. Movements are never edited; a reversal cancels the full amount.
  5. With the Accounting module, justifying a bank transaction with an invoice in Transactions records the payment. Check that it appears in Movement history.

5. Check Peppol delivery and the archive

  1. Open Peppol → Outbox and click Actualiser. The top-bar date selector applies here too; the footer counts Total documents, Livrés (delivered) and En erreur (in error).
  2. Act on every badge other than Traité:
BadgeMeaning at the closeAction
TraitéDelivered over the network; not accepted, not paidNone
Créé, En file, En attente, Nouvelle tentativeStill in progressClick Vérifier (check); never send again; contact OrdoGrid support after one working day
ErreurNot delivered, or outcome unknownFix any cause outside the invoice, then retry once with Envoyer à Peppol (globe button) before the 15th. OrdoGrid sends the invoice again only if its access point refused the first attempt. If OrdoGrid refuses the retry because an earlier outcome must first be reconciled, or the row still shows Erreur after it, stop and contact OrdoGrid support: no email copy, no new invoice. A retry re-sends the same archived file: if the invoice content is wrong, credit it and issue a new invoice
Pas sur PeppolOrdoGrid found the customer when you sent, but no Peppol registration accepting this document was found at deliveryAsk the customer whether its registration accepts invoices and credit notes. If it cannot receive, email the same invoice and note it: for a Belgian customer in scope this is the fallback rule; for a foreign customer the PDF is the normal invoice
Déjà envoyéReported as already sentFind the earlier transmission and its status; do not send again
  1. A rejection response from a customer does not remove the invoice from your sales: correct it with a credit note, and a new invoice if needed, never by editing it.
  2. Select the period's documents and click Download, then open the ZIP and check that xml/ holds one XML per document. If an XML is missing, download it from the document's row in the Outbox (XML) or with GET /api/v1/peppol/documents/{id}/xml, which reads the archived transmission. FPS Finance strongly recommends keeping the original XML. Badge details: Peppol delivery status.

6. Classify differences and sign off

CategoryTypical causeOwnerDefault action
Missing documentIn the ledger or source system but not in OrdoGrid, or the reverseAccountingFind it by number or external_id; never recreate it blindly
DuplicateThe same order created twiceIntegration ownerCredit the duplicate; fix the identity mapping
Amount or mappingVAT rate, rounding or currency differsAccountingExplain per invoice; credit note if the invoice is wrong
Late registrationMoney moved in the period, recorded afterTreasuryRecord it with the real occurrence time
Missing cash evidenceNo bank line behind a movement, or a legacy labelTreasuryGet the evidence; reverse the movement if no money came
DeliveryErreur, Pas sur Peppol, a send in progressOperationsStep 5; incident response if several invoices are hit
Timing at cut-offEvent near midnight, money in transitControllerName the event and the date it resolves

Sign off when every difference has a category, an owner and a date, and a second person can rebuild the list and the roll-forward from the close pack. "Timing" without the actual event is not an explanation, and a difference called temporary for three closes is escalated. At the next close, start from the carried-forward list and remove a case only once its resolution is verified.

Extracting with the API

GET /api/v1/me
GET /api/v1/invoices?issued_from=2026-10-01&issued_to=2026-10-31T23:59:59&limit=100&offset=0
GET /api/v1/credit-notes?issued_from=2026-10-01&issued_to=2026-10-31T23:59:59&limit=100&offset=0
GET /api/v1/invoices/{id}/payments
GET /api/v1/peppol/invoices/{id}/status
GET /api/v1/peppol/documents?direction=outbound&limit=100&offset=0
  • Scopes: invoices:read (it also covers payment histories, not payments:read), credit_notes:read and peppol:read. GET /api/v1/me confirms the company and the key's integration_id.
  • issue_date is a calendar date: give bounds without a time-zone offset and end at 23:59:59 on the last day.
  • Lists return at most 100 rows, newest first. Note pagination.total before the first page and after the last; if it changed, de-duplicate on id and read again, or pause posting.
  • Each invoice carries totals.gross (net plus VAT), totals.rounding, totals.payable (equal to settlement.document_total) and its current settlement.
  • Movements carry occurred_at and recorded_at in UTC: convert to Brussels time before assigning a period. Occurred before the cut-off but recorded after is a late registration.
  • Also read the payment history of every invoice open at the previous close: older invoices' cash is not in a list filtered on this period's issue dates.
  • The Peppol document list filters only on direction, newest first: page until you pass the period start, or read each invoice's status. A transmission_state of uncertain must be reconciled with OrdoGrid before any new send.

Worked example: October 2026 at Koffiebranderij Dewitte BV

Koffiebranderij Dewitte BV, a coffee roaster in Mechelen, files monthly VAT returns. On 30 September one invoice was open: F-2026-0170, Tearoom Mie Clara BV, €1,210.00. In October it issued:

DocumentDateCustomerNetVATArrondiTotalPeppol
F-2026-01812 OctHotel Ter Duinen NV990.00 (740.00 at 6%, 250.00 at 21%)96.90–1,086.90Traité
F-2026-01829 OctBrasserie 't Pleintje BV114.0423.950.01138.00Traité
F-2026-018315 OctCafé Sint-Rombout BV (webshop)2,000.00420.00–2,420.00Traité
F-2026-018422 OctBakkerij Verbeke BV462.5027.75–490.25Erreur
NC-2026-001226 OctHotel Ter Duinen NV, credits F-2026-0181−92.50−5.55–−98.05Traité
Total3,474.04563.050.014,037.10

F-2026-0182 is a barista workshop entered at VAT-inclusive prices: two lines of 6 seats at €11.50, so €138.00 payable. VAT per rate after the credit note: 6% on 1,110.00 is 66.60, 21% on 2,364.04 is 496.45, together 563.05.

Money received and refunded, in Brussels time: 12 October €1,210.00 (F-2026-0170), 15 October a €500.00 webshop deposit on F-2026-0183, 20 October €1,086.90 (F-2026-0181), 30 October a €98.05 refund to Hotel Ter Duinen. Brasserie 't Pleintje paid €138.00 by instant transfer at 00:30 on 1 November.

Roll-forward (EUR)AmountSource
Open at 30 September1,210.00September close pack
+ Invoice totals issued4,135.15Four October invoices
− Credit notes−98.05NC-2026-0012
− Money received−2,796.901,210.00 + 500.00 + 1,086.90
+ Refunds paid+98.0530 October
= Open at 31 October2,548.25F-2026-0182 138.00 + F-2026-0183 1,920.00 + F-2026-0184 490.25

What the close found:

FindingCategoryAction
F-2026-0164 (€605.00, September) shows Payée but €605.00 outstanding and the legacy warning: OrdoGrid's opening balance was €1,815.00Missing cash evidenceThe bank shows €605.00 on 29 September: Record payment, Bank transfer, 29/09/2026 12:00 UTC
On the 2 November extract, F-2026-0181 still showed Refund due €98.05Late registrationTreasury recorded the refund on 3 November with Occurrence time (UTC) 30/10/2026 12:00
A UTC extract counted F-2026-0182's payment (23:30 UTC on 31 October) in October: €2,410.25 openTiming at cut-offA November receipt in a Brussels close; nothing to change
A spreadsheet added Prepayments to Payments (including prepayments) for F-2026-0183 and showed €1,420.00 openAmount or mappingCorrect: 2,420.00 − 500.00 = 1,920.00
Sales journal net + VAT €4,037.09, OrdoGrid €4,037.10Amount or mappingThe €0.01 Arrondi on F-2026-0182 (BT-114 on Peppol); the accountant books it to a rounding account
F-2026-0184 in Erreur: the customer had no invoiceDeliveryCause fixed, sent again on 4 November, Traité the same day, before the 15 November deadline

The credit note's €5.55 VAT goes into the October return. The close pack sent to the accountant on 6 November:

2026-10_Koffiebranderij-Dewitte/
  00_scope_and_signoff.pdf
  01_documents_2026-10.csv
  02_sales_as-issued.zip
  03_peppol_outbox_2026-11-05.zip
  04_bank_2026-10.coda
  05_rollforward_2026-10.xlsx
  06_differences_2026-10.csv

With the Accounting module on the Business plan, Create share link in Transactions gives the accountant a read-only download page for 30 days without an OrdoGrid account. The CSV contains justified transactions from the selected period and their available supporting documents; it is not every movement or every invoice in that period. Original bank statements are excluded unless you explicitly include eligible source files. Such files can show movements absent from the CSV: inspect them before sharing. The package is rebuilt from current matching records at each download, not frozen at the closing date. Anyone with the link can download it. Only owners/admins can create a link, it is shown once, and Revoke ends access. See the accountant handover guide for selection and source-file limits.

More on the rounding line: VAT-inclusive prices, discounts and rounding.

Edge cases and common mistakes

SituationCorrect action
Credit note for a period invoice, issued after the closeDo not backdate it; its VAT is regularised in the period it is issued
Card payout net of feesPayments through OrdoGrid's Stripe payment links are already recorded at the gross amount: match the payout to those movements. For other card payments, record what the customer paid. The fee is a separate cost
Customer paid more than the balanceRecord the invoice's part; keep the excess on the differences list
Abandonnée (written off)A label only: no credit note, no movement, Outstanding unchanged. Agree the accounting and VAT treatment with your accountant
Amounts wrong after a payment or a Peppol sendThey are locked: correct or credit the invoice

Evidence to keep

  • Scope sheet: company and enterprise number, currency, period, time zone, cut-off in Brussels time and UTC, extract times, preparer and reviewer.
  • The document list with gaps explained, the PDFs as issued, the Peppol Outbox ZIP and one XML per Peppol document.
  • Bank statements or CODA files and card payout reports.
  • The roll-forward, per-invoice bridges and dated Current statement PDFs for open invoices.
  • The differences register and the sign-off; for API extractions, the queries, pagination.total at start and end, and the key's integration_id.

What the law requires: invoices are kept seven years from 1 January of the year after issue, some linked to VAT revision on real estate 15 or 25 years. What we recommend: keep the close pack with the period's accounting records for as long. What OrdoGrid does: it archives the exact XML and PDF of each Peppol transmission but gives no retention guarantee, so keep your own copies. See invoice archiving in Belgium.

FAQ

Can I close the month while a Peppol send is still En file or En attente?

Yes. Delivery and settlement are separate. Keep the invoice on the delivery list with an owner, click Vérifier, never send it again, and contact OrdoGrid support if it is still in progress after one working day.

A refund left our bank on 30 October but was recorded on 3 November. Which month is it?

October: that is when the money moved. Record it with an Occurrence time (UTC) on 30 October and classify it as a late registration. The credit note's VAT goes into the return of the period in which the credit note was issued.

Why is the OrdoGrid total one cent higher than net plus VAT?

With VAT-inclusive prices, OrdoGrid keeps the entered gross amount and shows the difference as Arrondi, sent on Peppol as BT-114. It is not an error; your accountant books it to a rounding account.

Why does Settlement show a balance on an invoice marked Payée?

It was marked paid before OrdoGrid recorded payments as movements. Record the payment from the bank evidence with its real date; without evidence, treat the invoice as open and ask your accountant.

Can OrdoGrid show the balance as it stood on the last day of the month?

No. Settlement and Current statement show today's position. Rebuild the cut-off position from Movement history, and close early in the month so few movements need removing.

Does OrdoGrid send my sales to FPS Finance or prepare the VAT return?

No. As of October 2026 no invoice data goes to the administration, and OrdoGrid prepares no VAT return or listing. Your accountant files the return from your records and the close pack.

Sources and references