NetSuite payroll reconciliation: international payment data and global payroll reporting considerations

Rejoice Ojiaku

NetSuite payroll reconciliation helps finance teams connect payroll costs to accounting records and confirm that payments match what the business owes. For global teams, that means bringing together payroll journals, payment records, exchange rates and fees across countries and currencies

This guide explains what finance teams need to match, where international payroll reconciliation breaks down, and how to structure payroll reporting in NetSuite. It also shows how Wise Business can give finance teams clear international payment records, with the cost shown before each transfer.

Table of contents

Register for Wise Business ✍️

Why NetSuite payroll reconciliation matters for global teams

Payroll repeats every pay period, so a small mapping error repeats with it. For global teams, the data behind each pay run can sit in a payroll provider, a bank and NetSuite, and a journal can balance while the bank tells a different story.

Payroll costs as finance data

Payroll reconciliation is the process of proving that payroll calculations, ledger entries and actual payments agree. It catches differences between a payroll provider's report, NetSuite's ledger and the bank before they reach month-end reporting.

In the UK, payroll software records pay, calculates deductions, and produces payslips; the employer then reports pay and deductions to HMRC in a Full Payment Submission (FPS) on or before payday.1 Finance needs those same figures in the ledger, split in a way that supports payroll reporting.

Why global payroll creates more reconciliation work

NetSuite's built-in payroll module, SuitePeople, covers U.S. payroll, so customers paying people elsewhere need a partner payroll solution.2,3 Oracle describes a Paycheck Journal feature that partners use to track payroll data for employees outside the U.S.3 Each country brings its own provider, currency and report format, adding to the global payroll challenges finance teams face.

A UK head office paying a team in Ireland in euros (EUR) adds a currency conversion and a payment record to the picture. That payment layer is where Wise Business helps, by keeping the international payment data for each pay run in a single place.

What finance teams need to see in NetSuite

For each pay run, finance needs four things in NetSuite:

  • total cost by subsidiary and department
  • the split between pay, tax, and employer costs
  • cash that left the bank
  • any difference still to be explained.

NetSuite requires every journal to balance, with debits equal to credits.4

What payroll data needs to be reconciled in NetSuite?

These 6 data points cover most of what finance teams need to match after each pay run.

Data itemWhat to matchWhere it comes from
Gross payPayroll register to journal debitPayroll provider report
Net payJournal credit for amounts paidRegister and payment records
Employer costsEmployer National Insurance and pension to ledger accountsPayroll provider report
Taxes and deductionsAmounts owed to HMRC to liability accountsFPS data and HMRC payment
Fees and FXTransfer fees and exchange differences to own accountsPayment provider records
Payment statusEach payment to a bank lineBank feed or statement
💡 Read More About Payroll reporting for global teams

Payroll totals and journal entries

Gross pay, deductions and net pay on the payroll register should tie to the payroll journal posted in NetSuite. Payslips must show pay before deductions, the deductions and pay after deductions, so they give a ready-made check against the ledger.5

Employer costs, taxes and deductions

Gross pay isn't the full cost of an employee. UK employers also calculate employer National Insurance and pay employer pension contributions.1,6 Each month, they pay HMRC the tax and National Insurance reported on the previous tax month's FPS, less any Employer Payment Summary reductions, by the 22nd (or the 19th if paying by post).1,7

Disclaimer: The information in this article is for reference purposes only and should not be considered financial advice. All investment decisions should be made after thorough research and consultation with a qualified financial advisor. Remember that investments, even in low-risk funds, are never guaranteed, and your capital is at risk.

Payment fees, FX and bank records

Payroll software calculates pay, but it can't see what a bank or payment provider charges to deliver it. Transfer fees, exchange differences and bank charges only appear in payment records. Wise Business shows the exchange rate and fee before you confirm each payment, so finance knows the cost of a transfer before it posts anything.

Where international payroll reconciliation breaks down

Payroll data from multiple countries

A provider in each country often means a different report format. Teams then reformat each file and upload it as a CSV journal. NetSuite's journal import accepts data by class, department, location, and subsidiary for entries of up to 10,000 lines.8 A wrong mapping in 1 file can affect every line it contains.

Currency and exchange rate differences

In OneWorld, when you select a subsidiary, NetSuite sets the journal currency to that subsidiary's base currency and shows its default exchange rate, which you can edit for that transaction only.9 For groups reporting under International Financial Reporting Standards (IFRS), IAS 21 requires them to record a foreign currency transaction at the spot rate on the transaction date, and exchange differences on settlement go to profit or loss.10

Wise Business converts at the mid-market exchange rate and shows the rate before you confirm, so the rate used for each payment is on record.

Missing or inconsistent payment references

A payment without a pay run number or employee ID is hard to match to a journal. NetSuite matches imported bank lines to transactions using reconciliation rules and leaves exceptions for manual matching, so every unclear reference adds work at the month-end.11 Agree on a single reference format across providers and entities before the next pay run.

wise-business

Discover Wise Business ✍️

How to structure NetSuite payroll reporting

Mapping payroll data to the general ledger

Create separate general ledger accounts for gross pay, employer taxes, employer pension, amounts owed to HMRC, net pay owed and a payroll clearing account. Then, map each provider's report lines to those accounts, so every country posts the same way.

Using departments, subsidiaries and cost centres

In NetSuite, departments, classes and locations classify records, and in OneWorld, subsidiaries are the primary classification.12 Many teams map cost centres to departments, classes or custom segments, so decide that mapping before the first import. A regular journal entry applies to only one subsidiary, so costs shared between entities require an intercompany journal entry.9

Separating salary costs, taxes, fees and FX

Post salary cost, employer taxes, transfer fees and FX differences to separate accounts. That way, a rate move or a fee change shows up as its own line instead of looking like a salary variance. It also keeps global payroll reporting readable when the same cost appears in several currencies.

Connecting payment data to payroll reconciliation

A payroll report tells you what you owed. A payment record tells you what was actually paid, when it left, what it cost and whether it arrived.

Tracking payment status after payroll approval

After payroll approval, finance needs to know which payments have gone out and which haven't. In Wise Business, you can download a transfer confirmation once a transfer is complete, with details such as the transfer number and banking partner reference.

Recording transfer fees and FX costs

Here's an example of paying a €20,000 net payroll from British pounds (GBP), using illustrative rates:

ItemAmount
Net pay in the payroll journal (€20,000 at £0.85 per €1)£17,000.00
GBP converted to pay €20,000 (£0.8524 per €1)£17,048.00
Transfer fee£12.00
Total debited from the bank£17,060.00
Difference to explain£60.00

Of that £60.00 difference, £48.00 is an exchange difference and £12.00 is a fee, so each one belongs in its own account.

Matching payment records back to payroll reports

NetSuite can import bank data and run reconciliation rules that match imported lines to account transactions, leaving exceptions for manual matching.11 A month-end routine keeps that manageable:

  1. Pull the payroll register and payment records for the pay run.
  2. Match the payroll journal totals to the register, subsidiary by subsidiary.
  3. Match each payment to a payroll line using its payment reference.
  4. Import or sync bank data and run NetSuite's bank matching.
  5. Post fee and FX differences to their own accounts.
  6. Approve the journals and file the confirmations with the pay run.

Wise Business lists Oracle NetSuite among the accounting software it connects with, so transactions in the Wise currencies you choose can sync into NetSuite as a bank feed, subject to availability for your account.

What to check before choosing a payroll-to-NetSuite workflow

The right workflow depends on your countries, providers and currencies. Here are the usual trade-offs.

WorkflowStrengthWatch-out
Manual CSV journal importLow set-up costReformatting and mapping errors by hand
Payroll provider integrationJournals post without manual filesDetails depend on the fields the integration sends
Provider integration plus a payment data feedJournals and payment records both reach NetSuiteNeeds consistent references and set-up work

Integration depth and data fields

Check whether the integration sends summary journals or line-level detail, and whether it carries department, location and subsidiary fields. Summary journals keep the ledger tidy, but they can hide the detail you need when a number doesn't match. For more, see Wise's guide to payroll integration.

Audit trails and approval records

NetSuite can require approval before a journal entry posts to the general ledger.13 Keep the payroll register, the approved journal and the payment confirmations together for each pay run, so a reviewer can follow the trail from payslip to bank. Check the payment side has clear roles for who prepares and who sends.

Month-end close and reconciliation effort

Count the manual steps between a finished pay run and a reconciled ledger: exports, reformatting, rate look-ups and reference matching. Each one repeats every month and is another place for an international payment to go missing from the ledger.

How Wise Business can support international payroll payment data

Wise Business can support businesses that make international payroll-related payments by helping them send money across borders and access transaction details relevant to finance reconciliation.

Its role is the payment layer. Payroll providers calculate what is owed, NetSuite records the accounting impact, and finance teams use payment and bank records to confirm settlement and reconcile differences. Businesses should verify which payment methods, currencies and recipient types are supported for their specific use case.

The Wise account is not a bank account but offers some similar features and your money is safeguarded.

International payroll-related payments

Wise Business lets eligible businesses pay employees, contractors and freelancers in other countries at the mid-market exchange rate, in their own currency, and send money to 140+ countries. Teams can use batch payments to pay many people from a single spreadsheet.

Transparent fees and FX records

International transfers can create reconciliation differences when the funding amount, destination amount and fees aren't recorded separately.

Wise Business shows applicable fees and exchange rates for supported transfers before confirmation, and lets you hold 40+ currencies in your main account to fund payments. Opening a Wise Business account is free, and a one-time £50 fee unlocks Advanced features. Check which plan covers the features you need on the Wise Business pricing page.

The accounting team should still establish how to record these amounts in NetSuite, including the treatment of exchange differences and any fees charged separately by other financial institutions.

Payment records for finance reconciliation

You can download a transfer confirmation for each completed transfer, as well as statements in formats such as CSV and CAMT.053. Wise Business also connects with accounting software, including Oracle NetSuite and Xero, so payment transactions can flow into the ledger. Larger teams that automate payouts can explore the Wise API.

Make international payroll payments easier to reconcile with Wise Business

If your finance team is tired of chasing international payroll payments through bank statements and spreadsheets, Wise Business gives you a cleaner way to run them. Pay people abroad at the mid-market exchange rate, see the fee before you confirm and, where available for your account, sync your Wise transactions into NetSuite so every pay run leaves a record your reconciliation can use.

wise-business

Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

With Wise Business, you can:

  • 🌍 Send money to 70+ countries and pay overseas invoices at the mid-market exchange rate with low, transparent fees and no hidden exchange rate markups (product availability varies by region)
  • 📥 Receive payments in 24 currencies and counting
  • 💵 Get local account details for 8+ currencies, including USD and EUR, to let your customers pay in a currency they know and trust - convenience for them and peace of mind for you
  • 💰 Hold money in 40+ currencies
  • 🔁 Convert currencies anytime at the mid-market exchange rate with low, transparent fees
  • ⚡ Use the batch payments tool to create and send up to 1,000 payments in a single transfer
  • 👥 Run payroll and make international payments for up to 1,000 employees all over the world - including paying suppliers using local payment methods like ACH, SEPA, and Faster Payments
  • 💳 Get business debit cards with 0.5% cashback for you and your team to keep track of team expenses and spend all over the world, with real-time visibility and categorisation. See full cashback terms and conditions
  • 🏢 Manage cash in 55+ currencies across international offices from a single business account and move money between business accounts in seconds (exact speeds can vary depending on individual circumstances and may not be the same for all transactions)
  • 🧾 Connect and sync every business transaction to your favourite accounting software, including Xero, Quickbooks, and more
  • 🔐 Create your own payment approvals process to manage your team better with customised access for different team members, roles and permissions
  • 📑 Create custom professional invoices and schedule invoice payments for future dates
  • 📈 Earn variable returns on GBP, USD and EUR with Wise Interest (Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative.)
  • 🔗 Create payment links and QR codes to get paid easily (Card payment acceptance for new Wise Business customers is currently unavailable. Payment methods subject to eligibility and availability.)
  • ⚙️ Automate payouts with the Wise API (comes with 24/7 customer support, a sandbox account to test integrations, API tokens, and clear documents on how to implement and make the most of our API)

Make the wise choice when selecting a business account for your domestic and global needs.

Be Smart, Get Wise.

Register for Wise Business ✍️

FAQs

Does NetSuite run payroll directly?

NetSuite's built-in payroll module, SuitePeople U.S. Payroll, handles payroll for U.S. employees.3 For employees elsewhere, including the UK, Oracle describes the Paycheck Journal feature, which partners use to build international payroll solutions.2 UK teams typically run payroll in a separate provider and bring the results into NetSuite.

Can NetSuite reconcile payroll from multiple providers?

Yes, if each provider's output maps to the same accounts and dimensions. NetSuite can import journal entries from another system, including data by class, department, location, and subsidiary, so that every provider's file can follow a single template.8

What is a payroll journal entry?

A payroll journal entry is the accounting entry that records a pay run in the general ledger. It typically debits pay and employer cost accounts and credits liability and clearing accounts. In NetSuite OneWorld, a journal entry posts to a single subsidiary, and entries between subsidiaries use an intercompany journal entry.9

What is a payroll clearing account?

A payroll clearing account is a temporary account that holds payroll amounts between the date you post the journal entry and the date the funds leave the bank. Once you match each payment, the account should return to zero; any remaining amount indicates a missing payment, fee, or FX difference.

How should FX fees be recorded in NetSuite?

Post transfer fees and exchange differences to their own accounts rather than adding them to salary cost. Under IFRS, IAS 21 recognises exchange differences on the settlement of monetary items in profit or loss.10 A payment platform such as Wise Business shows the rate and fee before you confirm, which gives you both figures to post.

Can international contractor payments be included in payroll reporting?

They can appear in management reporting if the mapping keeps them separate from employee payroll. GOV.UK says the employee payroll steps apply to people with the employment status of 'employee', and that the rules differ for freelancers, consultants and contractors.1 Confirm each worker's status with your accountant.

Sources used in this article

  1. https://www.gov.uk/running-payroll
  2. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_N945815.html
  3. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_N969418.html
  4. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157358611227.html
  5. https://www.gov.uk/running-payroll/payslips
  6. https://www.gov.uk/running-payroll/deductions
  7. https://www.gov.uk/running-payroll/paying-hmrc
  8. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N418118.html
  9. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_163165275262.html
  10. https://www.iasplus.com/en/standards/ias/ias21
  11. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_4842302228.html
  12. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N261486.html
  13. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1471271.html

Sources last checked on 14th October 2026


*Please see terms of use and product availability for your region or visit Wise fees and pricing for the most up to date pricing and fee information.

This publication is provided for general information purposes and does not constitute legal, tax or other professional advice from Wise Payments Limited or its subsidiaries and its affiliates, and it is not intended as a substitute for obtaining advice from a financial advisor or any other professional.

We make no representations, warranties or guarantees, whether expressed or implied, that the content in the publication is accurate, complete or up to date.

Money without borders

Find out more

Tips, news and updates for your location