This is the third article in our Exact Online Guide, which explains how you can export data from Moss and import it into Exact Online.

If you have any questions about how to connect Moss and Exact Online, please read the first and second article in the guide first.

You can export all your data from Moss directly into your accounting system.

Here you can read instructions on how to export the various data.

Follow these steps to go to the export page:

Open Moss
Click on “Export” in the feature overview
Now go to one of the instructions below, depending on which expenses you want to export.

Export card transactions from Moss into Exact Online

Follow these steps to export your card transactions from Moss and import them into Exact Online.

Make sure you are in the “Card Transactions” tab.
Now select the card transactions you want to export.
If you want to export all transactions at once, simply click on the box at the top of all items to select all.
To export the items, click on “Export items.” The number will change depending on how many items you have selected.
A side window will open where you have to click on “Export” at the bottom.
If you want to post into an accounting period different from the transaction date, you can select a period from dropdown. Please select the checkbox first, then select a period. Moss will then post transactions into that period.

Export invoices from Moss into Exact Online

Follow these steps to export your invoices from Moss and import them into Exact Online.

Make sure you are in the “Invoices” tab.
Now select the invoices you want to export.
If you want to export all invoices at once, simply click on the box at the top of all items to select all.
To export the items, click on “Export items.” The number will change depending on how many items you have selected.
A side window will open where you have to click on “Export” at the bottom.
If you want to post into an accounting period different from the invoice date, you can select a period from the dropdown. Please select the checkbox first, then select a period. Moss will then post the invoice into that period.

Export reimbursements from Moss into Exact Online

Follow these steps to export your reimbursements from Moss and import them into Exact Online.

Make sure you are in the “Reimbursements” tab.
Now select the reimbursements you want to export.
If you want to export all reimbursements at once, simply click on the box at the top of all items to select all.
To export the items, click on “Export items.” The number will change depending on how many items you have selected.
A side window will open where you have to click on “Export” at the bottom.
If you want to post into an accounting period different from the invoice date, you can select a period from the dropdown. Please select the checkbox first, then select a period. Moss will then post the invoice into that period.

Export balance movements from Moss into Exact Online

Follow these steps to export your balance movements from Moss and import them into Exact Online.

Make sure you are in the “balance movements” tab.
Now select the balance movements you want to export.
If you want to export all balance movements at once, simply click on the box at the top of all items to select all.
To export the items, click on “Export items.” The number will change depending on how many items you have selected.
A side window will open where you have to click on “Export” at the bottom.
If you want to post into an accounting period different from the transaction date, you can select a period from dropdown. Please select the checkbox first, then select a period. Moss will then post transactions into that period.

Export prepaid expenses from Moss into Exact Online

If you have the deferred cost (prepayments) account set-up in Exact Online, we will automatically export the transactions to this account when they have expense start and end dates that are different from the invoice date.

Please type in the Prepayment (Deferred Costs) Account number into Moss or set it up in Exact Online.

Learn more in this article.

How Moss posts into Exact Online

All transactions (card transactions, AP invoices, employee reimbursements) are posted as purchase entries in Exact Online with the coding from Moss and the receipts attached. Moss attaches an audit protocol in addition to the actual receipt.

You can find Moss exports under “Purchase” > “Invoices” > “Overview” in your administration.
All transactions appear as outstanding invoices, even when they have been paid from Moss (as credit card payment or wallet transfer). This is because Exact requires users to reconcile payments on their side.
All purchase entries have the documents from moss attached. Moss attaches an Audit protocol as an additional document to document expense processes in Moss
For all transactions that have been paid from Moss the integration automatically creates entries in the bank journal linked to the Moss account. From there you can reconcile the payments.
Open “Financial” > “Bank & Cash” > “Bank entries” > “Overview”
Identify the Moss Balance Account with an open balance or outstanding items. Then open the Moss Balance Account bank journal and “Process” the transactions.
To reconcile the payments open “Financial” > “Bank & Cash” > “Statements” > “to be completed”. This page shows a list of all unreconciled transactions.
You can filter for your Moss Balance account (optional) and click “automatic” in order to reconcile payments.
The Purchase entries will then appear as “Paid”.