All-in-One Business CRM and Budget Tracker

• All-in-One Business Tracker – Manage income, expenses, customers, vendors, and budgets in one streamlined Google Sheet.
• Designed for Australian Businesses – Includes GST handling, AUD currency formatting, and commonly used payment methods in Australia.
• Ready-to-Use Dashboard – Automatic monthly and yearly summaries with easy-to-read charts.

💰 Income & Expense Tracking

• Record Transactions Easily – Capture date, description, category, customer/vendor, amount, GST, payment method, and status.
• Dropdown Selections for:
• Categories (Rent, Utilities, Salaries, Marketing, etc.)
• Payment Methods (Bank Transfer, EFTPOS, PayID, BPAY, Credit/Debit Card, PayPal, Stripe, Cash, Cheque, Gift Card)
• Payment Status (Paid, Pending, Overdue, Refunded)
• Built-in GST Calculation – Automatically calculates the GST amount.
• Profit & Loss View – Quick calculation of total income vs. expenses per month.

🧾 Customer & Vendor Management

• Customer Database Tab – Track client name, contact info, ABN (if applicable), industry, payment terms, and history.
• Vendor Database Tab – Record supplier details, payment terms, location, and country (dropdown with most common trade countries: AU, NZ, USA, China, India, UK, Singapore, EU).
• Linked Transactions – Easily filter or analyse transactions by customer or vendor.

📊 Automated Reports & Visuals

• Monthly Summary – Income vs. expenses bar charts, GST totals, net cashflow.
• Annual Summary – Yearly overview with line graph for revenue trends and pie chart for expense breakdown.
• Category Insights – Visualise which expense categories consume most of your budget.
• Customer & Vendor Analysis – Who your top-paying customers are, and where your biggest costs come from.

⚙️ Smart Formulas & Automation

• Dynamic Drop-Downs for consistency in data entry.
• SUMIFS & FILTER formulas for automatic monthly roll-ups.
• Conditional Formatting – Highlights overdue or pending invoices, late payments, and over-budget expenses.
• Net Profit Calculation – Auto-calculates monthly and annual profits after GST.

🌏 Australia-Ready

• Currency Pre-Set to AUD ($)
• Australian Payment Methods Included
• GST-Friendly Fields (10% default, adjustable)
• Common Vendor Countries Preloaded

🖥️ Ease of Use

• Welcome & Instructions Page – Step-by-step guide to set up and customise your tracker.
• Plug & Play Setup – Simply enter your transactions, customers, and vendors, and the dashboards update automatically.
• 100% Google Sheets – No subscriptions, works online or offline.
• Scalable – Suitable for freelancers, sole traders, and small businesses.

📦 What You’ll Get

• ✅ Fully functional Google Sheets file (ready to duplicate and use)
• ✅ Easy-to-follow setup instructions
• ✅ Pre-populated dropdowns and sample data for quick learning
• ✅ Lifetime access + updates (if new features are added)

🔥 This tracker is built to save time, cut admin headaches, and give you clear financial visibility all without expensive accounting software.