GoldGram.my › Blog › GoldGram.my vs Spreadsheet: Which Is Better for Tracking Physical Gold and Ar-Rahnu Certificates?

GoldGram.my vs Spreadsheet: Which Is Better for Tracking Physical Gold and Ar-Rahnu Certificates?

Jasmine YapFounder & Lead Developer · Aug 7, 2026

For one or two Ar-Rahnu certificates, a spreadsheet is usually the better choice: it is inexpensive, flexible and easy to customise. For investors managing several certificates, multiple branches, changing gold prices, recurring Upah Simpan and different maturity dates, GoldGram.my is the more convenient option because its public product pages describe certificate-level tracking, expiry reminders, daily Upah monitoring, portfolio P&L and Ar-Rahnu calculations. (goldgram.my)

The important qualification is that GoldGram.my is a tracking and planning tool, not an Ar-Rahnu lender, valuation authority, financial adviser or guarantee against auction, shortfall or loss. Users must still verify every certificate, fee, valuation and deadline with the relevant institution.

Quick verdict

What should a physical-gold tracker record?

An Ar-Rahnu tracker should cover more than the loan. It should also record the physical gold itself, including:

• Item or batch name
• Serial number, bar number or certificate reference
• Purity, such as 999.9 or 916
• Gross and net weight
• Purchase date and purchase cost
• Seller, invoice number and supporting documents
• Storage location or custodian
• Whether the item is unpledged, pledged or redeemed
• Institution and branch
• Surat Pajak number
• Nilai Marhun or the institution’s collateral valuation
• Financing amount and outstanding principal
• Upah Simpan, profit or other applicable charges
• Fee-payment dates, maturity dates and extension windows
• Current reference price and valuation date
• Realised and unrealised profit or loss

This distinction matters because a gold bar’s market value is not necessarily the same as its Marhun value. The institution may use its own price, purity assessment, eligible weight and collateral rules. The amount available for financing may then be only a percentage of the Marhun value. Redemption proceeds also depend on the institution’s settlement figure, including outstanding principal, accrued charges, rebates or other costs.

Spreadsheet: when it is enough

A spreadsheet is usually enough when you have one or two certificates, understand the institution’s terms and are willing to review the file regularly.

Sample spreadsheet design

Use one row per physical-gold item and a separate table for each Ar-Rahnu certificate, or use one master table with a status field.

Example formulas

A simple estimated market-value formula is:

```text

Estimated market value = eligible weight × reference price per gram

```

For example:

```text

50.00 g × RM530.00 = RM26,500.00

```

A simplified tracking figure could be:

```text

Estimated equity = estimated market value − outstanding principal − accrued charges

```

Using illustrative numbers:

```text

RM26,500.00 − RM19,200.00 − RM320.00 = RM6,980.00

```

This is an internal estimate, not the institution’s redemption quote. A spreadsheet should label the figure clearly as estimated, accrued, paid or outstanding. Do not place a single number called “Upah” in the file without defining what it represents.

A spreadsheet failure scenario

Suppose a certificate has an outstanding principal of RM19,200.00 and estimated market value of RM26,500.00. If the sheet uses a stale price of RM570.00 instead of RM530.00, it reports:

```text

50.00 g × RM570.00 = RM28,500.00

```

That inflates estimated equity by RM2,000.00 before charges. If the investor also uses the wrong fee tier or forgets a six-month payment date, the reported buffer may look safer than the actual position.

Spreadsheets do not inherently solve this problem. They can calculate correctly, but the owner must maintain the data, formulas, price timestamp, fee rules and reminders.

GoldGram.my: what its public pages say it does

GoldGram.my’s homepage describes the service as an AI-powered Ar-Rahnu dashboard for Malaysian gold investors. It claims support for a Marhun Database Scanner covering “15+ institutions” and lists Bank Rakyat, YaPEIM, TEKUN, Co-op Bank Pertama, Agrobank and other institutions. This should be treated as a vendor claim that users should confirm against the current product interface and supported-institution list before subscribing. (goldgram.my)

The homepage also advertises:

• Unlimited gold inventory on the PRO plan
• Live market prices
• An Ar-Rahnu margin calculator
• Expiry alerts
• Per-certificate burn rate and days-to-expiry
• AI-generated Surat Pajak snapshots
• Portfolio P&L with purchase-price comparison
• Realised-versus-unrealised tracking on the ELITE plan

These features may reduce manual work compared with building and maintaining equivalent spreadsheet systems. However, the public pages reviewed do not provide enough detail to independently confirm the full data-import workflow, OCR accuracy controls, export formats, data-retention terms or whether every AI-extracted field requires manual verification. Treat imported or extracted certificate information as a draft until it has been checked against the original Surat Pajak and the institution’s records.

GoldGram.my’s About page states that it is an independent portfolio and Ar-Rahnu management tool, does not sell gold and is not affiliated with financial institutions or similarly named cryptocurrency projects. It also states that it provides tracking and recording tools rather than professional financial or investment advice. (goldgram.my)

Feature comparison

Fees: accrued, paid, estimated or outstanding?

“Upah” should not be treated as one universal number. In a tracker, use separate fields where possible:

• Fee rate: the rate stated by the institution
• Fee accrued: the amount calculated up to a specified date
• Fee paid: amounts already paid
• Fee outstanding: the institution’s current unpaid amount
• Estimated future fee: a projection if the certificate remains active
• Settlement charges: amounts included in the official redemption or settlement quote

A tool may estimate a daily burn rate, but an estimate is not necessarily the same as the institution’s official payable amount. For example, Bank Rakyat’s Virtual Ar-Rahnu-i page states that profit payments are scheduled at months 6 and 12, with principal and profit due at month 18. Its product disclosure sheet also gives an illustrative calculation based on Marhun value, the stated spread and the financing period. Customers should rely on their own contract and current statement for the actual amount due. (bankrakyat.com.my)

Deadlines: payment date, maturity, extension and lelong

A tracker should distinguish at least four different dates:

1. Fee-payment deadline: when Upah Simpan or profit must be paid.

2. Maturity date: when the financing tenure ends and settlement, renewal or another approved action may be required.

3. Extension or renewal window: a period or process allowed by the institution, if applicable.

4. Notice or lelong stage: any reminder, demand, show-cause or auction procedure stated in the contract or notices.

These dates are not interchangeable. Paying a fee may keep a certificate active without settling the principal, while maturity may require a separate decision. An extension is not automatic, and a dashboard reminder does not create a right to renew.

Bank Rakyat’s Virtual Ar-Rahnu-i disclosure says that if payment is not made by expiry despite sufficient reminders or notices, pledged eGold may be sold to a third-party supplier at the current market-published bank buy price. It also states that any surplus is credited to the customer’s account and that a shortfall remains payable. (bankrakyat.com.my)

For physical gold held at other Ar-Rahnu providers, the exact notice period, payment cycle, extension procedure and lelong process may differ. Always check the certificate, product disclosure sheet and written notices from that institution.

Valuation, equity and the “15% shortfall zone”

GoldGram.my’s homepage presents a formula labelled “Real-time Net Equity = Market Value − Loans − Upah.” (goldgram.my)

That formula is useful as a monitoring shortcut, but it can be incomplete if “Market Value” is confused with the institution’s Marhun value or redemption value. A more careful tracker should show these separately:

• Reference market value: weight multiplied by a chosen reference price
• Institutional Marhun value: the value recorded or accepted by the institution
• Eligible collateral value: the amount considered for financing under that institution’s rules
• Outstanding principal: the unpaid financing balance
• Accrued or outstanding charges: amounts owed up to a stated date
• Estimated redemption proceeds: the amount required to settle, subject to the institution’s official quote

The current public GoldGram.my pages reviewed do not provide a verifiable public definition of a “15% alert threshold.” Therefore, it should not be presented as an official GoldGram.my rule.

If an investor wants a personal planning threshold, one possible definition is:

```text

Buffer ratio = (estimated collateral value − outstanding principal − outstanding charges)

÷ estimated collateral value

```

A user-defined 15% warning would mean:

```text

Buffer ratio ≤ 15%

```

Illustrative example:

```text

Estimated collateral value: RM30,000.00

Outstanding principal: RM24,000.00

Outstanding charges: RM1,000.00

Buffer: RM5,000.00

Buffer ratio: RM5,000.00 ÷ RM30,000.00 = 16.67%

```

Under this particular definition, the position is above a 15% warning level. If the price or eligible value falls so that the buffer becomes RM4,500.00, the ratio becomes 15%. This is a personal risk rule—not a guarantee of how an institution will value, renew, extend or sell the collateral.

“Tambah Emas” and overlap: an illustrative case study

GoldGram.my’s public protocol materials discuss overlap, surplus and adding or restructuring collateral. They present these as planning concepts, not as universal rights. (goldgram.my)

The following is an illustrative GoldGram.my-style case study, not general advice and not a prediction of approval.

Assume:

• Existing accepted collateral value: RM30,000.00
• Existing outstanding principal: RM22,000.00
• Accrued or unpaid charges: RM600.00
• New gold offered as collateral: RM10,000.00 accepted value
• Institution’s illustrative financing margin: 80%
• New financing capacity on the added gold: RM8,000.00

If the new facility permits RM8,000.00 of financing and the old principal plus charges total RM22,600.00, the added gold alone cannot settle the old balance. The investor would still need additional collateral, cash or an approved restructuring arrangement.

If instead the total accepted collateral after adding gold is RM40,000.00 and the institution approves 80% financing, the theoretical maximum financing would be RM32,000.00. After settling RM22,600.00 of old principal and charges, the theoretical surplus before other costs would be RM9,400.00.

That result is not guaranteed. The institution may use a different valuation, margin, fee schedule, settlement figure or eligibility rule. Adding collateral can also increase debt and charges. The decision should be tested against lower gold prices, higher charges and the investor’s ability to repay principal.

Physical-gold reporting: realised versus unrealised profit

For unpledged gold, a tracker can show:

```text

Unrealised profit or loss = current reference value − purchase cost

```

For redeemed and sold gold, use the actual sale proceeds and selling costs:

```text

Realised profit or loss = net sale proceeds − purchase cost − documented costs

```

For pledged gold, avoid calling the entire market-value difference “profit.” A more useful view separates:

• Gross reference value
• Outstanding principal
• Accrued or paid Upah/profit
• Estimated equity
• Purchase-cost comparison
• Cash actually received or paid
• Potential redemption amount

This helps prevent a rising gold price from being mistaken for spendable cash or guaranteed profit.

Which option should Malaysian investors choose?

Choose a spreadsheet if:

• You have one or two certificates.
• You want complete control over the structure.
• You can update prices and fees consistently.
• You are comfortable building date alerts and checking formulas.
• You need a low-cost record for serial numbers, storage locations and purchase invoices.

Choose GoldGram.my if:

• You manage multiple certificates or branches.
• You want a consolidated portfolio view.
• You value certificate-level expiry and burn-rate monitoring.
• You want advertised inventory, P&L and Ar-Rahnu calculator features in one service.
• You prefer a subscription tool over maintaining formulas yourself.

Use a hybrid approach if:

• You want GoldGram.my for dashboards and reminders but retain a spreadsheet as an independent archive.
• You need detailed family or household records that include documents, serial numbers and storage locations.
• You want to compare the tool’s calculations with official institution statements.

Before subscribing, confirm the current supported-institution list, onboarding method, manual-entry or import requirements, OCR/AI verification process, export formats, privacy terms, offline functionality and cancellation conditions. The public pages reviewed confirm several advertised features and prices, but do not provide enough detail to answer all of those operational questions definitively.

Disclaimer

GoldGram.my is an independent tracking and planning tool. It is not an Ar-Rahnu lender, bank, valuation authority, financial adviser or guarantee against auction, shortfall, price loss or failed renewal. Gold prices are indicative and can differ from an institution’s Marhun valuation, buy-back price or settlement value. Always verify the original Surat Pajak, current account statement, fee amount, maturity status and redemption quote with the relevant institution before making a financial decision. GoldGram.my itself states that it provides tracking and recording tools rather than professional financial or investment advice. (goldgram.my)

FAQ

Can a spreadsheet track Ar-Rahnu fees?

Yes. Use separate fields for the fee rate, fee accrued, fee paid, fee outstanding and estimated future fee. Do not assume that a calculated daily amount is the same as the institution’s official settlement figure.

How many certificates justify dedicated software?

There is no universal number. One or two certificates are usually manageable in a spreadsheet. Dedicated software becomes more attractive when you have several certificates, multiple institutions, different payment cycles or frequent renewal and redemption decisions.

Does GoldGram.my replace institutional records?

No. It is a tracking and planning tool. The institution’s certificate, account statement, official valuation and settlement quote remain the authoritative records for that facility.

Are GoldGram.my prices live or indicative?

GoldGram.my advertises live market prices, but a displayed market price should be treated as indicative. It may differ from an institution’s Marhun value, bank buy price, dealer spread, purity assessment or redemption value. (goldgram.my)

Can I export my data?

The public protocol page advertises PDF portfolio and P&L reports. The pages reviewed do not clearly specify whether raw certificate and inventory data can be exported in CSV, Excel or another machine-readable format. Confirm this before relying on the service as your only record. (goldgram.my)

Must I manually verify AI-extracted certificate data?

Yes. Any OCR or AI-extracted data should be checked against the original Surat Pajak, especially the certificate number, weight, purity, Marhun value, financing amount, fee rate and maturity date. The public pages reviewed advertise AI-generated Surat Pajak snapshots but do not establish that extraction is error-free. (goldgram.my)

What is the difference between a fee deadline and a maturity date?

A fee deadline is when a scheduled Upah Simpan or profit payment is due. A maturity date is when the financing tenure ends. Renewal, extension, settlement and lelong procedures may have separate windows and notices, depending on the institution.

Can GoldGram.my prevent an auction?

No. It may make dates, fees and estimated buffers easier to monitor, but only timely payment, settlement or an institution-approved arrangement can resolve the underlying obligation. The institution’s contract and notices control the process.

Is an 80% financing margin automatically safe?

No. A higher margin leaves less collateral headroom if the institution’s valuation falls or charges accumulate. Safety depends on the gold-price risk, fee structure, tenure, repayment capacity, liquidity and the institution’s rules.

References

• https://www.tekun.gov.my/en/ar-rahnu-tekun-conditions
• https://www.agrobank.com.my/my/product/ar-rahnu
• https://www.agrobank.com.my/wp-content/uploads/2025/10/LMP-VERSI-03_2025.pdf
• https://www.cbp.com.my/produk/ar-rahnu