This is the third article in our Xero Guide, which explains how you can export data from Moss and import it into Xero.
If you have any questions about how to connect Moss and Xero, 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
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. Moss uses the last date of the selected month as Bill date in Xero in this case.
Export invoices from Moss into Exact Online
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 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. Moss uses the last date of the selected month as bill date in Xero in this case.
Export reimbursements from Moss into Exact Online
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 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. Moss uses the last date of the selected month as bill date in Xero in this case.
One Reimbursement folder is posted as a single Bill to Pay into Xero with the expenses as line items. If the folder exceeds the maximum of 10 expense lines in Xero, Moss automatically creates separate folders.
Export balance movements from Moss into Exact Online
Export balance movements from Moss into Exact Online
Follow these steps to export your balance movements from Moss and import them into Exact Online.
Balance Movements are Wallet top-up payments, Credit repayments and Invoice and Reimbursements Wallet payments.
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. Moss uses the last date of the selected month as bill date in Xero in this case.
Please see the FAQ article on top-up reconciliation in Xero to learn more how these transactions reconcile on your bank accounts.
Export prepaid expenses from Moss into Exact Online
Export prepaid expenses from Moss into Exact Online
Follow these steps to export your prepaid expenses from Moss and import them into Exact Online.
Make sure you are in the “Prepaid expenses” tab.
Now select the prepaid expenses you want to export.
If you want to export all prepaid expenses 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.
Prepayment releases sync into Xero as “Manual Journal” entries.
How Moss posts into Xero
All transactions (card transactions, AP invoices, employee reimbursements) are posted as Bills to Pay in Xero with the coding from Moss and the receipts attached. Moss attaches an audit protocol in addition to the actual receipt.
To find the synced transactions open “Business” > “Bills to Pay"
Bills which were paid with Moss (Credit Card transactions or Wallet payments for Invoices and Reimbursements) show as "Paid" while unpaid expenses appear as "Awaiting payment".
Looking at the Moss Balance Account bank account we find all Moss payments as already reconciled transactions as Moss does the receipt and statement reconciliation. No need to manually reconcile transactions in Xero.
The account balance will reflect your Moss statement balance if all transactions are synced.
You have now reached the end of the Xero Guide.
If you still have questions, we have additional articles about Xero.