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

 for

 and combine this with an appropriate layout to produce one page per MC form.

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

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

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

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

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

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

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

1. 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:

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

2. Select the period end date for the report.

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

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

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

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

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