Skip to content

Aurevia Group

Work Samples

A selection of the schedules, reconciliations and reports we prepare. Every sample here is fictional and shown for format only.

Illustrative Samples — Not Actual Client Data. All names and figures below are invented. Genuine client work will only be shown with the client’s written authorisation.

Reconciliations

Bank and card statements matched to the ledger.

Ledgers & Ageing

Ledger extracts and receivables ageing.

Financial Reports

Trial balance, P&L, balance sheet and cash flow.

Excel Tools

Reusable templates and workbook structure.

Bank Reconciliation

Fictional business · Operating account · 30 Sep

Illustrative Sample

Item	Amount (USD)
Balance per bank statement	48,250.00
Add: deposits in transit (2 items)	3,400.00
Less: outstanding cheques (3 items)	(2,150.00)
Adjusted bank balance	49,500.00
Balance per general ledger	49,500.00
Unreconciled difference	0.00

Preparer’s notes: All reconciling items cleared by the following statement date. No unexplained differences remain.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Credit Card Reconciliation

Business credit card · 30 September

Illustrative Sample

Item	Amount (USD)
Balance per card statement	3,860.40
Add: purchases not yet on statement	412.60
Less: payment sent, not yet credited	(1,500.00)
Adjusted card balance	2,773.00
Balance per general ledger	2,773.00
Unreconciled difference	0.00

Preparer’s notes: Two purchases were coded to the correct expense accounts during review. Payment expected to appear next cycle.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

General Ledger Extract

Account 1000 · Cash at bank · September

Illustrative Sample

Date	Description	Debit	Credit	Balance
01 Sep	Opening balance			40,809.00
05 Sep	Invoice INV-1001 · Client A	5,500.00		46,309.00
09 Sep	Software subscription		89.00	46,220.00
12 Sep	Office supplies		420.00	45,800.00
20 Sep	Receipt INV-1001 · Client A	5,500.00		51,300.00
28 Sep	Contractor payment		1,800.00	49,500.00
	Closing balance	11,000.00	2,309.00	49,500.00

Preparer’s notes: Each entry carries a reference to its source document. Running balance is recalculated after every posting.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Accounts Receivable Ageing

As at 30 September · by customer

Illustrative Sample

Customer	Current	1–30	31–60	61–90	Total
Client A	4,000	2,500	–	–	6,500
Client B	3,200	2,000	1,400	–	6,600
Client C	2,000	–	1,500	1,600	5,100
Total	9,200	4,500	2,900	1,600	18,200

Preparer’s notes: Total agrees to the receivables balance in the trial balance. Items over 60 days flagged for follow-up.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Trial Balance

As at 30 September · all accounts

Illustrative Sample

Account	Debit	Credit
Cash at bank	49,500
Accounts receivable	18,200
Accounts payable		9,750
Owner’s equity		40,000
Sales revenue		62,400
Cost of services	21,000
Operating expenses	23,450
Total	112,150	112,150

Preparer’s notes: Debits equal credits. Used as the starting point for the profit and loss statement and balance sheet.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Profit & Loss Statement

Month ended 30 September

Illustrative Sample

Line	Amount (USD)
Sales revenue	62,400
Cost of services	(21,000)
Gross profit	41,400
Operating expenses	(23,450)
Net profit	17,950
Gross margin	66.3%
Net margin	28.8%

Preparer’s notes: Figures agree to the trial balance. Margins shown for management review.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Balance Sheet

As at 30 September

Illustrative Sample

Line	Amount (USD)
Cash at bank	49,500
Accounts receivable	18,200
Total assets	67,700
Accounts payable	9,750
Total liabilities	9,750
Owner’s equity	40,000
Current period profit	17,950
Total equity	57,950
Total liabilities and equity	67,700

Preparer’s notes: Assets equal liabilities plus equity. Current period profit carried from the profit and loss statement.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Cash-Flow Summary

Month ended 30 September · indirect method

Illustrative Sample

Line	Amount (USD)
Net profit	17,950
Increase in accounts receivable	(8,200)
Increase in accounts payable	3,750
Net cash from operations	13,500
Owner capital introduced	14,000
Net change in cash	27,500
Opening cash	22,000
Closing cash	49,500

Preparer’s notes: Closing cash agrees to the reconciled bank balance and the balance sheet.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Excel Reconciliation Template

Reusable workbook layout · structure only

Illustrative Sample

Sheet	Purpose
Instructions	How to complete the workbook and what each column means
Bank Data	Imported statement lines, one row per transaction
Ledger Data	Matching ledger entries for the same period
Match	Formula-driven matching with status flags (Matched / Unmatched)
Summary	Reconciliation summary and reviewer sign-off block

Preparer’s notes: Shown as a layout description. Built to be adapted to a client’s own chart of accounts.

Illustrative Sample — Not Actual Client Data. Fictional figures, shown for format only.

Let’s Bring Clarity to Your Numbers.

Tell us about your business and the support you need. We’ll respond with a clear, practical way forward.

WhatsApp Us Email Us Send an Inquiry