Accounting basics for ERP consultants
Foundational concepts a D365 F&O consultant has to be fluent in: how the books work, what the reports say, how the close runs, how tax is collected and reported, and the local quirks that catch implementations by surprise.
An ERP consultant does not need to be a CPA, but the ones who succeed read finance fluently. Configuration choices in the chart of accounts, posting profiles, dimensions, fiscal calendar, and tax codes are accounting decisions disguised as IT decisions, and getting them wrong means broken reporting, painful re-implementations, or audit findings. This page covers the conceptual ground a consultant should walk into a finance workshop already knowing.
Why this mattersThe role of accounting in an ERP project
Every operational transaction in F&O eventually becomes an accounting entry. A vendor invoice, a customer shipment, a worker timesheet, a depreciation run, a stock count: all of them post journals. The consultant decides which accounts those journals hit through three setup areas:
- Posting profiles (per vendor group, customer group, item group, project group, etc.) which map operational events to general-ledger accounts.
- Account structures and advanced rules which define which combinations of main account plus financial dimensions are valid.
- Tax setup (sales tax codes, item / customer / vendor tax groups, posting groups) which routes VAT / sales tax to the right accounts.
If you cannot read a balance sheet or trace a journal back to its source transaction, you cannot configure these areas competently. Finance will know, and so will the auditors.
FoundationDouble-entry accounting and the accounting equation
Every accounting entry has at least one debit and at least one credit, and total debits equal total credits. This is the constraint that keeps the books balanced.
The accounting equation
Assets = Liabilities + Equity. The balance sheet is a snapshot of this equation at a point in time. Income statement activity flows into Equity through Retained earnings at year-end close.
Debit / credit rules by account type
- Assets increase with debits, decrease with credits. (Cash, AR, Inventory, Fixed assets.)
- Liabilities increase with credits, decrease with debits. (AP, accrued expenses, deferred revenue, taxes payable.)
- Equity increases with credits, decreases with debits.
- Revenue increases with credits, decreases with debits.
- Expenses increase with debits, decrease with credits.
A starter example
Buy 1,000 of inventory on credit:
| Account | Description | Dr | Cr |
|---|---|---|---|
| Inventory (asset) | Goods received | 1,000.00 | |
| Vendor / AP (liability) | Owed to supplier | 1,000.00 | |
| Totals | 1,000.00 | 1,000.00 | |
Both sides increase: an asset (inventory) and a liability (AP). The accounting equation stays balanced.
FoundationChart of accounts and financial dimensions
The chart of accounts (COA) is the catalog of natural accounts that classify every dollar of activity. F&O combines main accounts with financial dimensions (department, cost center, project, location, business unit, custom) to produce the full account string that posts to the GL.
Lean COA + dimensions
The modern philosophy is a relatively small main account list (a few hundred), with finer detail handled by dimensions. The old approach of encoding department / location / line of business directly into the main account number (so a 5,000-row COA emerges) makes reporting harder, not easier.
Account categories and main account types
Main accounts are tagged by type (asset, liability, equity, revenue, expense, balance, total) and by category (used by financial reports). The type drives the period-close behavior: P&L accounts close to retained earnings each year, balance sheet accounts roll forward.
Account structures
An account structure declares the valid combinations of main account and dimensions. Without one, any combination posts (chaos). With one, the system blocks invalid combos at journal entry. Most clients need 2 or 3 account structures (e.g., P&L with mandatory cost center, balance sheet with optional dimensions, tax-only, etc.).
ReportingThe five core financial reports
Every consultant should be able to describe each of these and where the data comes from in F&O.
1. Balance sheet (Statement of financial position)
Snapshot of assets, liabilities, and equity at a point in time. Reflects the accounting equation. In F&O, balances roll forward across fiscal years; only retained earnings absorbs the prior year P&L.
2. Income statement (Profit & loss / P&L)
Revenues minus expenses over a period (month, quarter, year). Captures operating performance. In F&O, P&L accounts zero out at year-end close and the net flows to retained earnings.
3. Cash flow statement
Sources and uses of cash, split into operating, investing, and financing activities. Reconciles opening cash to closing cash. Often produced via Financial Reporter or Power BI from F&O ledger data.
4. Statement of changes in equity
Movement in equity accounts: opening equity, plus net income, minus dividends, plus / minus capital changes, equals closing equity. Required under IFRS and most local GAAPs.
5. Trial balance
List of every account with its debit or credit balance. Total debits equal total credits. The trial balance is the bridge between the GL and the financial statements, and it is the first report every consultant should reconcile after a go-live.
ReportingTrial balance: the bridge to financial statements
The trial balance is a list of every account with its current debit or credit balance. It is the most important report for an ERP consultant during go-live because it proves three things at once.
- Mathematical integrity: total debits equal total credits. If they do not, journals are out of balance, period.
- Subledger reconciliation: AR balance on the trial balance equals the customer aging total. AP balance equals the vendor aging total. Inventory account equals the inventory valuation report. Cash equals reconciled bank statements.
- Reporting input: the trial balance is the source for every formal financial statement. The balance sheet and income statement are just trial balance lines grouped by account category.
The most common cause of broken reporting at go-live is a trial balance that does not tie to subledger balances. Reconcile each subledger to the GL before declaring close ready.
FoundationAccrual vs. cash basis
Two ways of recognizing transactions; consultants need to know which one their client uses (and which is required by law for them).
Cash basis
Revenue recognized when cash is received; expenses recognized when cash is paid. Simple, but distorts the picture of business performance. Permitted for very small entities in many jurisdictions; rarely used in ERP-scale businesses.
Accrual basis
Revenue recognized when earned (delivery, performance) regardless of cash timing. Expenses recognized when incurred regardless of cash timing. Required by GAAP, IFRS, and most countries' tax rules above certain size thresholds.
F&O is fundamentally an accrual system. The accruals you see (period-end accruals, prepaid amortization, deferred revenue, depreciation) all exist to align P&L recognition with the period of economic activity, not the period of cash movement.
StandardsGAAP vs. IFRS: what a consultant should know
The two dominant accounting frameworks. F&O can support either or both (often via multiple ledgers / books). Consultants need to know enough to ask the right setup questions.
US GAAP (Generally Accepted Accounting Principles)
Rules-based, US-centric, governed by FASB. Detailed prescriptive guidance per topic (revenue, leases, inventory, etc.).
IFRS (International Financial Reporting Standards)
Principles-based, used by 140+ countries (including all of the EU, most of Asia, Africa, Latin America). Governed by the IASB. Generally shorter standards leaving more room for judgment.
Differences a consultant should remember
- Inventory: US GAAP allows LIFO; IFRS does not. F&O supports FIFO, weighted average, standard, moving average across either framework.
- Development costs: US GAAP expenses R&D; IFRS allows capitalization of development phase if criteria are met (see Concept to market accounting).
- Inventory write-downs: Reversals are allowed under IFRS; not allowed under US GAAP.
- Leases: Both frameworks now require most leases on the balance sheet (ASC 842 / IFRS 16) but classification rules and lessor accounting differ.
- Revenue recognition: Largely converged under ASC 606 / IFRS 15 (5-step model), but disclosure differences remain.
- Component depreciation: Required under IFRS; permitted but not required under US GAAP.
- Property revaluation: Allowed under IFRS (revaluation model); generally not under US GAAP (cost model only).
Many multinationals run dual ledgers: one for local statutory (often local-GAAP or IFRS) and one for parent-company reporting (often US GAAP). F&O handles this via multiple posting layers and multiple FA books.
ImplementationOpening balances: what happens on ERP import
Opening balances are the data brought from the legacy system at go-live. Get them wrong and every report from day one is wrong. The process has three layers, and a consultant should be able to discuss each.
1. GL opening balances
The trial balance from the legacy system, posted as a single opening journal in F&O dated the cut-over date (typically the last day of the prior period or the first day of the new period). This journal must balance to zero across debits and credits.
Pattern: Dr each asset account, Cr each liability and equity account, totals match. Use a dedicated journal name (e.g., "Opening balance") and reference the legacy trial balance source.
2. Subledger opening balances
Customer open invoices, vendor open invoices, fixed assets, and inventory must be loaded into their subledgers, not just summed into the GL. Every customer needs the open invoice list (with original invoice date, due date, currency, amount), every vendor needs the same, every fixed asset needs cost / accumulated depreciation / book / placed-in-service date, every item with on-hand inventory needs quantity and unit cost.
Critical reconciliation: subledger totals must tie to the GL opening journal. AR subledger total = AR opening balance from the GL journal. Inventory subledger total = Inventory opening balance. Mismatch on day one means broken reporting forever.
3. Statistical / informational data
Open POs, open sales orders, open quotations, open production orders. These do not impact the GL on import (they are operational documents, not accounting events) but they are essential for operations to start day-one transactions cleanly.
What can go wrong
- Off-by-rounding. Currency rounding differences accumulate during cut-over. Reserve a "Cut-over rounding" account and post the rounding to it, with the controller's blessing.
- Missing dimensions. Opening journal posted to main account only; reporting by department breaks because the opening balances have no department.
- Wrong as-of date. Opening balances dated 1 January when the legacy cut-off was 31 December causes the first day to look like a massive transaction day.
- Sub-ledger to GL drift. AR subledger built from a different cut-off than the GL trial balance. Reconcile to one source of truth.
OperationsPeriod close: month-end, quarter-end, year-end
The period close is the disciplined sequence of work that converts operational data into reportable financials. F&O has explicit period status mechanics: open, on hold, closed, permanently closed.
Month-end close: the standard sequence
- Cut-off: stop transactional activity for the period at a defined time, or freeze data for a "soft close" while finance does the work.
- Sub-ledgers ready: AP invoices and payments posted, AR invoices and receipts posted, receipts and product receipts up to date, expense reports approved.
- Run cost processes: inventory close or recalculation, production order ending, project estimate process.
- Run period-end accruals: uninvoiced receipts accrual, manual accruals for known unbilled events, prepaid amortization, depreciation.
- FX revaluation: revalue open AR, AP, and bank balances in foreign currency.
- Reconcile clearing accounts: bank clearing, GRNI (purchase accrual), inventory in transit, asset clearing, remittance clearing, VAT accounts.
- Subledger to GL reconciliation: trial balance ties to AR aging, AP aging, inventory valuation, FA register, bank reconciliation.
- Run consolidation if multi-entity.
- Generate financial statements: trial balance, P&L, balance sheet, cash flow, management pack.
- Close period status: sub-ledgers first (AP, AR, inventory), then GL.
Quarter-end close
Same as month-end plus: external reporting (10-Q in the US, half-year report in the EU), audit interim reviews, larger management commentary.
Year-end close
Same as month-end plus: full inventory count and reconciliation, full FA register tie-out, FX year-end revaluation, statutory audit, year-end accruals (bonus, vacation, deferred tax), year-end closing journal that closes P&L accounts to retained earnings, opening transactions for the new fiscal year.
F&O period status
Open: transactions can post. On hold: only specific roles can post (used for soft close). Closed: nothing posts; can be reopened by a security-restricted role. Permanently closed: nothing posts ever again, no reopen possible. Use Permanently closed only after audit sign-off.
TaxIndirect tax (VAT / sales tax) mechanics
Indirect tax is collected on sales (output tax) and paid on purchases (input tax). Net is remitted to the tax authority. Mechanics differ between true VAT regimes (most of the world) and US-style sales tax (consumer-only), but the F&O configuration is similar.
Output tax
Tax collected from the customer on a sales invoice. Posted to a Sales tax payable account at invoice time.
| Account | Description | Dr | Cr |
|---|---|---|---|
| Customer (AR) | 1,000 net + 110 VAT (11%) | 1,110.00 | |
| Sales revenue | Net | 1,000.00 | |
| Sales tax payable (output) | Tax to remit | 110.00 | |
| Totals | 1,110.00 | 1,110.00 | |
Input tax
Tax paid to the supplier on a purchase invoice. Posted to a Sales tax recoverable account, which is recoverable against output tax (in true VAT regimes) or expensed (in US sales tax, where buyers are usually exempt and only end-consumers pay).
Periodic settlement (declaration)
At each tax-period end (monthly or quarterly per jurisdiction), the consultant runs Tax > Periodic tasks > Declarations > Sales tax > "Settle and post sales tax". F&O nets output against input per Sales tax authority and posts the difference to the Settlement account on the Ledger posting group, which is then paid to the authority. If the authority is linked to a vendor, the balance can be transferred to the vendor as an open invoice via the same process.
| Account | Description | Dr | Cr |
|---|---|---|---|
| Sales tax payable (output) | Clear period collected | 10,000.00 | |
| Sales tax recoverable (input) | Clear period recovered | 6,000.00 | |
| VAT settlement payable | Net to authority | 4,000.00 | |
| Totals | 10,000.00 | 10,000.00 | |
Tax declaration
The official filing to the authority. Uses electronic reporting (ER) configurations in F&O (e.g., Making Tax Digital in the UK, FEC in France, SAF-T in Portugal / Norway / Poland, declaracao mensal in Brazil). The consultant should know whether a country-specific ER configuration exists for the client's jurisdiction or whether it must be built.
Special VAT cases
- Reverse charge: Buyer accounts for both input and output tax on the same invoice (intra-EU acquisitions, certain services). Net cash impact is zero, but compliance reporting requires both lines.
- Exempt supplies: No output tax charged; corresponding input tax not recoverable.
- Zero-rated supplies: Output tax charged at 0%; input tax fully recoverable. Different from exempt despite the zero appearance.
- Partial exemption: Mixed exempt and taxable activity; only a proportion of input tax is recoverable. Calculation rules are jurisdiction-specific.
TaxDirect tax (corporate income, withholding)
Direct tax is tax on income / profit, not on transactions. It does not flow through every transaction; it is calculated on the period's results.
Corporate income tax
Tax on the company's profit at a country-specific rate (e.g., 21% US federal, 25% France, 17% Lebanon for most companies, 19% UK, 15% Germany federal plus solidarity / trade tax). Calculated quarterly or annually based on accounting profit adjusted for tax-allowable / disallowable items.
F&O does not natively calculate corporate income tax (that lives in tax provision tools or Excel for most clients). What F&O does book is the tax expense and the income tax liability:
| Account | Description | Dr | Cr |
|---|---|---|---|
| Income tax expense | Period tax accrual | 25,000.00 | |
| Income tax payable | Liability to authority | 25,000.00 | |
| Totals | 25,000.00 | 25,000.00 | |
Deferred tax
Differences between accounting profit and taxable profit (timing differences) create deferred tax assets or liabilities. Examples: depreciation differences between book and tax, accrued expenses not yet deductible, NOL carryforwards. These are not posted via F&O routine flows; they are manual GL journals based on tax provision calculation.
Withholding tax
Tax withheld at source from a payment. The payer deducts the tax from the gross payment, pays the supplier the net, and remits the withheld amount to the tax authority. Common on professional services, royalties, dividends, interest, especially cross-border. F&O has full withholding tax setup under Tax. (See the worked example in Source to pay, withholding tax.)
LocalizationLebanon-specific accounting and tax notes
Lebanon's accounting and tax landscape has its own rhythm. The notes below cover the items most likely to come up on an implementation. Tax rules in Lebanon have moved frequently since 2019; verify current rates and forms with a Lebanese tax advisor before configuring.
Accounting framework
Lebanon follows a French-style Plan Comptable General influence: a numeric account class structure (1xxx for equity / liabilities, 2xxx for fixed assets, 3xxx for inventory, 4xxx for receivables / payables, 5xxx for cash, 6xxx for expenses, 7xxx for revenues). IFRS is widely used by listed companies and many groups; SMEs often follow Lebanese GAAP which leans on French principles.
Currency reporting
Lebanon's accounting currency is the Lebanese Pound (LBP), but practical bookkeeping in many businesses runs in US Dollars. After 2019 the country has had multiple effective exchange rates, including the official central-bank rate, the bank rate, and the parallel market rate. ERP setups frequently need:
- LBP as accounting currency for statutory filings (income tax, VAT).
- USD as a reporting currency for management and group reporting.
- Multiple exchange rate types (official, bank, market) maintained per period.
- Awareness of "lollar" (banked USD pre-2019, subject to capital controls) versus "fresh USD" (post-2019 inflows, free-flowing). The distinction is operational rather than accounting, but contracts and customer / vendor balances often specify which currency variant applies.
VAT
- Standard VAT rate has historically been 11% (introduced in 2002).
- VAT registration threshold is set in LBP and has been revised after the currency adjustments; verify the current threshold before scoping.
- VAT declarations are typically filed quarterly.
- Standard forms include the L-3 quarterly declaration and the L-15 annual recap.
- Some supplies are exempt (financial services, education, certain medical) and some zero-rated (exports). Standard VAT mechanics apply.
Withholding tax
- 3% withholding on services rendered by non-residents (including professional services), and other rates apply per service type and residency.
- 10% withholding on income from movable capital (interest, dividends).
- Specific withholding on rental income paid to non-residents.
- Form R5 / R6 / R10 (and revisions) are used for various withholding declarations, verify the current forms in scope.
Income tax on profits
- Corporate income tax rate has been 17% for the standard regime; specific sectors and free zones have different treatment.
- Annual filing typically due in the months following fiscal year-end (calendar-year is dominant).
- Estimated payments / advances are required during the year.
Payroll tax (R10)
Income tax on salaries and wages is withheld monthly by the employer and remitted to the Ministry of Finance. The R10 form is the standard payroll-tax declaration. National Social Security (NSSF / CNSS) contributions are calculated separately and remitted on a different cadence.
Stamp duty
4 per mille (0.4%) stamp duty applies to many contracts and invoices in Lebanon. Often booked as a small expense line at contract signing rather than embedded in transaction taxes; confirm with the client whether it should be configured as an additional tax in F&O or treated as a manual journal.
Built-in property tax
Annual tax on rental value of real estate held by the company. Calculated outside F&O and posted via journal.
Practical implementation notes
- F&O does not ship a Microsoft-delivered Lebanon localization. Tax codes, withholding tax codes, and electronic reporting (declaration) configurations must be built or sourced from a partner.
- Bilateral books (LBP / USD) are best handled as accounting currency LBP plus USD reporting currency, not as two separate ledgers; only do dual ledgers when group reporting is in a different framework (e.g., IFRS group + Lebanese GAAP local).
- VAT-exclusive vs. VAT-inclusive pricing: Lebanese practice varies by industry; confirm at requirements stage. Wrong direction yields visible price differences immediately at testing.
OperationsReconciliations every consultant should know
Reconciliations are the audit trail that proves the books are right. A consultant who can list these (and explain how to fix each one) is automatically more credible.
- Bank reconciliation: bank statement balance to GL bank account. Difference is unreconciled items (timing differences). Run advanced bank reconciliation in F&O for serious volumes.
- AR aging to GL: sum of customer open transactions equals AR control account. Mismatch usually means a manual journal hit AR without going through the customer.
- AP aging to GL: same as AR but for vendors.
- Inventory subledger to GL: inventory valuation report by item equals inventory control account. Mismatch means manual journals or wrong posting profile setup.
- Fixed asset register to GL: sum of asset cost minus accumulated depreciation equals net book value on the balance sheet.
- Clearing account zero-out: bank clearing, GRNI / purchase accrual, inventory in transit, asset clearing, remittance, VAT settlement. None of these should have a stale balance at period end.
- Intercompany reconciliation: IC receivable in entity A equals IC payable in entity B. Mismatch is a sign of one-sided IC postings.
- Tax reconciliation: output tax in GL equals total of customer invoices' VAT lines for the period. Input tax in GL equals total of vendor invoices' VAT lines.
If you can produce these reconciliations cleanly, the financial close is on solid ground. If you cannot, the close is a hope and not a process.