1
00:00:00,000 --> 00:00:13,978
Welcome to the introduction to the FX Ledger beta. In about thirty minutes, this video explains what the multi-currency accounting system FX Ledger does, and how each type of user works with it.

2
00:00:13,978 --> 00:00:19,542
All screens and figures shown are sample data for demonstration purposes.

3
00:00:19,542 --> 00:00:23,008
The video has nine parts.

4
00:00:23,008 --> 00:00:36,492
First, we look at the concept behind the system and its book structure. Then we walk through the operations common to all users, followed by the steps for initiators, reviewers and approvers.

5
00:00:36,492 --> 00:00:50,696
In the second half, we cover payments and payment files, the month-end revaluation and the remeasurement rules for combination, the financial statements, the administrator settings, and finally the month-end close.

6
00:00:50,696 --> 00:00:58,458
FX Ledger is a multi-currency accounting web application for small companies operating overseas.

7
00:00:58,458 --> 00:01:05,318
Every transaction is recorded in the currency in which it occurs, in the book for that currency.

8
00:01:05,318 --> 00:01:14,746
The system follows a head office and branch model: the USD book is the head office, and books in other currencies are treated as branches.

9
00:01:14,746 --> 00:01:25,062
At period end, or on any date you choose, the branch books are remeasured into US dollars to produce combined financial statements under IFRS.

10
00:01:25,062 --> 00:01:29,128
Let us start with the accounting premises.

11
00:01:29,128 --> 00:01:36,996
The framework is IFRS, and both the presentation currency and the functional currency are US dollars.

12
00:01:36,996 --> 00:01:46,568
The system is designed for overseas companies with up to about twenty employees, and up to twenty users can take part in the approval workflow.

13
00:01:46,568 --> 00:02:02,548
The main business is participation in an LNG development joint venture. Under IFRS 11, the company records its own share of the joint operation’s assets, liabilities, revenue and expenses directly in its books.

14
00:02:02,548 --> 00:02:05,846
Here is the book structure.

15
00:02:05,846 --> 00:02:19,402
The USD book is the head office, and books in currencies such as Australian dollars are branches. One AUD branch is set up by default, and the system administrator can add further branches.

16
00:02:19,402 --> 00:02:23,166
All books share the same chart of accounts.

17
00:02:23,166 --> 00:02:34,634
When combining, each branch is remeasured into US dollars, and the branch current account in the head office is automatically eliminated against the head office account in the branch.

18
00:02:34,634 --> 00:02:38,940
This slide summarises the key functions.

19
00:02:38,940 --> 00:02:48,392
For data entry, there are standard journals, interoffice transfers, imports of JV billing statements, and document attachments.

20
00:02:48,392 --> 00:02:53,884
Every journal is approved through the workflow before it is posted to the books.

21
00:02:53,884 --> 00:03:04,536
Reports include books and statements for each currency, plus USD-remeasured and combined statements, all of which can be exported to Excel and PDF.

22
00:03:04,536 --> 00:03:17,156
Version 2 adds invoices in their document currency, payment of open payables with payment files for Mizuho and MUFG web banking, and an automated month-end FX revaluation.

23
00:03:17,156 --> 00:03:23,310
Now let us look at the operations, starting with those common to every user.

24
00:03:23,310 --> 00:03:29,882
Open the system address in your browser, enter your user name and password, and log in.

25
00:03:29,882 --> 00:03:40,774
After five failed attempts in a row, the account is locked for fifteen minutes. If you forget your password, ask the system administrator to reset it.

26
00:03:40,774 --> 00:03:45,320
After logging in, you see the inbox first.

27
00:03:45,320 --> 00:03:55,924
The menu is on the left. At the top right are your name, the language switch and the log-out button. Menu items depend on your roles.

28
00:03:55,924 --> 00:04:05,280
The upper part of the inbox lists journals waiting for your review or approval. The lower part lists open journals that you created.

29
00:04:05,280 --> 00:04:10,772
For those, you can also see whose action they are currently waiting for.

30
00:04:10,772 --> 00:04:19,926
The journal list lets you search by book, status, posting date range, or text such as the document number or description.

31
00:04:19,926 --> 00:04:30,314
The type column shows GL for standard journals, IO for interoffice transfers, JV for imported JV billings, and REV for reversals.

32
00:04:30,314 --> 00:04:37,366
Click a row to open the journal and see its lines, approval route, history and attachments.

33
00:04:37,366 --> 00:04:41,288
A journal has one of these statuses.

34
00:04:41,288 --> 00:04:52,972
A journal that has only been saved is a draft. While it is being routed, it is in review or in approval. If it is sent back for correction, it is returned.

35
00:04:52,972 --> 00:05:01,296
Once final approval is given, it becomes posted, and only then is it reflected in the books and financial statements.

36
00:05:01,296 --> 00:05:05,756
Rejected and cancelled journals also remain on record.

37
00:05:05,756 --> 00:05:12,294
Next are the steps for the initiator. Open New journal from the menu.

38
00:05:12,294 --> 00:05:23,546
First, select the book for the currency of the transaction. In this example, we are paying an Australian law firm, so we choose the AUD branch book.

39
00:05:23,546 --> 00:05:35,518
Then enter the posting date, which is the date recorded in the books, and the document date, such as the invoice date. Reports and the period lock are based on the posting date.

40
00:05:35,518 --> 00:05:43,808
Now enter the lines. Type an account code or part of its name, and matching accounts are suggested.

41
00:05:43,808 --> 00:05:48,532
Enter an amount on either the debit side or the credit side.

42
00:05:48,532 --> 00:05:59,856
For lines subject to GST, select a tax code. The tax is calculated automatically, and a GST line is created on the same side.

43
00:05:59,856 --> 00:06:07,076
Enter the tax-inclusive amount on the payable line, and make sure the difference at the bottom right is zero.

44
00:06:07,076 --> 00:06:20,512
For an invoice credited to trade payables, enter the due date and the vendor invoice number in the header and select the vendor on the payable line. The invoice is then managed as open until a payment is posted.

45
00:06:20,512 --> 00:06:26,882
When the invoice currency differs from the book currency, set the document currency.

46
00:06:26,882 --> 00:06:42,382
In this example, a yen invoice from a Tokyo law firm is recorded in the US dollar head office book. When you enter JPY, the daily rate for the posting date, or otherwise the monthly average, is shown as the exchange rate.

47
00:06:42,382 --> 00:06:52,458
Enter the yen amounts exactly as on the invoice. The US dollar amounts are calculated from the rate, and rounding is adjusted when you save.

48
00:06:52,458 --> 00:07:00,254
The document currency and foreign amount are kept on every line and used for month-end revaluation and payment.

49
00:07:00,254 --> 00:07:06,312
You can add or edit a partner on the spot, using the plus button on the line.

50
00:07:06,312 --> 00:07:12,548
Vendors and customers are kept in a single master, and one partner can be both.

51
00:07:12,548 --> 00:07:23,992
You can record the code, name, country, tax number such as an ABN, currency and payment terms. The general ledger can be filtered by partner.

52
00:07:23,992 --> 00:07:27,962
Finally, set the approval route.

53
00:07:27,962 --> 00:07:36,958
Choose between zero and five reviewers, in the order in which they should check the journal. You can change the order with the arrow button.

54
00:07:36,958 --> 00:07:44,466
Then choose the approver. You cannot choose yourself, and the approver cannot also be a reviewer.

55
00:07:44,466 --> 00:07:51,998
Click Save and submit to send the journal to the first reviewer, or Save draft to keep it without submitting.

56
00:07:51,998 --> 00:08:00,000
Once submitted, the journal receives a document number made up of the book code, the year and a sequence number.

57
00:08:00,000 --> 00:08:08,780
The journal view shows all lines, including the automatically generated GST line, and the progress of the approval route.

58
00:08:08,780 --> 00:08:18,568
The person whose turn it is appears in blue, and those still waiting appear in white. Supporting documents can be uploaded at the bottom right.

59
00:08:18,568 --> 00:08:25,682
If a reviewer or the approver returns a journal, it appears in your inbox with the status Returned.

60
00:08:25,682 --> 00:08:32,134
Open it and read the comments in the approval route and history to understand why it was returned.

61
00:08:32,134 --> 00:08:42,354
Click Edit, correct the journal, attach any missing documents, and submit it again. The review then starts again from the first reviewer.

62
00:08:42,354 --> 00:08:46,372
Initiators can also do the following.

63
00:08:46,372 --> 00:08:52,320
If you notice a mistake after submitting, recall the journal back to your drafts.

64
00:08:52,320 --> 00:08:59,372
Cancel a draft that is no longer needed. Its document number and record are kept.

65
00:08:59,372 --> 00:09:07,288
Use Copy to create a new journal from an existing one. This is useful for recurring monthly entries.

66
00:09:07,288 --> 00:09:14,546
A posted journal cannot be edited or deleted. Corrections are made with a reversal.

67
00:09:14,546 --> 00:09:21,334
Open the journal, click Reverse, and enter the posting date and approval route for the reversal.

68
00:09:21,334 --> 00:09:27,978
A draft with debits and credits swapped is created. Submit it for approval.

69
00:09:27,978 --> 00:09:33,878
Once it is approved, the original journal and the reversal are linked to each other.

70
00:09:33,878 --> 00:09:40,440
Transfers between the head office and a branch are entered on the Interoffice transfer screen.

71
00:09:40,440 --> 00:09:53,444
Choose the direction and the branch book. Enter the US dollar amount on the head office side and the local currency amount on the branch side, using the actual figures from the bank remittance advice.

72
00:09:53,444 --> 00:10:04,864
In this example, four hundred and twenty-five thousand US dollars arrived as six hundred thousand Australian dollars. The implied rate is shown automatically.

73
00:10:04,864 --> 00:10:12,218
An interoffice transfer is posted to both the head office book and the branch book with a single document.

74
00:10:12,218 --> 00:10:18,790
The head office debits the branch current account, and the branch credits the head office account.

75
00:10:18,790 --> 00:10:29,034
On the branch side, the US dollar amount you entered is stored as a fixed amount. That is why the two accounts eliminate exactly on combination.

76
00:10:29,034 --> 00:10:33,374
These two accounts cannot be used in a standard journal.

77
00:10:33,374 --> 00:10:38,592
Let us review the accounting flow for the LNG joint venture.

78
00:10:38,592 --> 00:10:45,356
When the operator issues a cash call, the payment is recorded as a JV cash call advance.

79
00:10:45,356 --> 00:10:54,664
When the monthly billing statement arrives, the company’s share is transferred from the advance to accounts such as development assets and expenses.

80
00:10:54,664 --> 00:11:01,644
Distributions are recorded as revenue or as a settlement of the advance, depending on their nature.

81
00:11:01,644 --> 00:11:07,414
Billing statements can be imported from an Excel or CSV file.

82
00:11:07,414 --> 00:11:22,194
The template has four columns: cost code, description, gross amount at one hundred percent, and our share. If our share is blank, it is calculated as the gross amount multiplied by the participating interest.

83
00:11:22,194 --> 00:11:32,486
Cost codes are converted to accounts using the JV cost mapping table. Codes that are not mapped are flagged, and you select an account on screen.

84
00:11:32,486 --> 00:11:42,816
Click Create journal draft, and the journal entry screen opens with each account on the debit side and the total credited to the JV cash call advance.

85
00:11:42,816 --> 00:11:48,308
Check the reference and description, set the approval route, and submit.

86
00:11:48,308 --> 00:11:53,368
The name of the imported file is recorded as the source of the journal.

87
00:11:53,368 --> 00:11:57,986
Next, the steps for reviewers and approvers.

88
00:11:57,986 --> 00:12:07,726
When a reviewer logs in, journals waiting for their review appear at the top of the inbox. The number in the menu shows how many there are.

89
00:12:07,726 --> 00:12:10,890
Click a row to open the journal.

90
00:12:10,890 --> 00:12:19,252
In the journal view, check the book, dates, lines, tax codes, partners and attached documents.

91
00:12:19,252 --> 00:12:26,952
In the approval route, your step is shown in blue. You cannot approve a journal when it is not your turn.

92
00:12:26,952 --> 00:12:33,788
If there are several reviewers, the journal passes to them one at a time, in the order specified.

93
00:12:33,788 --> 00:12:37,566
Here is a checklist for reviewers.

94
00:12:37,566 --> 00:12:44,162
Does the book currency match the transaction currency, and is the posting date in the right period?

95
00:12:44,162 --> 00:12:55,942
Do the accounts and amounts agree with the supporting documents? Is the tax code correct – taxable, GST-free or out of scope? Is the partner correct?

96
00:12:55,942 --> 00:13:04,338
For interoffice transfers, also check that both the US dollar and local currency amounts agree with the bank remittance advice.

97
00:13:04,338 --> 00:13:14,750
For foreign currency documents, check the currency and rate; for payments, check the paying account, the payee bank account and the invoices being paid.

98
00:13:14,750 --> 00:13:25,320
If everything is in order, click Approve. A comment is optional. The journal then moves to the next reviewer or to the approver.

99
00:13:25,320 --> 00:13:33,596
If something needs to be corrected, click Return and explain what needs fixing. A comment is required.

100
00:13:33,596 --> 00:13:42,664
If the transaction itself should not be accepted, reject it and give a reason. A rejected journal cannot be reused.

101
00:13:42,664 --> 00:13:51,722
The approver works in the same way as a reviewer: open the journal from the inbox, then approve, return or reject it.

102
00:13:51,722 --> 00:13:57,622
The difference is that the journal is posted to the books as soon as the approver approves it.

103
00:13:57,622 --> 00:14:02,490
Please read the reviewers’ comments and the history before approving.

104
00:14:02,490 --> 00:14:06,460
This is an approved, posted journal.

105
00:14:06,460 --> 00:14:15,336
The approval route keeps the date, time and comment of each step, and the history records every action from submission to posting.

106
00:14:15,336 --> 00:14:19,652
A posted journal can be neither edited nor deleted.

107
00:14:19,652 --> 00:14:26,118
As an internal control, the system checks segregation of duties automatically.

108
00:14:26,118 --> 00:14:34,082
Initiators cannot review or approve their own journals, and the approver cannot also be a reviewer of the same journal.

109
00:14:34,082 --> 00:14:39,214
Journals dated in a locked period cannot be submitted or approved.

110
00:14:39,214 --> 00:14:43,338
And every action is recorded in the audit log.

111
00:14:43,338 --> 00:14:48,796
Next, paying open payables and producing payment files.

112
00:14:48,796 --> 00:14:59,904
Once an invoice is posted, it is managed as an open payable. The initiator creates a payment journal on the Payment screen and submits it like any other journal.

113
00:14:59,904 --> 00:15:07,940
At final approval, the approver chooses the payment file format, and the file is produced together with the approval.

114
00:15:07,940 --> 00:15:15,088
The file is then uploaded to Mizuho or MUFG web banking in Australia to release the payment.

115
00:15:15,088 --> 00:15:28,226
Payments are made from four accounts: USD and AUD accounts at Mizuho and MUFG. The USD accounts are kept in the head office book and the AUD accounts in branch 1.

116
00:15:28,226 --> 00:15:37,894
AUD accounts pay AUD invoices only. Payments to Australian BSB accounts produce domestic files such as ABA.

117
00:15:37,894 --> 00:15:48,114
USD accounts can pay US dollar invoices, and also yen or euro invoices by international transfer; the bank converts the currency.

118
00:15:48,114 --> 00:15:53,414
Files are not combined: each payment journal produces one file.

119
00:15:53,414 --> 00:16:05,400
On the Payment screen, choose the vendor, the paying account and the payment date. The payee bank account is taken automatically from the default account in the vendor master.

120
00:16:05,400 --> 00:16:16,580
The open invoices are listed; tick the ones to pay now. Overdue invoices are shown in red, and invoices already in another payment cannot be selected.

121
00:16:16,580 --> 00:16:25,456
Check the journal preview – debit trade payables, credit the bank, and the exchange difference – then set the route and submit.

122
00:16:25,456 --> 00:16:31,226
When the approver opens a payment, the button reads Approve and output file.

123
00:16:31,226 --> 00:16:48,166
A dialog asks for the file format to match the bank’s web banking: ABA, pain.001 or CSV for domestic transfers, and pain.001 version 9 or version 3, or CSV for international transfers.

124
00:16:48,166 --> 00:16:54,522
On approval, the payment is posted and the payment file is downloaded at the same time.

125
00:16:54,522 --> 00:16:59,812
This payment settles a yen invoice from a US dollar account.

126
00:16:59,812 --> 00:17:13,224
Trade payables are cleared at the US dollar amount recorded with the invoice, and the bank is credited at the payment-date rate. The difference is booked automatically as a realised exchange gain or loss.

127
00:17:13,224 --> 00:17:19,796
The payment file is stored with the journal, together with its name, size and creator.

128
00:17:19,796 --> 00:17:24,462
The Payment files screen lists every file created.

129
00:17:24,462 --> 00:17:32,162
Files are stored with a hash value, and only the approver of the payment or a System Admin can download them again.

130
00:17:32,162 --> 00:17:42,814
Downloads are counted, and a warning is shown from the second download. Make sure the bank has not processed the file already, to avoid paying twice.

131
00:17:42,814 --> 00:17:56,360
Payee bank accounts are registered in the vendor master. There are two types: Australian BSB accounts and international accounts paid through SWIFT, with a default account for each currency.

132
00:17:56,360 --> 00:18:04,708
New or changed bank details cannot be used for payment until a System Admin other than the person who changed them approves them.

133
00:18:04,708 --> 00:18:13,464
If a change is notified by e-mail, confirm it by phone before approving. This control helps prevent payment fraud.

134
00:18:13,464 --> 00:18:18,082
Next, the month-end FX revaluation.

135
00:18:18,082 --> 00:18:29,694
Monetary items such as cash and payables recorded in a currency other than the book currency are revalued at the month-end closing rate, for each book – head office and branch.

136
00:18:29,694 --> 00:18:41,714
On the FX revaluation screen, choose the book and the month end to preview the foreign balance, book value, closing rate and gain or loss by account, currency and partner.

137
00:18:41,714 --> 00:18:48,382
Run revaluation and submit creates the journal, which is approved like any other journal.

138
00:18:48,382 --> 00:18:54,296
The difference is posted to the unrealised exchange gain or loss account.

139
00:18:54,296 --> 00:19:01,636
When the revaluation is posted, a reversal dated the first of the next month is posted automatically.

140
00:19:01,636 --> 00:19:12,624
As a result, the exchange difference at payment is always measured against the rate used for the invoice. A book cannot be revalued twice for the same date.

141
00:19:12,624 --> 00:19:17,290
Next, the remeasurement used for combination.

142
00:19:17,290 --> 00:19:26,598
Branch books are remeasured under IAS 21 as foreign currency transactions of a company whose functional currency is the US dollar.

143
00:19:26,598 --> 00:19:42,698
Monetary items such as cash, receivables and payables use the closing rate. Non-monetary items such as fixed assets and prepayments use the rate on the transaction date. Income and expenses use the monthly average rate.

144
00:19:42,698 --> 00:19:50,230
The resulting difference is recognised automatically in profit or loss as a foreign exchange gain or loss.

145
00:19:50,230 --> 00:19:54,992
Exchange rates are entered by the system administrator.

146
00:19:54,992 --> 00:20:07,732
There are three rate types: daily, monthly average and closing. Rates are entered as US dollars per one unit of currency, and you can also enter them as units per US dollar.

147
00:20:07,732 --> 00:20:16,896
Each month, enter the monthly average rate and the month-end closing rate. Rates can also be pasted in bulk as CSV.

148
00:20:16,896 --> 00:20:25,690
The remeasurement worksheet shows, for each branch account, the method used, the effective rate and the US dollar amount.

149
00:20:25,690 --> 00:20:39,630
For example, cash uses the closing rate of zero point six nine five, fixed assets use the rate on the acquisition date, and the head office account uses the US dollar amount fixed at the time of the transfer.

150
00:20:39,630 --> 00:20:44,378
The bottom line shows the remeasurement difference for the period.

151
00:20:44,378 --> 00:20:50,220
Next, reports. Open Reports from the menu.

152
00:20:50,220 --> 00:21:00,632
Choose the report, the book and the period, then click Run. Buttons such as This month, Last month and Year to date set the period for you.

153
00:21:00,632 --> 00:21:14,188
For a branch book, choose whether to view it in local currency or remeasured into US dollars. For financial statements and the trial balance, you can also choose the combined head office and branches.

154
00:21:14,188 --> 00:21:18,830
This is the combined statement of financial position.

155
00:21:18,830 --> 00:21:26,530
It compares the period end with the previous period end. Tick Show accounts to see the account detail.

156
00:21:26,530 --> 00:21:34,158
The branch current account and the head office account eliminate each other, so they do not appear in the combined statement.

157
00:21:34,158 --> 00:21:41,536
Profit or loss is shown as an IFRS statement of profit or loss and other comprehensive income.

158
00:21:41,536 --> 00:21:53,796
Revenue, cost of sales, other expenses, finance income and costs, foreign exchange gains and losses, and income tax are followed by total comprehensive income.

159
00:21:53,796 --> 00:21:58,952
The combined figures include the remeasurement difference of the branches.

160
00:21:58,952 --> 00:22:05,154
Branch statements can be produced both in local currency and in US dollars.

161
00:22:05,154 --> 00:22:12,710
This is the branch profit or loss, remeasured into US dollars, including the remeasurement difference.

162
00:22:12,710 --> 00:22:21,850
So you can use the Australian dollar books for local statutory accounts and tax filings, and the US dollar view for group reporting.

163
00:22:21,850 --> 00:22:25,868
This is the statement of changes in equity.

164
00:22:25,868 --> 00:22:37,360
It shows the opening balances of share capital, other reserves and retained earnings, the profit for the period, share issues, dividends and the closing balances.

165
00:22:37,360 --> 00:22:43,596
For a single branch, movements in the head office account are shown in a separate column.

166
00:22:43,596 --> 00:22:48,262
The cash flow statement uses the indirect method.

167
00:22:48,262 --> 00:23:00,042
Starting from profit before tax, it calculates operating, investing and financing cash flows automatically, based on the cash flow classification of each account.

168
00:23:00,042 --> 00:23:05,822
Spending on JV development assets is shown under investing activities.

169
00:23:05,822 --> 00:23:15,970
In US dollar and combined views, the effect of exchange rate changes on cash is shown on a separate line, so the closing cash balance agrees.

170
00:23:15,970 --> 00:23:23,324
For each currency book, you can also produce the trial balance, the general ledger and the journal.

171
00:23:23,324 --> 00:23:32,728
The general ledger can be filtered by account range and by partner, and shows the opening balance, each transaction and the running balance.

172
00:23:32,728 --> 00:23:39,276
The journal report can also include entries that are still in the workflow and not yet posted.

173
00:23:39,276 --> 00:23:54,214
The open payables report lists unpaid invoices by vendor as at a date, with the due date, days overdue, foreign amount, original book amount and the amount at the closing rate. It works as a payment schedule.

174
00:23:54,214 --> 00:24:03,858
The payment register lists the payments in a period with the paying account, method, currency, amount, file format and export time.

175
00:24:03,858 --> 00:24:10,180
The indirect tax summary totals the taxable amounts and tax by tax code.

176
00:24:10,180 --> 00:24:20,688
It calculates the net amount payable or refundable from output tax and input tax credits, which helps you prepare the Australian business activity statement.

177
00:24:20,688 --> 00:24:28,906
The combination worksheet lists the US dollar amount of each book, the eliminations and the combined totals.

178
00:24:28,906 --> 00:24:38,478
You can see how account 1950, the branch current account, eliminates against account 3900, the head office account.

179
00:24:38,478 --> 00:24:45,242
At period end, make sure the line labelled Total, should be zero, is in fact zero.

180
00:24:45,242 --> 00:24:50,388
Every report can be exported to Excel and PDF.

181
00:24:50,388 --> 00:24:58,616
Excel output downloads a formatted xlsx file, and the figures can be used directly in calculations.

182
00:24:58,616 --> 00:25:10,732
Click PDF or Print to open the print dialog with an A4 report layout, then choose Save as PDF. Reports with many columns switch to landscape automatically.

183
00:25:10,732 --> 00:25:15,230
Now, the system administrator’s tasks.

184
00:25:15,230 --> 00:25:23,698
On the Users screen, add or edit users, and set the user name, display name, initial password and roles.

185
00:25:23,698 --> 00:25:32,478
There are four roles: system admin, initiator, reviewer and approver. A user can have more than one.

186
00:25:32,478 --> 00:25:39,386
Leavers are deactivated rather than deleted. Up to twenty users can be active.

187
00:25:39,386 --> 00:25:47,124
About ninety standard accounts for a company in an LNG development joint venture are set up in advance.

188
00:25:47,124 --> 00:25:56,072
For each account, you set the financial statement line, whether it is a monetary item, and the cash flow classification and line.

189
00:25:56,072 --> 00:26:04,156
The monetary item flag decides which rate is used to remeasure the branches, so take care when adding accounts.

190
00:26:04,156 --> 00:26:14,990
On the Tax codes screen, you set the rate and the account to which tax is posted. VAT or sales tax can be used by adding tax codes.

191
00:26:14,990 --> 00:26:26,794
On the Books screen, you can add branches by specifying the currency code and the number of decimal places. Japanese yen and Indonesian rupiah use zero decimals.

192
00:26:26,794 --> 00:26:34,686
The currency of a book that already has journals cannot be changed, and the head office is fixed to US dollars.

193
00:26:34,686 --> 00:26:40,384
The Company bank accounts screen manages the accounts used for payments.

194
00:26:40,384 --> 00:26:54,804
Besides the book, GL account, BSB and account number, set the ABA user name, APCA user ID and financial institution code, and for international payments the BIC and debtor address.

195
00:26:54,804 --> 00:26:59,000
Enter the values exactly as given by the bank.

196
00:26:59,000 --> 00:27:10,002
On the Settings screen, set the company name, the joint venture name, the participating interest, the JV advance account and the first month of the financial year.

197
00:27:10,002 --> 00:27:21,206
After each month-end close, update the locked-through date to the last day of that month. Journals dated on or before it can then no longer be submitted or approved.

198
00:27:21,206 --> 00:27:27,024
The JV cost mapping links the operator’s cost codes to accounts.

199
00:27:27,024 --> 00:27:37,100
The audit log records every action, from log-ins and the life of each journal to master changes and report exports, with the newest first.

200
00:27:37,100 --> 00:27:41,584
Click an entry related to a journal to open that journal.

201
00:27:41,584 --> 00:27:52,394
Each user can switch the screens between Japanese and English, so local staff can work in English while colleagues at the head office in Japan work in Japanese.

202
00:27:52,394 --> 00:27:57,550
Reports are produced in English as IFRS financial statements.

203
00:27:57,550 --> 00:28:01,952
Finally, a summary of the month-end close.

204
00:28:01,952 --> 00:28:18,772
Record the joint venture transactions, expenses, sales, payroll and bank transactions, approve the payments and output the files, and finish interoffice transfers and closing adjustments. Then confirm that nothing is left unapproved.

205
00:28:18,772 --> 00:28:27,984
After entering exchange rates for every currency used, such as AUD and yen, run the month-end revaluation for each book.

206
00:28:27,984 --> 00:28:39,668
Reconcile the trial balances, open payables and tax summary, confirm that the eliminations net to zero, save the combined statements, and update the period lock.

207
00:28:39,668 --> 00:28:44,166
The beta version does not yet support the following:

208
00:28:44,166 --> 00:29:00,722
clearing of receivables, automatic transmission of payment files to the banks, e-mail notifications, approver rules based on amount, and automatic exchange rate feeds. Check file specifications against each bank’s latest documentation.

209
00:29:00,722 --> 00:29:07,462
Before using the system for a real close, please verify the report figures with test data.

210
00:29:07,462 --> 00:29:13,616
That concludes this introduction to the features and operation of FX Ledger.

211
00:29:13,616 --> 00:29:21,004
For more details, please see the feature overview and the user guide. Thank you for watching.
