Skip to content
Ringgit figures of a foreign-currency document

Where are the Ringgit figures for my USD invoice? Find the base-currency copy of a foreign-currency document

“Where are the Ringgit figures for my USD invoice?” In a second copy of the document. When you finalise a document in a foreign currency, BigLedger makes a copy of it in your company’s own currency — Malaysian Ringgit (MYR) for most companies — with its own document number. That copy is what posts to your books, so it is where the MYR figures are. Ten minutes here and you will know how to find it, check it, and find its journal.

This page is for whoever reconciles purchases or sales that are invoiced in another currency. Staff sometimes call the copy the “shadow” document.

Meet GadgetSphere

GadgetSphere Sdn Bhd buys flagship smartphones from a regional distributor in Singapore that bills in US dollars. This month’s purchase invoice is for USD 12,000. Your manager asks: “What did that cost us in Ringgit, and where is it in the ledger?”

Before you start

  • The document is FINAL. The base-currency copy is made when the document is finalised, not before. A draft has no copy.
  • The document carries an exchange rate. BigLedger refuses to finalise a foreign-currency document whose exchange rate is blank or zero.

Step 1: Note the foreign-currency document’s details

Open the FINAL foreign-currency document and note its document number, supplier or customer, date, currency and exchange rate. In the example: the USD 12,000 purchase invoice from the Singapore distributor.

Step 2: Open the base-currency copy

On a purchase invoice: Purchase Invoice → the FINAL foreign-currency invoice → BASE

A FINAL foreign-currency purchase invoice has a BASE button. Press it and the base-currency copy opens; on the copy, the same button reads FOREX and takes you back.

On a sales invoice, or from any listing: the base-currency copies appear in the listing as their own rows, highlighted in orange-red. The copy has the same party, date and lines as the original, in your company’s currency, and a document number of its own. (On the purchase invoice listing an applet setting can hide these rows; if you never see a highlighted row there, ask your administrator.)

Step 3: Check the converted figures

Compare the two documents line by line. Each amount on the copy is the matching foreign amount converted at the document’s exchange rate. If your document shows the rate as Ringgit per unit of the foreign currency, the MYR amount is the foreign amount multiplied by that rate: in the example, USD 12,000 at 4.40 is RM 52,800.

BigLedger works the copy out by dividing each foreign amount by the rate it stores. If the copy shows the foreign total divided by the rate you expected — RM 2,727.27 for USD 12,000 at 4.40 — the rate was stored the other way round; read the forex troubleshooting before anything else posts. For any other mismatch, stop and report it (see below) rather than adjusting anything.

Step 4: Find the journal

Ledger and Journal → Journal Transaction

The journal for a foreign-currency document is posted from its base-currency copy, so it carries the copy’s document number. Type that number into the listing’s search box (at least three characters) to find the journal. Searching with the original foreign-currency document’s number will not find it.

What success looks like

You can open the base-currency copy, its amounts equal the foreign amounts converted at the document’s rate, and searching Journal Transaction with the copy’s number finds the journal in MYR. For GadgetSphere: the RM 52,800 copy and its journal, found in under a minute.

Common mistakes

  • Searching the ledger with the foreign document’s number. The journal belongs to the base-currency copy. Search with the copy’s number.
  • Reading the foreign-currency document as the accounting record. The figures that reach your books are the copy’s figures, in your company’s currency.
  • Looking for the copy before FINAL. It is created at FINAL. A draft has none.
  • Expecting a copy that was never made. Two cases make none, and so post nothing to the ledger: a tenant set up to skip these copies (an e-Invoice-only set-up), and a document an integration finalised through the ETL endpoint, which saves it FINAL directly (the ordinary API finalise call makes the copy as the screen does). If a FINAL foreign-currency document has no highlighted twin and no journal, ask BigLedger support which case it is.
  • Expecting a BASE button on a sales invoice. Only the purchase invoice has it. On sales, use the highlighted row in the listing.

If it still does not work

Contact BigLedger support with the document type and number, the currency and exchange rate shown, the figures you expected and the figures you see, and when the document was finalised.

Related documentation

Last updated on