Share a General Ledger or AP Export Without Vendor and Employee Data

Auditors, consultants and software vendors often ask for a ledger export. It carries vendor names and the people who approved each entry. You can hide those and keep every number the other side needs.

Open the Data Masking

What a ledger export gives away

A general ledger or accounts payable export lists posting date, account, amount, vendor, cost center, approver and a memo line. The account codes and amounts are what a reviewer needs. The vendor names, approver names and free-text memos are what you may not want to hand over, because they show who you pay, how much and who signs off.

Try it on a sample ledger

In the Data Generator, choose Finance & insurance and pick General ledger. It has an entry id, posting date, account code, account name and type (they always match, for example 4000 is Sales revenue), vendor, amount, cost center, approver and memo. The values are random and fictional.

Keep, mask or remove

Keep: posting date, account code, account name, account type, amount and cost center. These make the file useful and are not personal. Mask: vendor with Replace with fake data (company) and approver with fake names, both consistent, so one vendor always maps to the same fake vendor and spend by vendor still adds up. Remove or check: the memo. Free text often holds invoice numbers, names and email addresses, so either remove it or run the PII detector.

Excel files

Most ledgers come as Excel. Anonymize an Excel file reads the first sheet of an .xlsx file, so move the data you need to the first sheet, and save older .xls files as .xlsx first. Masked output can be downloaded as Excel or CSV.

Prove the numbers did not change

Before you send, use a Group and summarize step in Data Transformation to total the amount by account on the original and on the masked file. The two tables must be identical. This takes a minute and is the check a reviewer will want to see.

Know what you are sharing

Masked vendor names can still be guessed from patterns, such as one very large payment each quarter. If that matters, share a smaller date range or an aggregate. Check your contract and company policy before sharing financial records outside the company. For the method behind each option, see test data masking. This is not accounting, legal or compliance advice.

Open the Data Masking

Related tool pages

  • Test Data Masking: Test data masking in your browser: hide emails, phones, names and card numbers in a production export and keep formats and joins. Free, no upload.
  • GDPR Test Data Generator: GDPR test data without real people: generate synthetic rows that follow the patterns of your own file, in your browser. Not legal advice.
  • Mask Emails in a CSV File: Hide email addresses and phone numbers in a CSV file before you share it. Detects personal columns for you. Free, in your browser.
  • Anonymize CSV Data: Anonymize a CSV before sharing it: hide names, emails, phones and card numbers with the method you choose. Free, in your browser.
  • Mask PII in Excel Files: Find and hide personal data in an Excel file before you share it, such as emails, phone numbers and names. Free, in your browser.
  • Mask Phone Numbers in a CSV: Hide phone numbers in a CSV, Excel or JSON file before you share it. Keep the country code or last digits, or replace with fake numbers. Runs in your browser.

Also try

How to use the Data Masking: step by step

  1. Open the ledger in Data Masking (or Anonymize an Excel file).
  2. Replace vendor and approver names with consistent fake ones.
  3. Remove or check the memo column.
  4. Total amounts by account before and after, then download.

When to use the Data Masking

  • Send an AP export to a software vendor to debug an import
  • Give an auditor a ledger without vendor names
  • Share a sample with a consultant
  • Test a reporting tool with realistic accounts

Example

Input: ada@example.com, +1 555 0100

Output: a**@example.com, +1 *** ****

Frequently asked questions

What should I keep in a ledger I share with an auditor?

Keep dates, account codes, account names, amounts and cost centers. Mask vendors and approvers, and remove or check free-text memos.

Will masking vendor names break my spend analysis?

Not with consistent masking. The same vendor always gets the same fake name, so totals and counts by vendor stay correct.

Does it work on .xlsx files?

Yes, on the first sheet of an .xlsx file. Move the data you need to the first sheet first, and convert old .xls files to .xlsx.

Tip: Use consistent masking so a vendor keeps the same fake name throughout the file. Spend-by-vendor analysis then still works.