Integration with Exact Online and Exact Globe
Connect your POS system to Exact Online
SmartPOSapp turns your till day into a journal entry with the right ledger accounts, VAT codes and payment methods. You export the file and read it into Exact — no more retyping receipts and no separate spreadsheets for your accountant.
What exactly is exported?
- Daily revenue per VAT rate (21%, 9% and 0%), split by revenue ledger account
- VAT payable per rate on the VAT ledger account with the matching VAT code
- Payment methods as offsetting entries: card, cash, gift voucher and online payments
- Cash difference from the day closing as a separate line, so the journal entry stays balanced
- Tips and cash withdrawals as separate booking lines when you register them
- Document number and date per till day, so every line can be traced back to the Z-report
Step-by-step: setting up the integration
- 1
Collect ledger accounts in Exact Online
In Exact Online, note your ledger accounts for high-rate revenue, low-rate revenue, VAT payable, cash, card receivables and gift vouchers, plus the VAT codes per rate and your memorial journal code.
- 2
Fill in the chart of accounts in SmartPOSapp
Open Accounting in SmartPOSapp and enter the matching ledger account and VAT code per revenue category, VAT rate and payment method. You only do this once.
- 3
Choose a period and select the export format
Choose the period you want to book — a day, a week or a month — and select the format 'Exact Globe / Exact Online (CSV)'.
- 4
Download the file
Click export. You get a CSV with journal entry lines per till day; the file is named exact-memoriaal-<period>.csv.
- 5
Import into Exact Online
In Exact Online, go to the import function for bookings, choose your memorial journal and upload the file. Check the proposed lines before processing.
- 6
Check against the Z-report
Compare the total of the booking with the Z-report for the same day. If revenue, VAT and payment methods match, the integration is set up correctly.
Columns in the export file
The file is a CSV with a semicolon as separator. These columns are included, in this order:
| Column | Content |
|---|---|
| Journal | Your memorial journal code from Exact, for example MEMO or KAS. |
| Document | Date in yyyymmdd, so every till day has one document number. |
| Date | Booking date in dd-mm-yyyy. |
| Ledger | The ledger account you configure per revenue category, VAT and payment method. |
| Description | Recognisable text, for example 'Revenue 9% 14-08-2026'. |
| Debit / Credit | Amount in euros with a period as decimal separator. |
| VATCode | The VAT code from Exact that you link per rate, for example 1 or 2. |
| VATAmount | The VAT amount for that line. |
Does your accountant use a different package? You can export the same data to Twinfield, SnelStart, e-Boekhouden.nl, Moneybird, Yuki, AFAS, King and Unit4, or as a universal XAF 3.2 audit file.
Frequently asked questions
Is this a direct API connection with Exact Online?
No. SmartPOSapp creates an import file that you read into Exact Online. This works with any Exact subscription and you don't need to buy a connection licence or extra add-on. You stay in control of what you process.
What exactly is exported?
Per till day, a journal entry with revenue per VAT rate on your revenue accounts, the VAT payable with VAT code, the payment methods as offsetting entries and, if present, the cash difference and tips.
Does it also work with Exact Globe?
Yes. The 'Exact Globe / Exact Online (CSV)' format uses the same column layout with journal, document, ledger, debit, credit and VAT code, which both packages can read.
Can I book per venue?
Yes. You export per venue and can set different ledger accounts or a different journal per venue, so revenue stays separated in Exact.
How often do I need to export?
That's up to you. Many business owners export once a month for the VAT return; if you want your accounting up to date daily, export after the day closing.
What if my accountant uses a different package?
Besides Exact, there are formats for Twinfield, SnelStart, e-Boekhouden.nl, Moneybird, Yuki, AFAS, King and Unit4, plus a universal XAF 3.2 audit file that almost every Dutch package can read.
Your accounting done in a few minutes each month
Set up your chart of accounts once and export with a single click every period after that.
Buy a POS system — instalments available
Buy the complete till set with touchscreen till, cash drawer and receipt printer. With a yearly contract you pay in monthly instalments. We install and set everything up on site.