AE Tax only The fields and variables listed here can be specified in text documents to print the information as described: System Fields UI Expand |
---|
| These variables can be specified in text documents to print the information shown: |
Variable | Description |
---|
@Date | The system date in the format 30/10/02 | @Time | The system time in the format 03:44:32:43. | @Client Code | The client code of the ledger currently open | @Application | The application code of the ledger currently open | @Client Name | The client name of the ledger currently open | A6 fields | To include an A6 field determine the current status of the field by clicking [F9] at the relevant Tax Step of the Return. |
| UI Expand |
---|
| The date can be formatted in fifteen different ways. The 'D' in the date field is used to determine whether the date is printed in upper or lower case. Format that may be used when printing a date: Field | Sample/Format (using 2009 as an example) |
---|
^Date | 19/05/2009 | ^0Date | 19/05'09 | ^1Date | 19/05/09 | ^2Date | 19th May 2009 | ^U2Date | 19TH MAY 2009 | ^3Date | May 2009 | ^4Date | May | ^5Date | 2009 | ^6Date | 19th May | ^7Date | 19th | ^8Date | 19th May 2009 | ^9Date | 19/05/09 | ^10Date | 09/05/19 | ^11Date | 19 (day) | ^12Date | Oct (abbreviated month name only) | ^13Date | 5 (numeric month only) | ^14Date | pp (two digit year) | ^15Date | th (day extension) |
| Reports | These fields are available in most tax reports: Field | Description |
---|
#14 | Amount payable or refundable | #15 | PAYG Tax payable ('NIL' when this amount is zero) | #17 - #32 | Refer to Total Report. | #59 | First two initials of an individual without full stops. Alternative to A198 | #73 | Name of CONTACT1 for Client | #74 | Name of CONTACT2 for Client | #77 | PDF password | #89 | Company /Fund Lodgment Classification in long format. A Flexi Reporting field to provide a translation of the Company and Fund lodgment (LOD) levels from 1-9 and A-K to Lod 1, Lod 2, Lod 3, and so on. | #91 | Tax software version (Estimate Footer only) | #94 | 'Refund' when C477 is negative otherwise 'Tax Due' | #95 | Given Names and Surname (A189 + A191 + A190) of individual or entity name | #96 | 'Payable' A125 is positive; otherwise reads 'Refundable'. | #97 | A125 (amount payable) cannot be used ONLY to print its value. | #98 | A125 (amount refundable) cannot be used ONLY to print its value. | absA125 | absA125 can be used in numeric calculations in place of #97 or #98. |
|
Fields specific to the report or Flexi report as shown: |
Field | Flexi Report | Invoice - when Return printing | Letter printed with or without a Return |
---|
#21 | - | Partner Name | Partner Name | #22 | - | Manager Name | Manager Name | #23 | - | Employee Name | Employee Name | #48 | - | I/We | I/We | #49 | - | Agent name | Agent name | #52 | - | Agent phone number | Agent phone number | #53 | - | Agent phone area code | Agent phone area code | #54 | Name of Partner for Return | Agent phone | Agent phone | #55 | Name of Manager for Return | Agent ABN | Agent ABN | #56 | Name of Employee for Return | Agent ABN Division Number | Agent ABN Division Number | #57 | Name of Agent for Return | - | - | #58 | Name of Contact for Return | - | - | #60 | Name of the Client to which the Return is attached. | Invoice number. This functions only when printing Returns to printer. In other situations the invoice number does not increment. | Name of the Client to which the Return is attached. | #61 | Name of the Client to which the Return is attached. | | Name of the Client to which the Return is attached. | #70 | - | Name of the Client to which the Return is attached. | - | #71 | - | Name of the Client to which the Return is attached. | - |
| Report | The fields listed below are available for the Total report when the selections for the report are: To locate these settings, click Reports | > Flexi > Properties > Properties > Layout. A sample report using this method is available by printing the Flexi report with the layout code 'Lodge'. Field | Description |
---|
#17 | First Total | #18 | Second Total | #19 | Third Total | ...and so on up to 16 | #32 | Sixteenth Total |
| Fields Field | Description |
---|
A101 | Return Code | A102 | Client Code | A103 | Tax File Number | A104 | Year | A106 | Form Type | A107 | Lodged? | A108 | Date Lodged | A109 | Lodged This Run? | A110 | Period Start Date | A111 | Period End Date | A112 | Status | A113 | Date Status Changed | A114 | Partner | A115 | Manager | A116 | Employee attached to a return | A117 | Office Index | A118 | ATO Level | A119 | ELS Return? | A120 | Tax Paid Last Year | A121 | 1 PAYG Tax Paid Last Year | A122 | Estimated Tax This Year | A123 | Estimated PAYG Tax This Year | A124 | Taxable Income | A125 | Tax Assessed | A126 | PAYG Tax Assessed | A127 | Invoice Amount | A128 | Amount paid on Invoice | A129 | Amendment Number | A130 | Lodged via ELS | A132 | ELS Checklist? | A133 | Amendment lodged? | A134 | Delete on Rollover? | A135 | Data Entry Complete? | A136 | Offline - is the return exported? | A137 | Is the return Secure? | A138 | Company Classify | A139 | Previous Title | A140 | Date ELS Sent | A141 | Date Due | A142 | Date Tax Payable | A143 | Date amendment lodged | A144 | Agent | A145 | Contact | A146 | Date Printed | A147 | Instalment Type Quarterly? | A148 | Company or Super Fund Classification | A149 | I/T/EFT Status | A150 | ATO | A151 | ATO Last Year | A153 | Name Changed? | A154 | Postal Address Change? | A155 | Printed? | A156 | ELS Accepted by ATO? | A157 | 30% CCR Transfer form flag | A158 | STS taxpayer? flag | A159 | Sent for signature? | A160 | ANZSIC Code | A161 | Last year Taxable Income loss | A162 | Last year Gross Tax Paid | A165 | PAYGTaxDate1 | A166 | PAYGTaxDate2 | A167 | PAYGTaxDate3 | A168 | PAYGTaxDate4 | A169 | Australian Business Registration Number (ABN) | A170 | Occupation Code | A171 | Likely Tax This Year | A172 | Use Agent EFT details? | A173 | Application for refund excess credits? | A174 | SFN of Fund | A175 | ABN Division Number | A176 | E-mail address | A177 | Mobile telephone | A178 | Fax area code | A179 | Work Telephone area code | A180 | Work Telephone | A181 | Fax | A182 | Occupation Description | A183 | back-up Of Return (Original to amendment) | A184 | back-up Return Codes | A185 | Home Telephone area code | A186 | Home Telephone number | A187 | BAS Period | A188 | IAS Period | A189 | Title | A190 | Surname | A191 | Given Names | A192 | ACN | A193 | Mailing Address 1 | A194 | Mailing Address 2 | A195 | Mailing Address 3 | A196 | Mailing Address 4 | A197 | Salutation | A198 | Initial(s) | A199 | Alternate Salutation (Given Name) |
| UI Expand |
---|
title | Control Record and ELS Fields (A201 - |
---|
| A299 Field | Description |
---|
A201 | Control Code | A202 | Schedule Year | A204 | ELS Lodgment Office | A207 | ELS User ID | A208 | Date password Change | A210 | ELS Approval Code | A214 | Agent Reference No. | A218 | Previous ATO Office | A219 | ATO Office | A220 | I/We | A263* | Australian Business Number (ABN) of practice* | A264* | Division Number of practice* | A267 | Start of standard financial year | A268 | End of standard financial year | A279 | Fax Area Code | A280 | Fax Number | A281 | ACN/ARBN Number | A290 | Agent Name | A291 | Contact Given Names | A292 | Contact Family Name | A293 | Postal Street Number and Name Line 1 | A294 | Postal Street Number and Name Line 2 | A295 | Previous Street Number and Name Line 1 | A296 | Previous Street Number and Name Line 2 | A297 | Alternate Address 1 | A298 | Alternate Address 2 | A299 | E-mail Address | C385 | Postal Town/Suburb | C386 | Postal State | C387 | Postal Country | C388 | Postal Postcode | C391 | Previous Town/Suburb | C392 | Previous State | C393 | Previous Country | C394 | Previous Postcode | C397 | Telephone Area Code | C398 | Telephone | C399 | Ledger Name |
UI Text Box |
---|
| The fields A263 and A264 print the ABN and Division Number of the practice using Flexi Reporting. To print the ABN and Division Number of the agent attached use the System Fields #55 and #56, also refer to System Fields. |
|
UI Expand |
---|
title | Agents, contacts, lodgment status and |
---|
| Standard standard answers (A601 - A691) |
|
Field | Description |
---|
A601 | Code | A605 | Type (Agent, Contact, Return Status, Standard answer, Flexi Report) | A606 | Schedule Type/Flexi | A608 | I/We/SFS | A609 | ELS | A611 | Bank BSB Number | A613 | Bank Account Number | A620 | ELS Code | A663 | Agent's Australian Business Number (ABN) | A664 | Agent's ABN Division Number | A679 | Mobile | A683 | A683 Bank Account Name | A681 | A684 Fax Area Code | A685 | A685 Fax | A686 | A686 Area Code | A687 | A687 Phone 1 | A690 | A690 Name/Description | A691 | A691 Phone 2 |
| UI Expand |
---|
title | Current User Fields (A701 - A797) |
---|
|
Field | Description | A701 | Employee Code of the user currently logged into Tax | A704 | Default ATO lodgment office | A725 | Default contact code | A797 | Employee Name of the user currently logged into Tax |
UI Text Box |
---|
| The employee attached to a return is A116. |
|
UI Expand |
---|
title | Front Cover Fields (C101 - C180) |
---|
|
Field | Description |
---|
C101 | Return Code | C102 | Gender | C103 | Attachments? | C105 | Resident? | C106 | First? | C107 | Final? | C108 | Refund? | C109 | Company/Trust/Fund Type | C111 | Industry group (F form) | C112 | Trustee Tax Payable? | C113 | Section 16A Question | C114 | EFT Election | C115 | Variation Applied? | C116 | Original Resident | C117 | First S16A Year | C118 | Assessment Number | C119 | Section 158K Year | C120 | Date of Birth | C121 | Date of Death | C122 | Date Last Super Contribution | C123 | Date Released | C124 | Assessment Issue Date | C125 | Primary Tax Due | C126 | PAYG instalment 1 date | C127 | PAYG instalment 2 date | C128 | PAYG instalment 3 date | C129 | PAYG instalment 4 date | C130 | Century Of Birth | C131 | Amount of post-June 1983 ETP threshold previously used | C134 | Item 3 Tax Amount | C136 | PAYG instalment 1 amount | C137 | PAYG instalment 2 amount | C138 | PAYG instalment 3 amount | C139 | PAYG instalment 4 amount | C140 | Varied PAYG Tax? | C141 | Partner/Trustee C/I | C142 | Company in Liquidation? (C form) | C143 | Number of PP Average Years | C144 | I Dist PrtnrshipTrust | C145 | PP Average 1Yr Prior | C146 | PP Average 2Yr Prior | C147 | PP Average 3Yr Prior | C148 | PP Average 4Yr Prior | C149 | I Eligible Business Income | C150 | Postal Postcode | C151 | I Other Eligible Tax Income | C152 | Residential Postcode | C153 | Hours Taken | C154 | Previous Postcode | C155 | Other Average 1Yr Prior | C156 | Other Average 2Yr Prior | C157 | Other Average 3Yr Prior | C158 | Other Average 4Yr Prior | C159 | Election Status 1 | C160 | Postal Address | C161 | Postal Address 2 | C162 | Residential Address 1 | C163 | Residential Address 2 | C164 | Previous Address 1 | C165 | Previous Address 2 | C166 | Family Name of Spouse (I form) Public Officer (C form) Partner (P Form) Trustee (T and F Forms) | C167 | First Name(s) of Spouse (Form I) Public Officer (C Form) Partner (P Form) Trustee (T and F Form) | C168 | Previous Family Name | C169 | Previous Given Names | C170 | Partner/Trustee title (P, T, F forms only) | C171 | Previous Partnership TFN (P form only) | C172 | Type Source Amount Future | C173 | EFT Account BSB | C174 | EFT Account number | C176 | EFT Account name | C177 | FC Home Phone Area | C178 | FC Home Phone | C179 | Election Status 2 | C180 | Election Status 3 |
| UI Expand |
---|
title | What-If Calculator Fields (C401 to C492) |
---|
|
Field | Description |
---|
C401 | Return Code | C402 | Primary Producer | C403 | No. Average Years | C404 | Year Prior Income | C405 | 2 Year Prior Income | C406 | 3 Year Prior Income | C407 | 4 Year Prior Income | C408 | Current Year Income | C409 | Net PP Income | C411 | IED Withdrawn | C412 | Net Medical Expenses | C413 | Life Assurance Bonus | C414 | Reduced notional lease premium | C415 | Net Salary Income | C416 | Group Tax Deducted | C417 | Zone Rebate? | C418 | PAYG Tax Paid | C419 | Pensioner? | C420 | Unmarried Minor? | C421 | Resident? | C422 | Instalments? | C423 | Eligible Income | C424 | Tax on Trust Income | C425 | Tax on This Year's Income | C426 | Tax on PP Average Income | C427 | Benefit from Average Income | C428 | Pensioner Rebate | C429 | Additional Threshold Income | C430 | Primary Production Rebate | C431 | Zone Rebate | C432 | Term Income Rebate | C433 | Spouse Rebate | C434 | Child-Housekeeper Rebate | C435 | Invalid Relative Rebate | C436 | Parent/Spouse Rebate | C437 | Sole Parent Rebate | C348 | Student Child < 25yrs | C439 | Other Children < 16yrs | C440 | Relevant Rebate Amount | C441 | Beneficiary Rebate Indicator | C442 | Beneficiary Rebate? | C443 | Marital status | C444 | Days In Special A | C445 | Days in Special B | C446 | Days in Ordinary A | C447 | Days in Ordinary B | C448 | Gifts/Donations | C449 | Salary Related Deductions | C450 | Net Other Income | C452 | Other Deductions | C453 | Net Capital Gain | C454 | Notional PP Income | C455 | Section 59AB balancing charge | C458 | Housekeeper rebate | C459 | Total Heritage Conservation Rebate | C460 | Film Industry Deduction | C461 | PPS Tax Paid | C462 | Average Income | C463 | Spouse Taxable Income | C464 | Total Other Rebates | C465 | Capital Gains Tax | C466 | Medicare Levy | C467 | TFN tax paid | C468 | Medical Expenses Rebate | C469 | PAYG Tax | C470 | Married? | C471 | Sole Parent? | C473 | Section 86 notional lease premium | C474 | Foreign Tax Credit | C475 | Unemployed/Sickness Rebate | C476 | HECS Contribution | C477 | Refund/Payable | C478 | IED Tax Paid | C479 | Remote Area Allowance | C480 | Child-Housekeeper Rebate? | C481 | Over 55 years? | C483 | Medicare Half Exemption Days | C484 | Tax-Free Threshold | C485 | Rebate Unused Annuity Premium | C486 | Lump sum 30% | C487 | HECS Debt | C488 | Non Rebatable Unused Annuity Premium | C490 | Transfer Unused Spouse Rebate? | C492 | Spouse/Child-Housekeeper/Dependant? |
| UI Expand |
---|
title | What-If Calculator fields (E105 to E182) |
---|
|
Field | Description |
---|
E105 | Super Rebate? | E106 | Spouse a Pensioner? | E107 | Sportsperson? | E108 | Calculate PAYG Tax? | E109 | Housekeeper? | E110 | Threshold Months | E111 | 1st Year of Averaging (Div16A) | E115 | Spouse Days | E116 | Days Full Medicare Exemption | E117 | Sole Parent Days | E118 | Housekeeper Days | E119 | Child-Housekeeper Days | E130 | Marginal Tax Rate | E137 | Abnormal Income | E138 | Spouse SNI | E139 | Child-Housekeeper SNI | E141 | Post-June 1983 taxed component of ETP | E142 | Post-June 1983 untaxed component of ETP | E143 | ETP at 0% (Other than Death Benefit ETP) | E145 | ETP at 15% (Other than Death Benefit ETP) | E147 | ETP at 20% (Other than Death Benefit ETP) | E149 | ETP at 30% (Other than Death Benefit ETP) | E150 | Exempt Foreign Source Income | E151 | Average Tax Rate of Australian Tax | E152 | Sports 4 Year prior Income | E153 | Sports 3 Year prior Income | E154 | Sports 2 Year prior Income | E155 | Sports 1 Year prior Income | E156 | Life Ass/Friendly Society Rebate | E157 | Income in Arrears Rebate | E158 | Low income earner's rebate | E159 | Other Rebates | E160 | Residency Question? | E161 | Social sec/Veteran type of pension | E163 | Total Primary Tax on Taxable Income | E164 | Total Rebates | E168 | Franking Credit | E170 | Foreign Employment and Pension Income | E171 | Other general net foreign source income | E172 | Superannuation Contributions | E173 | Total Assessable Income | E174 | 5% Assessable Income | E175 | Friendly Society Bonus | E176 | Net Average Eligible Income | E177 | Superannuation Rebate | E179 | Div16A Year | E180 | Eligible Salary Income | E181 | Eligible Other Income | E182 | Higher Education Contribution Scheme amount |
|
Create a Flexi Report Layout Invoice Layout in a text letter Invoice Layout in a text letterAE Tax only The Invoice Layout Selection screen displays when you select to print an invoice from the Print Return screen. There is one invoice layout available for an entity (where the taxpayer is a Company, Fund, Partnership or Trust). If a layout other than the four default layouts is required, click Edit then [F10] for an index of practice letters from which to choose. At the Starting Invoice Number field, you may enter an invoice number. The maximum available field length is ten numeric characters. The invoice number is augmented by one with every subsequent invoice printed. UI Text Box |
---|
| Make sure that the field ^#60 which is the special field designed as the Invoice number accumulator, is included in any layout chosen otherwise no Invoice number will be printed. To do this, click Maintenance > Letter Writing > Practice Letters. Select the desired layout from this Index and type ^#60 at the position you wish the invoice number to print. Where it is required to preface the invoice number with a description (for example, 'Invoice No.'), this description should be typed before the ^#60. |
The invoice field is only available when an Invoice is printed to the printer and only when printing from the Print Returns option in the Reports menu. It cannot be used if you are using the Letters option in the Reports menu. Example of a text letter Invoice ^2Date^A193 See word processing fields to view ^A194 the fields available ^A195 for use in document or note preparation ^A196 Ref: ^A101 Invoice Number: ^#60 for Preparation of ^A106 return Dear ^A197 This document is to demonstrate how your practice can prepare an invoice using the word processing features of Tax. An invoice amount can be included and invoiced. In this example you are about to be invoiced for the following amount $^A127. This figure can be included for a return after selecting the invoice option when adding a return. The estimate of your tax payable for this year is $^#14. This should be included in your notice of assessment issued by the ATO. (As per ^D491). Fields available for word processing Office IndexUsing the Office Index, Tax can sort client and return information for you. Enter a mask, up to 8 alphanumeric characters, to represent details of a client or return (such as type of return, new client, etc). Unused spaces can be blank. Tax will sort and group clients according to each of these characteristics. UI Text Box |
---|
| Characters must be entered in the correct order (the same order each time), otherwise the sorting (and therefore reporting) is meaningless. |
ExampleThis shows the office index set up to sort on these information types: Position of Office index | Description of character | Examples of possible entries |
---|
1st | Partners | 1 2 3 4 | 2nd | Managers | 1 2 3 | 3rd | Type of return | I C T P | 4th | New client this year | Y (Yes) N (No) | 5th | Type of industry | W (Wage Earner) P (Primary Producer) M (Manufacturer) | 6th | FBT | F | 7th | Land Tax Client | L | 8th | PAYG Tax Payer | P |
So a new wage-earning client assigned to partner 1 and manager 2 for whom you are preparing an I return would have office index 12IYW. Mask Facility Office Index Mask Office Index MaskThe Office Index Mask is used for sorting and reporting. In the Office Index Mask, enter the sort character(s), then enter a ? in place of the other characters. Doing this means that sorting will proceed according to the characters that you entered. Example: To print a report of new clients this year in the Office Index, the Office Index Mask would be ???Y???? or ???Y* (where * represents any character following the ?'s). To print a report of new Individual Return clients this year, the Office Index Mask would be ??IY???? or ??IY*. New P clients would be ??PY???? or ??PY* etc. Office Index Mask Facility Mask FacilityThe Mask facility allows the user to select data by matching against specific character contents. For example, select a set of returns to print by matching return codes against the mask. Masking is currently available for the following: Special characters that can be used to select groups of codes include the following: Special Character | Meaning when used to match against groups of codes |
---|
* | asterisk signifies that 0 or more characters must be in the position | ? | question mark signifies that 1 character must be in the position. | - | minus negates the mask and may be used at each mask selection defined or separated by a pipe or tilde. | | | pipe means 'or' | ~ | tilde means 'and' |
Examples of the use of a mask: Mask | Meaning |
---|
H???i | Match all codes where the first letter is H and fifth letter is i. The three question marks signify one unknown character each. | *I | Match all entries whose code ends in I. The asterisk signifies an unknown and unlimited number of characters, followed by I (then the rest of the code). | *I* | Match all entries whose code contains an I. Any characters, then I then any characters. | ?? | Match all entries whose code is two characters long. One character, followed by another character (then end of code). | C*|F* | Match all entries whose code starts with C or F. C followed by anything OR F followed by anything. | -C* | Match all entries whose code does NOT start with C. NOT C followed by anything. | -F* | Match all entries whose code does NOT start with F. NOT F followed by anything. | -C*~-F* | Match all entries which start with anything other than F or C. NOT C followed by anything AND NOT F followed by anything. |
Letter Writing in Tax Calculator, Tax Tracking and Client DatabaseAE Tax only The letter writing options include: The only Letters in the Calculator are the Header and Footer for the Estimate. These are stored as Master Letters. In order to be able to edit the Header or the Footer, they need to be Copied from Master. How to add or edit the details of a letter layoutClick Maintenance > Letter Writing > Client Letters.
The Lettersindex is displayed.If you are adding a new letter layout, click New.
If you are editing an existing letter layout, highlight the letter layout to be edited and click Properties.
If you are adding a new letter this letter screen displays:
INSERTIMAGE Image Removed Code: There are up to ten alphanumeric characters available in this field. Key a code with which to index the letter layout. All letters are listed in alphabetical order according to the code that has been entered in this field. Description: There are up to forty alphanumeric characters available in this field. Key a meaningful description for the letter layout, for example, 'Label page definition'.Click [F6] to save the changes you have made in the Letter screen and proceed to write the actual layout of the letter or report. Master Letters IndexAE Tax only Master letters are provided as templates for all the reports and listings that can be printed from Tax Calculator. Master letters in Tax Calculator consist solely of estimate headers and footers. Each letter is set out as a multi-columned report containing letter writing fields. The fields are used to extract specific name and address information from the application for inclusion in your reports, for example ^A124 for the name of the partner. In order to create a letter or customise the master letter to suit your practice's needs, it must be transferred to Client Letters. Master letters are retained by the Tax Calculator and cannot be edited. Transferring Master Letters to Client LettersClick Maintenance > Letter Writing. Click Master Letters. Click [Alt+N] for Transfer. The range of letters to be transferred defaults to all Master Letters, that is 'first' to 'last'. Click [Enter] twice to accept the default range. Alternatively, complete the prompts to define the range of master letters to be transferred.
At Code From: Enter the code to identify the letter that will be the first letter transferred. At Code To: Enter the code to identify the letter that will be the last letter transferred. Click OK to continue editing the letter format or click Cancel to halt the process.
The Format Codescreen is displayed next.Enter a mask, if required. A mask is a sorting device which is used to sort out master letters with particular features from the range of master letters you have selected. For example, when the Mask entered is ???4*, only those master letters with the number '4' in the fourth position of their codes will be transferred. As each letter is transferred you are given the opportunity to select transfer the master letter. To do this, select: Yes to transfer this master letter and move to the next in the range No to bypass this master letter and move to the next in the range Cancel to exit the transfer routine All to transfer the full range of master letters selected
If a client letter has the same code as a master letter being transferred, you are given the opportunity to select: Switching to the Client Letters IndexFrom the Master Letters index, you may switch to the Client Letters index by clicking Client Letter or clicking [Alt+L]. The Client Letters index lists all the client letters that you have transferred. To return to the Master Letters index, click Master Letters option. Print A List of Master LettersTo print a list of the Master Letters. Click File > List. The Output Selection screen opens. Select the required printing options for this listing.
Estimate, Header/Footer Fields Client Letters Maintenance Masking Page Setups Back to Letter Writing in Tax Calculator, Tax Tracking and Client Database Client Letters MaintenanceAE Tax only Client letters consist solely of estimate headers and footers transferred from Master Letters. From the Client Index, an estimate header and footer can be selected and edited to suit a practice's needs. Header and footer fields can be inserted to extract specific name and address information for the header or footer, for example, "^A124" for the name of the partner. UI Text Box |
---|
| The content of a client letter cannot be edited in the Tax Calculator. However, the content of a client letter can be edited in the Tax Ledger by inserting letter writing fields in order to extract data from the Calculator Ledger. |
How to edit Client Letters:Click Maintenance > Letter Writing > Client Letters. To select a header or footer from the Client Letter index, highlight the client letter, then click Details or [Alt+T]. OR To create a new Client Letter select to create a new header or footer and [Enter]:
Code: Enter a code to identify the header. Each client letter must have a unique code. Up to 10 alphanumeric characters can be entered in this field. Description: Enter a description that defines the contents of the client letter. This description should be meaningful and relevant to the user. Up to 40 alphanumeric characters can be entered in this field. Click OK to continue. The letter writing screen opens. Refer to Letter Writing.
How to delete a Client LetterTo delete a client letter from the Client Letter index, highlight the letter and click Delete or [Alt+D]. How to print a List of Client LettersThe client letters contained in the index may be listed. Click File > List. The Output Selection screen opens. Select the required printing options for this report. Switch to the Master Letters IndexFrom the Client Letters index, you may switch to the Master Letters index by clicking Master Letter or [Alt+L]. The Master Letters index lists all the master letters provided by Tax Calculator. To return to Client Letters, click Client Letters option. Master Letters Index Text Letter Writing Estimate, Header/Footer Fields Record Selection How to Preview a Report Back to Letter Writing in Tax Calculator, Tax Tracking and Client Database How To print a list of letter layouts in Tax Calculator:AE Tax only Click Maintenance > Client Letters or Maintenance > Master Letters.
From the Letters index, click File > List. The default mask (*) will include all the letter layouts in the Letters index. You can key in a mask to restrict the listing to letters whose codes have specific features or attributes. Click OK. Complete the Preview/Print screen, to output to screen, printer or disk file.
Mask Facility How to Preview a Report Estimate, Header/Footer FieldsAE Tax only Practice name and contact details, and return contact and staff details, are available as letter writing fields in both Tax and Tax Calculator, for use solely in Estimate Headers and Footers. These fields in Tax pre-fill into the Tax Calculator. The corresponding Tax and Tax Calculator Field references are listed here: Client Code: ^A103 prefills to ^A102 Return Code: ^A104 prefills to ^A101 Tax Year: ^A108 prefills to ^A104 Tax File Number: ^A110, ^A111, ^A112 prefill to ^A103 Partner: ^A124 prefills to ^A114 Manager: ^A125 prefills to ^A115 Employee: ^A126 prefills to ^A116 Title: ^A192 prefills to ^A189 Surname: ^A195 prefills to ^A190 Given names: ^A194 prefills to ^A191 Full Name: ^A191 prefills to ^A190, ^A191 Mailing Address-Line 1: ^A120 prefills to ^A193 Mailing Address-Line 2: ^A121 prefills to ^A194 Mailing Address-Line 3: ^A122 prefills to ^A195 Mailing Address-Line 4: ^A123 prefills to ^A196 Agent: ^A127 prefills to ^A144 Contact: ^A128 prefills to ^A145 Salutation: ^A129 prefills to ^A197 Residential Address-Line 1: ^A196 prefills to ^A162 Residential Address-Line 2: ^A197 prefills to ^C163 Practice Name: ^C190 prefills to ^C399 Practice Address-Line 1: ^C152 prefills to ^A293 Practice Address-Line 2: ^C153 prefills to ^A294 Practice Address-Line 3: ^C154 prefills to ^C385 Practice Address-Line 4: ^C155 prefills to ^C386, ^C388 Practice Telephone number: ^C156 prefills to ^C398 Practice Facsimile number: ^C157 prefills to ^C280 Footers only: Tax Due/Refund: ^I221 prefills to ^C470 Estimates only: Agent's fee: ^I154 prefills to ^A127
Back to Letter Writing in Tax Calculator, Tax Tracking and Client Database What is personal services income (PSI)?Click this link for the Personal services income essentials on the ATO website. Reset ATO Level, Classification and Due DateAE Tax only The options available are: Confirm each change Update ATO Level Update due date Print report
After selecting your options click OK. Select the range of returns to be updated by the Utility. MCS Import Trans-Tasman Imputation System OverviewFrom 1 October 2003, a New Zealand company that has chosen to join the Australian imputation system may pay dividends franked with Australian franking credits. (A franking credit is your share of tax paid by a company on the profits from which your dividends or distributions are paid.) Australian residents who own shares in the New Zealand company or receive a distribution from a partnership or trust that includes dividend income from the New Zealand company may be entitled to claim a tax offset for the Australian franking credits. This reform is known as the Trans-Tasman imputation reform (TTI). UI Text Box |
---|
| New Zealand imputation credits cannot be claimed by Australian residents. |
Prior to the reforms, Australian shareholders of New Zealand companies who earn Australian income could not access credits arising from company tax paid in Australia on that income. This resulted in shareholders being taxed twice on such income. The same problem existed with New Zealand shareholders of Australian companies that earn New Zealand income. The Australian Government introduced rules to allow a New Zealand company to join the Australian imputation system. The ATO administers these rules. Similar rules, which are administered by the New Zealand Inland Revenue Department, were introduced by the New Zealand Government to allow an Australian company to join the New Zealand imputation system. Refer to Trans Tasman rules on the ATO website page for International tax for business. Refer to You and your shares (NAT 2632) available on the ATO website. Foreign Income Worksheet CCH References 4-490 Trans-Tasman triangular imputation rules Foreign Residents and Temporary Residents - New LawForeign ResidentsGenerally, for CGT events that happened before 12 December 2006, foreign residents have been subject to CGT on assets that have the 'necessary connection with Australia'. The Law has been changed so that for CGT events that happen on or after 12 December 2006, foreign residents who are individuals are subject to CGT on: direct interests in real estate located in Australia an interest in an entity where they and their associates hold 10% or more of the entity and the value of their interest is principally attributable to Australian real property an asset they have used in carrying on a business through a permanent establishment in Australia an option or right over one of the above
Temporary ResidentsFor CGT events that happen on or after 1 July 2006, the Law has changed so that temporary residents are subject to CGT in the same way as foreign residents. Definition of Temporary ResidentTaxpayers are temporary residents if: they hold a temporary visa granted under the Migration Act 1958 they are not an Australian resident within the meaning of the Social Security Act 1991, and their spouse (if applicable) is not an Australian resident within the meaning of the Social Security Act 1991
If the person is an Australian resident for tax purposes but not a temporary resident on or after 6 April 2006 they will not be entitled to the temporary resident exemptions from that time, even if they later hold a temporary visa. An electronic publication Foreign income exemption for temporary residents is available on the ATO website. Non-Assessable Non-Exempt income for Temporary ResidentsIf the person is a temporary resident: their foreign income is non-assessable non-exempt income, except that earned from their employment overseas for short periods while they were a temporary resident capital gains and capital losses they made from the disposal of assets that have the necessary connection with Australia from 1 July 2006 until 11 December 2006, or taxable property on or after 12 December 2006 are disregarded, except certain gains on shares and rights acquired under employee share schemes.
Any income that is non-assessable non-exempt because they are a temporary resident should not be shown on their income tax return. Eligibility for the MLS LPSIA Tax OffsetA lump sum payment in arrears will only be eligible for the MLS LSPIA Tax Offset if the amount of the lump sum is equal to or greater than ten per cent (10%) of taxable income for MLS purposes (Excluding the spouse's income when there is a spouse) in the current year, less the total LSIA. Click this link for information on the ATO website Lump sum payment in arrears. Searching a listSelection lists comprise a numeric code column and an alpha details column. UI Text Box |
---|
| You can search for an entry in the list by code or details. Remember the search facility is case-sensitive and there is no Find button. |
To locate a classification or industry code using partial details: Click on the column headed Details, to list the entries in ascending order. Click into the Details column. Begin typing as much of the description as you know and press [Enter].
UI Text Box |
---|
| What you type must match the entry in the list exactly from the beginning and taking into account upper and lower case letters. |
Scroll down through the entries to locate the one you require. Click Select to transfer the code and related details to the return.
To locate a classification or industry code using a partial code: Click on the column headed Code, until you are sure the entries are in ascending order. Click into the Code column. Type as much of the code as you know and press [Enter] Scroll down through the entries to locate the one you require. Click Select to transfer the code and related details to the return. Small business entities electionIf your client wishes to take advantage of the Concessions for small business entities, then eligibility for those concessions must be reviewed each year. If the taxpayer carried on a business at any time during the year and has an aggregated turnover of less than $2 million or is a former STS taxpayer. You need to know:Use the Tax Small business entity worksheet (sbe) to assist with the decision making and to calculate aggregated turnover. The 'sbe' can be opened by: Entering Yes in the 'Quick access to Small Business Entity worksheet' box, at this item, or Click SBE in the Depreciation worksheet (d) Index. Entering Yes in the 'Quick access to Small Business Entity worksheet' box, at item P10
It will be necessary each year to answer the 2 basic questions: Are you carrying on a business?, and Is the aggregated turnover of the business less than $2 million?
Where one or both of the answers to these 2 questions is No, access to the Simplified depreciation small business pools will not be given. For taxpayers previously in the STS, the General and Long-life STS pools will be rolled into the General and Long-life small business pools. New Small Business Entity Rules:From the 2008-2009 income year small businesses with an aggregated turnover of less than $2 million are called small business entities and may qualify for a range of tax concessions. Eligible businesses can choose to use the concessions that best suit their needs. It is not necessary to elect to be a small business entity each year in order to access the concessions. Nevertheless, eligibility must be reviewed each year. While the STS is no longer in operation all of its concessions remain available to eligible businesses. A small business entity may be eligible for the following concessions: Capital gains tax (CGT) 15-year asset exemption CGT 50% active asset reduction CGT retirement exemption CGT roll-over provisions Simplified depreciation rules Deducting certain prepaid business expenses immediately Simplified trading stock rules Accounting for GST on a cash basis Annual apportionment of GST input tax credits Paying GST by quarterly instalments Fringe benefits tax car parking exemption PAYG instalments based on GDP-adjusted notional tax
Some of these concessions have specific eligibility conditions that must also be satisfied. EligibilityThe sole trader will be a small business entity if they are carrying on a business and have an aggregated turnover of less than $2 million. Aggregated turnover is the sole trader's annual turnover plus the annual turnovers of any entities that are connected with the sole trader or are affiliates (adjusted to ignore dealings between connected entities or affiliates). Eligibility must be review each year. Calculating TurnoverTurnover includes all ordinary income the sole trader earned in the ordinary course of business for the income year. The following are some examples of amounts included and not included in order income. INCLUDE THESE AMOUNTS Sales of trading stock Fees for services provided Interest from business bank accounts Amounts received to replace something that would have had the character of business income, for example a payment for loss of earnings
DO NOT INCLUDE THESE AMOUNTS GST charged on a transaction Amounts borrowed for the business Proceeds from the sale of business capital assets Capital gains Amounts received from repayments of farm management deposits
Special rulesThere are special rules for calculating the turnover if the sole trader has retail fuel sales or business dealings with associates that are not at market value. Use the SBE Eligibility worksheet at item S1 to assist in calculating aggregated turnover. Also visit the ATO website for very detailed information. Special rules called the aggregation rules will determine who the sole trader is connected or affiliated with. These rules prevent larger businesses from structuring or restructuring their affairs to take advantage of the small business entity concessions. An entity that is connected with the taxpayer or that is its affiliate is referred to as a relevant entity. When calculating the sole trader's aggregated turnover, do not include: income from dealings between the taxpayer and a relevant entity income from dealings between any of the taxpayer's relevant entities, and income from a relevant entity when it was not the taxpayer's relevant entity
If the taxpayer is not connected or affiliated with any other entities and its business turnover is less than $2 million, then the taxpayer is a small business entity. Business operated for only part of the yearIf the taxpayer, or a relevant entity, carries on a business for only part of the income year, annual turnover must be worked out using a reasonable estimate of what the turnover would have been if the taxpayer, or a relevant entity, had carried on a business for the whole of the income year. Satisfying the Aggregated Turnover ThresholdThere are three (3) ways to satisfy the $2 million aggregated turnover requirement, but most businesses will only need to consider the first method. Business operated for only part of the yearIf the taxpayer's aggregated turnover for the previous income year was less than $2 million, it will be a small business entity for the current year. This is regardless of its estimated or actual aggregated turnover for the current year. For the purpose of working out the taxpayer's aggregated turnover for the previous year, the rules about aggregated turnover apply as if they had been in force for the 2007-08 income year. Estimate of current year turnoverIf the taxpayer's estimated aggregated turnover for the current income year is less than $2 million, it will be a small business entity for the current year. If you are estimating the taxpayer's turnover you need to assess whether it is more likely than not to have less than $2 million aggregated turnover as at the first day of income year or, if it started a business part way through the year, as at the time the business started, The taxpayer's turnover should be based on the conditions you are aware of at the beginning of the income year or, if the business was part way through the year, at the time the business started. Companies that commenced carrying on a business in the current year need to make a reasonable estimate of what their turnover would have been had the business been carried on for the entire year. This method cannot be used if the taxpayer's aggregated turnover in each off the previous two income years was $2 million or more. Actual current year turnoverIf the taxpayer's actual aggregated turnover is less than $2 million as at the end of the income year, it will be a small business entity for that year. This method is only needed if the first two tests cannot be met. It is important to note that if the taxpayer is a small business entity by means of this method only, it cannot use the GST and PAYG concessions for that income year as those particular concessions must have been chosen earlier in the income year. Although the STS has now ceased, the taxpayer may continue using the STS accounting if they: were an STS taxpayer for the most recent income year starting before 1 July 2005 and continued to be an STS taxpayer to the end of the 2006-07 year; have been using the STS accounting method for the 2005-06 and 2006-07 income years, and were a small business entity in the 2007-08 income year.
If the taxpayer meets these three requirements, they can continue using the STS accounting method until they choose not to or they are no longer a small business entity. Treatment of depreciating assets for former STS taxpayers who are Small business entities in the current income year is covered at Item P8 expense label M. If the taxpayer continues to use the STS accounting method, base the amounts included at item P8 on the STS accounting method. If the accounting system or financial statements do not reflect the STS accounting method, the taxpayer may need to make additional reconciliation adjustments at Reconciliation items at item P8. If the taxpayer had a particular type of ordinary income or general deduction that had to be apportioned or altered under STS - for example, double wool clips or pre-payment of a business expense for a period greater than 12 months - you continue to apportion or alter them and make adjustments at Reconciliation items. Business income and expenses that have not been accounted for using the STS accounting method - because they had not been received or paid during the previous income year - are accounted for in the current income year. You may need to make additional reconciliation adjustments at Reconciliation items. UI Text Box |
---|
| The STS accounting method does not apply to income or deductions that receive specific treatment under income tax law - for example, net capital gains, dividends, depreciation expenses, bad debts and borrowing costs. |
Where the taxpayer has depreciating assets that have been rolled into the Small business pools but had exited the former STS, depreciation calculated in the pools must be included at item D15 - Other deductions. Related Topics Small business entity eligibility tests worksheet (sbe) Depreciation worksheet (d) CCH References 7-050 Small business entities - aggregated turnover 7-130 Affiliates or connected entities 7-370 Paying GST by quarterly instalments 7-515 Special rules for deducting pre-paid expenses 7-530 FBT car parking exemption 7-540 Small business depreciation 17-015 Depreciating assets Names and Addresses in tax returnsThe topic looks at: MYOB AOA padlock symbol in the returnThis symbol indicates that the client data has been selected from details entered into AO. If the padlock is present and the details need to be updated this must be done in AO from where the details flow to the tax return. To display any updated information that does not show in the open return click View > Refresh. INSERTIMAGE Image Removed Client data derived from AOThe fields include: Current postal address, refer to Overseas country names for individuals.Home address, refer to Overseas country names for individuals. ABN, TFN, ACN, Date of birth, Client Name and Postal address on the previous tax return are derived from AO. Click the ellipsis to choose different details. Business address of the main business is derived from AO. Where available click Amend Address to enter an address.
Tax Agent declaration detailsThese are derived from details recorded in Tax: if the Return Properties > Staff tab shows no agent, lodgment will use the default agent for the practice recorded under Utilities > Control Record. if the Return Properties > Staff tab shows an agent, lodgment will use that agent rather than the default for the practice as recorded under Maintenance > Agent > Properties.
Client details from other tax returnsClient details can be provided by selecting another tax return of the same year for details such as: Ultimate Holding Company; Spouse Details (Form I), Member Details (Form MS); Beneficiary or Partner Details for Distribution Statements (Form T and P) etc. Click [F10] to select the relevant return from those in the current year ledger.Fields open for data entryAny field that you can type text into is ‘open’. These include: Fund Auditor (Form MS); Full name of the trustee to whom notices should be sent (Form T); Full name of the partner to whom notices should be sent (Form P); Business Name at Item P6 (Form I).
Details open for data entry include:Trustee or Director’s Declaration (Form MS). Title on Front Cover and Declarations, is selected from a list acceptable to the ATO. Practice Manager (AE, Series 6 & 8)A padlock symbol in the returnThe padlock symbol indicates that the client data has been selected from Practice Manager. If the padlock is present and the details need updating this must be done in Practice Manager from where they will flow through to the tax return. To display any updated information that is not showing in open return click View > Refresh. INSERTIMAGE Image Removed Client data derived from Practice ManagerThis will include: Current client name, Current postal address, refer to Overseas country names for individuals, Home address, refer to Overseas country names for individuals, ABN, TFN, ACN, Date of birth, Client Name and Postal address on the previous tax return are derived from Practice Manager. Select the ellipsis to choose different details. Business address of the main business is derived from Practice Manager. Where available click Amend Address to enter an address.
Tax Agent declaration detailsThe agent declaration details are derived from details recorded in Tax: if the Return Properties > Staff tab shows no agent name, lodgment will use the default agent for the practice as entered under Utilities > Control Record. if the Return Properties > Staff tab shows an agent name, lodgment will use that agent rather than the default for the practice. These agent details are entered under Maintenance > Agent > Properties.
Client details selected from another tax returnClient details can be provided by selecting another tax return in the same year for details such as: Ultimate Holding Company; Spouse Details (Form I); Member Details (Form MS); Beneficiary Details (Form T); Partner Details (Form P), etc. Click [F10] to select the relevant return. It must be in the current year ledger.Fields open for data entry includeAny field that you can type text into is ‘open’. These include: Fund Auditor (Form F); Full name of the trustee to whom notices should be sent (Form T); Full name of the partner to whom notices should be sent (Form P); Business Name at Item P6 (Form I).
Details open for data entry include:Trustee or Director’s Declaration (Form MS). Title on Front Cover and Declarations, is selected from a list provided by the ATO.
In 2007 and earlierTax return data entry shows changes including: Newly created returns take data from Practice Manager. The names and addresses on the front covers of an unlodged return are updated from Practice Manager details each time the return is opened. Tax Return Front cover details are editable, but changes do not update Practice Manager. During return data entry, lists of client data are provided from Practice Manager for Select Address, Select Employee, Select Extra Field. Client Data ValidationIncome tax return client data validation guidelines include: A name must be either an individual name or a company (entity) name, not both. On the same return current and previous names cannot be the same. Names can only be made up of the characters listed below: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z (upper or lower case) 1 2 3 4 5 6 7 8 9 0 ' - space ! @ $ % & ( ) - = [ ] ; : ' " . ? / space ` # _ { } | \These characters are not valid in any name: , ^ * ~ + < > Family name and given names cannot contain: the words "Exec for", "Rep for" or "Trustee for" repeated hyphen, apostrophe or space characters a space hyphen space combination. If a hyphen is used, it must be in the format, Smith-Jones. the titles "Mr, Miss, Mrs or Ms" "Esq, II, III, IV, Jnr, JP, MHA, MHR, MLA, MLC, MP, QC or Snr"If other names are present, then a first given name is required If given names are present, then a family name is required Non-individual name field: cannot contain "P/L" and must contain at least one alphabetic or numeric character. If second line of name is present then a first line is required Warnings are generated when: The name field contains 3 or more identical contiguous alphabetic characters The name field contains 2 or more identical contiguous non-alphabetic characters The name field contains all numerics The last character of the first line is filled and the first character of the second line is also filled - words cannot be split between 2 lines. A company name contains the word 'partnership' - if the name is correct then Form P should be used. ELS requirements for addressesOn the same return current and previous addresses cannot be the same. Up to two lines of 38 characters are allowed for street name and number: Street address line 1 must be present and neither line of address can include C/0, Care Of, CO, C/ Suburb, State and postcode must be printed on one line. The suburb may not exceed 27 characters. For a domestic address, The State must be ACT, NSW, NT, QLD, SA, TAS, VIC or WA. Both state and postcode must be entered and country name must be blank. Address fields may contain only: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z a b c d e f g h i j k l m n o p q r s t u v w x y z 1 2 3 4 5 6 7 8 9 0 ' & / ( ) spaceDomestic addresses: A domestic address must contain street name, suburb/town, state and postcode but must leave the country blank. Overseas addresses: An overseas address must contain street name, suburb/town and country (not Australia). Overseas country names for individualsFrom 1 July 2012 if your individual client has an overseas address for service of notices or as the home address, you will need to adhere to the list of acceptable Country names provided by the ATO when completing income tax returns. In many cases the addresses already recorded in your data base will be valid and no further action will be required. On the return front cover, MYOB Tax provides a list of country names that will validate at the ATO. At the Overseas country field in the Postal or Home address click [F10] to select the country name. For example, if you key your client’s overseas home address as South Korea, [F3] validation will generate V1221. To find the name the ATO will accept and validate for South Korea: At the Overseas country field open the list of countries, Type ‘South Korea’ into the Search field and click Search. On the list of matching entries highlight the country and click Select.
UI Text Box |
---|
| Long country names are truncated to meet ELS requirements. | Parameter TablesAE Tax only The parameter tables are used in estimate calculations for resident and non-resident individuals, minors and trustees. The following links shows where in the parameter tables you can find the rates, offsets, thresholds, percentages and so on. How to access the Resident Tax Rates:Click Maintenance > Parameter Tables. For the relevant income year select Master Individual Table > Properties > Resident Tax Rates
Resident Tax Rates include:General Tax Rates and Income Thresholds, resident and non-resident individuals, and resident and non-resident minors under Div 6AA. Dependant Offset Details - Offset, ATI and Reduction percentage for: Spouse, Child/housekeeper, Housekeeper, Notional Dependants Other Income Test Thresholds - Dependency offsets, employee share schemes, Commercial business losses thresholds. Senior and pensioner Offset (SAPTO) - The categories of Pensioner Offset codes. The Properties option for each code provides the Offset information and combined taxable income. Low Age Government Pensioners Offsets - The categories of Low Age Government Pensioners Offset codes. Zone Offsets - Amounts and Offsets for Zone and Overseas forces: Special and Ordinary Zone A Special and Ordinary Zone B Remote area allowance Overseas Forces Other Offsets tab - Tabs provide the details of offsets, thresholds and reduction rates for: Government Co-contributions, Super contributions for spouse2017, Low Income Earners, and Medical Expenses; Private Health insurance income ceilings and maximum tax offsets; Other offsets rates for life assurance and friendly society bonuses, and infrastructure borrowing. ETP and Lump Sum Offsets - Tabs are provided for: ETP ETP Death Benefit Payments to Dependants and Non-dependants Taxable Component of Lump Sum Super Death Benefits to Dependants and Non-dependants SIS Taxable Components SIS Death Benefits to Dependants HECS-HELP and SFSS - Income ceiling and percentage of repayment of loans for: HECS - HELP repayment rates, and Student Supplement Loans (SFSS) repayment thresholds and rates Medicare Levy: Medicare and Surcharge levy rates and thresholds Low Income Thresholds for single and married taxpayers and Phase in limits, and additional child increments. SAPTO thresholds Levy Surcharge Thresholds
UI Text Box |
---|
| For non-residents, the only rebate rate applicable is for ETP and Lump Sum Offsets. | CDS to VPM code mapping indexAE Tax only This index displays the address and number types that have been mapped to VPM. Altering Column WidthsType: Either an address or a number Normalised: Will display a tick if the address or number has been normalised for integration with the VPM database CDS Code: Address or number type code as shown on the CDS database CDS Description: Address or number description as shown on the CDS database. The Normalise routine will create unique CDS address and number types to remove duplicates where the same type has been used more than once for a particular Contact. Where these types have been created, the description will be ‘Added by System’. VPM Type: This displays the address/number type code as used in the VPM database. UI Text Box |
---|
| This normally will be the same as the CDS type code, but can be different if so desired. Refer to: Set VPM Type |
Employee: This displays the VPM address/number type that will integrate to the Employee on CDS. Also read: Set VPM Type Normalising multiple types: you may select more than one item at a time to Normalise. Hold the Shift key down and click on the items you wish to normalise. Each item will remain highlighted as it has been selected. Refer to Normalise Tables. Additional OptionsThe right click provides additional functionality on this index. These are: Standard selection: Choose this option to select all address/number types on the index De-select all: Choose this options to de-select all address/number types on the index UI Text Box |
---|
| You are advised not to change this setting except on the direction of a MYOB consultant. Any errors made in association with VPM integration, will require restoring data to a back up taken prior to the integration being changed. This may result in loss of data. | Profiles mapping indexAE Tax only This index is accessed by pressing the Map button from the Integration tab when you select the integration type to be either: Profiles Profiles and VPM or Non-MYOB
This index should be completed with advice from your MYOB consultant. Set VPM TypeAE Tax only This routine is used to map VPM address and number types to your CDS address and number types. There are two stages to this process. These are: UI Text Box |
---|
| The Clear button will remove a VPM Type from an address/number. Use this function if you wish to remove a VPM Type. |
Setting the VPM typeOnce you have normalised the address/number type you wish to map (it will have a tick in the Nml column), click Set and the Set VPM type window displays. CDS Code: This shows the CDS code that you are going to map. VPM Type: This will default to the same code as used in CDS. Enter the VPM code you wish CDS to map to. Also use for Employee:This routine allows you to map the CDS address / number type, for employee use. CDS allows you to store multiple address and number types against an employee. The VPM database allows only one address and up to four numbers to be stored against an employee. VPM's four numbers are predefined and are as follows: If you are mapping an address, click [F10] or the arrow button to open the selection list. The option are address or none. Select address then click OK to save. If you are mapping a number, again press the[F10] key or select the arrow button to open the selection list. The option are Telephone, Fax, Mobile, Email or None. Make a selection then click OK to save. Once saved, the address / number will be shown in the Employee column of the CDS to VPM code mapping index. UI Text Box |
---|
| You are advised not to change this setting except on the direction of an MYOB consultant. Any errors made in association with VPM integration, will require restoring your data to a data back up taken prior to the integration being changed. This may result in loss of data. |
Normalise Tables CDS to VPM code mapping index Normalise TablesAE Tax only This routine is used during the installation of integration between CDS and VPM and is normally performed by your MYOB consultant. The VPM database will only store unique codes and can therefore only store one of each type of address or number against each contact. CDS however, permits duplicates and these must be removed prior to integration with VPM. This is achieved by the normalise function. For example: Prior to integration with VPM, a CDS contact had 3 addresses of type BUSINESS attached. The Normalise routine will remove the duplicates by using the following address types: BUSINESS BUSINESS1 BUSINESS2
Refer to: CDS to VPM mapping index Set VPM Type
UI Text Box |
---|
| You are advised not to change this setting except on the direction of an MYOB consultant. Any errors made in association with VPM integration, will require restoring data to a data back up taken prior to the integration being changed. This may result in loss of data. |
CDS to VPM code mapping index Set VPM Type
|