This guide provides instructions on a. Selecting the appropriate report from your accounting software b. Generating the report to Excel c. Transforming the Excel report to LodgeiT Smart Excel Standard Format .XML for use in AccFx & LodgeiT Tools
Note that for Handlledger, the trial balance report is used to extract the profit & loss report. This is to ensure that all elements necessary to reproduce the profit loss report are captured.
Now, open the Excel file in Excel. As long as the LodgeiT Smart Excel Plugin is loaded, you will be able to select Profit and Loss Report & transform the Excel report to a normalized Lodge iT format XML output.
Here information for the report can be added like Name, Company, ABN and Generated Source. Also the current or historical Profit and Loss Report can be generated from the excel report.
Here is a small sample of the report, viewable in either Notepad or Internet Explorer
Once you have generated the xml file, you need to upload a PAIR of PL and BS via Financials tab
Related help guide Article: