Download free Excel workbooks and master financial reporting with five fully-synthetic, audit-ready Finance & Accounting datasets—General Ledger, Accounts Payable, Accounts Receivable, Budget Forecast and Expense Claims. Each file mimics real-world workflows yet is 100 % dummy data, perfect for practicing PivotTables, Power Query, Power BI, variance analysis, ageing schedules and audit trails—no sign-ups, no compliance worries.

1. General Ledger Dataset

Two thousand balanced journal lines spanning revenue, COGS and expense accounts. Ideal for building trial balances, P&L statements and drill-down ledger explorers. Every entry includes department, cost center and multi-currency codes so you can practice segment reporting and currency conversions without touching a live ERP.

Finance and Accounting Data General Ledger Dataset

Columns Included:
GLID, TxnDate, AccountNumber, AccountName, Debit, Credit, Dept, CostCenter, Description, Currency

  • Create trial balance PivotTables.
  • Build department-level P&L dashboards.
  • Test multi-currency conversions.
  • Audit journal entries with Power Query.

Download General Ledger (.xlsx)

2. Accounts Payable Dataset

Eight hundred vendor invoices featuring due dates, currencies, payment status and terms. Use it to build ageing schedules, track cash-flow impact of payables or practice VLOOKUP joins with vendor master lists. Status flags let you highlight open versus paid liabilities in seconds.

Finance and Accounting Data Accounts Payable Dataset

Columns Included:
APID, Vendor, InvoiceDate, DueDate, Amount, Currency, Status, PaidDate, Terms

  • Create AP ageing buckets (30/60/90 days).
  • Analyse cash-flow requirements.
  • Match invoices to payments.
  • Graph top vendors by spend.

Download Accounts Payable (.xlsx)

3. Accounts Receivable Dataset

Nine hundred customer invoices with due dates and receipt status for practicing collection KPIs, DSO calculations and customer ageing reports. Pair it with the General Ledger to reconcile AR control accounts or build a cash-collection forecast.

Sample Finance and Accounting Data Accounts Receivable Dataset

Columns Included:
ARID, Customer, InvoiceDate, DueDate, Amount, Currency, Status, ReceivedDate, Terms

  • Compute Days Sales Outstanding (DSO).
  • Build AR ageing charts.
  • Reconcile AR to GL balances.
  • Highlight overdue invoices automatically.

Download Accounts Receivable (.xlsx)

4. Budget Forecast Dataset

This workbook holds quarterly budgets, forecasts and actuals for six departments across two fiscal years. Practise variance analysis, waterfall charts and rolling forecasts. Perfect for FP&A learners who need realistic numbers without sharing real financials.

Sample Finance and Accounting Data Budget Forecast Dataset

Columns Included:
FiscalYear, Dept, Quarter, BudgetUSD, ForecastUSD, ActualUSD, VarianceUSD, Notes

  • Visualize budget vs actual variances.
  • Create department KPI scorecards.
  • Build rolling-forecast formulas.
  • Analyze year-over-year growth.

Download Budget Forecast (.xlsx)

5. Expense Claims Dataset

One thousand employee claims for travel, meals and supplies with approval flows and multi-currency amounts. Practice conditional-format workflows, build dashboards for policy compliance or test Power Query merges with employee master data.

Sample Finance and Accounting Data Expense Claims Dataset

Columns Included:
ClaimID, EmployeeID, SubmitDate, Category, Description, Amount, Currency, Status, ApprovedBy, PayDate

  • Flag claims over policy limits.
  • Create approval funnel charts.
  • Analyse spend by category or employee.
  • Reconcile paid claims to GL postings.

Download Expense Claims (.xlsx)

Conclusion & Next Steps

Use these Finance & Accounting workbooks to build ageing schedules, P&L dashboards, variance waterfalls or audit-ready ledgers—risk-free. Bookmark this page and revisit each quarter for fresh numbers. Looking for other business functions? Head back to the Main Sample Data Library to explore HR, Sales, Manufacturing and more.