Procore Business Central Accounting Integration 2026

Check Procore and Business Central accounting integration for a client. Verify the connector, mapped records, exceptions and a reconciled import or export.

Published
Updated

Procore and Business Central can exchange accounting records indirectly. Use a connector that supports your client’s region and records, or a reviewed export and import.

Choose the Record Handoff

Procore’s ERP Integrations support list omits Business Central. The DynamicsSmartz extension listed in Microsoft Marketplace is a third-party connector. It lists projects, vendors, purchase and sales invoices (including posted invoices) and payment journals.

The marketplace listing gives the United States and Canada as supported countries. The vendor’s own page lists the United States. For an Australian company, begin with a reviewed file transfer unless you have a supported connector for its setup.

Record the client’s Procore product and enabled tools, company and project IDs. In Business Central, identify the edition, online or on-premises environment, country configuration and destination company.

Choose the direction for each record. In one purchase workflow, Procore owns the approved project cost and Business Central owns the supplier balance and ledger posting. Name who approves release from Procore and who can post in Business Central.

Before enabling a connector, record its supported record types and direction for each. Specify which events start a sync, how often it runs and whether it creates drafts or posts entries. Check which records it can retry safely.

In the project’s Direct Costs tool, choose Summary or Summary by Cost Code. You need Read Only access or higher. Narrow the list with the available filters and choose Export > CSV.

Check the exported rows against the approved batch before mapping them for import.

Open a Business Central configuration package with the required purchase document tables and export its Excel template. Map the CSV and supplier invoice details into that template. Preserve the worksheet columns and retain the original CSV.

Use the configuration package import to import and validate the workbook before applying it. Use a package tested for your client’s tables and extensions. Review the saved purchase documents before posting.

A direct cost is a project record. An unposted purchase invoice is a document awaiting posting. Business Central’s configuration packages do not import directly into tables for posted entries.

Map the Accounting Records

Write down how each supported source field reaches the destination before you transfer any records.

Source detailBusiness Central check
Entity and projectSelect the correct company and map the project ID and cost code to the agreed project, task and dimensions.
Supplier or customerMatch the supplier to its vendor number. For a sales route, map the customer separately.
Cost type and taxConfirm the purchase line account or item and the GST treatment. In the Australian version, check the combination in VAT Posting Setup.
Currency and amountConfirm the document currency, whether prices include tax and the exchange rate if needed. Check net, GST and gross separately.
DatesPreserve the invoice date and choose a posting date allowed for the intended period. Flag costs received after cut-off for review.
Document identifiersPreserve the source ID in the transfer register. Keep the supplier invoice number in Vendor Invoice No. on the purchase document.

Agree one duplicate check across both routes. Search open and posted documents by company, vendor and supplier invoice number. Keep the source record ID and destination document number together so a retry can find the original.

Correct an unposted document through review. For an already posted purchase, use the applicable purchase credit memo procedure and retain the link to the original. Record whether the connector can carry the credit or needs a separately approved entry.

The finance reviewer decides how to handle a closed period. Keep the original document date and record the authorised posting date. Hold the transfer if the period treatment is unresolved.

Test a Small Supported Transfer

Test the route with fictional records in an isolated project and Business Central sandbox company. Record who owns any connector credential and what access it holds. Give the preparer and posting reviewer only the permissions they need.

Use two fictional supplier invoices for one project. Assume valid tax invoices for fully creditable purchases in Australian dollars and a GST setup that calculates 10% on amounts excluding GST.

Source referenceNetGSTGrossTest condition
TEST-01$1,000$100$1,100Complete mapping
TEST-02$500$50$550Missing vendor mapping on first pass
Source total$1,500$150$1,650Two invoices

For a route that creates unposted purchase invoices, run the transfer on both records. Expect one saved purchase document for $1,100 and one rejected row in the test register.

If the route accepts incomplete data, reject the unmapped row during review before it can be posted.

Fix the vendor map and resubmit only TEST-02. Reopen the destination company and find one document for each source reference. Confirm the project, supplier, currency, GST and posting date against the source.

Have the reviewer check Preview Posting before posting in the sandbox. Then open Posted Purchase Invoices and the corresponding ledger entries. Expect two invoices totalling $1,650, with $1,500 of net cost and $150 of recoverable GST.

For a connector that posts automatically, run the same test with posting enabled in the sandbox. Check posted invoices and ledger entries directly at each checkpoint. Confirm the rejected row has no posting before resubmitting it.

Save the test export, rejection and resubmission record, document numbers and ledger totals. Include the company, posting period and reviewer’s sign-off. A connection status confirms access. The saved documents and entries show what reached the accounts.

Reconcile and Handle Exceptions

Match each source row and its amount to the actual destination document. Check the posted entries against batch totals by currency, period and project. Keep drafts, posted documents and rejected rows distinct in the reconciliation.

Use general ledger reconciliation for the subsequent account-level tie-out. Match the transfer to posted costs and payables before checking the separate payment or bank records.

Record every missing, duplicate or rejected item with its source ID, amount and owner. Retain the corrected mapping, credit or other approved action with the original line.

Pause the next transfer for an unexplained difference, a duplicate posting or an entry in the wrong company or period. Resume after the reviewer can trace every affected record and confirms the corrected totals.

Assign one route to each batch. Before entering a cost manually, have the reviewer check open and posted documents, approve the entry and exclude that record from any pending import or connector retry.

Retain the Handover and End Access

Keep the supported record list, field map, permission owners and test results with the batch reconciliations. Review access when staff or providers change and confirm who can approve transfers and post entries.

Before ending the connection or engagement, pause transfers and reconcile the last batch. Give the client the source exports, mappings, transfer and exception logs and destination document references. Record who will resolve any open items.

Remove the practice’s access from both systems once the handover is complete. Revoke connector credentials if it is being retired, or transfer responsibility to the client’s authorised administrator if it will continue.

Tax Genie’s role is at client onboarding. It uses rules and AI to check answers in the client’s guided form. Your finance reviewer owns the Procore and Business Central transfer and signs off the accounting result.

One client form. One finished return.

Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works