Sample delivery: before and after
This is a complete LedgerReady delivery made from synthetic statements for a fictional design studio: 6 statements, 15 receipt photos and the files we send back. Every bank, business and number is made up; no real person's data is used.
The job
Juniper Lane Studio LLC is a fictional one-person design studio. Input: 3 monthly checking statements (running-balance layout), 3 monthly card statements, 15 receipt photos. Our pipeline read 216 transactions, reconciled 6 of 6 statements to the penny, matched 15 of 15 receipts and put 26 lines on the "please confirm" list (cheques, Venmo payments, likely-personal purchases).
Before


After

| Date | Account | Description (as on statement) | Amount | Category | Check |
|---|---|---|---|---|---|
| 2026-07-01 | Visa card | B&H PHOTO 800-606-6969 NY | -168.51 | Office Supplies & Equipment | ok |
| 2026-07-05 | Checking | CHECK #1957 | -285.03 | Uncategorised | please confirm |
| 2026-07-07 | Checking | MOBILE DEPOSIT REF 0974 | 964.94 | Sales / Income | ok |
| 2026-07-10 | Visa card | GOOGLE *WORKSPACE_JUNIPERL G.CO/HELPPAY# | -14.40 | Software & Subscriptions | ok |
| 2026-07-13 | Checking | WEWORK MEMBERSHIP PKBB59 | -350.00 | Rent | ok |
| 2026-07-18 | Visa card | FOREIGN TRANSACTION FEE | -2.90 | Bank & Merchant Fees | ok |
| 2026-07-22 | Visa card | UDEMY COURSE FVPRZG | -70.86 | Education & Training | ok |
| 2026-07-26 | Checking | VERIZON WRLS 3981 BILL PAY | -82.19 | Utilities, Phone & Internet | ok |
| 2026-08-03 | Checking | GUSTO CONTRACTOR PMT NFM5LJ | -1,089.24 | Contractors | ok |
| 2026-08-09 | Visa card | GOOGLE *WORKSPACE_JUNIPERL G.CO/HELPPAY# | -14.40 | Software & Subscriptions | ok |
| 2026-08-15 | Visa card | TRADER JOE S #3894 AUSTIN TX | -89.34 | Owner Draw / Personal | please confirm |
| 2026-08-25 | Visa card | STARBUCKS STORE 9318 AUSTIN TX | -7.20 | Meals | ok |
| 2026-09-05 | Checking | ONLINE TRANSFER TO SAV XXXX3859 | -601.08 | Transfer / Card Payment | ok |
| 2026-09-13 | Visa card | TRADER JOE S #0231 AUSTIN TX | -86.50 | Owner Draw / Personal | please confirm · receipt |
- Categorised ledger (Excel): Transactions, P&L summary, Reconciliation, Needs review, Receipts
- P&L summary (PDF)
- QuickBooks Online import CSV (checking)
- Xero precoded statement CSV (checking)
- Wave import CSV (checking)
The Xero account codes in the sample use Xero's demo chart; on a real job we use your own chart's codes.
Get a free 20-transaction sample See a before/after sample
Last updated · What changed