This is the third article in our NetSuite 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 NetSuite, 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 and post card transactions
Push card transactions from Moss into NetSuite
Push card transactions from Moss into NetSuite
Follow these steps to export your card transactions from Moss and import them into NetSuite.
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.
How card transactions appear to NetSuite
How card transactions appear to NetSuite
In NetSuite open “Transactions” > “Payables” > “Edit Bills” > “List”
View Transactions exported from Moss in list. You can filter by recently created bills to see the latest exports. Card transactions are exported with status “Paid In Full”.
You can open the bill and see the booking details, navigate to accounts and view the attached receipt file (under “Communication”).
View GL Impact under “Action” > “GL Impact”
View the GL Impact. A Moss card transaction credits the Account's Payable account and debits the expense or spend account.
The Bill Payment can be found under “Related Transactions”. It opens when pressing the date.
The Bill Payment balances the vendor account and uses the Moss Balance Account to pay the bill.
Open GL Impact of Bill Payment under “Action” > “GL-Impact”
View the GL Impact of Bill Payments. The Moss Balance Account gets credited, the Accounts Payable gets debited.
Export and post invoices
Push invoices from Moss into NetSuite
Push invoices from Moss into NetSuite
Follow these steps to export your invoices from Moss and import them into NetSuite.
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.
How invoices appear NetSuite
How invoices appear NetSuite
Moss exports complete posting records with attached documents as “Bills” in NetSuite. Bills can be paid through NetSuite, or accountants can book the payment for each bill.
In NetSuite, open “Transactions” > “Payables” > “Edit Bills” > “List”
View Transactions exported from Moss in list. You can filter by recently created bills to see the latest exports. Card transactions are exported with status “Paid In Full”.
You can open the bill and see the booking details, navigate to accounts and view the attached receipt file (under “Communication”).
View the GL Impact. A Moss card transaction credits the Account's Payable account and debits the expense or spend account.
Export and book reimbursements
Push employee reimbursements from Moss into NetSuite
Push employee reimbursements from Moss into NetSuite
Configure Reimbursement export options:
When exporting your reimbursements from Moss to Netsuite, you can decide to receive them as :
Option 1: Vendor Bills
Option 2: Expense Reports
You can toggle between the two settings in the Accounting Integration setup page under "Settings" > "Accounting" > "Accounting Integration", at the bottom.
Should you choose to export as expense reports, please make sure to sync your suppliers and chart of accounts, to import your expense categories as expense accounts in Moss and your employees as suppliers in Moss.
You will need this information when filling out the pre-accounting details for a reimbursement.
Follow these steps to export your reimbursements from Moss and import them into NetSuite:
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.
Post reimbursements in NetSuite
Post reimbursements in NetSuite
There are two options how you can post your reimbursements in NetSuite.
As Vendor Bill
As Expense Report
You can read how to toggle between the two options in the section "Export reimbursements from Moss into NetSuite" above.
Post reimbursements as Vendor Bills
Post reimbursements as Vendor Bills
1. In NetSuite open up “Transactions” > “Payables” > “Edit Bills” > “List”
2. View Reimbursements exported from Moss in the list. You can filter by recently created bills to see the latest exports. Reimbursements are exported with status “Open” if they were not paid from your Moss Wallet balance. They are exported with status “Paid in Full” if paid from the Moss Wallet balance.
3. You can view the bill and see the booking details, navigate to accounts and view the attached receipt under "History" > "Files".
4. View GL Impact under “Action” > “GL Impact”
5. View the GL Impact. A Moss reimbursement transaction credits the Accounts Payable account and debits the expense or spend account.
If paid from your Moss Wallet Balance (Pay with Moss)
The Bill Payment can be found under “Related Transactions”. It opens when pressing the date.
Post reimbursements as Expense Report
Post reimbursements as Expense Report
Note:
Enable Expense Reports for reimbursement exports in "Settings" > "Accounting" > "Accounting Integration" tab
Sync suppliers to import employees as a supplier and sync chart of accounts to import categories.
Reimbursements now need an employee selected as supplier, and a category as the expense account.
1. In NetSuite open “Transactions” > “Employees” > “Enter Expense Reports” > “List”.
Moss reimbursements are exported with status “Approved by Accounting”.
2. You can view the details of the expenses
3. And the receipts under "Communication" > "Files"
If paid from your Moss Wallet Balance (Pay with Moss)
Moss will also create a Bill Payment and link it to the Expense Report.
Balance movements
Export balance movements from Moss into NetSuite
Export balance movements from Moss into NetSuite
Balance Movements include Wallet Top-up transactions or Credit re-payments, but also invice and reimbursement payments if these were paid from your Moss Wallet balance using Pay with Moss.
Top-ups- and Credit re-payments are posted into NetSuite using an in-transit account and must be reconciled against the outgoing bank transaction from your business bank account.
Follow these steps to export your balance movements from Moss and import them into NetSuite.
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.