LedgerLearn — QuickBooks L3 Advisor

L3 Module 1

Advanced Multi-Entity Accounting

Group structures, intercompany transactions, consolidation, and QBO's limitations

Multi-Entity Group Structures in QBO

At advisor level you will encounter clients who operate multiple legal entities — holding companies, subsidiaries, joint ventures, and franchise networks. Understanding how to manage these in QBO and where QBO falls short is critical to avoiding costly errors.

QBO's multi-entity capability

Each QBO subscription is a single legal entity. You manage multiple entities by having separate QBO files linked under the same accountant login. There is no native consolidation engine — intercompany eliminations must be performed manually.

Critical limitation QBO does not automatically eliminate intercompany transactions on consolidation. If Entity A sells $50,000 of services to Entity B, both the income (Entity A) and expense (Entity B) must be removed from the consolidated P&L manually — otherwise group revenue and costs are both overstated by $50,000.

Intercompany loan accounting

When one entity lends money to another, both sides need corresponding entries:

Entity A (Lender)	Entity B (Borrower)
Dr Intercompany Loan Receivable Cr Bank	Dr Bank Cr Intercompany Loan Payable
Interest income each period	Interest expense each period

Transfer pricing risk Related-party loans at 0% interest may be challenged by tax authorities. Under IRS Section 7872 (US) or similar rules, below-market loans require imputed interest — income is deemed earned even if not charged. Advisors must flag this risk to clients.

Consolidation workflow (manual in QBO)

Export trial balance from each entity at the consolidation date
Combine all entities into a consolidation spreadsheet
Identify all intercompany balances (loans, sales, purchases)
Eliminate each intercompany item (both sides must cancel)
Adjust for minority interests if applicable
Produce consolidated P&L, Balance Sheet, and Cash Flow

When to recommend moving beyond QBO

QBO is appropriate for groups up to 5–6 entities with simple intercompany activity. Beyond that, consider: Xero with consolidation add-ons, Sage Intacct, NetSuite, or Microsoft Dynamics — depending on complexity and budget.

🎯 Scenario

A holding company (Entity A) owns two subsidiaries (Entity B and C). During the year: A charged B $120,000 in management fees; B sold $85,000 of products to C at cost; A has a $200,000 intercompany loan to C at 0% interest. You are preparing consolidated accounts.

What are the three elimination entries required and what tax risk must be flagged?

Eliminations: (1) Remove $120k management fee income (A) and expense (B); (2) Remove $85k intercompany sales (B) and purchases (C) — and any unrealised profit in C's closing inventory; (3) Eliminate $200k intercompany loan receivable (A) and payable (C). Tax risk: 0% loan requires imputed interest disclosure under Section 7872 or equivalent.

Only the loan needs eliminating — trading transactions between subsidiaries are kept in the consolidated accounts

No eliminations needed as all three entities are under common control

Eliminate only the management fee — product sales are third-party equivalent transactions

✅ A is correct. All three intercompany flows must be eliminated. The management fee elimination removes fictitious income/expense. The product sale elimination removes revenue and COGS plus any profit still sitting in closing inventory (unrealised profit). The loan elimination removes assets and liabilities that cancel within the group. The 0% interest rate creates a transfer pricing/imputed interest obligation.

L3 Module 2

Revenue Recognition — ASC 606 / IFRS 15

The 5-step model, deferred revenue, contract liabilities, and QBO implementation

Why Revenue Recognition Matters at Advisor Level

The single most common financial statement misstatement in growing businesses is incorrect revenue recognition. For any client raising investment, preparing for acquisition, or subject to audit — getting this right in QBO is non-negotiable.

The ASC 606 / IFRS 15 five-step model

Identify the contract — written, oral, or implied agreement with a customer
Identify performance obligations — what distinct goods/services have been promised?
Determine the transaction price — fixed, variable, or constrained?
Allocate the price to obligations — based on standalone selling prices
Recognise revenue when (or as) obligations are satisfied — point-in-time vs over time

Point-in-time vs over time Point-in-time: revenue at delivery (product sales, one-off services). Over time: revenue spread across the service period (SaaS, maintenance contracts, construction). The wrong choice materially misrepresents profitability.

Deferred revenue in QBO

When cash is received before the performance obligation is met (e.g. annual subscription paid upfront), the amount is a liability — the business owes the customer the service.

Record cash receipt: Dr Bank / Cr Deferred Revenue (liability)
Each period as service is delivered: Dr Deferred Revenue / Cr Revenue
At any balance sheet date, Deferred Revenue shows obligations still to be fulfilled

Revenue Type	Recognition Timing	QBO Treatment
Product sale	On delivery	Invoice on shipment date
Annual SaaS subscription	Monthly over 12 months	Deferred revenue → monthly journal release
Construction contract	% of completion	Progress invoices + manual accruals
Retainer (professional services)	As hours are worked	Bill against time tracking records

Contract assets vs contract liabilities

Under ASC 606: if you've done more work than you've billed, you have a contract asset (unbilled receivable). If you've billed more than you've earned, you have a contract liability (deferred/unearned revenue). Both must appear on the balance sheet.

QBO limitation

QBO has no native revenue recognition schedule engine. Advisors must either: (1) set up recurring journal entries for deferred revenue releases, or (2) use an integrated app (e.g. Maxio, Chargebee, or Deferred) that syncs with QBO and automates the recognition schedule.

🎯 Scenario

A SaaS client signs three new annual contracts in October: Contract 1: $24,000 (October start). Contract 2: $36,000 (November start). Contract 3: $18,000 (December start). All are billed upfront and received in cash. The financial year ends December 31. The client has recorded all $78,000 as revenue in October–December.

What is the correct year-end revenue and what balance sheet adjustment is required?

Correct revenue: Contract 1: 3/12 × $24k = $6k. Contract 2: 2/12 × $36k = $6k. Contract 3: 1/12 × $18k = $1.5k. Total = $13,500. Deferred revenue liability = $78,000 − $13,500 = $64,500 on the balance sheet.

All $78,000 is correctly recognised — cash has been received so it's income

Defer all $78,000 — none can be recognised until the full contract is delivered

Recognise 50% of each contract at year-end as a halfway estimate

✅ A is correct. Revenue is recognised as service is delivered. By Dec 31: Contract 1 has delivered 3 months, Contract 2 has delivered 2 months, Contract 3 has delivered 1 month. Total recognised = $13,500. The remaining $64,500 is a contract liability (deferred revenue) on the balance sheet — the company still owes 9–11 months of service to those customers.

L3 Module 3

Due Diligence & M&A Accounting

Quality of earnings, purchase price allocation, goodwill, and pre-sale preparation

The Accountant's Role in M&A Transactions

Whether your client is buying or selling, the QBO file is the primary evidence base. Poorly maintained books kill deals, reduce valuations, and create post-closing disputes. An advisor-level bookkeeper must prepare files to withstand scrutiny.

Quality of Earnings (QoE) report

The QoE is a financial due diligence report produced for buyers, investors, and PE firms. It normalises EBITDA by removing:

One-off, non-recurring items (legal settlements, once-off grants, unusual losses)
Owner compensation above or below market rate
Related-party transactions at non-market prices
Accounting policy choices that inflate earnings (aggressive revenue recognition, under-depreciation)

EBITDA normalisation example Reported EBITDA: $420,000. Add back: owner salary above market rate $80,000. Deduct: one-off insurance payout included in income $50,000. Add back: litigation expense unlikely to recur $30,000. Normalised EBITDA: $480,000. At a 4× multiple, this $60,000 adjustment = $240,000 in deal value.

Purchase price allocation (PPA)

When a business is acquired, the purchase price must be allocated to identifiable assets and liabilities at fair value. Any residual = goodwill.

Component	Valuation Method	Balance Sheet Treatment
Tangible assets (PPE, inventory)	Fair market value appraisal	Restated at FMV
Customer relationships	Multi-period excess earnings	Intangible asset — amortised
Brand/trade names	Relief from royalty method	Intangible asset — may have indefinite life
Goodwill	Residual (price − net FMV assets)	Not amortised (US GAAP); tested for impairment

Pre-sale QBO preparation checklist

All bank accounts reconciled to latest date
Remove personal expenses from business records — recode to director's drawings
Write off all uncollectable debts (clean AR ageing)
Ensure revenue recognition is correct — no deferred revenue buried in income
Fixed asset register reconciled to balance sheet
No large "Miscellaneous" or "Other" balances — everything coded and described
3 years of clean, consistent financial statements

Post-acquisition integration in QBO

If the acquirer uses QBO: set up the acquired entity as a new QBO file, enter opening balances at fair values (not historical cost), and establish intercompany transaction processes from day one. Do not merge historical data into the acquirer's existing QBO file.

🎯 Scenario

A client is selling their business. During pre-sale due diligence you discover: (1) $28,000 of the owner's personal car loan is being paid through the business and expensed to Vehicle Costs. (2) $15,000 of revenue was recognised in the current year for a contract that is only 40% complete. (3) A $45,000 "Miscellaneous Expense" balance has no supporting documentation.

How do these three issues affect the sale valuation and what must be done?

(1) Recode $28k to drawings — adds back to EBITDA, increasing business value. (2) Reverse $9k of premature revenue (60% undelivered portion) — reduces normalised EBITDA. (3) Investigate and document $45k or write off to drawings if personal — undocumented expenses are a deal-breaker for any serious buyer.

All three should be left as-is and disclosed in the sale agreement for the buyer to deal with

Only item (1) is material — items (2) and (3) are common in small businesses

Post a single year-end adjusting journal to tidy all three items before providing accounts to the buyer

✅ A is correct. Each item has a specific valuation impact: (1) recoding personal expenses increases normalised EBITDA — at a 4× multiple, $28k adds $112k to deal value. (2) Early revenue recognition must be corrected — QoE analysts always check this. (3) $45k undocumented creates audit qualification risk and buyer concern about cash diversion. Clean books before sale, not after.

L3 Module 4

International QBO & Multi-Currency

Foreign currency accounting, exchange gains/losses, transfer pricing, and cross-border compliance

Multi-Currency in QBO Advanced

International clients add complexity at every accounting touchpoint. Multi-currency setup in QBO is the foundation — but the advisory challenges go far beyond software configuration.

Enabling multi-currency in QBO

Settings → Company Settings → Advanced → Currency → enable multi-currency
Warning: once enabled, multi-currency cannot be turned off
Set the home/base currency first — all reporting will be in this currency
Add foreign currency bank accounts as separate accounts in QBO

Exchange rate policy decisions

Approach	Pros	Cons
Real-time rates (QBO auto)	Most accurate daily	Monthly statements fluctuate
Fixed monthly rate	Consistent P&L comparisons	Must update manually each month
Transaction-date rate	Precise per-transaction	Admin intensive

Realised vs unrealised exchange gains/losses

Unrealised: arises when a foreign currency balance is revalued at a new rate before settlement. Example: a USD invoice raised when $1 = R18 is still unpaid when $1 = R19 — the ZAR value increased, creating an unrealised gain.

Realised: arises at the point of actual settlement (payment or receipt). The difference between the rate at invoice date and the rate at payment date is the realised gain or loss.

Year-end revaluation QBO does not auto-revalue foreign currency balances at year-end. Advisors must manually revalue all foreign currency debtors, creditors, and bank balances at the closing rate and post the unrealised gain/loss — then reverse on the first day of the new period.

Transfer pricing

When related entities in different countries transact with each other, tax authorities require these to be priced at arm's length (market rates). Key obligations:

Intercompany services must be charged at a rate a third party would pay
Loans must carry market interest rates (or imputed interest applies)
Documentation requirements increase with entity size — advisors must flag this early

Cross-border VAT/GST / withholding tax

International invoicing triggers complex tax questions: Does the client have a permanent establishment in the foreign country? Is the service subject to reverse charge? Are there withholding taxes on royalties or service fees? These require specialist tax advice — the advisor's role is to identify the questions and refer appropriately.

🎯 Scenario

A South African client (ZAR base currency) invoiced a US customer $10,000 on November 1 when the rate was $1 = R18.20. The customer paid $10,000 on December 15 when the rate was $1 = R18.85. The year-end is December 31 and a second invoice for $8,000 is still outstanding at a rate of $1 = R19.10.

What are the two exchange differences to record and what is the year-end adjustment?

Realised gain on Nov invoice: ($18.85 − $18.20) × $10,000 = R6,500. Year-end unrealised gain on Dec invoice: ($19.10 − invoice rate) × $8,000 — need the Dec invoice rate to calculate. Both posted to Exchange Gains/Losses in P&L. Unrealised gain reversed Jan 1.

No entries needed — both amounts are in USD so no ZAR conversion is required

Record both as income at the original invoice rates only — payment rates don't affect the accounts

Exchange differences are only recorded at year-end for all transactions together

✅ A is correct. The realised gain on the settled invoice = R6,500 (rate moved R0.65 × 10,000 units). The outstanding December invoice requires year-end revaluation at the closing rate — the difference vs the rate when invoiced is an unrealised gain/loss posted to P&L and reversed January 1. This is the standard treatment under IAS 21 / ASC 830.

L3 Module 5

Professional Ethics & Going Concern

Ethical obligations, going concern assessment, fraud indicators, and professional standards

Professional Ethics in Accounting

At advisor level, you will encounter ethical dilemmas. Understanding your professional obligations — and the consequences of getting them wrong — protects both you and your clients.

The five fundamental principles (IESBA / AICPA)

Integrity — be straightforward and honest in all professional relationships
Objectivity — do not allow bias, conflict of interest, or undue influence to override professional judgement
Professional competence and due care — maintain knowledge and act with diligence
Confidentiality — do not disclose information without authority (unless legally required)
Professional behaviour — comply with relevant laws; avoid actions that discredit the profession

Ethical red lines — situations you must refuse

Client Request	Correct Response
Backdate an invoice to reduce this year's tax	Refuse — this is tax evasion
Inflate revenue to meet a bank covenant	Refuse — financial statement fraud
"Just put it in Miscellaneous" (large unexplained items)	Investigate; refuse to mask undisclosed items
Don't disclose related-party loans to auditors	Refuse — related-party disclosure is mandatory

What to do when a client insists Document your refusal in writing. If the client proceeds without you, consider whether continued association compromises your professional standing. In cases involving suspected money laundering or tax fraud, you may have a legal reporting obligation (Suspicious Activity Report — SAR) that overrides client confidentiality.

Going concern assessment

Going concern is the assumption that a business will continue operating for at least 12 months from the reporting date. You must assess this — not just accept management's assurance.

Indicators of going concern doubt:

3+ consecutive years of losses
Current ratio below 1.0 (current liabilities exceed current assets)
Net liabilities (total liabilities exceed total assets)
Key loan covenant breaches
Loss of a major customer (significant revenue concentration)
Inability to obtain refinancing

When doubt exists, the accounts must disclose the uncertainty — with evidence of management's plans to address it. Preparing accounts on a going concern basis without adequate evidence is a professional standards breach.

Fraud indicators in QBO

Large, round-number transactions with no supporting documentation
Payments to vendors with no physical address or history
Payroll payments to employees not on the HR list
Transactions deleted or voided after reconciliation
Journal entries posted directly to revenue by non-finance staff
Audit log showing unusual after-hours access or bulk changes

🎯 Scenario

You are preparing year-end accounts for a client who has made losses in each of the last 3 years. Year 1: −$45,000. Year 2: −$62,000. Year 3: −$89,000. The balance sheet shows net liabilities of $38,000 (liabilities exceed assets). The director tells you: "We've signed a new contract — things will turn around. Just prepare the accounts as a going concern."

What is the correct professional response?

Request written evidence of the new contract value and start date; obtain management's formal going concern assessment with 12-month cash flow projections; if evidence is sufficient, prepare on going concern basis with disclosure of the material uncertainty; if insufficient, qualify the accounts.

Accept the director's assurance — they know the business better than you

Refuse to prepare accounts — the business is insolvent and must be wound up

Prepare accounts on a break-up basis without informing the client

✅ A is correct. The evidence must be obtained and documented — verbal assurance is not sufficient. A single new contract does not automatically resolve 3 years of losses and net liabilities. If proper evidence supports going concern, disclose the material uncertainty in the notes. If not, the accounts may need qualification. This is the accountant's professional obligation, not a choice.

L3 Module 6

Business Advisory & Valuation

EBITDA, valuation multiples, cash flow forecasting, KPIs, and the advisory transition

From Bookkeeper to Trusted Advisor

The highest-value accounting service is advisory — helping business owners make better decisions using their financial data. This requires mastering the language of business value, not just transaction recording.

Business valuation fundamentals

For SMEs, the most common valuation method is the EBITDA multiple:

Enterprise Value = Normalised EBITDA × Sector Multiple
Typical SME multiples: 2×–5× EBITDA (varies by sector, growth rate, and risk)

How to extract EBITDA from QBO

Start with Net Profit from QBO P&L
Add back: Interest expense, Tax provisions
Add back: Depreciation and Amortisation (from fixed asset schedule)
= EBITDA (Earnings Before Interest, Tax, Depreciation and Amortisation)
Apply normalisation adjustments (owner salary, one-offs)
= Normalised EBITDA for valuation purposes

13-week cash flow forecasting

A 13-week (90-day) cash flow is the most powerful tool for managing working capital. Build it from QBO data:

Input	QBO Source
Debtor collections (week by week)	AR Ageing + payment history
Supplier payments due	AP Ageing + payment terms
Weekly payroll	Payroll schedule
Loan repayments	Loan schedule (external)
Opening cash	Bank reconciliation balance

Key Performance Indicators (KPIs) from QBO

Gross Margin %: (Revenue − COGS) ÷ Revenue — benchmark against industry
Debtor Days: (AR ÷ Revenue) × 365 — how long customers take to pay
Creditor Days: (AP ÷ COGS) × 365 — how long you take to pay suppliers
Inventory Turns: COGS ÷ Average Inventory — how fast stock moves
Current Ratio: Current Assets ÷ Current Liabilities — liquidity health
Revenue per Employee: Total Revenue ÷ Headcount — productivity benchmark

The advisory conversation shift Compliance-only: "Here are your accounts." Advisory: "Your debtor days have increased from 28 to 47 days — that's $85,000 of cash tied up in late payments. If we get this back to 28 days, you free up enough cash to avoid the overdraft you used in Q3." This is the value proposition of advisor-level certification.

Loan covenant monitoring

Many business loans include financial covenants (minimum current ratio, maximum debt-to-equity, minimum EBITDA coverage). Advisors must: identify all covenants in their client's loan agreements, calculate the ratios from QBO monthly, and alert clients before a breach occurs — not after the bank does.

🎯 Final scenario — full advisory analysis

A client's QBO shows: Net profit $180,000. Depreciation $45,000. Interest expense $28,000. Tax provision $52,000. Owner salary $240,000 (market rate for their role: $120,000). One-off legal settlement income: $35,000. The industry trades at a 3.5× EBITDA multiple.

Calculate normalised EBITDA and the estimated enterprise value.

EBITDA = $180k + $28k + $52k + $45k = $305k. Normalise: add back excess owner salary $120k; deduct one-off legal income $35k. Normalised EBITDA = $305k + $120k − $35k = $390k. Enterprise value = $390k × 3.5 = $1,365,000.

EBITDA = $180k + $45k = $225k. Enterprise value = $225k × 3.5 = $787,500.

Enterprise value = Net profit × multiple = $180k × 3.5 = $630,000.

EBITDA = $305k. Enterprise value = $305k × 3.5 = $1,067,500 — no normalisation adjustments needed.

✅ A is correct. Step 1: Build EBITDA from net profit by adding back interest, tax, and depreciation = $305,000. Step 2: Normalise — add back the excess owner salary ($240k paid vs $120k market rate = $120k addback, as a buyer would replace the owner-manager at market rate); deduct the one-off legal income (not repeatable, so buyers exclude it). Normalised EBITDA = $390,000. Enterprise Value = $390k × 3.5 = $1,365,000. This is a $297,500 difference vs unadjusted EBITDA — normalisation has a massive impact on deal value.

🏆

You have completed all QB L3 modules

The L3 Advisor assessment tests your ability to handle complex scenarios at the level of a practicing accountant. Pass rate required: 80%.

This is the highest QuickBooks certification on LedgerLearn. Certificate issued with your name, score, region, and a unique verifiable ID.