1
00:00:00,000 --> 00:00:11,554
Welcome to the introduction to the JVLedger beta. This video explains what the accounting system JVLedger does, and how each type of user works with it.

2
00:00:11,554 --> 00:00:17,118
All screens and figures shown are sample data for demonstration purposes.

3
00:00:17,118 --> 00:00:20,584
The video has nine parts.

4
00:00:20,584 --> 00:00:34,884
First, we look at the concept behind the system and how it differs from FX Ledger. Then we cover entering foreign currency invoices, payments and payment files, and the management of payee bank accounts.

5
00:00:34,884 --> 00:00:45,824
In the second half, we look at the month-end FX revaluation, books and financial statements, administrator settings, and finally the monthly routine.

6
00:00:45,824 --> 00:00:55,506
JVLedger is an IFRS accounting web application for small companies that take part in joint ventures such as LNG developments.

7
00:00:55,506 --> 00:01:07,790
There is a single book in US dollars. Transactions in yen, Australian dollars and other currencies are recorded both in their document currency and in US dollars.

8
00:01:07,790 --> 00:01:16,570
Everything from booking an invoice to paying it, producing the bank payment file and the month-end revaluation is handled in one flow.

9
00:01:16,570 --> 00:01:24,582
Controls against payment fraud, such as approval of payee bank details and duplicate-payment checks, are built in.

10
00:01:24,582 --> 00:01:28,648
Let us start with the accounting premises.

11
00:01:28,648 --> 00:01:44,220
The framework is IFRS, and both the local and functional currency is the US dollar. Foreign currency transactions are translated at the rate on the transaction date, and foreign currency monetary items at the closing rate.

12
00:01:44,220 --> 00:01:52,616
Two bank accounts are preset: a US dollar account and a yen account, at banks such as Mizuho and MUFG.

13
00:01:52,616 --> 00:01:59,452
Yen invoices are paid from the yen account and US dollar invoices from the US dollar account.

14
00:01:59,452 --> 00:02:08,630
JVLedger is derived from the multi-currency accounting system FX Ledger, and inherits its reports and approval workflow.

15
00:02:08,630 --> 00:02:17,890
The main difference is that there are no currency branch books: foreign and US dollar amounts are both recorded in a single US dollar book.

16
00:02:17,890 --> 00:02:28,326
JVLedger adds open-item management of payables, payments with payment files, a month-end revaluation journal, and payee bank account management.

17
00:02:28,326 --> 00:02:31,720
There are four user roles.

18
00:02:31,720 --> 00:02:43,932
Every document is routed from the initiator to reviewers and then to the approver, and is posted when the approver approves it. Zero to five reviewers can be chosen, in order.

19
00:02:43,932 --> 00:02:55,208
Initiators cannot review or approve their own documents. Comments are required to return or reject, and the approval history is kept for each document.

20
00:02:55,208 --> 00:03:01,362
Now let us look at the operations, starting with those common to every user.

21
00:03:01,362 --> 00:03:07,934
Open the system address in your browser, enter your user name and password, and log in.

22
00:03:07,934 --> 00:03:16,762
Repeated failed attempts lock the account. If you forget your password, ask the system administrator to reset it.

23
00:03:16,762 --> 00:03:20,996
After logging in, you see your inbox.

24
00:03:20,996 --> 00:03:32,296
The upper part lists documents waiting for your review or approval; the lower part lists the open documents you created. The number in the menu shows the count.

25
00:03:32,296 --> 00:03:37,068
You can switch between Japanese and English at the top right.

26
00:03:37,068 --> 00:03:43,678
The journal list lets you search by type, status, posting date range and text.

27
00:03:43,678 --> 00:03:54,762
The types are GL for standard journals, PY for payments, FX for revaluations and REV for reversals, and document numbers are assigned per type.

28
00:03:54,762 --> 00:04:00,614
Click a row to see the lines, approval route, history and attachments.

29
00:04:00,614 --> 00:04:06,624
Now the initiator’s work. Let us enter a yen invoice.

30
00:04:06,624 --> 00:04:14,180
Open Journal entry, enter the posting and document dates, and set the document currency to JPY.

31
00:04:14,180 --> 00:04:26,776
The exchange rate is filled in from the rate master: the latest daily rate in the same month up to the posting date, or otherwise the monthly average. You can also overwrite the rate.

32
00:04:26,776 --> 00:04:42,242
Enter the lines in yen, the invoice currency. The US dollar amounts appear automatically in the column on the right. If rounding makes the US dollar debits and credits differ, the largest line is adjusted.

33
00:04:42,242 --> 00:04:50,062
Trade payables are managed as open items per invoice, so a credit to that account needs a partner and a due date.

34
00:04:50,062 --> 00:04:57,618
Enter the vendor invoice number too: it appears on the payment screen and in the remittance message of the payment file.

35
00:04:57,618 --> 00:05:06,988
Note that the US dollar bank account can only be used in US dollar documents, and the yen bank account only in yen documents.

36
00:05:06,988 --> 00:05:12,696
This keeps the account currency and the recorded foreign amount always in line.

37
00:05:12,696 --> 00:05:22,892
When you have finished, choose the reviewers and approver and submit. Once approved, the invoice is posted and appears as open on the payment screen.

38
00:05:22,892 --> 00:05:27,054
Next, payments and payment files.

39
00:05:27,054 --> 00:05:36,746
Posted invoices are managed as open items. The initiator selects the invoices to pay on the Payment screen and creates a payment.

40
00:05:36,746 --> 00:05:47,206
After review, the approver chooses the payment file format at final approval. The payment is posted and the file is created at the same time.

41
00:05:47,206 --> 00:05:52,314
The file is then uploaded to the bank’s web banking to send the payment.

42
00:05:52,314 --> 00:05:55,732
Open Payment from the menu.

43
00:05:55,732 --> 00:06:09,456
Choose the vendor, the paying account and the payment date. The payee bank account matching the paying account’s currency is selected automatically from the partner master, and the rate is the rate on the payment date.

44
00:06:09,456 --> 00:06:18,308
The open invoices are listed; tick the ones to pay. Check the payment journal in the preview below, then submit.

45
00:06:18,308 --> 00:06:22,566
The payment journal is built automatically.

46
00:06:22,566 --> 00:06:36,434
Trade payables are debited at the US dollar amount recorded with the invoice, and the bank is credited at the foreign amount times the payment-date rate. The difference is booked as a realised exchange gain or loss.

47
00:06:36,434 --> 00:06:54,814
For example, a one-million-yen invoice booked at 152 yen per dollar and paid when the rate is 148 reduces the bank by 6,756 dollars 76, and the difference of 177 dollars 81 is an exchange loss.

48
00:06:54,814 --> 00:07:00,392
A submitted payment is checked by reviewers like any other document.

49
00:07:00,392 --> 00:07:08,836
Compare the paying account, payee bank account, method, amount and the invoices being cleared with the original invoices.

50
00:07:08,836 --> 00:07:14,232
The lines show trade payables, the bank and the exchange difference.

51
00:07:14,232 --> 00:07:20,002
When the approver opens a payment, the button reads Approve and output file.

52
00:07:20,002 --> 00:07:30,030
Clicking it shows the file formats. For domestic transfers, choose the Zengin bulk transfer format, with or without line breaks.

53
00:07:30,030 --> 00:07:41,354
On approval, the payment is posted and the file is created and downloaded at the same time. Payment files are not combined: each payment produces one file.

54
00:07:41,354 --> 00:07:45,708
The available formats depend on the method.

55
00:07:45,708 --> 00:07:59,576
For yen payments to domestic Zengin accounts, the file uses the Zengin bulk transfer format. Kana are converted to half-width automatically, and each record is exactly 120 bytes.

56
00:07:59,576 --> 00:08:17,620
International and foreign currency transfers use ISO 20022 pain.001 version 9 or version 3, or a generic CSV, with the debtor and creditor details, the creditor bank BIC, charges and the remittance message.

57
00:08:17,620 --> 00:08:22,694
This is a posted payment made by international transfer.

58
00:08:22,694 --> 00:08:31,234
The payment file field shows the format and time of output, with the file name, size, creator and download count.

59
00:08:31,234 --> 00:08:37,662
The invoice is cleared when the payment is posted, and drops off the open payables report.

60
00:08:37,662 --> 00:08:42,328
The Payment files screen lists every file created.

61
00:08:42,328 --> 00:08:54,708
Files are stored with the payment, together with a SHA-256 hash and a download count. Only the approver of that payment and system administrators can download them again.

62
00:08:54,708 --> 00:09:04,256
From the second download, a warning about duplicate payment is shown. Every file creation and download is recorded in the audit log.

63
00:09:04,256 --> 00:09:08,826
There are also controls against duplicate payments.

64
00:09:08,826 --> 00:09:20,438
Invoices already in a payment in progress cannot be selected in another payment. When a payment is posted the invoice is cleared, and a paid invoice cannot be reversed.

65
00:09:20,438 --> 00:09:30,178
Posting a reversal of the payment re-opens the invoice. The bank transfer itself is not cancelled, so take action at the bank as well.

66
00:09:30,178 --> 00:09:35,084
Payee bank accounts are registered in the partner master.

67
00:09:35,084 --> 00:09:47,032
A partner can have several accounts, with one default per currency. When you enter a payment, the default account matching the paying account’s currency is selected automatically.

68
00:09:47,032 --> 00:09:58,610
For a domestic Zengin account, enter the bank and branch codes with their half-width kana names, the account type, the seven-digit account number, and the account holder in kana.

69
00:09:58,610 --> 00:10:03,022
These accounts are used for domestic yen transfers.

70
00:10:03,022 --> 00:10:17,624
For an international account, enter the beneficiary name and address, the IBAN or account number, the creditor bank BIC, name and location, any intermediary bank, the charges and the purpose.

71
00:10:17,624 --> 00:10:27,196
The address is split into street, building number, post code, town and country, to support the new structured SWIFT message formats.

72
00:10:27,196 --> 00:10:38,414
New or changed bank details are held as awaiting approval, and cannot be used for payment until a system administrator other than the person who changed them approves them.

73
00:10:38,414 --> 00:10:49,834
If the account changes after a payment has been submitted, that payment cannot be given final approval. Changers, approvers and times are kept in the audit log.

74
00:10:49,834 --> 00:10:59,862
When you are told of a bank change by e-mail or letter, always confirm it through another channel, such as calling the vendor on a known number, before approving.

75
00:10:59,862 --> 00:11:11,008
Next, the month-end FX revaluation. Under IAS 21, foreign currency monetary items are translated at the closing rate.

76
00:11:11,008 --> 00:11:24,852
On the FX revaluation screen, set the revaluation date to the month end to preview the balances and differences. Bank accounts are revalued by account, and payables by partner and currency.

77
00:11:24,852 --> 00:11:30,464
The rate used is the closing rate, or otherwise the latest daily rate.

78
00:11:30,464 --> 00:11:43,290
Run revaluation and submit creates the revaluation journal and routes it through the normal approval workflow. The counter account is the unrealised exchange gain or loss account.

79
00:11:43,290 --> 00:11:49,742
When it is posted, a reversal dated the first of the next month is posted automatically.

80
00:11:49,742 --> 00:12:03,730
So next month’s payments clear payables at the US dollar amount recorded with the invoice, and the realised difference is calculated correctly. A second revaluation for the same date cannot be created.

81
00:12:03,730 --> 00:12:07,724
Now the books and financial statements.

82
00:12:07,724 --> 00:12:21,352
The journal and general ledger show both foreign and US dollar amounts. The financial statements include the statement of financial position, profit or loss, changes in equity and cash flows.

83
00:12:21,352 --> 00:12:32,532
JVLedger adds open payables, the FX revaluation preview and the payment register. Every report can be exported to Excel and PDF.

84
00:12:32,532 --> 00:12:39,838
The open payables report lists unpaid invoices as at a date, by partner and currency.

85
00:12:39,838 --> 00:12:50,418
It shows the due date, days overdue, the original and closing US dollar amounts, and ageing, and works as a payment schedule for invoices falling due.

86
00:12:50,418 --> 00:13:00,268
The FX revaluation preview shows foreign currency monetary items as at any date, with the expected difference at the closing rate.

87
00:13:00,268 --> 00:13:05,448
Use it to check the figures before running the month-end revaluation.

88
00:13:05,448 --> 00:13:13,810
The journal shows the document currency and rate for each document, and the foreign and US dollar amounts for each line.

89
00:13:13,810 --> 00:13:18,126
It can also include documents still in the workflow.

90
00:13:18,126 --> 00:13:27,328
The general ledger shows each account’s lines, foreign amounts and US dollar balance, including the closing foreign balance.

91
00:13:27,328 --> 00:13:30,516
It can be filtered by partner.

92
00:13:30,516 --> 00:13:36,910
The statement of financial position compares the end date with the prior period end.

93
00:13:36,910 --> 00:13:44,706
Once the month-end revaluation is posted, foreign currency cash and payables are shown at the closing rate.

94
00:13:44,706 --> 00:13:49,492
The statement of cash flows uses the indirect method.

95
00:13:49,492 --> 00:13:59,544
Exchange differences on foreign currency cash are excluded from operating adjustments and shown separately as the effect of exchange rate changes on cash.

96
00:13:59,544 --> 00:14:09,442
The payment register lists the payments in a period with the method, amount, status, file format, export time and who exported it.

97
00:14:09,442 --> 00:14:14,814
Use it to review the month’s payments and to reconcile with bank statements.

98
00:14:14,814 --> 00:14:18,520
Now the administrator settings.

99
00:14:18,520 --> 00:14:24,732
Register the company’s US dollar and yen accounts and link them to GL accounts.

100
00:14:24,732 --> 00:14:40,016
Set the Zengin client code and name, the bank and branch codes with kana names, and for ISO 20022 the debtor name and address, BIC and IBAN. Enter the values exactly as given by the bank.

101
00:14:40,016 --> 00:14:49,050
Exchange rates come in three types – daily, monthly average and closing – entered as US dollars per unit of currency.

102
00:14:49,050 --> 00:14:55,550
They can also be entered as units per US dollar, or pasted in bulk as CSV.

103
00:14:55,550 --> 00:15:00,802
Enter daily rates as needed, and the closing rate at each month end.

104
00:15:00,802 --> 00:15:09,092
The Users screen adds users and sets their roles. Up to twenty users can take part in the workflow.

105
00:15:09,092 --> 00:15:25,816
The administrator also manages accounts, tax codes, JV cost mapping, company settings and the period lock. The audit log records log-ins, master changes, document actions and every payment file created or downloaded.

106
00:15:25,816 --> 00:15:30,194
Finally, a summary of the monthly routine.

107
00:15:30,194 --> 00:15:42,310
Enter the exchange rates and book invoices. Check invoices falling due in the open payables report, create and approve payments, and upload the payment files to web banking.

108
00:15:42,310 --> 00:15:49,530
At month end, import the JV billing statement, and run and approve the FX revaluation.

109
00:15:49,530 --> 00:16:00,326
Review the trial balance, financial statements, open payables and payment register, save them in Excel or PDF, and finally lock the period.

110
00:16:00,326 --> 00:16:04,032
Here are the beta limitations.

111
00:16:04,032 --> 00:16:17,612
The payment files follow common specifications. Check with each bank’s import specifications for Mizuho and MUFG web banking, and test with a small payment before using them for real.

112
00:16:17,612 --> 00:16:31,576
There is no bank API connection, automatic import of results or combining of payment files. Open items are managed for trade payables only, and bank charges are booked separately from the bank statement.

113
00:16:31,576 --> 00:16:37,634
That concludes this introduction to the features and operation of JVLedger.

114
00:16:37,634 --> 00:16:45,790
For more detail, please see the feature overview and the user guide in PDF. Thank you for watching.
