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 Utility Standard Format .XML for use in AccFx & LodgeiT Tools.

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

Extract the financials from the Accounting Software


Transform

Now, open the Excel file in Excel. As long as the AccRip Plugin is loaded, you will be able to select Profit and Loss & transform the Excel report to a normalized AccRip 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 can be generated from the excel report. User also needs to select the start and end dates.

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

Import

Importing Financials to LodgeiT, 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.

Related help guide Article:

Installing Accrip Generate LodgeiT Import Files from Any Accounting System

Attachments