Overview

The Opening Invoice Creation Tool helps you quickly import outstanding customer and supplier balances—without needing item-level details. This article shows how to use the tool for smooth and accurate data migration.

What is the Opening Invoice Creation Tool?

The Opening Invoice Creation Tool is a specialized tool in iVendNext designed to import outstanding balances for customers and suppliers. Unlike the standard Data Import Tool, this tool focuses solely on importing financial data, making it ideal for scenarios where item-level details are not required. Key features of the tool include:

• Import Outstanding Balances: Quickly import outstanding invoices for customers and suppliers.

• Create Missing Parties: Automatically create customer or supplier records if they don’t already exist.

• Excel Integration: Download and upload Excel templates for easy data entry.

When to Use the Opening Invoice Creation Tool

The Opening Invoice Creation Tool is particularly useful in the following scenarios:

1. System Migration: When moving from another accounting system to iVendNext.

2. Year-End Balances: Importing outstanding balances at the start of a new financial year.

3. Quick Setup: Setting up customer and supplier balances without detailed item data.

Step-by-Step Guide to Using the Opening Invoice Creation Tool

Let’s walk through the process of using the Opening Invoice Creation Tool to import outstanding balances.

1. Accessing the Opening Invoice Creation Tool

To access the Opening Invoice Creation Tool, follow these steps:

1. Navigate to Home > Accounting > Opening and Closing > Opening Invoice Creation Tool.

2. Click on New to create a new import.

2. Selecting the Company and Invoice Type

Once you’re in the Opening Invoice Creation Tool, fill in the following details:

1. Company:

• Select the company for which you want to import outstanding balances.

2. Invoice Type:

• Sales Invoice: For importing outstanding customer balances.

• Purchase Invoice: For importing outstanding supplier balances.

3. Create Missing Party:

• Check this box if you want the system to automatically create customer or supplier records for any new parties in your import data.

3. Filling in the Invoices Table

In the Invoices table, you can manually enter the details of the outstanding invoices or upload an Excel template. The table consists of the following fields:

1. Party:

• Select an existing customer or supplier, or enter the name of a new party.

2. Posting Date:

• The date on which the invoice will be posted.

3. Due Date:

• The date after which the invoice will be overdue.

4. Item Name (Optional):

• Enter the item name if you want it to appear in the invoice.

5. Outstanding Amount:

• Enter the outstanding amount for the invoice.

6. Invoice Number:

• Enter the invoice number from the previous system. If left blank, iVendNext will generate a new invoice number.

4. Using the Excel Template

To simplify data entry, you can download an Excel template, fill it in, and upload it back into iVendNext:

1. Click on the Download button to download the Excel template.

2. Fill in the template with the required data (Party, Posting Date, Due Date, Outstanding Amount, etc.).

3. Click on the Upload button to upload the filled-in template.

4. The system will automatically populate the Invoices table with the data from the Excel sheet.

5. Saving and Submitting the Import

Once all the details are filled in:

1. Click Save to save the import.

2. Review the data to ensure accuracy.

3. Click Submit to finalize the import.

Common Use Cases for the Opening Invoice Creation Tool

The Opening Invoice Creation Tool is used in a variety of scenarios. Here are some common use cases:

1. Importing Customer Balances

Scenario: You need to import outstanding balances for multiple customers from your previous system.

• Invoice Type: Sales Invoice

• Party: Select or enter customer names.

• Outstanding Amount: Enter the outstanding amounts for each customer.

• Submit: The system will create Sales Invoices for the outstanding balances.

2. Importing Supplier Balances

Scenario: You need to import outstanding balances for multiple suppliers from your previous system.

• Invoice Type: Purchase Invoice

• Party: Select or enter supplier names.

• Outstanding Amount: Enter the outstanding amounts for each supplier.

• Submit: The system will create Purchase Invoices for the outstanding balances.

3. Creating Missing Parties

Scenario: Some customers or suppliers from your previous system are not yet set up in iVendNext.

• Create Missing Party: Check this box.

• Party: Enter the names of the new customers or suppliers.

• Submit: The system will automatically create new customer or supplier records and import the outstanding balances.

Advanced Features of the Opening Invoice Creation Tool

iVendNext offers several advanced features to enhance the functionality of the Opening Invoice Creation Tool:

1. Excel Integration:

• Download and upload Excel templates for easy data entry.

• This is particularly useful for large volumes of data.

2. Automatic Party Creation:

• Automatically create customer or supplier records for new parties.

• This saves time and ensures that all outstanding balances are imported.

3. Customizable Invoice Numbers:

• Use invoice numbers from your previous system or let iVendNext generate new ones.

• This ensures consistency with your existing records.