Prepared a complete Trial Balance in Excel. Organized ledger accounts with balanced debit and credit totals, ensuring accuracy before financial statement preparation. Demonstrates core bookkeeping and accounting knowledge.
0
6
Developed an Accounts Receivable Aging Report. Categorized outstanding balances by aging periods (Current, 1–30, 31–60, 61–90, and 90+ days) to help monitor collections and improve cash flow management.
0
9
Created a monthly Profit & Loss Statement in Excel. Organized revenue, cost of sales, operating expenses, and net profit to provide a clear overview of business performance. Demonstrates financial reporting and bookkeeping skills for small businesses.
0
10
Prepared a complete bank reconciliation in Excel. Reconciled bank and book balances, identified outstanding deposits and cheques, recorded bank charges and interest, and ensured the adjusted balances matched accurately. Demonstrates strong bookkeeping and reconciliation skills applicable to QuickBooks Online and Xero.