Overview  

Prerequisites

1. Microsoft Office 365, or Microsoft Office 2013 or later, is installed on your computer.  
   
2. You have access to the required installation files from the following Google Drive folder:
   Download Installation Files
3. Have Windows 8 and above for smooth installation
   

Step-by-Step Installation Guide

Step 1: Download Required Files  

1. Visit the Google Drive Excel folder Link here.
   

Step 2: Install Office 2010 Tools Redistributable 

1. Locate the downloaded files.
   
2. Run the Office 2010 Tools Redistributable installer from your download folder.
   

Step 3: Click the License Agreement terms, then install the Office Add-In. 

1. Depending on your Excel version (x64 or x86), install the appropriate Office Add-In Installer.
   

 NB: Open Excel go to Account ->go to About Excel  then you will be able to see the Excel version 

(x64 or x86 relating to x32)

Step 4: Access the Assembly Locator  

1. Open your Local disk (C:\) go to Program Files (x86), find the Fiscal Harmony folder. Alternatively, enter the path C:\Program Files (x86)\Fiscal Harmony.
   
2. Navigate to the following path: Fiscal Harmony > MS Office > OfficeAddIn > Tools > Assembly Locator. 
   
3. Run AssemblyLocator.exe as an Administrator. 
   

Step 5: Create the "Custom Office Templates" Folder (if needed) 

1. Create a new folder named Custom Office Templates in your Documents folder. 
   
2. Rerun AssemblyLocator.exe as an Administrator. 
   

Step 6: Locate the Fiscal Harmony Template 

1. After successful installation, open your Documents folder and open the folder Custom Office Templates. 
   
2. Right-click on the folder path and click Copy Address. 
   

Step 7: Configure Excel Options 

1. Open Microsoft Excel and navigate to Options (under Account/Feedback). 
   
2. Go to the Save tab. 
   
3. Paste the copied folder address into the field for Default personal templates location. 
   
4. Click Save.

Step 8: Access the Fiscal Harmony Template 

1. Close Excel and reopen it.
   
2. When creating a new document, under the Personal tab, you should see the Fiscal Harmony Invoice Template.
   

Step 9: Enter Access Credentials  

1. Double-click the Invoice template and allow it to load. You will see a pop-up screen 

Step 10:  Retrieve API Keys

1. If your Excel plugin has the option for "Retrieve API Keys" or "Authorise", simply click on this, and this will direct you to the Authorisation page, where you can select your device it will automatically retrieve the API Keys.
2. If your plugin lacks this option, or it fails to authorise:
1. Navigate to the Fiscal Harmony app account on https://app.fiscalharmony.co.zw/ and enter your login details.
   
2. Navigate to Settings > API Keys on the sidebar on the left of the screen.
   
3. Click on where it says "Create API key" and give it a name "Excel". You would be prompted to enter your 2FA code from your authenticator app. If you already have an API Key, you would have to click "Refresh the Secret" to be able to access it.
   Caution: Refreshing your Secret will cause any other apps using your old secret to stop working and they would need to be update with the new API Secret.
4. Copy both your API Key and API Secret and place them into the plugin's respective fields.
   
3. Once you enter the API credentials into the Excel modal form, click Save as shown below.
   

Step 11: Complete the Setup 

1. Close Excel. 
   
2. Reopen Excel, and the Fiscal Harmony Invoice Template should now be ready for use.