Note: The lodged information pulled from the ATO for the ICA and ITA templates are based on the binder dates. For example, if you created an Activity Statements binder for the period 1 April 2024 - 30 June 2024, the ATO data for the ICA and ITA templates will pull lodged data from 1 April 2024 - 30 June 2024.

On the index, we recommend adding these worksheet templates to the 'Taxation' section by clicking Accept.

When the template is inserted into the Excel file, you will be asked to log in again. This login is required to access the ATO. Use the same login as your Active Platform login.

Note: When obtaining data, you will be asked to log in every 30 minutes as required by the ATO's security guidelines.

After logging in, the worksheets will be pre-populated with the ATO transactions in the 'Transactions' section.

Note, at this stage, the ATO integration will import the transactions for the full year even if the binder period is set to a period less than a year (i.e. a quarter). We plan to enhance this in the future to allow you to select the exact period for which you want to import the transactions.

Above this 'Transactions' section, the 'Summary' section summarises the various tax payables, payments/refunds, and most other common transactions that you will typically find in either of these accounts. Use the 'Manual Allocation' column within the 'Transactions' section of the worksheet to allocate any transactions that haven't been included in the summary.

Income Tax Account 'Summary' section:

Use the 'Net Transfers Reconciliation' section to reconcile transfers between ATO accounts. Any transfers between income tax and integrated client accounts will be pre-populated after both worksheets have been inserted into the binder. Manually input any transfers to other accounts.

Once the above steps have been completed, navigate back to the 'Summary' section of the worksheet and take up the 'Recommended Journal' in the clients cloud accounting software to reconcile the ITA and ICA.