The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Title: Automatic Bookkeeping Workbook — Single-Entry Journal to Full Financial Statements
Description:
A lightweight, fully automated Excel bookkeeping template built around one core idea: type a transaction once, and every downstream report updates itself.
Unlike a full client engagement model, this is designed as a clean, reusable template — enter journal entries as balanced debit/credit lines on the one editable sheet, and the workbook handles the rest automatically:
1.One input sheet: Journal Entries is the only tab you type in — pick accounts from a dropdown, enter debit or credit amounts, and a built-in check column flags instantly if a line doesn't balance
2.Automated General Ledger: every account's full transaction history and running balance, generated without a single manual formula
3.Trial Balance with a live balance check
4.Financial statements: Income Statement, Balance Sheet (with automatic balance verification), and a direct-method Cash Flow Statement — all driven off a Cash Flow Category tag on cash transactions
5.Dashboard: auto-generated KPI snapshot (Total Assets, Liabilities, Equity, Net Income, Ending Cash) plus Revenue vs. Expenses and Operating Expense Mix charts
6.Color-coded design: blue for inputs, black for same-sheet formulas, green for cross-sheet links, grey for automated helper columns — so anyone opening the file immediately understands what's safe to edit
Built to show that solid double-entry bookkeeping logic can be made genuinely foolproof for a non-accountant user — no VBA, no macros, just clean formula architecture.
Skills demonstrated: Excel automation · Double-entry bookkeeping · Template design · Data validation · Financial statement preparation · Dashboard & chart design
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Title:
VAULT — Personal Finance & Wallet iOS UI
VAULT is a modern personal finance & wallet app designed for iOS, focused on making everyday money management simple, clear, and intuitive.
The complete UI includes:
• Overview / Home
• Transactions
• Transaction Details
• Budgets
• Analytics
• Profile & Settings
Designed in Figma with an iOS-first approach, clean layouts, clear financial data visualization, and a consistent mobile experience.
📱 iOS UI Design
🎨 Figma
💰 Personal Finance App
Transaction Details splits the payment record from the merchant card - status, card, transaction ID in one block, the store address in another. That separation is what makes a dispute resolvable.
Excel Data Entry & Financial Records
I provide accurate and organized Excel data entry and financial record management services.
✅ Excel data entry
✅ Financial records
✅ Data organization
✅ Expense & income tracking
✅ Basic reporting
If you need clean and organized financial data, feel free to contact me.
Excel PivotTable — Sales Summary
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
Structured the raw data into a proper table (consistent headers, currency formatting)
Built a PivotTable summarizing Sum of Sales by Last Name and Country
Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded
Checked every formula for errors before delivery
Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.
If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.
