This is the first article in a guide that will walk you through the process of connecting Moss and QuickBooks Online. If you follow this guide step by step, you will have successfully connected Moss and QuickBooks by the end.
Moss only supports a direct integration with QuickBooks Online. To exchange data with QuickBooks Desktop you can use our custom CSV export formats.
Purpose of this article:
This article guides you through the steps you need to take before connecting Moss and QuickBooks. By connecting Moss to QuickBooks, you can create Moss purchase and bank journals, a dummy supplier account for transactions and one for top-up payments and give the right user the necessary permissions. This ensures that the data flow works from day one, without queries or manual corrections.
Quick checklist (before you connect)
Note: Before connecting Moss with QuickBooks, make sure you have Administrator access for the QuickBooks entity you want to connect.
Create a Moss Balance Account in QuickBooks (mock bank account to record Moss payments and top-ups and to reflect your Moss Wallet balance)
Optional: Create a Default Supplier in QuickBooks for Moss transactions without a specific vendor (MOSS DEFAULT SUPPLIER)
Moss Balance Account
If you use a Moss Credit account, you may have to set up two mock bank accounts. One for your Moss Credit balance and one for your Moss Wallet balance.
Set up the Moss balance account
Set up the Moss balance account
In QuickBooks, go to "Accounting" > "Chart of Accounts" → Click “New account”
Enter a name “Moss Wallet Balance Account”, select “Cash bank and in hand” as Account Type and “Cash on hand” as Detail type. Then save.
Note: Make sure the account is created in your Moss account currency (GBP in the UK).
Default Supplier (Optional)
Moss allows posting Credit card transactions on a single collective supplier account (your Moss Default Supplier) in QuickBooks. Alternatively you can select posting transactions against the respective supplier accounts of the merchant. Also a hybrid approach is possible. In this case you would assign single suppliers to larger subscriptions and invoice payments via Moss cards, but use a single collective Moss supplier for all other spend (such as smaller employee expenses).
If you want to post FX conversion fees or Pay with Moss payment fees as separate expenses, Moss also requires a Default Supplier for these transactions.
Set up a default supplier
Set up a default supplier
Navigate to "Accounting" > "Expenses & Bills" > "Suppliers", click “New Supplier”
Name it “Moss Default Supplier”, then save.
You have finished the preparations.
You are now ready to start connection Moss and QuickBooks.