Import Accounting Transactions (Journal)

Follow

You can easily import your Chart of Accounts from your old accounting system into Monchilla.

Note: This article is for importing accounting transactions (also known as journal entries) from a previously used double-entry accounting system. To import simple bank transactions, see Importing Bank Transactions.

Format Your File

To import your journal entries you need to put it into a format that Monchilla can understand. You can either use a free Google account or you can use a spreadsheet application.

Note: If you're working with a file that has extra rows such as the total of the transactions you don't need to delete those as they will be ignored.

Desktop Spreadsheet Application

If you use a spreadsheet application like Microsoft Excel click to download the CSV Journal TemplateThen remove the sample data and paste in your own.

Google Docs

If you don’t have a spreadsheet application you can use Google Docs. Click to open the Google Docs Journal Template.

Note: If you don’t already have a Google account, you can register for a free one at accounts.google.com.

Next, create an editable copy. Click File, then select Make a copy....

Enter a name for the file and click OK.

Now, in your copy of the spreadsheet, you can delete the sample data and paste in your existing records. Be careful not to delete or edit the column headings.

Export the Spreadsheet to .CSV Format

Once you have updated the spreadsheet entries, export the file. In the toolbar, click File, select Download as…, and select Comma separated values (.csv, current sheet).

The file is downloaded to your Downloads folder. 

Import the File to Monchilla

Now, open your Monchilla account. To navigate to the Import page, hover over Settings, and then click Import.

On the Import page, click Skip this Step three times to get to Step 4: Import Journal.

Next, click Select.

In the window that opens, select the .csv file you just exported, and click Open.

The selected filename will appear below. Now click Import Journal.

If the import is successful, the page will move ahead to Step 5: Import Open Invoices.

If the import fails, you will receive an error message. Check your Google spreadsheet against the template to ensure the formatting is correct. Even if the error message refers to the filename it is likely an issue related to the format of the data in the spreadsheet.

To verify that the transactions imported correctly click Accounting and then Ledger and set your date range. You should now see the transactions you imported.

You've now successfully imported your journal.

Have more questions? Submit a request

Comments

Powered by Zendesk