Journal Entry Import from CSV file (QuickBooks) : Windward Software Customer Care

Journal Entry Import Overview

The Journal Entry Import option has been added to 7.0.0.1533 or greater which allows importing from a third-party CSV file.

A new Journal Import module was added under General Ledger – Journal Entries. This allows the import of journal entries similar to the required format in System Five. This is done in the CSV file format saved from your payroll program.
Journal entries from the payroll software need to be exported and saved as a CSV file. Choose the file to import in the Journal Import window after creating and selecting a Journal template.
Column Type and Transaction Start needs to be configured from the data table once the CSV file is loaded.

Enhancement Release: 7.0.0.1533

Enhancement Area: Payroll Item

Enhancement TFS Ticket: 77553 - Journal Entry Import (Payroll)

Business Case

Problem:

Previous versions of System Five did not offer an option to import Journal entries from a file saved from third-party software such as QuickBooks. This creates additional workload to enter journal entries into System Five. It can impact a businesses efficiency and accuracy of data given the time spent to manually input data twice.

As a customer, I want to be able to transfer journal entries from my payroll software to System Five without entering the same data twice.
As a customer, I need all the information on the journal entries from my payroll to be transferred/copied accurately to System Five.

Solution (Workflow):

Journal entries from the payroll software need to be exported and saved as CSV file. Choose the file to import in General Ledger – Journal Entries > Journal Import window after creating and selecting a Journal template.

Assumptions:

This module is especially valuable to customers using payroll software that has the ability to export csv file for journal entries.
Note that there’s a format provided for the CSV Journal import. The exported file from your payroll software should be of similar format.
Column Type and Transaction Start need to be configured from the data table once the CSV file is loaded.

Enhancement User Interface

Navigate to General Ledger > Journal Entries > Journal Import.

You will need to create a new template and choose a file to import.

Create a New Template
Load and Select the CSV file to import
Select the column type for each column by clicking on the column header then selecting the Column type in the drop-down box.
If you want only to import certain entries such as Journal Entries, for the Column Type Transaction Type select the start of each Journal you wish to import
3. JournalDesc - optional journal entry name. This is required if you do not have a transaction type to separate one journal from another.
4. LineDesc - optional line description
5. AccountName - the ledger account name or account number
6. Credits/Debits - the credits or debits column, or use the Amount Column
7. Posted - a Y or N for posted, this is currently not used
8. Credit / Debit Flag - option for use with Amount column
Import. The import will interpret the loaded file and show on the Processed File
Match Account Names or Numbers with the correct Account number. To do this, click on the account name/number, select the account in the Ledger Account drop down above and then press Set To. Note that the account name to number mapping is stored globally in the template file, so if you make a new template, the existing mappings will be there.
Once you have all the ledger numbers assigned, the Create column should show a check mark if the debits and credits match.
The template file is stored in the Shared directory /LedgerImportSettings.xml.
If the debits and credits don't match you can use the Post Differences to Clearing Account to balance
You can now use the menu Journals and "Create Journals" to create the entries. Only those with a check box will be created. You can click on the icon to toggle in the Create column or X with the option to create for journals that don't balance which can then be manually adjusted.
The Journal entry numbers will show in the Journal column, or an error message if not successful. The Journal entry will still be created if there is an error.
Post Created Journals will post all journals that can be posted.
Delete Created Journals will delete all the journals that were created.
The Edit Journal button will edit the journal entry created.