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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Leave A Comment