Page tree


 

 

This function retrieves ledger data from the Client Accounting module, and maps this information to the Tax Return.

This option is only available if:

  • You have a licence to use Client Accounting.

  • A new Tax Return exists for the current client for the current tax year.

  • The Form Type of the Tax Return is:

    • Company

    • Individual

    • Partnership

    • Trust.

  • The Tax Return status must be “In Progress”.

  • The Tax Return amendment is not lodged.

  • The user has the appropriate security rights to access this function.

Importing ledger data

Any existing values in the Tax Return will be overwritten if replacement values are also present in the ledger.

If any errors are encountered during this process, an error message will be displayed in a pop-up window. No fields will be updated in the Tax Return.

  1. In Client Accounting, create a new Tax workpaper on the ledger for the current year. See Adding workpapers for more information. Only one Tax Workpaper can be added to a given period. The workpaper will be automatically populated with some values from the ledger (based on account group totals). Other fields may also be entered.
  2. Complete the workpaper and generate any necessary reports. Once the workpaper is approved, it will be in a state in the workflow process that enables it to be imported into the Tax Return.

  3. Navigate to the Tax homepage. The Tax Return form for the current year should already be created.

  4. Click Import Ledger Data in the Tasks bar to import fields from the ledger via the workpaper.

  5. Once the process is completed successfully, the Tax Return is displayed in a new window. Complete the Tax return process as per usual.

Data mapping between the ledger and workpaper

The tables below show which fields will be mapped from Client Accounting to Tax.

Individual

Code (PP)

Code (NPP)

Item

 

Account Group Source

DR / CR

TOSPP

TOS

P8 - Business Expenses

Opening stock

Profit and Loss Statement / Direct Costs / Cost of Sales / Opening Inventories

DR

PURCIPP

PURCINPP

Purchases and other costs

Profit and Loss Statement / Direct Costs / Cost of Sales / Purchases

DR

TCSPP

TCSNPP

Closing Stock

Profit and Loss Statement / Direct Costs / Cost of Sales / Closing Inventories

DR

TLEPP

TLENPP

Lease expenses

Profit and Loss Statement / Expenses / Leases

DR

TDEPP

TDEPPTI

Depreciation expenses

Profit and Loss Statement / Expenses / Depreciation

DR

Partner

Code (PP)

Code (NPP)

Item

 

Item #

Account Group Mapping

DR / CR

TCOSPP

TCOSNPP

Item 5 - Expenses

Cost of sales

 

Profit and Loss Statement / Direct Costs / Cost of Sales

sum of sub account groups:

- Opening Inventories

- Purchases

- Closing Inventories

DR

TLEPP

TLENPP

Lease expenses

 

Profit and Loss Statement / Expenses / Leases

DR

TDEPP

TDEPPTI

Depreciation expenses

 

Profit and Loss Statement / Expenses / Depreciation

DR

TCA

N/A

Items 32-45 – Key financial information

All current assets

32

Balance Sheet / Assets and Liabilities / Assets / Current Assets

DR

TTA

Total assets

33

Balance Sheet / Assets and Liabilities / Assets

DR

TCL

All current liabilities

34

Balance Sheet / Assets and Liabilities / Liabilities / Current Liabilities

CR

TTL

Total liabilities

35

Balance Sheet / Assets and Liabilities / Liabilities

CR

TOS

Opening stock

38

Profit and Loss Statement / Direct Costs / Cost of Sales / Opening Inventories

DR

PURCINPP

Purchases and other costs

39

Profit and Loss Statement / Direct Costs / Cost of Sales / Purchases

DR

TCS

Closing stock

40

Profit and Loss Statement / Direct Costs / Cost of Sales / Closing Inventories

DR

Company

Code

Item

 

Account Group Source

DR / CR

TINT

Item 6 - Income

Gross interest

Profit and Loss Statement / Sales and Income / Income / Interest

CR

TDIV

Total dividends

Profit and Loss Statement / Sales and Income / Income / Dividends

CR

TCOS

Item 6 - Expenses

Cost of sales

Profit and Loss Statement / Direct Costs / Cost of Sales

sum of sub account groups:

- Opening Inventories

- Purchases

- Closing Inventories

DR

TLEA

Lease expenses within Australia

Profit and Loss Statement / Expenses / Leases

DR

TDEP

Depreciation expenses

Profit and Loss Statement / Expenses / Depreciation

DR

TCOS

Item 8 - Financial and Other Information

Opening Stock

Profit and Loss Statement / Direct Costs / Cost of Sales / Opening Inventories

DR

PURCINPP

Purchases and other costs

Profit and Loss Statement / Direct Costs / Cost of Sales / Purchases

DR

TCS

Closing Stock

Profit and Loss Statement / Direct Costs / Cost of Sales / Closing Inventories

DR

TCA

All Current Assets

Balance Sheet / Assets and Liabilities / Assets / Current Assets

DR

TTA

Total Assets

Balance Sheet / Assets and Liabilities / Assets

DR

TCL

All current liabilities

Balance Sheet / Assets and Liabilities / Liabilities / Current Liabilities

CR

TTL

Total liabilities

Balance Sheet / Assets and Liabilities / Liabilities

CR

Trust

Code (PP)

Code (NPP)

Item

 

Item #

Account Group Mapping

DR/CR

TCOSPP

TCOSNPP

Item 5 - Expenses

Cost of sales

 

Profit and Loss Statement / Direct Costs / Cost of Sales

sum of sub account groups:

- Opening Inventories

- Purchases

- Closing Inventories

DR

TLEPP

TLENPP

Lease expenses

 

Profit and Loss Statement / Expenses / Leases

DR

TDEPP

TDEPPTI

Depreciation expenses

 

Profit and Loss Statement / Expenses / Depreciation

DR

TCA

N/A

Items 32-45 – Key financial information

All current assets

32

Balance Sheet / Assets and Liabilities / Assets / Current Assets

DR

TTA

Total assets

33

Balance Sheet / Assets and Liabilities / Assets

DR

TCL

All current liabilities

34

Balance Sheet / Assets and Liabilities / Liabilities / Current Liabilities

CR

TTL

Total liabilities

35

Balance Sheet / Assets and Liabilities / Liabilities

CR

TOS

Opening stock

38

Profit and Loss Statement / Direct Costs / Cost of Sales / Opening Inventories

DR

PURCINPP

Purchases and other costs

39

Profit and Loss Statement / Direct Costs / Cost of Sales / Purchases

DR

TCS

Closing stock

40

Profit and Loss Statement / Direct Costs / Cost of Sales / Closing Inventories

DR

 
Related topics