1. Setting up Twinfield

2. Accounting set-up in Moss

3. Creating export formats in Moss

4. Exporting your transactions

5. Importing your transactions into Twinfield

6. Matching purchase and bank transactions

1. Setting up Twinfield

To make sure your Moss transactions are correctly exported to Twinfield, we will need to create 4 different accounting attributes in Twinfield: purchase journal, balance account, Moss default supplier and bank account.

1.1 New Purchase journal

To start, we will have to create a new purchase journal to be able to export your transaction receipts from Moss to Twinfield, without interfering with the configurations of your existing purchase journal.

To do so, go to Company settings > Transaction types > Type the code for the new journal (for example, INK2) and click Next. Then, select Purchase invoice in the Transaction type category drop-down and click Next once more.

Once in the journal settings page, name the new journal and scroll all the way down to Document imaging. Setting this up correctly is of major importance, as it will allow us to easily link receipts in Moss to the corresponding purchase entries in Twinfield.

How does document imaging work? In this section we will define the base URL of the receipt in Moss (https://getmoss.com/app/transactions/all/view/) and indicate in which field will the transaction identifier be provided. In the case of Moss, the transaction identifier will be provided by the Description field. When an entry is created, Twinfield will combine base URL and entry description to generate the receipt URL.

To set it up, provide a Name, fill the Link field with the following value (https://getmoss.com/app/transactions/all/view/$Description$) and click Save:

1.2 New Balance account

Open the left navigation panel > Financial professionals > Dimensions > Balans > Click First free code, as shown in the screenshot below and move to the next page.

Once there, name the new balance account as you wish and click Save:

1.3 New Moss Default Supplier

All transactions you make with a Moss card will be booked to the same Moss Default Supplier. Hence, you will need to create this supplier in Twinfield so that you can later define it as your default supplier in the Moss app.

To create a new supplier for Moss, open the left navigation panel > Purchase > New suppliers > name the new supplier and click Save.

1.4 New (dummy) bank account

To create a new bank account, go to Cash & Banks > Bank accounts > click New bank account and complete the New bank form as desired. For the Account number, since it is not yet possible to create a Moss bank account, we will have to provide a fictitious account number: select Account type = BBAN and use Account number = 0123456789.

Next, click Create and go to account settings > Select Bank statement processing on the left panel > fill the form as shown in the screenshot below and click Save:

2. Accounting set-up in Moss

2.1 General set-up

Once we have created the required accounting resources in Twinfield, we can start the accounting set-up in the Moss platform.

Log in to your Moss account, go to Accounting > General setup and use the codes of the Balance Account and Supplier Account created earlier in Twinfield to populate these fields. For the Cash in Transit field, we are going to be reusing your Twinfield crediteuren account, most likely with code 1600.

2.2 Importing accounting attributes

Once you have completed the general setup, we will have to import your Twinfield accounting attributes into Moss, meaning Expense Accounts (Winst & verlies), Suppliers (Leverancies), VAT Rates (BTW), Cost Centers (Kostenplaatsen).

All resources except VAT rates can easily be downloaded from Twinfield. We recommend exporting them in Excel format, formatting them to the format required by Moss, saving the file in CSV format and importing it into Moss. For example, for Expense accounts, go to Financial professionals > Dimensions > Winst & verlies and click Export all.

Once in the File Manager view, click on the file name to download.

Format the file as shown below, keeping only the Name and Account Number columns in this specific order and save it in CSV format.

Then, go back to the Moss platform > Accounting > Expense Accounts, click Add / Import Subcategory and upload your CSV file containing your Twinfield balance accounts.

Repeat the operation with Suppliers (Leverancies), VAT Rates (BTW), Cost Centers (Kostenplaatsen).

3. Creating export formats in Moss

Your Moss transactions can be exported to Twinfield’s Purchase and Bank journals by means of CSV files. For ease of use, we have created two predefined export formats that you can easily add to your Moss account.

What is an export format? An export format allows us to structure and format the data stored in Moss to meet the requirements of the accounting system, in this case Twinfield, going from column order, to column and decimal separators, amounts formats, etc.

As mentioned above, the transactions created in Moss need to be exported to both the Purchase and Bank journals in Twinfield. Since they have different import requirements, two different export formats will have to be created: Twinfield Purchase and Twinfield Bank.

3.1 Purchase format

To create a new export format in Moss, you will need to go to Accounting > Export Formats and click Create export format, which will open the Format Preferences. Once you have named the export format, open the Base template drop-down, select Twinfield CSV - Purchase and click Continue:

When landing in the Columns page, you will see that the mapping is already predefined. This mapping is intended to meet the requirements of the average Twinfield set-up. Nevertheless, if you have specific wishes, the export format can easily be customized. Please note however that Twinfield is very strict when it comes to the number of columns and their position within the CSV file. As a result, we strongly advise limiting the changes to the Data source column.

  • Name column: column header of your CSV file (row 1);

  • Data source: values in Moss that will fill the body of each column (row 2 to n).

Export file example:

3.2 Bank format

After creating the Purchase export format, you will have to follow the very same flow to create a bank format.

4. Exporting your transactions

Once you have created the required export format, you are ready to start exporting your transactions. To do so, you will have to go to Cards > Export > Export Queue, Then, select the transactions to be exported and finally Click Export.

Make sure to select the Twinfield Purchase export format in the File format drop-down and click Download to generate the CSV file to be imported in the purchase journal:

Now, select the Twinfield Bank export format and click Download once more. If you would like to Mark transactions as Exported, make sure to check the relevant box:

5. Importing your transactions into Twinfield

5.1 Importing purchase transactions

To import you transactions, open the file manager, browse and upload the CSV files previously downloaded from Moss > click the blue menu button and select Import:

Once in the next page, open the Template drop-down and select the Purchase/sales transactions (CSV,FLV,XLS) import format, and click Process.

Wait a few seconds and click the blue Refresh icon to update the import status. Once finished, if the import is successful, the Status column will show green:

To view the created purchase transactions, go to Financial professionals > Transactions > Provisional transactions > Inkoopfactuur > Sort by transaction number descending:

5.2 Importing bank transactions

After the Moss Dummy account is created, you are ready to start importing transactions. Once again, open the file manager, browse and upload the CSV files previously downloaded from Moss > click the blue menu button and select Import.

Unlike with the import of purchase transactions, for bank transactions we will have to create a new import format by clicking the orange New button.

Name the import template, make sure that comma is selected as the field separator and map the Value column as shown in the screenshots below:

After saving the template, you will be redirected back to the import view. Make sure to fill the Bank code with the bank code of the Moss Dummy Account as shown below and click Process:

Wait a few seconds and click the blue Refresh icon to update the import status. Once finished, if the import is successful, the Status column will show green.

6. Matching purchase and bank transactions

Finally, to confirm the creation of the bank statement, go to Cash & Banks > click the orange Bank statements button > Select the bank statement on the table and click Post.

Once the bank statement is posted, the matching of purchase and bank transactions will take place automatically. To see the matched transactions, open the side panel > click Financial Professionals > Transactions > Transaction lines > Crediteuren > Click Next find the posted purchase and bank transactions and make sure that Payment status = Matched:

War diese Antwort hilfreich für dich?