We have an audit of the TPAR and they want listings in excel.
Although essentials creates a file we can't seem to get any physical reports that show/print anywhere but the screen.
We are writing each line by hand from the essentials screen into excel to give the ATO what they want. We can't copy and paste as it is not wokring, if we screen print, we only get the first screen of information.
We are presently copying this by hand (about 13 screens worth).
This needs to be addressed as it is available in AccountRight and other accoutning packages and it is a pretty basic requirement.
Thanks for your idea, yes had thought of that .
Yes we did reconcile the subcontractors, but the accounts are run for us to run the business, not to report to the ATO, so we have a mixture of reportable and not reportable subcontractors in this account. Which is why we can tick transactions not just cards.
The "narration" that comes up on the general ledger is not always easy to match to the subcontractor which is the first problem.
Not all entries to subcontractors are reportable, so that sorting through that also takes time. That's why we decided on going directly from the TPAR screen.
Either way, both of these are a work around that takes time and shouldn't. The report is there, it just needs to be able to be sent to PDF or Excel.