How to Import Budgets Using Excel Templates in QNE Optimum

Overview:

QNE Optimum allows users to maintain monthly budgets by account. To make data entry faster, you can export the Budget Maintenance template to Excel, edit the budget figures there, and then import it back into the system.

Scenario:

You want to prepare a budget plan in Excel for multiple accounts and upload it back into QNE Optimum without manually encoding everything.

Procedure:

Step 1 – Open Budget Maintenance

1. Go to General Ledger > Monthly Budget from the Navigation Pane.

2. The Budget Maintenance screen will appear.
    

Step 2 – Export Template to Excel

1. On the Budget Maintenance screen, right-click anywhere on the data grid.

2. Select IO > Export > to Excel.

3. The system will prompt you to save the file.

   • Choose a location on your computer.

   • Rename the file if needed (e.g., Budget Maintenance 2025).

   • Click Save.

4. The Excel file will be generated containing account codes, descriptions, and months (Jan–Dec).
    
   
    

Step 3 – Fill in the Budget Data in Excel

1. Open the exported Excel file.

2. Enter your budget amounts per account per month.

   • Example: For Account 101-0000 (Metrobank), you may input values under Jan, Feb, etc.

3. Save the Excel file once done.
    

Step 4 – Import Budget from Excel

1. Go back to Budget Maintenance in QNE Optimum.

2. Right-click on the grid again, then select IO > Import > from Excel.

3. Browse and select the updated Excel file.

4. Click Open, and the system will load your budget amounts into QNE Optimum.
   
   
    

Step 5 – Verify and Save

1. Review the imported data on the screen to ensure values are correct.

2. Click Save (under Common Tasks) to finalize.
   
   
   
   

Application

• This feature is useful when preparing annual budgets across multiple accounts.

• Instead of encoding manually, accountants can collaborate in Excel and then bulk import the data.

• Ensures accuracy, efficiency, and faster budget preparation.