ERPNext Accounting Consultant, Oman

Supplier balances in dollars, euros and yuan

Most Omani importers owe money in a currency other than the rial. If those suppliers are booked in rials at an estimated rate, the creditor balance never quite matches the supplier's statement, and the difference is cleared by a journal nobody can explain. ERPNext handles this properly when it is set up from the start.

The design I use:

• Party account currency: each overseas supplier is linked to a payable account in its invoicing currency, so the balance is held in that currency and in rials side by side.
• Actual payment rates: payment entries record the rate your bank applied, and the exchange gain or loss on settlement posts to its own account automatically.
• Advances: deposits paid before shipment are recorded as supplier advances and allocated to the invoice when it arrives, keeping both currency and rial values right.
• Revaluation: at each month end, open foreign balances are revalued to the closing rate through the exchange rate revaluation feature, and the entry reverses in the next period.

Because the rial carries three decimals, I also check that converted amounts on long invoices round consistently with what the bank reports. The aim is simple: your supplier's statement and ERPNext agree in the supplier's currency, every month. Currency design in general is covered on multi-currency ERP.

Import VAT, customs duty and the clearing agent's invoice

When goods arrive in Oman, several costs land at different times: the supplier invoice, freight and insurance, the customs declaration with duty and VAT, and the clearing agent's bill, which often mixes reimbursed charges with its own fees and VAT on them. If these are posted inconsistently, stock is valued wrongly and the VAT return picks up the wrong amounts.

The posting rules I agree with your finance team and advisor:

1. Customs duty, freight and insurance are added to stock cost through landed cost vouchers against the purchase receipt.
2. VAT on imports is kept out of stock cost and recorded in the way your advisor specifies, whether paid at the border or accounted for under any deferral arrangement your business uses.
3. The clearing agent's invoice is split: disbursements on your behalf, the agent's service fee and the VAT charged on that fee.
4. Customs declaration references are captured on the documents so the accountant can trace import VAT back to source.

Before each return, the accountant compares import VAT in ERPNext with the customs records for the period. Template setup for domestic VAT and e-invoicing readiness are discussed on ERPNext in Oman; this page stays with the ledger. Treatment of each import is your advisor's decision, not mine.

Letters of credit and trust receipt loans

Omani traders frequently finance imports through their banks: a letter of credit opened with a cash margin, documents accepted, then a trust receipt or import loan that is repaid when the goods are sold. Each stage moves money or creates a liability, and the bank charges for most of them.

As far as I know, core ERPNext has no dedicated letter of credit document, so I design around standard features rather than assume an add-on. A well-maintained community app may exist for your version; if so I check its upkeep before relying on it. Otherwise the approach is:

• Accounts for margin deposits, letters of credit outstanding where your auditor wants them shown, and each loan facility.
• A simple register, a custom doctype or a tracked list, holding the credit number, supplier, amount, expiry and linked purchase order.
• Journal templates for margin placement, loan drawdown against supplier payment, interest and charges, and repayment.
• A bank reconciliation check that loan statements agree with ERPNext each month.

The result is that the treasurer and the auditor see the same facility balances, and the finance cost of each shipment can be estimated. For the Odoo approach to Omani finance, see Odoo Accounting in Oman.

Credit control for contractor and retail customers

Selling to Omani contractors and retailers usually means long credit, dated checks and disputes over deliveries. ERPNext gives finance the tools to manage that, if they are switched on and owned.

• Payment terms on each customer drive due dates, so aging reflects what was agreed rather than a default.
• Credit limits per customer and company can block sales orders or invoices beyond the limit, with an override role for the credit controller.
• Dated checks are entered as payment entries with a reference date, so the expected clearance is visible and unpresented checks can be listed.
• Statements of account are generated and emailed from ERPNext on a schedule, which settles many queries before they escalate.
• Dunning letters can be raised for overdue invoices where your customers respond to formal reminders.

I also set up a weekly collections view by sales person and branch, because in many Omani firms the person who sold the goods is also the person best placed to collect. Bank statements are imported and matched in the reconciliation tool, so cleared checks drop off the list automatically. The Oman trading ERP page covers the commercial side of these businesses.

Year-end, the auditor and moving from Tally

The year-end is where all the above is tested. The auditor will ask for supplier confirmations in currency, bank and loan confirmations, aging with provisions, and a stock valuation that agrees with the ledger. In ERPNext I prepare that pack from standard reports, close periods with accounting periods, and post the period closing voucher only after the auditor has agreed adjustments.

Many Omani traders arrive from Tally, where bill-wise outstandings, multiple currencies and godown stock are all present but loosely controlled. The migration steps I follow:

• Groups and ledgers mapped to the ERPNext chart, with analysis ledgers replaced by cost centers or dimensions.
• Open supplier and customer bills loaded individually, in original currency, with the rate at which they were booked.
• Bank loans and trust receipts loaded per facility with their maturity.
• Warehouse stock valued so it ties to the final balance sheet.

Each test load is reconciled before the final run. My ERP data migration service explains the sign-off. Product detail sits on ERPNext Accounting, while the Oman hub and Oman ERP consultant pages describe how else I support businesses there.