Import Ledger Data

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.

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.
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.
Navigate to the Tax homepage. The Tax Return form for the current year should already be created.
Click Import Ledger Data in the Tasks bar to import fields from the ledger via the workpaper.
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	Item 6 - Income	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