Microsoft Dynamics 365 Business Central vs QuickBooks Online

Requirement evaluated: Period-close controls that prevent posting to closed periods while allowing adjustments with proper authorization

For a controller at a multi-entity professional services company preparing for audit, Business Central delivers period-close controls through a documented, two-layer posting-date enforcement system. At the company level, an administrator sets 'Allow Posting From' and 'Allow Posting To' dates in General Ledger Setup; <cite index="11-1,11-3">these fields define the allowed posting window, and those posting periods apply to the company and to all users.</cite> When a period needs to be locked for general staff while remaining open for authorized roles such as the controller or CFO, <cite index="15-1,15-2">the administrator can define different posting periods for specific users on the User Setu …

Limitations: The 'authorized adjustment' pathway relies on an administrator manually extending a named user's posting date range in User Setup rather than a formal workflow-gated approval chain; there is no native in-product request-and-approve flow for period reopening, which means the authorization process is controlled through a …

Requirement evaluated: Period-close controls that prevent posting to closed periods while allowing adjustments with proper authorization

For a company preparing for its first audit across 8 entities, QBO's period-close control works as follows: an admin navigates to Account and Settings > Advanced > Accounting and turns on 'Close the books,' setting a closing date. Once set, any user who attempts to add, edit, or delete a transaction dated on or before that date will either see a warning or be required to enter a shared password before the change is saved, depending on which mode the admin configures. The official QBO help article 'Lock your books in QuickBooks Online' describes this as a hard enforcement at the transaction-posting layer, not merely a report filter. …

Limitations: The authorization pathway for posting to a closed period is a single shared password held by any admin, with no workflow-gated approval chain, no named-approver record tied to a specific prior-period posting, and no multi-tier role hierarchy (e.g., Staff can request, Controller approves). …

Requirement evaluated: Real-time executive dashboard showing consolidated cash position, revenue by segment, and AP/AR aging

For a company with 8 legal entities replacing a QuickBooks-plus-spreadsheets consolidation workflow, Business Central offers two complementary mechanisms. First, a native Consolidation module lets the controller set up a dedicated "consolidated company," register each of the 8 legal entities as business units, and run the consolidation batch job (via database link for same-environment entities or API for cross-environment) to transfer GL entries into the consolidated company; the Consolidated Trial Balance and G/L Consolidation Eliminations reports then surface a unified, elimination-adjusted financial view. …

Limitations: The out-of-the-box Power BI Finance app does not natively produce a single consolidated dashboard spanning all 8 entities; it requires either custom Power BI development to merge per-entity datasets or use of the consolidation company (which covers GL balances but not live subledger aging detail). …

Requirement evaluated: Real-time executive dashboard showing consolidated cash position, revenue by segment, and AP/AR aging

For an 8-entity professional services company migrating from QuickBooks Enterprise, the native QBO dashboard is single-entity only: each company file is a separate subscription and the standard Business Overview dashboard cannot aggregate data across entities. Cross-entity consolidation in QBO Advanced is delivered via Spreadsheet Sync, which pushes multi-company financial data into Microsoft Excel rather than an in-app executive dashboard, replicating the manual aggregation workflow the buyer is trying to eliminate. The full consolidated executive dashboard the buyer needs is available through Intuit Enterprise Suite (IES), Intuit's own higher-tier offering. …

Limitations: The 2-hour dashboard refresh interval is a documented mechanism gap against the buyer's real-time requirement: an executive checking cash position or AP aging mid-day may see data that is up to 2 hours stale. …

Requirement evaluated: REST API with documented endpoints for custom integrations

For a multi-entity professional services and distribution company moving off QuickBooks Enterprise, Business Central provides a fully documented REST API (v2.0) with published endpoints covering core ERP objects including GL, AP, AR, vendors, customers, and journal lines. The built-in API layer requires no custom code and minimal setup to activate: for the online (SaaS) version, APIs are enabled by default, and any coding language capable of calling REST APIs can be used to build Connect apps for point-to-point integrations with systems like ADP and Salesforce. …

Limitations: One documented constraint is that existing built-in API pages cannot be extended with additional fields directly; if a built-in endpoint does not expose a field the buyer needs, the documented workaround is to copy the AL code and build a new custom API, which requires AL development resources. …

Requirement evaluated: REST API with documented endpoints for custom integrations

For a buyer needing programmatic connectivity between QBO, Salesforce, ADP, and custom consolidation tools, Intuit provides a publicly documented REST API accessible via the Intuit Developer Portal at developer.intuit.com. <cite index="1-2,3-1,3-2">The QuickBooks Online Accounting API is based on the REST framework and uses standard HTTP methods and JSON for input and output.</cite> <cite index="5-4,5-5">The API uses OAuth 2.0 for authentication and covers the full accounting data model: customers, invoices, bills, payments, vendors, accounts, and profit/loss reports, with endpoints for create, read, update, delete, and query operations.</cite> <cite index="5-6">Webhooks are also supported f …

Limitations: <cite index="11-4,11-5">Every API call targets a specific company (realm) identified by a realmId, requiring all requests to carry a valid OAuth 2.0 access token per company.</cite> For this buyer's 8 legal entities, that means 8 separate token lifecycles and no single API call that spans entities for consolidation que …

Requirement evaluated: Multi-currency support: CAD to USD translation with automatic gain/loss calculation per ASC 830

For this buyer's CAD-to-USD requirement across 8 legal entities pursuing audited financials, Business Central delivers two distinct layers of FX handling. At the transaction level, <cite index="1-29,1-30,1-31,1-32,1-33">the Exchange Rates Adjustment batch job uses the exchange rate valid on the posting date to adjust currency balances, calculates differences for individual currency balances, and posts unrealized amounts to dedicated Unrealized Gains and Unrealized Losses G/L accounts, with balancing entries automatically posted to the receivables/payables accounts.</cite> Realized gains and losses are handled at settlement: <cite index="4-18,4-19,4-20">when an invoice is paid and the bank re …

Limitations: Business Central's per-account Average/Closing Rate translation methods and automated unrealized/realized FX gain-loss posting cover the transaction-level mechanics of ASC 830, but the CTA equity section entry is not automated natively, and Microsoft's own documentation explicitly cautions against using the ACY for sub …

Requirement evaluated: Multi-currency support: CAD to USD translation with automatic gain/loss calculation per ASC 830

This buyer operates 8 legal entities across the US and Canada and needs CAD-to-USD translation that is fully ASC 830-compliant in time for audited financials. QBO's Multicurrency feature does post realized FX gain/loss automatically at the transaction level: when a CAD-denominated invoice is settled at a different exchange rate than the booking rate, QBO calculates the difference and records it to a system-generated 'Exchange Gain or Loss' account. For period-end unrealized revaluation, QBO offers a 'Revalue Currency' workflow (Settings > Currencies > Revalue Currency) …

Limitations: QBO cannot produce a CTA posting to OCI, cannot apply differentiated rate types by account category (closing rate for balance sheet vs. average rate for income statement) …

Requirement evaluated: Customer portal for invoice access and online payment

For a $180M professional services company expecting audited financials and self-service AR, Business Central's native capability stops well short of a true customer portal. Out of the box, BC supports per-invoice payment links: when a sales invoice is emailed as a PDF, <cite index="21-5,21-6,21-7">there is a PayPal link in the email body and in the attached PDF document; if the customer chooses the link, the service page for their PayPal account opens showing payment details, and the customer can pay the invoice as any other PayPal payment.</cite> <cite index="21-1,21-2">Business Central can register payments automatically if the seller has a Business Merchant account for the PayPal Commerce …

Limitations: <cite index="14-12,14-13">Natively, customers are unable to pay invoices online out of the box; Business Central lacks payment links to a persistent portal, customer-facing login, and real-time account balance visibility.</cite> For this buyer's audit readiness requirement and B2B customer base, achieving the full port …

Requirement evaluated: Customer portal for invoice access and online payment

For this buyer's 8-entity, audit-bound professional services and distribution operation, QBO's customer-facing AR experience is built around QuickBooks Payments: the staff creates an invoice in QBO, enables online payments (credit card, ACH, PayPal, Venmo, Apple Pay), and emails it to the customer. <cite index="23-4">With QuickBooks Payments (Merchant Services), you can securely email an invoice with a 'Pay now' button.</cite> <cite index="20-2,20-3">The customer sees a 'Pay Now' button in the email; that button acts as an embedded payment link that connects directly to the invoice and updates records automatically once the payment is made.</cite> That is the full extent of the native custom …

Limitations: The 'Pay Now' link is scoped to a single emailed invoice in a single QBO company file: this buyer's customers transacting across multiple of the 8 legal entities would receive separate, entity-siloed payment emails with no consolidated invoice history, no persistent login, and no cross-entity statement view — a materia …

Requirement evaluated: Dedicated support contact (not ticket-only) during the first year

For a $180M professional services company moving off QuickBooks, the practical path to a dedicated contact in Business Central runs through the VAR/reseller model, not Microsoft directly. Microsoft's own documentation states that 'each Business Central customer has a partner who assists with technical support when requested by the internal administrator,' and that partner is required to configure their named support contact details in BC's Help and Support page. This means the implementing VAR is, by design, the dedicated human contact for day-to-day support. Beyond the VAR, two Microsoft-direct options exist: (1) …

Limitations: The VAR-as-dedicated-contact model carries no Microsoft-standardized SLA for named contact continuity or response time, and its quality varies entirely by which partner is selected. …

Requirement evaluated: Dedicated support contact (not ticket-only) during the first year

For a $180M, 8-entity company pursuing audit readiness, QBO Advanced includes Priority Circle, a premium support program bundled at no additional charge with an active QBO Advanced subscription. <cite index="1-23">Priority Circle is a service for QuickBooks Online Advanced customers that provides in-depth product training and premium support.</cite> On the support contact question specifically, <cite index="1-14,1-15">Priority Circle gives you a direct line to top QuickBooks technical support agents; when you need a fast answer, specialists are available via phone or chat.</cite> Third-party reseller documentation describes the program as also including a dedicated account manager or custome …

Limitations: <cite index="1-37">Priority Circle is included at no extra charge only to customers located in the 50 United States and the District of Columbia who have an active paid subscription to QBO Advanced</cite>; this buyer's Canadian entities are explicitly excluded from Priority Circle benefits, meaning the support model is …

Requirement evaluated: 1099 preparation and electronic filing

For a company moving off QuickBooks with 8 legal entities each requiring separate EIN filings, Business Central's US localization includes a fully native 1099 workflow. During the year, each vendor card is flagged with an IRS 1099 Form No. and Form Box No. (e.g., NEC-01, MISC-03) on the Payments FastTab; <cite index="1-12,1-13">on purchase documents you can specify that the document is 1099-liable and assign the 1099 code for the vendor, and before you start using Business Central you must set up 1099 Form Boxes and designate vendors as 1099-liable.</cite> When invoices are posted and payments applied, <cite index="3-39">the Amount field on the 1099 Form Document page updates automatically.< …

Limitations: Business Central's native 1099 module does not document Combined Federal/State Filing (CF/SF) state-level e-filing or active IRS TIN matching against the database; state-level 1099 obligations would need to be handled separately or confirmed with a tax advisor. …

Requirement evaluated: Three-way matching for PO-based invoices with configurable tolerance (we need 2% on price, 5% on quantity)

For a $180M distribution company processing 2,500 invoices per month and preparing for audited financials, QBO Online's PO-to-bill workflow is manual and does not perform automated matching of any kind. When a vendor bill arrives, a user navigates to Expenses > Bills, opens the bill, and manually links it to an open PO for that vendor; the system then copies PO line items into the bill. There is no automated comparison engine that validates the bill's unit price against the PO price, no goods-receipt layer that captures confirmed quantities separately from the bill, and no configurable tolerance thresholds (percentage or dollar-based) on either the price or quantity dimension. …

Limitations: The buyer's specific requirement for automated three-way matching (PO, goods receipt, vendor bill) with separate configurable percentage tolerances per dimension (2% price, 5% quantity) …