MYOB Exo Fixed Assets

Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

Asset Sale - Worked Examples

Scenario 1

An Asset is purchased on 1 Feb 2010 for $5000, set up with book depreciation of 33% SL.  The company’s balance date is 31 March, so it is depreciated for each year and year-ends are performed. The asset is finally sold for $3000 on 30 Jun 2011.

The following schedule shows each event that affects the asset, and the impact that the event has on the Asset Values, as shown on the Details tab, and the General Ledger Accounting that is initiated by that event.

 

Add Asset
01/02/2010

Depreciate
to 31/03/2010

Year-End Roll
to 31/03/2010

Depreciate
to  31/03/2011

Year-End Roll
to 31/03/2011

Depreciate
to  31/05/2011

ASSET VALUES

 

 

 

 

 

 

Opening value
(NBV at start of year)

5,000.00

5,000.00

4,733.29

4,733.29

3,083.29

3,083.29

Current Year Depreciation

0.00

266.71

0.00

1,650.00

0.00

275.75

Depreciation Value
(current NBV)

5,000.00

4,733.29

4,733.29

3,083.29

3,083.29

2,807.54

Last Dep Date
(NBV as at this date)

01/02/2010

31/03/2010

31/03/2010

31/03/2011

31/03/2011

31/05/2011

GL ACCOUNTING

 

 

 

 

 

 

Depreciation Expense

 

266.71

 

1,650.00

 

275.75

Depreciation Recovered

 

 

 

 

 

 

Accumulated Depreciation

 

-266.71

 

-1,650.00

 

-275.75

Asset Cost

5,000.00

 

 

 

 

 

Debtors or Bank

 

 

 

 

 

 

Depreciation Calculation
(33% Straight Line)

 

$5000
× 33%
× 59 days/365

 

$5000
× 33%
× 365 days/365

 

$5000
× 33%
× 61 days/365

The asset is sold on 30/06/2011 for $3000.00

 

Sale 30/06/2011

 

 

 

 

ASSET VALUES

 

 

 

 

 

Opening value
(NBV at start of year)

3,083.29

 

 

 

 

Current Year Depreciation

411.37

 

 

 

 

Depreciation Value
(current NBV)

2,671.92

 

 

 

 

Last Dep Date
(NBV as at this date)

30/06/2011

 

 

 

 

GL ACCOUNTING

Sale Journal A

Sale Journal B

Sale Journal C

Sale Journal D

Account Totals

Depreciation Expense

135.62

 

 

 

2,328.08

Depreciation Recovered

 

 

-328.00

 

-328.00

Accumulated Depreciation

-135.62

2,000.00

328.00

 

0.00

Asset Cost

 

-2,000.00

 

-3,000.00

0.00

Debtors or Bank

 

 

 

3,000.00

3,000.00

Depreciation Calculation
(33% Straight Line)

$5000
× 33%
× 30 days/365

 

 

 

 

Sales Journals

A - Additional Depreciation from 31/05/09 to 30/06/09 (the sale date).

B - Offset Cost and Accumulated Depreciation with Cost less Proceeds ($5000 - $3000). The expectation is that the Sale proceeds will be accounted for separately (see Journal D).

C - Take whatever the system considers to be Accum Depn (Cost - NBV : $5,000 - $2,671), then subtract the amount that has already been debited to Accumulated Depreciation ($2000). This is either depreciation recovered or additional depreciation.

D - Journal to handle proceeds (not automatic from Fixed Assets).

Exceptions

In this example the asset was sold for more than its Book Value and less than its original Cost.

If it was sold for less than its book value, the system would account for the difference between NBV and the sale value as additional depreciation. The Depreciation Recovered account would not be affected.

If the asset is sold for more than its original cost, the entries would be as above except that Depreciation Recovered is only credited up to the total of Accumulated Depreciation; the remaining credit (the difference between sale proceeds and original cost) is credited to the Capital Reserve account, as it represents a capital gain. This is dealt with in Scenario 2 below.

After the sale the asset looks like this:

Scenario 2

This is exactly the same as Scenario 1, except that the asset is sold for $6,000, giving rise to capital gains.

Note that all columns are the same as the previous example, except for the GL journal entries that account for the sale.

 

Add Asset
01/02/2010

Depreciate
to 31/03/2010

Year-End Roll
to 31/03/2010

Depreciate
to  31/03/2011

Year-End Roll
to 31/03/2011

Depreciate
to  31/05/2011

ASSET VALUES

 

 

 

 

 

 

Opening value
(NBV at start of year)

5,000.00

5,000.00

4,733.29

4,733.29

3,083.29

3,083.29

Current Year Depreciation

0.00

266.71

0.00

1,650.00

0.00

275.75

Depreciation Value
(current NBV)

5,000.00

4,733.29

4,733.29

3,083.29

3,083.29

2,807.54

Last Dep Date
(NBV as at this date)

01/02/2010

31/03/2010

31/03/2010

31/03/2011

31/03/2011

31/05/2011

GL ACCOUNTING

 

 

 

 

 

 

Depreciation Expense

 

266.71

 

1,650.00

 

275.75

Depreciation Recovered

 

 

 

 

 

 

Accumulated Depreciation

 

-266.71

 

-1,650.00

 

-275.75

Asset Cost

5,000.00

 

 

 

 

 

Capital Gains

 

 

 

 

 

 

Debtors or Bank

 

 

 

 

 

 

Depreciation Calculation
(33% Straight Line)

 

$5000
× 33%
× 59 days/365

 

$5000
× 33%
× 365 days/365

 

$5000
× 33%
× 61 days/365

The asset is sold on 30/06/2011 for $6000.00

 

Sale 30/06/2011

 

 

 

 

ASSET VALUES

 

 

 

 

 

Opening value
(NBV at start of year)

3,083.29

 

 

 

 

Current Year Depreciation

411.37

 

 

 

 

Depreciation Value
(current NBV)

2,671.92

 

 

 

 

Last Dep Date
(NBV as at this date)

30/06/2011

 

 

 

 

GL ACCOUNTING

Sale Journal A

Sale Journal B

Sale Journal C

Sale Journal D

Account Totals

Depreciation Expense

135.62

 

 

 

2,328.08

Depreciation Recovered

 

 

-2,328.00

 

-2,328.00

Accumulated Depreciation

-135.62

-1,000.00

3,328.00

 

0.00

Asset Cost

 

1,000.00

 

-6,000.00

0.00

Capital Gains

 

 

-1,000.00

 

-1,000.00

Debtors or Bank

 

 

 

6,000.00

6,000.00

Depreciation Calculation
(33% Straight Line)

$5000
× 33%
× 30 days/365

 

 

 

 

Sales Journals

A - Additional Depreciation from 31/05/09 to 30/06/09 (the sale date).

B - Offset Cost and Accumulated Depreciation with Cost less Proceeds (-$1,000 = $5000 - $6000). The expectation is that the Sale proceeds will be accounted for separately (see Journal D).

C - Take whatever the system considers to be Accumulated Depreciation (Cost - NBV : $5,000 - $2,671), then subtract the amount that has already been debited to Accumulated Depreciation ( $1000).

$3,328.08 = (5,000.00 - 2,671.92) -1,000

This amount is debited to Accumulated Depreciation in order to clear out its balance for this asset.

An amount equivalent to the total depreciation written-off over time ($2,328.08) is credited to depreciation recovered. The remaining amount ($1000) is equivalent to the sale proceeds ($6000) less the original cost ($5000), is credited to Capital Gains.

D - Journal to handle proceeds (not automatic from Fixed Assets).