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
| Question | Where OrdoGrid shows it | What 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 history | Delivery or acceptance |
| Did each document reach the customer? | Peppol → Outbox badges | Acceptance 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 situation | Route |
|---|---|
| One company, a few dozen invoices a month, no integration | The 20-minute check below |
| Several companies, a webshop, POS or ERP integration, a shared-service team | The full close, plus the API extraction if you use one |
| Your accountant keeps the books | The 20-minute check, then the accountant handover |
The 20-minute check for small businesses
- Open Factures (Invoices). In the top-bar date selector, choose Mois dernier (last month).
- Click the Number column header and scan the series: every missing number needs a reason, such as a deleted draft.
- Set Statut (status) to Brouillon (draft): finish or delete drafts that should not exist.
- 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.
- 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.
- In Peppol → Outbox, click Actualiser (refresh) and deal with any Erreur (error) or Pas sur Peppol (not on Peppol), as in step 5 below.
- 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:
| Day | Date | Work | Owner |
|---|---|---|---|
| 1 | Monday 2 November | Scope and cut-off, chase missing payments, extracts | Controller |
| 2 | Tuesday 3 November | Document list and gaps | Accounting |
| 3 | Wednesday 4 November | Settlement and bank | Accounting with treasury |
| 4 | Thursday 5 November | Peppol and archive exceptions | Operations |
| 5 | Friday 6 November | Review, sign-off, handover | Controller 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
- 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.
- 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.
- 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. - 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.
- Select the period's issued documents, click Download and count the PDFs in the ZIP against your list.
- Compare net, VAT per rate and Arrondi with your sales journal. For integrations, match on source
external_idandintegration_id, then on OrdoGrididand 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:
| Line | Meaning | Watch out |
|---|---|---|
| Invoice total | Net + VAT + Arrondi, frozen at issue | Can be a cent away from net + VAT |
| Prepayments | Deposits recorded when the invoice was created | Already inside the next line |
| Payments (including prepayments) | Confirmed money received, net of reversals | Never add Prepayments again |
| Credits | Linked credit notes, counted once | Reduce the debt; no cash moved |
| Completed refunds | Money returned, net of reversals | Recorded after it left your bank |
| Outstanding / Refund due | Owed by the customer / owed back by you | Today'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
- Find each bank credit, debit and card payout in the matching invoice's Movement history: same amount, reference and date.
- 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.
- A refund left your bank? Click Record refund; it shows only while Refund due is above zero.
- 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.
- 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
- 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).
- Act on every badge other than Traité:
| Badge | Meaning at the close | Action |
|---|---|---|
| Traité | Delivered over the network; not accepted, not paid | None |
| Créé, En file, En attente, Nouvelle tentative | Still in progress | Click Vérifier (check); never send again; contact OrdoGrid support after one working day |
| Erreur | Not delivered, or outcome unknown | Fix 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 Peppol | OrdoGrid found the customer when you sent, but no Peppol registration accepting this document was found at delivery | Ask 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 sent | Find the earlier transmission and its status; do not send again |
- 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.
- 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 withGET /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
| Category | Typical cause | Owner | Default action |
|---|---|---|---|
| Missing document | In the ledger or source system but not in OrdoGrid, or the reverse | Accounting | Find it by number or external_id; never recreate it blindly |
| Duplicate | The same order created twice | Integration owner | Credit the duplicate; fix the identity mapping |
| Amount or mapping | VAT rate, rounding or currency differs | Accounting | Explain per invoice; credit note if the invoice is wrong |
| Late registration | Money moved in the period, recorded after | Treasury | Record it with the real occurrence time |
| Missing cash evidence | No bank line behind a movement, or a legacy label | Treasury | Get the evidence; reverse the movement if no money came |
| Delivery | Erreur, Pas sur Peppol, a send in progress | Operations | Step 5; incident response if several invoices are hit |
| Timing at cut-off | Event near midnight, money in transit | Controller | Name 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, notpayments:read),credit_notes:readandpeppol:read.GET /api/v1/meconfirms the company and the key'sintegration_id. issue_dateis a calendar date: give bounds without a time-zone offset and end at23:59:59on the last day.- Lists return at most 100 rows, newest first. Note
pagination.totalbefore the first page and after the last; if it changed, de-duplicate onidand read again, or pause posting. - Each invoice carries
totals.gross(net plus VAT),totals.rounding,totals.payable(equal tosettlement.document_total) and its currentsettlement. - Movements carry
occurred_atandrecorded_atin 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. Atransmission_stateofuncertainmust 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:
| Document | Date | Customer | Net | VAT | Arrondi | Total | Peppol |
|---|---|---|---|---|---|---|---|
| F-2026-0181 | 2 Oct | Hotel Ter Duinen NV | 990.00 (740.00 at 6%, 250.00 at 21%) | 96.90 | – | 1,086.90 | Traité |
| F-2026-0182 | 9 Oct | Brasserie 't Pleintje BV | 114.04 | 23.95 | 0.01 | 138.00 | Traité |
| F-2026-0183 | 15 Oct | Café Sint-Rombout BV (webshop) | 2,000.00 | 420.00 | – | 2,420.00 | Traité |
| F-2026-0184 | 22 Oct | Bakkerij Verbeke BV | 462.50 | 27.75 | – | 490.25 | Erreur |
| NC-2026-0012 | 26 Oct | Hotel Ter Duinen NV, credits F-2026-0181 | −92.50 | −5.55 | – | −98.05 | Traité |
| Total | 3,474.04 | 563.05 | 0.01 | 4,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) | Amount | Source |
|---|---|---|
| Open at 30 September | 1,210.00 | September close pack |
| + Invoice totals issued | 4,135.15 | Four October invoices |
| − Credit notes | −98.05 | NC-2026-0012 |
| − Money received | −2,796.90 | 1,210.00 + 500.00 + 1,086.90 |
| + Refunds paid | +98.05 | 30 October |
| = Open at 31 October | 2,548.25 | F-2026-0182 138.00 + F-2026-0183 1,920.00 + F-2026-0184 490.25 |
What the close found:
| Finding | Category | Action |
|---|---|---|
| F-2026-0164 (€605.00, September) shows Payée but €605.00 outstanding and the legacy warning: OrdoGrid's opening balance was €1,815.00 | Missing cash evidence | The 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.05 | Late registration | Treasury 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 open | Timing at cut-off | A 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 open | Amount or mapping | Correct: 2,420.00 − 500.00 = 1,920.00 |
| Sales journal net + VAT €4,037.09, OrdoGrid €4,037.10 | Amount or mapping | The €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 invoice | Delivery | Cause 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
| Situation | Correct action |
|---|---|
| Credit note for a period invoice, issued after the close | Do not backdate it; its VAT is regularised in the period it is issued |
| Card payout net of fees | Payments 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 balance | Record 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 send | They 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.totalat start and end, and the key'sintegration_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
- FPS Finance – VAT calendar 2026 (Btw-kalender, in Dutch)
- Justel – Royal Decree no. 1 on VAT invoicing, art. 4 (issue deadline) and art. 5
- Belgian Official Journal, 27 February 2004 – Royal Decree amending Royal Decree no. 4, art. 5 §1 (VAT restitution in the current period)
- Belgian Official Journal – Law of 18 December 2025, art. 97 and 101 (7-year retention, art. 60 VAT Code)
- OpenPeppol – BIS Billing 3.0, PayableRoundingAmount (BT-114)
- OrdoGrid – Public API reference