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

> Send a general ledger or AP export to an auditor, consultant or software vendor without exposing vendor names or approvers. Mask in your browser, free.

Page: https://datautility.in/blog/share-general-ledger-export-without-vendor-and-employee-data
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-16 · Analyze & protect · mask general ledger data, anonymize vendor names excel, share accounting data safely, accounts payable export, anonymize excel file

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 tool: [Data Masking](https://datautility.in/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](https://datautility.in/mock-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](https://datautility.in/pii-detection-tool).

## Excel files

Most ledgers come as Excel. [Anonymize an Excel file](https://datautility.in/anonymize-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](https://datautility.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](https://datautility.in/data-masking-for-testing). This is not accounting, legal or compliance advice.

## 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.

## Related tool pages

- [Test Data Masking](https://datautility.in/data-masking-for-testing): 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](https://datautility.in/gdpr-safe-test-data): 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](https://datautility.in/mask-emails-in-csv): 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](https://datautility.in/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](https://datautility.in/mask-pii-in-excel): 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](https://datautility.in/mask-phone-numbers-in-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

- [Anonymize an Excel file](https://datautility.in/anonymize-excel-file)
- [Compare financial files and reconcile](https://datautility.in/blog/compare-financial-reports-reconciliation-files)
- [Data lineage for finance audit reports](https://datautility.in/blog/data-lineage-for-finance-audit-reports)
- [Test data masking](https://datautility.in/data-masking-for-testing)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
