LodgeiT Smart Excel Utility (LSU) - This is an excel plug-in that provides the ability to convert any excel report generated from your accounting software into a format that can easily consume by LodgeiT, Learn more
First, download LodgeiT Smart Excel Utility (make sure to close any excel from your desktop machine)Extract the balance sheet to Excel format. the exact report shown)
Be sure to line up the dates with the reporting period. For tax purposes, typically 01/07/20xx to 30/06/20xx. DO NOT modify any other filters. You MUST use Accruals.
Pay careful attention to which folder on your computer you save the file to. Use Desktop if in doubt.
Then extract the report.
Be sure to line up the dates with the reporting period. For tax purposes, typically 01/07/20xx to 30/06/20xx.
Pay careful attention to which folder on your computer you save the file to. Use Desktop if in doubt.
Once you have the exported excel, press the LSU/LodgeiT tab and choose "Reckon Accounts"
You need to 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)
BalanceSheet and Profitloss XML file are now ready for import in LodgeiT.
Make sure to drag or copy the file together for uploading.
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.
