Creating an Import Journal Entry
Objective
To create a journal entry by importing data from an Excel or CSV file using the Import function in the Journal Entry section of the Home Source Accounting System.
Key Steps
Access the Journal Entry section and click on the option to create a new entry.
Select the Import option, which will open a window titled "Import Journal Entry" with a template for data input.
Download the template provided and fill in the required fields:
Account number (full account number)
Type of account (e.g., current asset)
Description
Debit amount
Credit amount
Date
Ensure the data is formatted correctly by removing commas and special characters from debit/credit amounts and adding the full account number.
Optionally, create a manual journal entry first to understand the format, then use the information from post reports to fill out the template accurately.
Upload the CSV file containing the data with fields for account number, type of account, description, debit, date, and credit.
Review the imported data, make any necessary changes, such as adjusting dates, and ensure debits and credits match.
Click on "Post" to finalize the journal entry.
Cautionary Notes
Ensure the data in the CSV file matches the required fields in the template to avoid errors during import.
Double-check the formatting of the data to ensure accuracy in the journal entry.
Tips for Efficiency
Utilize post reports to gather accurate information for filling out the import template.
Save time by creating a standard import template for recurring journal entries and make minor adjustments as needed.
Regularly review and reconcile imported journal entries to maintain accurate financial records.