Lodgment Reporting

Reporting options are found under Reports and Lodgment menus.

• To open the log of reports received from the ATO, select
  Lodgment > Electronic > ATO Reports .

• Reports accessed via the Lodgment menu concern monitoring the lodgment process for income tax returns and other lodgable forms:

ATO Statistics
BAS/IAS > Lodgment Status Report
Month Due Reports
(AE) BAS/IAS > Lodgment Report
Verify ATO Listings
(AE) BAS/IAS > Due Report

• These reports accessed via Lodgment > Other reports:

ATO Letter
FBT Lodgment Report  
EFT Lodgment Report
XX Lodgment Report
Performance Report
SCS Lodgment Report 
CU Lodgment Report
YY Lodgment Report
Progress Report
MC Lodgment Report 
TD Lodgment Report
Table Report
EX Lodgment Report
TW Lodgment Report

Reports Menu

Reports accessed via the Reports menu concern data in your tax ledger.

Related topics

Facsimile Preview and Print

Back to Reporting from Tax

ATO Reports

This is the ATO Report print, update and sort option.

The ELS Reports index lists reports received from the ATO. To open the ELS Reports index select Lodgment > Electronic > ELS Reports.

The Report Options that may be specified for printing, updating and sorting will depend on the type of report selected for processing.

The ATO report index initially shows all report types.

Filter

You can restrict the ATO reports received to the type you require by making a selection from the Filter field:

• Client Lists - to show:

• Client Statistics (RPTCS),

• Client List (RPTCL),

• Due Lodgment Report (RPTDL)

• Activity Statement Lists - to show

• BAS Preparation details (RPTAB)

• IAS Preparation details (RPTAI)

• Activity Statement Client List (RPTAS)

• Activity Statement Lodgment (RPTOL)

• Activity Statement Summary (RPTOM)

• Gateway Bulletins (BULL)

• Transmission Reports (TRANS)

• Validation reports (VALID)

Client List Reports

When a Client List Report is processed, you may print, update and sort the Client List data in ways appropriate to the data you have downloaded.

Client Statistics (RPTCS)

This Client List Report only offer options for print and delete.

Client List (RPTCL) and Due Lodgment Report (RPTDL)

The Client List and Due Lodgment Report facilities provide an automated process in which the data received from the ATO is matched or compared with the data on the Tax Agent's client database. This comparison should show inconsistencies and/or allow the Tax Agent to update their database and to advise the ATO via a Client Update form what the ATO has that is no longer current.

The report options offered for these reports can be printed, deleted and used to update your Tax ledger.

INSERTIMAGE  

The Report Options for RPTCL are:

• ATO Report: Tick this option to display the ATO report that was flagged in the ELS Reports index.

• List Exception Report: Tick this option to display the Exception Report screen, which provides further options for comparing and analysing the data in the flagged ATO report. This would normally be printed before updating Tax with data received from the ATO. The exceptions reported include:

• Return not found in ledger

• different form type, level, financial year, name, Company or Fund classification, address, final due date and different lodgment status.

• List Returns not in ATO list: Tick this option to list all returns that are in your ledger but are not on the ATO List. These are returns for which you need to lodge a Client Update form.

• Exception report - TFN only: Tick this option to display returns that are on the Client List but are not in your current Tax ledger matching by Tax File Number. The exceptions are reported as ‘Return not found in ledger’.

Update Options for RPTCL

These are:

• Level; Classification: Updates ATO level, Company and Super Fund classification.

• Date Due: Updates Due date of return.

• Lodged: Updates lodgment status of return. As a precaution, the lodgment status of returns which have had their lodgment status modified after the date the Client Report was prepared, will not be updated.

• Financial year: Updates Accounting year of return.

The updated fields are found in the Lodgment Details of the return, except for the lodgment status which is displayed on the Return index.

Exception report - Updating Tax

Updating Tax may be initiated by the operator at any time but prior to instructing Tax to update the ledger, an Exceptions report should be produced and examined and any necessary Client Update forms (CU) prepared and transmitted to the ATO for those clients no longer with the Practice but still on the ATO List or for those client new to the Practice and not yet on the ATO List.

The Sort Options for RPTCL:

For information on these further options for this type of report refer to Client Report Sorting Options.

Activity Statement Client List Report

The Activity Statement Lists confirm for you the BAS and IAS forms you have lodged. Importantly, by selecting List returns with no statement lodged for DIN in ATO you will know which of your clients the ATO expects an activity statement to be lodged.

BAS (RPTAB) and IAS (RPTAI) Preparation details

The options for printing are:

INSERTIMAGE  

• Print ATO Report: The BAS Activity Statement Report is printed.

• Create/Update Schedule from ATO Report: This will update Tax according to the data received.

• List returns with no statement lodged for DIN in ATO: Select this to list all returns that do not have a Lodged BAS schedule with the same DIN as in the report.

The options for sorting are Return code or TFN.

Activity Statement Client List (RPTAS)

When a Client Statistics Report is selected the print selection screen is displayed where you may choose Preview, Printer or Print to disk file for presentation of the report.

The options for printing are:

 

• List ATO Report: The BAS Activity Statement Report is printed.

• List Exception Report: This report matches TFNs or ABNs on the ATO report with those in the Add/Edit return record. The exceptions are reported according to the selection you make where:

• TFNs match the report will list discrepancies in the ABN.

• TFN or the ABN match the report will list differences in either name, postal address or Received via option.

Refer to Exception Report.

• List BAS/IAS payers in Tax not in ATO list: These are your clients you need add to the ATO list by lodging a Client Update.

• List returns on ATO list not BAS/IAS payers in Tax: You need to lodge Client Updates to delete these from the ATO list.

• Update Received via option of BAS/IAS payers: By selecting this option you will update the ‘BAS/IAS Received via’ field in the Return Properties General tab with the value on the ATO report if the TFN and ABN for the return match that on the ATO Report.

Activity Statement Lodgment (RPTOL)

This report can be previewed or printed. It provides Tax Agents with the lodgment status of their activity statement clients for the previous six months and also for the annual IAS return and annual GST return.

Activity Statement Summary (RPTOM)

This is the report that the Tax uses to automatically create Activity Statements with information contained in the report.

INSERTIMAGE  

The options for printing are:

• Print ATO Report: The BAS Activity Statement Report is printed. When you select to print the full report you can choose to print the report in order by return code or TFN.

• List returns with no statement lodged for DIN in ATO: Select this to list all returns that do not have a Lodged BAS schedule with the same DIN as in the ATO report.

Transmission Report

When a Transmission Report is selected the print selection screen is displayed where you may choose from Preview, Print or Print to disk file for presentation of the report.

After printing the Transmission Report you may select to delete TRANS_XXX.nnn file. The transmission file will remain in the ELS Reports index until you delete it.

Validation Report

When a Validation Report is selected the print selection screen is displayed where you may choose to Preview, Print or Print to disk file for presentation of the report.

Following this you may select from the options:

• Update Status from log - this changes the lodgment status of the return and can be confirmed from the [Shift+F2] Summary of Return or Return Properties > PAYG/Lodge Tab.

• Delete VALID_XXX.nnn (file identifier)

ATO Report Audit Trails

For the Activity Statement Client List files of quarterly or annual BAS/IAS received from the ATO, you may view or print the Import Audit Trail Report or clear (that is, delete) the imported files. To do this: Select Reports > Audit Trail > ATO report import. Refer to ATO Report Import.

Related topics

Client Report Sorting Options

ELS/PLS Reports list

Exception Report

Tax Agent Request Form

How to request reports from the ATO

Reports received from the ATO

Client Report Sorting Options

These reporting options are offered when you have chosen to prepare either the ATO Report or the Exception Report.

Employee Sorting

From these options, select to group the returns according to the Partner, Manager or Employee nominated on the Return Properties Staff tab.

Sorting Options

From the sorting options select to list the returns in order:

• numerically by Tax File Number,

• alphabetically by name,

• ATO level (the column labelled ‘TL’), returns with the same ATO level are listed alphabetically by name

• Form Type (C, F, I, P, T), returns of the same type are listed alphabetically by name

• from the oldest date due to the latest, returns with the same date due are listed alphabetically by name.

Back to ATO Reports

Reports received from the ATO

This index provides the reports downloaded from the ATO in an index that includes solicited and unsolicited reports requested using a Form RR and other ATO Reports such as Transmission and Validation reports. Reports downloaded from the ATO may include:

Solicited Reports

Each type of solicited report is described briefly below. Each must be requested individually via a separate RR form each time it is required. Refer to How to request reports from the ATO.

01

Unsolicited Reports

Unsolicited reports are routinely prepared by the ATO after the end of month processing. They are requested from the ATO as an unsolicited report on an Agent Request (RR) Form and are shown on the List ELS Reports index.

Any Agent who has requested Unsolicited Reports will automatically download this type of report during normal lodgment sessions.

Other reports

Related topics

ATO Report Import

Tax Preparation Audit Trail

Activity Statements

Solicited Reports

Unsolicited Reports

Back to ATO Reports

Solicited Reports

Solicited reports include:

Activity Statement Client List

The ATO offers services for receiving Business Activity and Instalment Activity Statements, namely RPTABxxx (BAS) and RPTAIxxx (IAS).

RPTAB: Provides the facility for tax practitioners, where nominated by their client (the taxpayer) to receive personalised Business Activity Statement Information via ELS. This facility caters for quarterly and annual BAS production.

RPTAI: Provides the facility for tax practitioners, where nominated by their client (the taxpayer) to receive personalised Instalment Activity Statement Information via ELS. This facility caters for quarterly and Annual IAS production.

Overview of Processing OutBAS and OutIAS

After receiving a request for these reports the ATO will transmit Activity Statement information to the tax practitioner through ELS.

The tax agent collects this information during transmissions to the ATO and uses it to create the respective Activity Statement in Tax. The tax agent updates the Activity Statement with additional client information.

Once updated, checked and validated the Activity Statement is transmitted back to the ATO via ELS.

Batches of Activity Statements

Activity Statements may be lodged in batches containing a maximum of 1000 statements.

Activity Statement Client List Background

The first listing of Activity Statement clients was made available to tax practitioners in mid-July 2000 from the internet or on request in paper form. This list identified all clients whom the ATO expected to lodge an Activity Statement (monthly, quarterly or annually) and who also had a Tax Agent number nominated in the ATO records.

All Tax Agents registered on the ATO Client Activity Centre (CAC) are supplied with a password and PIN so that they can download files via the Internet including their Activity Statement Client Lists files.

Subsequent Activity Statement Client Lists are available via ELS by requesting a form called the OG. This form may be requested using the Tax Agent Report Request in the normal way.

The ATO maintains their records from Update of Client Update Form (CU) lodged by Tax Agents. The Tax Agent must lodge an Update Activity Statement for each taxpayer where details held by the ATO need correction. Each CU form must be lodged via ELS.

How to Read the Activity Statement Client List

This client list will include:

• Tax File Number (TFN)

• Australian Business Number (ABN)

• Trade Name where available, otherwise Legal Name

• Postal Address

• GST Indicator (per the ABN request received)

• An ELS/ECI/Paper indicator (E, I or P) to define method of lodgment

The first four points need no explanation but where the ATO list differs from the Tax Agent's records, the Tax Agent must decide which is correct and either update the Practice records or advise the ATO via the Client Update Form (CU) of the correct information.

GST - GST Indicator:

Y Registered for GST and will be lodging a Business Activity Statement

N Not registered for GST and will be lodging an Instalment Activity Statement

Received via - Activity Statement lodged via:

• I Internet

• E ELS

• P Paper

Internet: This means that the ATO is expecting this taxpayer to lodge the BAS or IAS via the Internet directly to the ATO ECI site and that henceforth all updates sent by the ATO to that taxpayer will only be available via the internet and will not form part of the tax agent's BAS Lodgment program.

Therefore, if the tax agent is actually going to lodge that return on behalf of the taxpayer, then the tax agent will need to determine whether the taxpayer will be lodging their own BAS via the internet or if they will have the tax agent lodging on their behalf.

If the taxpayer wants the agent to lodge, the agent will have to prepare a Form CU so that the CAC will be updated and all future electronic correspondence for that taxpayer will be sent to the agent via ELS.

ELS: Where this code is present, there is no requirement for the tax agent to advise the ATO via the Form CU of any change to that status unless the tax agent will not in fact be lodging the BAS via ELS. However, the agent would have to lodge a Form CU if any of the details (Name, Address, etc.) were different from the details advised by the ATO.

Paper: Where this code is present, the ATO is expecting that the taxpayer will lodge a paper BAS, which the ATO will post to the client or the tax agent. The tax agent will collate information and the completed form will then be mailed to the ATO for data capture. Any payments may be made using the Payment Advice Form attached to the Activity Statement or the Bpay method for telephone or internet payments.

Related topics

Client update for entities (CU)

Client Update for Individuals (cui)

Reports received from the ATO

How to request reports from the ATO

Activity Statements

Back to ATO Reports

Client Statistics Report

Three reports are output for each RPTCS report request. Each report contains statistics pertaining to lodgments for specific Tax Levels:

• First report - Individuals, Partnerships and Trusts - is sorted by Tax Level [^BJW] in the following order: PY, IPY, 6A, IP6, 5, 4, 3, 2, 1, 0, 7, 8, TOT.

• Second report - Companies and Superfunds - is sorted by Tax Level [^BJW] in the following order: CS7, CS6, 5, 4, 3, 2, 1, 0, TOT.

• Third report - Totals - is sorted by Tax Level [^BJW] in the following order: PY, IPY, 6A, CS7, CS6, IP6, 5, 4, 3, 2, 1, 0, 7, 8, TOT.

The ATO transmits totals for each of the statistical fields in the report. The final value transmitted for each statistical tag is the total for that column of the report

All information displayed on the client statistics report (RPTCS) is based on details as at the run date shown and reflects current ATO processing. Some ATO branch offices may experience delays in lodgment of returns during peak processing times. Your client statistics report, therefore, may not reflect your total lodgments to date.

If you have any queries regarding your client statistics report contact Tax Practitioner Lodgment Support phone 13 7286 (FKC 142) for the cost of your local call rate.

How to Read the Client Statistics Report:

• Tax Level

Current Tax Levels encompassing all entities:
PY Prior Year
IPY Immediate Prior Year
6A Individuals and Trusts greater than $500k tax payable for current income year.
CS7 Company and Superfund level 7
CS6 Company and Superfund level 6
IP6 Individual and Trust level 6
5 all entities level 5
4 all entities level 4
3 all entities level 3
2 all entities level 2
1 all entities level 1
0 all entities non taxables
7 Individual and Trust refunds
8 Partnerships

• Total Clients

Total number of clients the agent has

• No. Lodged

Number of lodgments received by the office for the agent, both ELS and non-ELS

• % Lodged

Number of lodgments received by the office for the agent as a percentage of total clients

• % AUST Lodged

Number of lodgments received by the office Nationally as a percentage of total National clients

• No. ELS Lodged

Number of lodgments received by the office for the agent

• % ELS Lodged

Number of lodgments received by the office as a percentage of total clients

• % AUST ELS Lodged

Number of ELS lodgments received by the office Nationally as a percentage of total National clients

• No. Not Lodged

Total number of clients less the number of lodgments received by the office for the agent, both ELS and non-ELS

• % Not Lodged

Number not lodged for the agent as a percentage of total clients

• % AUST Not Lodged

Number not lodged Nationally as a percentage of total National clients

Back to Solicited Reports

 

How to Read the Client Report:

• CT Client Type of the taxpayer:

I Individual
P Partnership
T Trust
C Company
F Superannuation Fund

• TAX LVL

Displays the tax level of the taxpayer. For lodgment purposes, this value will remain constant during the year.

• SAP

If a substituted accounting period has been approved, code shown denotes the balance date.
CODE BALANCE DATE (IN LIEU OF 30 JUNE 2017)

• LYL

Last Year Lodged by taxpayer.

• LC Lodgment Code:

E Last return was lodged electronically.
P Last return was lodged by paper (non-electronically).
U Return has been received for the current income year but taxpayer details have not been verified due to processing delays.

• RA

'R' Denotes address of taxpayer does not match your address as shown above - this may indicate the taxpayer's residential address is being used.

 

For Individuals, Partnerships and Trusts ONLY: Latest Date for Lodgment

This shows the latest permitted date for lodgment of the taxpayer's current year return based on your lodgment program as at the run date. If your lodgment program has subsequently changed, the date shown may no longer be correct.

A date different to your lodgment program will be shown for taxpayers who have a substituted accounting period or who are subject to a special lodgment arrangement.

For individual and trust taxpayers, if a date is not shown on the list, the taxpayer is not subject to your lodgment program and may be overdue for lodgment.

Partnership returns are required to be lodged by the earliest due date for any partner's return.

The ATO may commence action to obtain lodgment of the current year return at any time, regardless of the date shown on the list. 'CY DMD' will be shown if such action has been taken.

Tax level 0 or 7 individual and trusts with a latest date for lodgment of, for example, 15 May of the current income year may be lodged up to 3 June of the current income year without incurring penalty where the return for the prior income will be non-taxable or will result in a refund.

The dates shown are end dates and the ATO expects that the majority of your clients' returns will be lodged progressively during the lodgment season.

If you believe that you will have difficulties meeting your lodgment program, contact the Tax Practitioner lodgment support desk to negotiate a new program as soon as possible, and certainly no later than the relevant program end date. Additional burdens placed on you by other sections of the ATO may be taken into account when negotiating a new program.

Full details of tax agent lodgment arrangements are contained in the current income year tax agent lodgment rules that can be obtained from the tax agent portfolio on the ATO website (www.ato.gov.au) or from the tax practitioner lodgment support. It is important that you read and understand the lodgment rules as a number of important changes have been made.

For Companies and Superannuation Funds ONLY

• CATEGORY types

1 - 9: Lod 1 to Lod 9
A - E: Lod 10 to Lod 14
G - W: Lod 15 to Lod 30
U: Unclassified **
Null: Blank **
F: NFSA

 

• CYD

Current Year Demanded indicator.
'CY DMD' denotes the current year return has been demanded.

• CYL

Current Year Lodgment status.
Displays the status of the current year return:
1 Current Year Lodged
2 Current Year Not Lodged
3 Current Year Not Necessary
Information on lodgment requirements for Companies and Superannuation funds is contained in the Tax Agent lodgment rules that can be obtained from the Tax Agent portfolio on the ATO website (www.ato.gov.au) or from Tax Practitioner Lodgment Support. It is important that you read and understand the lodgment rules as a number of important changes have been made.
'CY DMD' denotes action to obtain lodgment of the current year return has been taken.

Back to Solicited Reports

Unsolicited Reports

Unsolicited reports are routinely prepared by the ATO after the end of month processing. They are requested from the ATO as an unsolicited report on an Agent Request (RR) Form and are shown on the List ELS Reports index.

Any Agent who has requested Unsolicited Reports will automatically download this type of report during normal lodgment sessions.

Related topics

Activity Statement Lodgment Report

Activity Statement Summary Report

Reports received from the ATO

Return Print Setup for the practice

Back to ATO Reports

Activity Statement Lodgment Report

This is an unsolicited report produced by the ATO mid-month. It provides a statistical report of all Activity Statements lodged for the previous 6 months. All information displayed on this list is based on details as at the run date shown.

If you have any queries regarding this list phone 13 7286 (FK C142) for the cost of your local call rate.

How to read the Activity Statement Lodgment Report

• Run Date: Date this lodgment report was produced.

• ABN/TFN: Displays the Australian Business Number (ABN) or the Tax File Number (TFN) of the taxpayer. the three digit number following the ABN/TFN is the client account number.

• Name: Either The Individual Or Non-Individual Name Used On The Activity Statement.

• Frequency (F):

• 'M' Indicates Monthly,

• 'Q' Indicates Quarterly,

• 'A' Indicates Annual.

• Period Column Headings: The headings are sent as text data and will be displayed/printed as received e.g. 'MAR14', 'FEB14', etc. The last two columns for the Annual IAS return and Annual GST return will be displayed/printed as per the following examples: 'IAS13/14', 'GST13/14'.

• (Lodgment Status):

• N/A indicates no activity statement issued for the lodgment date shown.

• Nldg indicates an activity statement issued for the lodgment date shown, but not yet received by ATO.

• Lodg indicates an activity statement received by the ATO for the lodgment date shown

• Total No of Clients: The number of this tax agent's clients who had an obligation to lodge an activity statement for the previous six months.

 

Back to Unsolicited Reports

Activity Statement Summary Report

Unsolicited reports are those routinely prepared by the ATO after the end of month processing. They may be requested from the ATO on an Agent Request Form.

The RPTOM report contains a summary of all Activity Statements issued to the Tax Agent and the Tax Agent's clients. It contains both Paper and ELS statement information, DINs, Commissioner's Rates, etc.

Tax Agents typically use this report to search for the DIN number issued to their clients who currently receive paper Activity Statements, to avoid delays in applying to the ATO for new or replacement DINs.

The ATO report OM is designed to print each Instalment notice on a separate page. Tax offers the choice of printing multiple statements contiguously or using the ATO standard layout.

The Report Options available include:

• Print ATO Report: The BAS Activity Summary Report is printed, or

• List returns with no statement lodged for DIN in ATO: Select this to list all returns that do not have a Lodged BAS schedule with the same DIN as in the report.

You can select to include:

• Include ATO banner with report: The report will include the banner page offering an explanation of codes used in the body of the report, and

• Use ATO layout: This layout commences each instalment notice on a new page thus adding to the length of the report.

How to read the OM

All information displayed on this list is based on details as at the run date shown on the report.

If you have any queries regarding this list contact 13 7286 (FK C142) for the cost of your local call rate.

Banner page

The report is preceded by banner pages that explain the terms used in the report. These terms are:

• Run Date: Date this summary report was produced.

• Form Type: Business activity statement or instalment activity statement and identifier or Consolidated Activity Statement

• Period Dates: Either annual, quarterly or monthly obligation dates. For example:

'July to September 2014' or 'September 2014' or '1 July 2014 to 30 June 2015' or '10 September 2014 to 28 February 2015'. The latter example is an Abbreviated Annual GST Return, generated following bankruptcy, liquidation, receivership, death, or change of GST Group Membership.

• DIN: Document identification number (DIN).

• ABN/TFN: Displays the Australian Business Number (ABN) or the Tax File Number (TFN) of the taxpayer.

• CAN: The client account number (CAN) will always be displayed. It is the three digit number immediately to the right of the ABN/TFN.

• Due Date: Form due date

• Payment Date: Payment due date

• Name: The client's name

• GST Accounting Method:

'03' - 'GST accounting method: Cash'
'04' - 'GST accounting method: Non-Cash (accruals)'

• Deferred Company/Fund Instalment: Always 'Deferred Company/Fund Instalment'

GST Portion

• GST Period Labels

Reporting period for any GST obligations
Goods and Services Tax fields (G1 - G24)
'Goods and services tax for the MONTH from 1 to 30 Apr' of the same calendar year OR
'Goods and services tax for the QUARTER from 1 Jul to 30 Sep' of the same calendar year OR
'No goods and services tax obligation for this period'

• GST Instalment Amount Label

'06' - 'ATO instalment amount (G21)'
'07' - 'Not eligible for option (G21)'
'08' - 'Varied instalment amount (G21)'
'09' -'Two instalment payer (pay in quarters 3 and 4) (G21) Nil this quarter'

• GST Instalment Amount

either the dollar amount or blank (field G21)

PAYG Withholding Portion

• PAYG Withholding Period Labels

Reporting period for any PAYG withholding obligations PAYG withholding fields (W1 - W5) -
'PAYG tax withheld for the MONTH from 1 to 30 April' of the same calendar year OR
'PAYG tax withheld for the QUARTER from 1 Jul to 30 Sep' of the same calendar year OR
'No PAYG tax withheld liability due for this period'

PAYG Instalment Portion

• PAYG Instalment Period Labels

Reporting period for any PAYG instalment obligations PAYG instalment fields (T1 - T11) -
'PAYG income tax instalment for the QUARTER from 1 Jul to 30 Sep ' of the same calendar year OR
'No PAYG income tax instalment obligation for this period' OR
'PAYG Instalment for the period 1 July to 30 June ' (that is, one full income year)

• PAYG Instalment Amount Label

'06' - 'ATO instalment amount (T7)'
'07' - 'Not eligible for option (T7)'
'08' - 'Varied instalment amount (T7)'
'09' - 'Two instalment payer (pay in quarters 3 and 4) (T7)
'10' - 'Consolidated amount (T7)'
Nil this quarter'

• PAYG Instalment Amount

either the dollar amount or blank (field T7)

• Instalment Amount Notional Tax Message

Located immediately to the right of the T7 or T5 amount block and may be either:
'From XXXX amended assessment' OR
'From XXXX assessment' (where XXXX is relevant year)

• PAYG Instalment Rate Label

'05' - 'ATO instalment rate (T2)'
'06' - 'Not eligible for option (T2)'
'07' - 'Varied instalment rate (T2)'
'08' - 'Consolidated Rate (T2)'

• PAYG Instalment Rate

either the percentage rate or blank (field T2)

• Instalment Rate Notional Tax Message

Located immediately to the right of the T2 rate block and may be either:
'Notional tax $XXX,XXX,XXX,XXX from XXXX amended assessment' OR
'Notional tax $XXX,XXX,XXX,XXX from XXXX assessment' (where $XXX is the dollar amount and XXXX is relevant year)

• Commissioner's Instalment Amount

Either the dollar amount or blank (field T5)

FBT Instalment Portion

• FBT Instalment

Reporting period for any FBT obligations

• Period Labels FBT instalment fields (F1 - F4)

'FBT instalment for the QUARTER from 1 Jul to 30 Sep ' of the same calendar year OR
'No FBT instalment required for this period' OR
'FBT return lodged - do not complete'

• FBT Instalment Amount Label

'01' - 'ATO instalment amount (F1)'
'02' - 'NOT APPLICABLE'

• FBT Instalment Amount

Either the dollar amount or blank (field F1)

Summary Portion

• Deferred Company/Fund Instalment

(label for field 7)

• Deferred Company/Fund Instalment Amount

Always the dollar amount (field 7)

• Total No. of Clients

The number of this tax agent's clients who were sent activity statements in this monthly generate.

 

Related topics

Reports received from the ATO

Return Print Setup customised for the user

Back to Unsolicited Reports

Exception Report

Below is a list of possible messages on an exception report and what they mean.

• Different Address: Under the heading RA on your client list, the code 'R' denotes that the ATO has recorded that the taxpayer's Current Postal Address on the taxpayer's Front Cover does not exactly match your postal address in the Control Record - this may simply indicate the taxpayer's residential address is being used.

• The Exception report will display 'different address' if:

• The Client List does not have an 'R', and the addresses are different, or

• The Client List does have an 'R' and the addresses are the same.

• Different Level: Is displayed if the ATO level in the Return Properties > PAYG/Lodge tab differs from that on the Client List.

• Different Financial Year: Is displayed if the accounting year for the return is different to that on the Client List.

• Different ATO: Is displayed if the ATO branch on the return is different to that on the Client List.

• Different Name: Is displayed if the return name is different to that on the Client List. An exception is not reported if the Client List has initials only and Tax has the full name, or vice versa.
  To avoid reporting exceptions where the only difference is in the client name select Exclude name differences on the Client Reporting Sort Options. The default for this option is 'on', therefore if you wish to have name differences reported, you need to turn off the option.

• Different Final Due Date: Is displayed if the Due Date of the return is different to that on the Client List.

• Different Lodgment Status: Is displayed if the return has a status of lodged in Tax but the Client List has return as being Not Lodged, and vice versa.

• Different Company or Fund Classification: Is displayed if the company classification of the return is different to that on the Client List. This only applies to companies and Super funds.

• Different Last Year Lodged: is displayed if:

• Client list has last year lodged before the current year and the return has status of lodged in the current year Tax ledger.

• Client List has last year lodged as the current year but the return has status of not lodged in the current year Tax ledger.

• Different Agent Code: Is displayed if you requested a Client List for one agent and when the exception report was run, the return in your Tax ledger had a different agent reference number.

• Return Not Found in Ledger: Is displayed if a return is on the Client List but not in your current Tax ledger.

Back to ATO Reports

ATO Statistics

How to print ATO Statistics:

1. Click Lodgment > ATO Statistics and select the return types required:

• Standard I,P,T

• Standard C,F

• Budget I,P,T

2. Complete the Record Selection for the sort sequence and range or this report and click OK.

3. Complete the Preview/Print options required for this report and click OK.

4. Complete the ATO Reports screen which differs according to your prior selections.

5. Click OK to produce the report.

Standard Reports

Standard I,P,T and Standard C,F reports are based on the lodgment requirements set up in the Budget Maintenance index. The 'Required' number and percentage for each 'Tax Level' will be displayed when the Report Date equals or exceeds the date and percentage lodged set up in the Budget Maintenance index.

Budget Report

Budget I, P, T and Budget C, F reports are based on the 'date due' entered in the Lodgment Details screen. The 'Required' number and percentage for each level of return will be displayed when the Report Date exceeds or equals the first 'date due' entered in the Lodgment Details screen.

The reports include the following columns:

Tax Level: These levels are set by the ATO. The standard I,P,T and Budget I,P,T Reports display the relevant ATO levels allowable for Individual Returns, Partnership Returns and Trust Returns. The standard C,F and Budget C,F Reports display the relevant ATO levels allowable for Company Returns and Fund Returns.

Total Returns: This column displays the returns that fall within the report parameters set in the Record Selection and the ATO Reports options. (See below).

Lodged: This shows the number and percentage of returns that have a status of 'lodged'. This is derived from the returns listed in the Total returns column.

Required: This shows the number and percentage of returns required to be lodged as specified by the Report Date.

For example, in a Standard I,P,T Report the column will list the required amount and percentage of returns required to be lodged by the Report Date (as specified in the ATO Reports screen). The Parameters for the required dates depend on the report selected, that is, Standard or Budget.

Variance: This shows the variance between the Returns Lodged and the Returns Required to be lodged as detailed in the report parameters.

ATO Reports Options

Include Levels: Where applicable, this option refers to the tax levels to be included in the selection criteria for the report. Click [Enter] to leave the field blank and accept all levels. Alternatively, to include specific levels, enter the levels to be included. For example, if you enter the numbers 1 and 5, only these levels are included in the report.

Report Date: This refers to the date by which returns have to be lodged. Today's date will default but this may be changed if required. This field is linked to the dates entered in the Budget Maintenance index. Therefore, the report printed for this date will list according to the information entered for the date (or the closest to it but not past it) in Budget Maintenance.

ELS Agent: If you are an ELS agent, answer [Y] so Tax will report the percentage according to the ELS agent program.

Separate Partner Statistics: Selecting this option causes the statistics to be listed for each partner. Similarly if Separate Manager Statistics is selected.

Totals only: For Standard C, F returns this shows totals for each ATO Lodgment Classification. For Standard I, P, T this shows the totals for each Tax level/classification.

Exclude Subsidiaries (Consolidation): All lodgment reports have a checkbox that may be ticked so that the report will EXCLUDE subsidiaries of a consolidated group.

Related topics

Record Selection

PAYG/Lodge

Budget Maintenance

Back to Lodgment Reporting

Month Due Reports

The Month Due Report option lists the lodgment due date for returns within a specific category. The user nominates the scope of the report, for example, the types of returns on which they wish to report.

How to print Month Due Reports:

1. Click Lodgment > Month Due Report.

2. Click the category of reporting:

• by Return

• by Partner

• by Manager or

• by Employee.

3. Click OK.


If you selected by Return the Record Selection screen is displayed. Select the sort sequence and the range of reports to be printed and click OK.

4. The Preview/Print screen will be displayed. Select the printing options for this report and click OK.

Month due report printed as a Flexi Report (AE)

Month due reports may also be printed using the Flexi Report which provides greater sorting flexibility. This is accessed from the Reports menu. Flexi report layouts can be added and saved for printing month due reports. For example, you may create a layout to report on all I, P and T returns which are due within the dates of May 1 and May 31 but which are not lodged as yet).

Specifying the report

The categories by which the Month Due Reports may be prepared are:

• by Return

• by Partner

• by Manager or

• by Employee.

Range: When you prepare this report by Return the range of returns to be included is specified on the standard Record Selection screen.

When you are preparing this report by Partner, Manager or Employee, the report will include all partners, managers or employees unless you enter the relevant codes in the From and To fields. For example, if you choose to report by partner, enter the first and last partner codes which you wish to include in the report.

From Month to Month: Enter the months from 1 to 12 which the report will cover.

Include Types: This is a 10 character alpha field which refers to the form type to be included in this report. Leaving the field blank means all form types will be reported on. Click [Enter] to leave the field blank.

Include Levels: This field refers to the levels of the returns to be included in the report. This is a 10 character field. Click [Enter] to leave blank and accept returns of all levels.

Include Lodged Returns: Tick this checkbox to include lodged returns in your report.

Include Status: Tick this checkbox to include or exclude returns depending on status. If selected, enter the range of status codes to be included at the From and To fields. For example, to restrict your list of returns when using simple monitoring enter From as 'lodged' and To as 'lodged'. If you do not tick this checkbox you will list all returns regardless of status, that is lodged, sent for signature, not lodged.

Exclude Subsidiaries (Consolidation): All lodgment reports have a checkbox that may be ticked so that the report will EXCLUDE subsidiaries of a consolidated group.

Office Index Mask: The Office Index Mask is an 8 character alphanumeric field where an office index mask can be entered so the report sorts according to the mask you enter here. Click [Enter] to bypass this field if required.

Related topics

Office Index Mask

Record Selection

Back to Lodgment Reporting

Verify ATO Listings

This report checks that returns reported as ‘lodged’ on the ATO listing correspond to the returns marked as ‘lodged‘ in Tax. Any discrepancies found are reported.

How to print Verify ATO Listings:

1. Click Lodgment > Verify ATO Listings.

2. If the query Data Already on file. Delete? is displayed, enter No to maintain the report settings previously saved.

3. The Verify ATO listings screen is displayed. Select Edit to the first field.

4. Key in a TFN and click [Enter]. The TFN will be verified.

5. Key in the ATO level and click [Enter] to add another TFN, or


when all relevant TFNs are entered, click OK to continue.

6. At the prompt Commence print run? select Yes to proceed with the routine.

7. Complete the Preview/Print screen to select the printing options. Click OK.

8. If you have specified particular TFNs for this report, you will be prompted to Retain data? Select Yes to retain the current report settings for the next print.

Discrepancies reported

This report provides one or more of these messages concerning discrepancies:

• Returns lodged on the ATO listing but not on master. This means that there is a return lodged on the ATO listing that has not been flagged as lodged in Tax.

• Returns lodged on master but not lodged on the ATO listing. This means that there is a return lodged in Tax which does not appear on the ATO listing.

• Returns not lodged and not on the ATO listing. This means that the return has not been lodged.

Verify ATO Listing options

Update ALS levels: Tick this checkbox to compare the tax level on the ATO listing with the level in Tax. If it does not correspond, the return is updated with the new level.

Verify Lodgment status: Tick this checkbox to verify that the status of the return is lodged. If it is not, update the return to lodged status.

Lodged as at what date: Enter the date from the ATO listing so that returns lodged after that date will not appear as exceptions. Enter the date in the format DD-MM-CCYY.

If you are printing a listing of returns that are not lodged, click Delete to clear the date from this field. Otherwise, simply enter the date of the ATO listing.

Redefault date due: Tick this checkbox to update the due dates when tax levels have been changed (through the Verify ATO Listing Routine).

Tax File Number: You do not have to key spaces in the TFN, Tax will automatically format them. If the tax file number keyed does not match any return on the system, the following query displays: Tax File Number not on System. Re-key? Answer Yes, or No.

If you have retained a list of TFNs from a previous print then any TFN you enter in the current print are added to the list to be verified.

If no TFNs are specified then all the returns will be verified.

ATO Level: For each TFN specify the ATO level if any. This is a one character field requiring a number between 0-8. At this field click [Enter] to add another TFN or click OK to indicate the list is complete.

Back to Lodgment Reporting

Other Reports

Access: Select Lodgment > Other Reports and select the type of report.

The types of reports to be selected are:

• ATO Letter

• Performance Report

• Progress Report

• Table Report

• FBT Lodgment Report

• SCS Lodgment Report

• MC Lodgment Report

• CU Lodgment Report

• EFT Lodgment Report

• EX Lodgment Report

• XX Lodgment Report

• YY Lodgment Report

• TD Lodgment Report

• TW Lodgment Report

Back to Lodgment Reporting

ATO Letter

Access: Select Lodgment > Other Reports > ATO Letter.

The ATO Letter facility provides the user with a form letter to the ATO including details of the returns being enclosed. The heading of the letter consists of the name and address of the ATO. The returns which have been lodged through Tax will appear in the body of the letter with the relevant details about the lodged returns.

How to access the ATO letter:

1. Click Lodgment > Other Reports > ATO letter.

2. Complete the Record Selection screen by selecting the sort sequence and the range to be printed.

3. Complete the Preview/Print screen.

4. At the prompt Reset ‘lodged this run’ flag? select Yes.

Related topics

Record Selection

Back to Other Reports

Performance Report

Access: Select Lodgment > Other Reports > Performance Report.

This report lists this statistical information:

• number and percentage of returns for each type of form.

• number and percentage lodged to date.

• total percentage complete.

How to print the Performance Report:

1. Click Lodgment > Other Reports > Performance.

2. Complete the Record Selection screen to select the range and click OK.

3. Complete the Preview/Print screen to select the output options required for this report.

4. Select the Performance Report options and click OK to prepare the report.

Performance report options:

A series of prompts to determine the details of this report.

Office Index: This is relevant only if your tax practice uses office indexes for sorting purposes. Enter the necessary information here or click [Enter] to bypass this field.

Date Start: This displays last year's deadline for lodging returns. Click [Enter] to accept the default or edit it if required. Enter the date in the format of DD-MM-CCYY.

Date Finish: This displays the current date and can be edited if required. Enter the date in the format of DD-MM-CCYY.

Exclude Subsidiaries (Consolidation): All lodgment reports have a checkbox that may be ticked so that the report will EXCLUDE subsidiaries of a consolidated group.

Back to Other Reports

Progress Report

Access: Select Lodgment > Other Reports > Progress Report.

For each form type this report details one or more of the following:

• the number of current year returns on the system.

• the total of each form type.

• the percentage of returns lodged on a year to date basis.

How to print the Lodgment Progress Report:

1. Select Lodgment > Other reports > Progress.

INSERTIMAGE  

2. On the Record Selection screen:

• select Status:Returncode

• enter a range of returns or accept the default which all returns, and

• click OK.

3. Complete the Preview/Print screen to select the output options required for this report.

INSERTIMAGE  

4. On the Lodgment Progress Options select the Status to appear on the report and click OK to continue.

INSERTIMAGE  

INSERTIMAGE  

Lodgment Progress options

State:

• Not Lodged will provide a list of all those returns that are Not Started or in Progress

• Sent for Signature will provide a list of all those returns that have been sent to your client for signing.

• Lodged will provide a list of all those returns that have been Transmitted and were accepted as Valid and are therefore Lodged with the ATO.

Sort by level: Return Code: Tick this checkbox to list by level sequence, or leave it unticked to list returns in return code sequence.

Include Levels: Select to include all returns at all status levels or list only returns at certain levels. Click [Enter] to include all levels or enter the relevant levels if required.

Include blank return types: Tick this checkbox to include blank return types.

Exclude Subsidiaries (Consolidation): All lodgment reports have a checkbox that may be ticked so that the report will EXCLUDE subsidiaries of a consolidated group.

The checkbox will be unticked initially, as the standard is to include subsidiaries of a group.

5. If required enter the range of dates that contain the lodged returns on which you wish to report and click OK. The report is printed in the format you have selected.

INSERTIMAGE  

Date Range

The Date Range prompt depends on the type of the returns being reported: If the State is:

• Sent for signature: If you selected to list returns sent for signature, the Date Range prompts will not be displayed.

• Returns not lodged: If you selected to list those returns that are not lodged, only the Date To field will be displayed. The default date is the current date (that is, today's). This means that all those returns not lodged before this date, and those returns lodged after this date, will be included in the report.

• Lodged returns: The Date From and Date To fields are displayed if you are reporting on lodged returns. Enter the range of dates that contain the lodged returns on which you wish to report.

Related topics

Record Selection

Back to Other Reports

Table Report

Access: Select Lodgment > Other Reports > Table Report.

The Lodgment Table provides a list of the various return types and their corresponding tax levels as selected on the Return Properties, PAYG/Lodge tab. The tax levels are levels designated by the ATO numbering 0-8. The report displays the number of returns included in each tax level.

How to print the Table Report:

1. Click Lodgment > Other Reports > Table.

2. At the Lodgment Table window select one of the alternatives:

• All returns, 

• Returns not lodged and 

• Returns lodged.

3. At the Lodgment Table window select to Exclude Subsidiaries (Consolidation):

Initially this checkbox is unticked, as the standard is to include subsidiaries of a consolidated group.

4. Click OK to continue.

5. Complete the Record Selection to select the sort sequence and the range to be printed.

6. Complete the Preview/Print screen to select the printing options for this report.

7. The table report prints in the manner you have chosen.

Related topics

How to Preview a Report

Record Selection

Back to Other Reports

FBT Lodgment Report

Access: Select Lodgment > Other Reports > FBT Lodgment.

The FBT Lodgment report produces a listing, with statistical summary, of EB forms on the system.

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Date

• Partner code

• Manager code

• Name

How to prepare the report:

1. Click Lodgment > Other Reports > FBT Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgFBT which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'Letter' one page per EB form suitable for writing letters to clients will be produced.

• Report Type: The default is listing. In MYOB AE, alter the report type to E for Letter and combine this with an appropriate layout to produce one page per EB form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Record Selection

Back to Other Reports

SCS Lodgment Report

Access: Select Lodgment > Other Reports > SCS Lodgment Report.

Superannuation Contributions Surcharge (SCS) Lodgment Report may be used to produce a listing, with statistical summary, of SP forms sent and accepted.

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• SFN

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > SCS Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgSCS which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per SP form suitable for writing letters to clients will be produced.


These fields are available for this report if using the letter layout:
#60 - SFN
#61 - Status
#64 - Number of member statements
#65 - Date due

• Report Type: The default is listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per SP form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

MC Lodgment Report

Access: Select Lodgment > Other Reports > MC Lodgment Report.

The Member Details (MC) Lodgment report produces a listing, with statistical summary, of MC forms on the system.

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Date

• Partner code

• Manager code

• Name

How to prepare the report:

1. Click Lodgment > Other Reports > MC Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgMC which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'Letter' one page per MC form suitable for writing letters to clients will be produced.

• Report Type: The default is listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per MC form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

CU Lodgment Report

Access: Select Lodgment > Other Reports > CU Lodgment Report.

The Lodgment Report CU may be used to produce a listing, with statistical summary, of CU forms on the Tax ledger (attached to Individual, Trust and Company returns).

The listing reports one line per form including:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > CU Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgCU which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per CU form suitable for writing letters to clients will be produced.


This field is available for this report if using the letter layout:
#61 - Status

 

• Report Type: The default is listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per CU form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

EFT Lodgment Report

Access: Select Lodgment > Other Reports > EFT Lodgment Report.

The Direct Debit Authorisation (EM) Lodgment Report may be used to produce a listing, with statistical summary, of EM forms on the Tax ledger (attached to Individual and Trust returns).

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > EFT Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgEFT which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per EM form suitable for writing letters to clients will be produced.


This field is available for this report using the letter layout:
#61 - Status

• Report Type: The default is listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per EM form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

EX Lodgment Report

Access: Select Lodgment > Other Reports > EX Lodgment Report.

The EX Lodgment Report may be used to produce a listing, with statistical summary, of EX forms (Notification of Members Joining/Leaving a Consolidated Group) on the system.

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > EX Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgEX which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per EX form suitable for writing letters to clients will be produced.


The following fields are available for this report if using the letter layout:
This field is available for this report using the letter layout:
#61 - Status

• Report Type: The default is listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per EX form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

XX Lodgment Report

Access: Select Lodgment > Other Reports > XX Lodgment Report.

The Standalone Family Trust election (xx) Lodgment Report may be used to produce a listing, with statistical summary, of XX forms on the Tax ledger (attached to Fund and Trust returns).

Alternatively, to produce one report per XX form, suitable for writing letters to clients select Reports > Letter and the appropriate letter layout.

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Partner code

• Manager code

How to prepare the report:

1. Click Lodgment > Other Reports > XX Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgXX which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per XX form suitable for writing letters to clients will be produced.

• Report Type: The default is Listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per XX form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

YY Lodgment Report

Access: Select Lodgment > Other Reports > YY Lodgment Report.

The Standalone Interposed Entity election (YY) Lodgment Report may be used to produce a listing, with statistical summary, of YY forms on the Tax ledger (attached to company, Fund, Partnership and Trust returns).

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Partner code

• Manager code

How to prepare the report:

1. Click Lodgment > Other Reports > YY Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgYY which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per YY form suitable for writing letters to clients will be produced.

• Report Type: The report type defaults to Listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per YY form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

TD Lodgment Report

Access: Select Lodgment > Other Reports > TD Lodgment Report.

The Trust Details TFN Reporting Lodgment Requirements is a listing, with statistical summary, of TD forms on the file (attached to Trust returns).

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > TD Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgTD which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per TFN report suitable for writing letters to clients will be produced.

• Report Type: The default is Listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per TD form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

TW Lodgment Report

Access: Select Lodgment > Other Reports > TW Lodgment Report.

The Trust Details Annual TFN Withholding Lodgment Requirements is a listing, with statistical summary, of TW forms on file (attached to Trust returns).

The data reported includes:

• Return code

• TFN (this may be excluded by setting the Print Options appropriately)

• Status

• Status Date (this is the date the status shown was attained)

• Partner code

• Manager code

• Name appearing on the return

How to prepare the report:

1. Click Lodgment > Other Reports > TW Lodgment 

2. Select the report options:

• Sort by: The sort option determines the sequence of the report. The default is to prepare the report in Return code sequence.

• (AE) Letter Layout: The default layout is LodgTW which prepares the listing with the statistical summary. By choosing an appropriate layout combined with the Report Type 'letter' one page per Annual TFN Withholding Report suitable for writing letters to clients will be produced.

• Report Type: The default is Listing.


(AE) Alter the report type to E for Letter and combine this with an appropriate layout to produce one page per TW form.

3. Click OK to proceed to preview or print the report or both.

Related topics

(AE) Return Fields (A101 - A199)

(AE) Front Cover Fields (C101 - C180)

How to Preview a Report

Back to Other Reports

BAS/IAS Reports

The BAS/IAS reports monitor the lodgment of BAS and IAS form types:

• Lodgment Status Report

• BAS/IAS Lodgment Reporting

Lodgment Status Report

The Lodgment Status Report for BAS and IAS verifies for a specific period end date which Activity Statements need to be lodged and those that have been lodged.

How to prepare the report:

1. Click Lodgment > BAS/IAS > Lodgment Status Report.


To complete the report parameters:

2. Select the type of BAS or IAS by entering a number from 1 - 9 (the [F10] list provides the meaning of these codes).

3. Select the period end date for the report.

4. Select the lodgment status, (either lodged or not lodged may be selected, or you may select both).

5. For formatting select the report layout at Use layout. For example, to prepare the BAS/IAS Lodgment Report select GAGBLODG.

6. Select the Sort sequence Primary, Secondary or Tertiary.

7. Each Activity Statement type begins on a new page.

8. Click OK to proceed to print or preview the report.

Failed lodgments

To reduce instances of failed lodgment because of an incorrectly used DIN, Tax provides a Revision Management process which forces the tax agent to apply a revision number to amended activity statements. Activity statements listed in this report will have a Rev number if they have been created for the purpose of revising a previously lodged activity statement. this will be a number between 1-9.

This Rev number is not to be confused with the reporting code (also a number between 1 - 9) used to indicate what type of activity statements to include in the report.

Back to BAS/IAS Reports

BAS/IAS Lodgment Reporting

BAS/IAS Lodgment Reporting: This reports on the lodgment status of BAS and IAS Payers.

BAS/IAS due report: This reports all BAS/IAS payers (as determined by the criteria selected) that:

• Do not have a BAS or IAS schedule attached with a period end within the date range specified OR

• Do have a BAS or IAS schedule attached with a period end within the date range specified, but which has not been lodged.

To access BAS/IAS Lodgment reporting:

• Click Lodgment > BAS/IAS > BAS/IAS Lodgment reporting or

• Click Lodgment > BAS/IAS > BAS/IAS due report.

Lodgment Report

This function is used to report on the lodgment status of BAS and IAS Payers.

Report: Select from one of the six options as shown below that have been previously selected in the BAS/IAS Payer field on Return Properties, General Tab.

1. BAS Monthly

2. BAS Quarterly

3. IAS Monthly

4. IAS Quarterly

5. All BAS and IAS (GA/GB)

6. Annual GST (GR)

7. Annual GST (GI)

8. All Annual (GR/GI)

9. All Returns (GA/GB/GR/GI)

Include forms with period ending From/To: If the default of 'First' and 'Last' is used, all BAS or IAS payers (as selected in the Report field) will be reported on. However, this report can be restricted to a date range by entering the first date in the range in the From field and the last date in the To field.

Status: Select one or more of the following options to report on the lodgment status of BAS/IAS payers (as set in the Lodgment, Update, BAS/IAS forms screen).

• Not Lodged

• Sent for signature

• Lodged

Date status level reached From/To: If the default of 'First' and 'Last' is used, all BAS or IAS payers who have attained their selected status will be included in the report.

However, the report can be restricted so that only those schedules that have reached a certain status within a particular date range are included. This can be done by entering a date range in the From and To fields.

For example, to report on all monthly BAS payers (as selected in the Return Properties, General Tab) that have not lodged a BAS for the period ending 31/07/2009:

• select BAS Monthly in the Report field, and

• enter a date range of 1/07/2009 to 31/07/2009 for period ended From and To.

The report lists all returns that:

have been flagged as a monthly BAS payer in the Return Properties, General Tab, and

do not have a Lodged BAS schedule with a period ending 31/07/2009.

Use layout: Accept the default option GAGBLODG, which is the BAS/IAS Lodgment Report layout or select another format from the list.

Suppress printing of multiple schedules: Tick this option to print only the latest BAS or IAS attached to each return.

Sort sequence: Accept the default sorting sequence of Primary or select Secondary or Tertiary sequence.

New page on new code?: If Y is selected, the information for each of the sorting sequences selected at the By Field field will begin on a new page. For example, if the report is sorted by Partner, the information sorted by Partner code will begin on a new page. If N is selected, the report will print on continuous pages.

Due Report

This function is used to report on upcoming lodgment due dates of BAS and IAS Payers.

Report: Select from one of the options as shown below that have been previously selected in the BAS/IAS Payer field in the Return Properties, General Tab.

1. BAS Monthly (GA)

2. BAS Quarterly (GA)

3. IAS Monthly (GB)

4. IAS Quarterly (GB)

5. All BAS and IAS

6. Annual GST (GR)

7. Annual IAS (GI)

8. All Annual (GR/GI)

9. All returns

Specify period end From/To: Enter the period end that you want to report on.

For example, to report on all monthly BAS payers (as selected in the Return Properties, General Tab) that have not lodged a BAS for the month ending 31/07/2009:

• select BAS Monthly in the Report field, and

• enter a date range of 1/07/2009 to 31/07/2009 for period ended From and To.

The report will then list all returns that:

• have been flagged as a monthly BAS payer in the Return Properties, General Tab, and

• do not have a Lodged BAS schedule with a period ending 31/07/2009.

Use layout: Accept the default option GAGBDUE, which is the BAS/IAS Due Report layout or select another format from the list.

Sort sequence: Accept the default sorting sequence of Primary or select Secondary or Tertiary sequence.

New page on new code?: If Y is selected, the information for each of the sorting sequences selected at the By Field field will begin on a new page. For example, if the report is sorted by Partner, the information sorted by Partner code will begin on a new page. If N is selected, the report will print on continuous pages.

Back to BAS/IAS Reports

Table Maintenance

The ATO defines these tax tables but they can be edited should the ATO change the tax levels during the year. A sub-menu of two options:

1. Standard I, P and T forms and

2. Standard C and F forms.

The Lodgment Levels display for editing as required.

Back to Reporting from Tax

Budget Maintenance

The ATO defines lodgment budgets, as the date by which returns of each tax level must be lodged. This routine is used to set targets for the tax practice so that a lodgment program can be planned and maintained.

To access Budget Maintenance:

1. Click Lodgment > Budget Maintenance and select:

• Select New and complete the Date and Form types that pertain to this new table of budgets. Click OK to add the new table to the Budget Index.

• Highlight an entry in the Budget index and click [Enter] or Properties to open the table for editing. If this is a new table there will be no budgets recorded, or

• Delete an existing option. Highlight the entry and click Delete.

When setting the budgets the user nominates:

• the date by which returns should be lodged

• the type of returns involved, for example, I, P or T

• what percentage of returns of a specific level must be lodged, for example, 50% of level 4 returns

Related topics

Budgets Data Entry

Back to Reporting from Tax

Budgets Data Entry

This allows you to plan your lodgment program and later report on the number and percentage of returns lodged against the budgets you have set.

You may nominate:

• the date by which returns should be lodged;

• the type of returns, either I, P, T or C, F

• what percentage of returns of a specific level must be lodged by the date shown, (for example, 50% of level 4 returns).

Table

Date: This is the target date by which you want to have the returns lodged. Enter the date in the format DD-MM-CCYY.

Form: Select the form types to be included in the report from the list of the available options: I, P and T forms, or C and F forms.

Percentages

% Lodged: Enter the percentage of returns in classifications LOD1, LOD2, LOD3 and All, for example, 100% of level LOD2 returns. You may bypass a level by click [Enter].

Related topics

ATO Statistics

Performance Report

Progress Report

Back to Budget Maintenance