How to Export Transactions to Jurnal using Custom CSV – Spenmo

Role: ✔ Accountant, ✔ Admin, ✖ Team Manager, ✖ Employee, ✖ Bookkeeper

This article will serve as a guide on how to export transactions from Spenmo using Custom CSV and importing it into Jurnal.

Setup

In order to get the best results with Custom CSV, it is recommended that you adopt the following setup:

Chart of Accounts

Ensure that you have created Categories for each Expense account in Jurnal and that the Account Code set in Spenmo is the same as the Account Code set in Jurnal.

Tax (GST)

Ensure that you have created Tax Name and Tax Rate in Spenmo. You can also set default Tax on your categories so that a tax rate is auto-attached to a transaction under a specific category.

Transactions

Ensure that all your transaction details are correctly filled with the necessary information (Category, Tax, Vendor, Notes, etc.) before you export the file as CSV.

Export Transactions from Spenmo

In your Spenmo dashboard, you can export 4 types of data transactions using Jurnal CSV templates.

Bank Statement
Purchases
Expenses
Refund and Reversal

To make the most out of the exported CSV, we recommend inputting your Spenmo Bank Account Code. This account code is the one used for your Spenmo Bank Account and can be found under the ‘Cash & Bank’ page inside Jurnal.

Note: For Purchases, you will need to input the Product information in the CSV manually before it can be uploaded to Jurnal.

Import Transactions Inside Jurnal

After downloading the data, you can import the file into Jurnal. This section will serve as a guide on how to do so based on the type of data you have exported from Spenmo.

A. Bank Statement

On your Jurnal dashboard, click ‘Cash & Bank’ on the side left bar.

2. In the ‘List of Accounts’ section, look for Spenmo and click ‘Import Bank Statement’.

3. On the Import your bank statements page, you can skip the first two steps and proceed directly to Step 3: Import the template file. Click ‘Choose File’ and select the CSV file you want to import.

4. Next, proceed to complete Step 4: Choose Existing Account Name and Step 5: Choose Bank Partner. For step 4, you can choose Spenmo as an existing account name for importing bank statements.

5. After you have completed the steps, click ‘Import’.

B. Purchases

1. On your Jurnal dashboard, click ‘Purchases’ from the left sidebar.

2. On the Purchase Transactions section, click ‘Import’.

3. On the Import Purchase Transactions pop-up screen, you can skip the first two steps and proceed directly to Step 3: Upload CSV template. Click ‘CHOOSE FILE’ and select the CSV file you want to import.

4. After the file upload is complete, click ‘Proceed’.

5. You will receive a notification email after the data import is finished.

C. Expenses

1. On your Jurnal dashboard, click ‘Expenses’ from the left sidebar.

2. On the List of Expenses section, click ‘Import’.

3. On the Import Expenses pop-up screen, you can skip the first two steps and proceed directly to Step 3: Upload CSV template. Click ‘CHOOSE FILE’ and select the CSV file you want to import.

4. After the file upload is complete, click ‘Proceed’.

5. You will receive a notification email after the data import is finished.

D. Refund & Reversal

1. On your Jurnal dashboard,click ‘Chart of Accounts’ from the left sidebar.

2. Click ‘Actions’ button. Then, click ‘Import Journal Entry’.

3. On the Import General Journal pop-up screen, you can skip the first two steps and proceed directly to Step 3: Upload CSV template. Click ‘CHOOSE FILE’ and select the CSV file you want to import.