Returns

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

The Client Update (Form CU) allows tax agents to communicate to the ATO changes pertaining to income tax and activity statement details for individuals and entities on the one form.
Tax identifies Form CU for individuals with the code 'cui' and for entities with the code 'cue'.

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:

Click Lodgment > Other Reports > CU Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > EFT Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > EX Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > XX Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > YY Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > TD Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > TW Lodgment
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.

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

How to prepare the report:

Click Lodgment > BAS/IAS > Lodgment Status Report.

To complete the report parameters:

Select the type of BAS or IAS by entering a number from 1 - 9 (the [F10] list provides the meaning of these codes).
Select the period end date for the report.
Select the lodgment status, (either lodged or not lodged may be selected, or you may select both).
For formatting select the report layout at Use layout. For example, to prepare the BAS/IAS Lodgment Report select GAGBLODG.
Select the Sort sequence Primary, Secondary or Tertiary.
Each Activity Statement type begins on a new page.
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.

BAS Monthly
BAS Quarterly
IAS Monthly
IAS Quarterly
All BAS and IAS (GA/GB)
Annual GST (GR)
Annual GST (GI)
All Annual (GR/GI)
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.

BAS Monthly (GA)
BAS Quarterly (GA)
IAS Monthly (GB)
IAS Quarterly (GB)
All BAS and IAS
Annual GST (GR)
Annual IAS (GI)
All Annual (GR/GI)
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:

Standard I, P and T forms and
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:

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

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).

UI Text Box

type	note

If you do not elect to update levels, or if the level of the return in Tax is correct, the due date will not be updated.

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.

UI Text Box

type	note

You cannot click OK to proceed to the report from the TFN field. You must click [Tab] or [Enter] so that the TFN is matched against the returns in the ledger before the report can commence.

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:

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:

Click Lodgment > Other Reports > ATO letter.
Complete the Record Selection screen by selecting the sort sequence and the range to be printed.
Complete the Preview/Print screen.
At the prompt Reset ‘lodged this run’ flag? select Yes.

How to print the Performance Report:

Click Lodgment > Other Reports > Performance.
Complete the Record Selection screen to select the range and click OK.
Complete the Preview/Print screen to select the output options required for this report.
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.

UI Text Box

type	note

The checkbox will be unticked initially, as the standard is to include subsidiaries of a 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:

Select Lodgment > Other reports > Progress.

INSERTIMAGE Image Removed

On the Record Selection screen:

select Status:Returncode
enter a range of returns or accept the default which all returns, and
click OK.

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

INSERTIMAGE Image Removed

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

INSERTIMAGE

INSERTIMAGE Image Removed

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.

UI Text Box

type	note

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

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 Image Removed

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.

How to print the Table Report:

Click Lodgment > Other Reports > Table.
At the Lodgment Table window select one of the alternatives:

All returns,
Returns not lodged and
Returns lodged.

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

UI Text Box

type	note

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

Click OK to continue.
Complete the Record Selection to select the sort sequence and the range to be printed.
Complete the Preview/Print screen to select the printing options for this report.
The table report prints in the manner you have chosen.

How to prepare the report:

Click Lodgment > Other Reports > FBT Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > SCS Lodgment
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.

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

How to prepare the report:

Click Lodgment > Other Reports > MC Lodgment
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.

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

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.

UI Text Box

type	note

The default Date Due in return lodgments is generated from the first date the return's ATO level is 100% due, in budgets.

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].

UI Text Box

type	note

LOD3 - LOD9 are used for substituted accounting periods.

Page tree

Versions Compared

Old Version 1

New Version Current

Key

Discrepancies reported

Verify ATO Listing options

Related topics

How to print the Performance Report:

Performance report options:

How to print the Lodgment Progress Report:

Lodgment Progress options

Date Range

Related topics

How to print the Table Report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Related topics

How to prepare the report:

Failed lodgments

To access BAS/IAS Lodgment reporting:

To access Budget Maintenance:

When setting the budgets the user nominates:

Related topics

Table

Percentages

Related topics

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?

Returns

Activity Statements

Forms and Schedules

Using MYOB AE/AO Tax