This guide provides instructions on 

  • Selecting the appropriate report from your accounting software.  
  • Generating the report to Excel .  
  • Transforming the Excel report to LodgeiT Smart Excel Utility Standard Format .XML for use in AccFx & LodgeiT Tools.

Use the method shown below to extract balance sheet & profit&Loss reports from both the current (reporting) and historical (comparative) years.

First, extract the balance sheet to Excel format. (select the exact report shown)

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 Utility Plugin is loaded, you will be able to select Profit and Loss & transform the Excel report to a normalized LodgeiT 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 report.

Here is a small sample of the report, viewable in either Notepad or Internet Explorer

Once you have generated the BalanceSheet and Profit&Loss, you can import the XML in LodgeiT "Financials"

Learn more HERE

Select "Import from any other accounting software using LodgeiT Excel Add-In"

 

Related help Article:

Installing LodgeiT Smart Excel Utility

Generate LodgeiT Import Files from Any Accounting System

Attachments