How to Use The Journal Import Wizard

Zumzum Financials Knowledge Base

    How to Use The Journal Import Wizard

    Overview

    The Zumzum Financials Journal Import Wizard will take a CSV file and create a draft journal. Once the draft journal is created you may edit, delete or post the journal to the general ledger.

    Journal Import Wizard Steps

    Below is a description of the main steps to prepare and import a draft Journal into Zumzum Financials.

    1. Download the Sample Journal Import Template file
      • Do not change the column order
    2. Prepare your journal import data file
      • Use the name of the Tax Rate to reference the Tax Rate in your system.
      • Use the Nominal Code.
      • Use the Dimension Name
    3. Import data with the Journal Import Wizard
    4. Edit, delete or  post the draft Journal in the Zumzum Financials web interface

    1. Download the sample import file

    1. You can download the Sample Import File here: Sample Journal Import Wizard CSV Template
    2. Make a copy so you can edit and save your own custom template.

    2. Prepare your journal import data file

    1. Open up your Sample Journal Import File.
      • Do not change the column order when editing.
    2. Remove all the sample data in the sheet other than the column headings.
      • (do not change the column order)
    3. In the Nominal Code column, enter the Nominal Code from the Nominal Account record.
    4. In the VAT column enter the Name from the Tax Rate record.
    5. In the Debit column, enter the value as 2 decimal points
    6. In the Credit column, enter the value as 2 decimal points
    7. You can Add the Dimensions by using the Dimension Name
    8. Please ensure your Debits and Credits  balance to 0 to ensure your Journal is imported correctly
    9. Your Journal Import Wizard import file should now look something like this (example in a Google Sheet):
      • Please remove any extra columns added by your spreadsheet.

    3. Use the Journal Import Wizard

    Follow these steps to take your Journal Import Wizard file and create a draft journal in Zumzum Financials.

    1. To access the Import Wizard go to the Transaction Tab,
    2. Select the Import Journal icon to start the Journal Import Wizard
    3. Select Upload File and select the CSV file which contains your journal line items.
    4. Click Next to be able to Review the Journal  Line items to ensure that they have all been entered correctly.
    5. Add any  Reference to help you identify the source of the journal.
    6. Edit the Posting Date if you wish to have another date than the default date of today.
    7. Select Insert Record when you are happy all the information is correct.
    8. The system will then confirm that the records have been uploaded successfully.
    9. Use the View journal record link to go directly to your imported Journal.
    10. Select Upload Again if you wish to import another journal
    11. Select Finish to close the Journal Import Wizard.

    3.1 Use the Journal Import Wizard Global Action (Lightning Only)

    1. Go to the Global Actions list on the top right-hand side of any Salesforce page and select Journal Import Wizard.
    2. You will see a popup with the Journal Import Wizard, so increase the size to make it easier to work in
    3. Select Upload File and select the CSV file which contains your journal line items.
    4. Click Next to be able to Review the Journal  Line items to ensure that they have all been entered correctly.
    5. Add any  Reference to help you identify the source of the journal.
    6. Edit the Posting Date if you wish to have another date than the default date of today.
    7. Select Insert Record when you are happy all the information is correct.
    8. The system will then confirm that the records have been uploaded successfully.
    9. Use the View journal record link to go directly to your imported Journal.
    10. Select Upload Again if you wish to import another journal
    11. Select Finish to close the Journal Import Wizard.

    4. Edit, Delete or Post Your Imported Journal

    Once your Journal record is imported, you will be able to edit and process your Journal in the same way you would if you had created the Journal in the Zumzum Financials web interface.

    After the Journal Import Wizard has completed processing your request, next to the green tick is the option to View journal record so click this link to go directly to your imported Journal.

    At any other time, you can return to your draft journals. Go to the Journal Tab and in your preferred list view, find your most Recent journal or your list of draft journals.  Follow this help article to edit and post your journal.

     

    in Journal Import Wizard Tags: Data ManagementImportJournalWizard