1
00:00:00,500 --> 00:00:02,443
Welcome to FX Ledger 3.0.

2
00:00:02,443 --> 00:00:12,078
This video introduces our discussion paper on how to record foreign-
currency CAPEX and depreciation in an Australian entity,

3
00:00:12,078 --> 00:00:17,828
and three accounting systems, one for each bookkeeping method we compared.

4
00:00:19,228 --> 00:00:28,272
The company is an Australian entity reporting under IFRS, with USD as both
functional and presentation currency.

5
00:00:28,272 --> 00:00:32,633
It participates in an LNG development joint operation.

6
00:00:32,633 --> 00:00:40,708
Cash calls are mainly in USD, but sometimes in AUD, and the company makes
many AUD expense payments.

7
00:00:42,108 --> 00:00:49,073
Under IAS 21, monetary items such as cash and payables are retranslated at
the closing rate,

8
00:00:49,073 --> 00:00:55,130
while non-monetary items such as fixed assets stay at the transaction-date
rate.

9
00:00:55,130 --> 00:01:04,139
Foreign-currency CAPEX is fixed at its USD cost on the payment date, and
depreciation is calculated from that USD cost.

10
00:01:04,139 --> 00:01:09,060
All exchange differences go to profit or loss, and no OCI arises.

11
00:01:10,460 --> 00:01:20,274
The paper compares four methods: the Base Case with a single USD ledger,
the head office and branch methods 1-C and 1-D, and method 2,

12
00:01:20,274 --> 00:01:22,398
which keeps the books in AUD.

13
00:01:22,398 --> 00:01:28,916
When the procedures are followed correctly, all four give identical
financial statements.

14
00:01:28,916 --> 00:01:37,412
The key point is that the AUD branch is remeasured under IAS 21 paragraph
34, not translated as a foreign operation.

15
00:01:38,812 --> 00:01:44,485
Our conclusion recommends the Base Case, which leaves the least room for
error.

16
00:01:44,485 --> 00:01:50,014
Methods 1-C and 1-D are acceptable if the remeasurement policy is
documented.

17
00:01:50,014 --> 00:02:00,641
Method 2 is not recommended: it creates fictitious exchange differences
and effectively requires two ledgers, so the effort and audit risk are
high.

18
00:02:00,641 --> 00:02:05,308
The paper also lists eight points to confirm with the accountant.

19
00:02:06,708 --> 00:02:16,945
Based on this study we built three apps: FX Ledger BC for the Base Case,
FX Ledger 1-C, which keeps branch assets at historical USD,

20
00:02:16,945 --> 00:02:22,141
and FX Ledger 1-D, which transfers branch CAPEX to the head office.

21
00:02:22,141 --> 00:02:29,508
All three hold the same sample transactions, and their net loss and total
assets agree exactly.

22
00:02:30,908 --> 00:02:39,958
In the Base Case, CAPEX paid in AUD is recorded in the USD book with its
AUD amount and the transaction-date rate.

23
00:02:39,958 --> 00:02:44,324
The resulting USD amount becomes the cost of the asset.

24
00:02:45,724 --> 00:02:53,308
Because the USD and AUD accounts are in the same book, a currency exchange
is recorded at the deal amount.

25
00:02:53,308 --> 00:03:00,820
No exchange difference arises on the day, and later movements are picked
up by the month-end revaluation.

26
00:03:02,220 --> 00:03:07,061
This is the fixed asset register, common to all three apps.

27
00:03:07,061 --> 00:03:13,788
For each asset it keeps cost, accumulated depreciation and carrying amount
in USD.

28
00:03:15,188 --> 00:03:18,396
Assets under development are not depreciated.

29
00:03:18,396 --> 00:03:25,525
At first production they are transferred to producing assets and
depreciated by units of production.

30
00:03:25,525 --> 00:03:32,012
Each month keeps the basis: the depreciable amount, the production and the
remaining units.

31
00:03:33,412 --> 00:03:39,192
For units-of-production assets, the monthly production for our share is
entered here.

32
00:03:39,192 --> 00:03:46,060
When the reserves estimate changes, the new remaining units are registered
and applied prospectively.

33
00:03:47,460 --> 00:03:51,746
In the depreciation run, choose the month to preview the charge.

34
00:03:51,746 --> 00:03:58,644
The system creates one depreciation journal per book and sends it through
the normal approval workflow.

35
00:04:00,044 --> 00:04:09,236
In 1-C, AUD CAPEX is recorded in the AUD branch book, and the asset
register keeps its historical USD cost.

36
00:04:10,636 --> 00:04:17,072
For a branch asset you can see the AUD cost, the USD cost and the
historical rate.

37
00:04:17,072 --> 00:04:22,252
Each line of a branch depreciation journal carries its USD amount.

38
00:04:23,652 --> 00:04:33,597
The branch remeasurement worksheet shows that depreciation and accumulated
depreciation are remeasured at historical USD from the register,

39
00:04:33,597 --> 00:04:35,315
not at the average rate.

40
00:04:35,315 --> 00:04:38,892
This gives the same depreciation as the Base Case.

41
00:04:40,292 --> 00:04:46,019
In 1-D, CAPEX paid from a branch account is entered on the CAPEX transfer
screen.

42
00:04:46,019 --> 00:04:55,988
The head office asset is recorded in USD at the payment-date rate, which
can be overridden with the advance-date rate for prepaid cash calls.

43
00:04:57,388 --> 00:05:06,212
A single document posts the head office account and the bank in the
branch, and the asset and the branch account in the head office.

44
00:05:06,212 --> 00:05:09,220
Branch books cannot use fixed asset accounts.

45
00:05:10,620 --> 00:05:16,170
The statement of financial position shows exactly the same amounts in all
three apps,

46
00:05:16,170 --> 00:05:20,676
and no exchange difference is recorded in other comprehensive income.

47
00:05:22,076 --> 00:05:27,268
The auditor pack is created by choosing the period and the language.

48
00:05:27,268 --> 00:05:31,772
You can view it on screen, or export it to Excel or to PDF.

49
00:05:33,172 --> 00:05:40,423
The control checks automatically confirm the rate table, the month-end
revaluation, the interoffice elimination,

50
00:05:40,423 --> 00:05:47,932
the absence of OCI and the agreement of the register with the ledger, and
show each result as pass, warning or fail.

51
00:05:49,332 --> 00:05:59,676
The depreciation test compares depreciation booked at historical USD with
the amount an average-rate conversion would give, and shows the
difference.

52
00:05:59,676 --> 00:06:03,564
It explains in numbers why the average rate is not used.

53
00:06:04,964 --> 00:06:10,556
The register-to-ledger reconciliation shows a zero difference for each
account.

54
00:06:11,956 --> 00:06:16,497
All three apps have the same trial accounts and sample data.

55
00:06:16,497 --> 00:06:21,340
The passwords are on the website, so please log in and try them.

56
00:06:22,740 --> 00:06:24,341
Thank you for watching.

57
00:06:24,341 --> 00:06:29,772
We hope the paper and the three apps help your discussion with the
accountant.
