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.
This guide provides instructions on:
A. Download LodgeiT Smart Excel Utility
B. Selecting the appropriate report from your accounting software
C. Generating the report to Excel
D. Importing Financials to LodgeiT
A. Download LodgeiT Smart Excel Utility
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"
B. Selecting the appropriate report from your accounting software
Extract report for both BS and PL
Balance Sheet
Profit & Loss
C. Generating the report to Excel
Once you have the exported file, open the excel, press the "LSU/LodgeiT" Tab and select "QuickBooks Online"
As long as the LodgeiT Smart Excel Utility Plugin is loaded, you will be able to select Standard Balance Sheet and Profit&Loss, that you can transform the Excel report to a normalized LodgeiT Smart Excel Utility format XML output.
Do it for both PL and BS
Here information for the report can be added like Name, Company, ABN and Generated Source.
Here is a small sample of the report, viewable in either Notepad or Internet Explorer
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
D. Importing Financials to LodgeiT
Once you have the xml file for PL and BS, you can now import to LodgeiT
Attachments