This feature is a process to convert excel reports for Elite software into a format that can be easily consumed by LodgeiT, this will save time re-keying facts as well as provide a more accurate outcome.
TABLE OF CONTENTS
Download
First, download LodgeiT Smart Excel Utility (make sure to close any excel from your desktop machine)Extract the balance sheet to Excel format. Click HERE to download.
You have successfully added the plug-in once you see a tab "LSU/LodgeiT"
Extract
Selecting appropriate report from your accounting software
Extract Profit&Loss and a Balance Sheet
Transform
Generate the report to excel.
Once you have the exported file, open the excel, press the "LSU/LodgeiT" Tab and select "Myob Tax and Contacts"
Now, open the Excel file in Excel. As long as the LodgeiT Smart Excel Utility Plugin is loaded, you will be able to select Standard Balance Sheet & transform the Excel report to a normalized LodgeiT Smart Excel Utility format XML output.
Here information for the report can be added like Name, Company, ABN and Generated Source. Also the current or historical balance sheet can be generated from the excel report. User also needs to select the start and end dates.
Fill either ABN or TFN
Choose file location, it will be save as XML file. (You need to generate a separate XML for PL and BS)
After clicking "Save", you will see this confirmation message
Here is a small sample of the report, viewable in either Notepad or Internet Explorer
BalanceSheet and Profitloss XML file are now ready for import in LodgeiT.
Make sure to drag or copy the file together for uploading.
Import
Once you have the xml file for PL and BS, you can now import to LodgeiT
If you need to make changes in the accounts, simply re-import after you've made those changes.
Once you've imported the files, navigate to and resolve any classification errors.
Attachments