NeatSum user guide
Your complete guide to managing your business finances with confidence.
For: Accountants, Bookkeepers, Small Business Owners, and Anyone New to Accounting Software
Getting Started
What Is NeatSum?
NeatSum is an online accounting platform that helps you manage your business finances -- from raising invoices and tracking expenses to running payroll and generating financial reports. Think of it as your digital bookkeeper that keeps everything organised and up to date.
Whether you run a freelance operation, a growing small business, or manage accounts for multiple clients, NeatSum gives you the tools to stay on top of your money.
Who Is It For?
- Small business owners who want to track income, expenses, and profitability without hiring a full-time accountant
- Bookkeepers and accountants who manage finances for one or more businesses
- Freelancers and sole traders who need to invoice clients and track expenses
- Teams that need collaborative access to the same set of books
Key Benefits
All-in-one platform
Invoicing, bills, payments, payroll, inventory, fixed assets, bank reconciliation, and reports in one place
Double-entry accounting
Your books are always balanced, giving you accurate and trustworthy financial data
Multi-company support
Manage multiple businesses from a single login
Team collaboration
Invite your bookkeeper, accountant or staff with the access each needs (up to 10 people per company on Pro, no limit on Enterprise)
AI-powered assistance
Automatic transaction categorisation, a nightly check that flags unusual transactions for review, and a chat assistant that answers financial questions in plain language
Australian GST and BAS
GST on every transaction, and your GST and BAS figures calculated from the ledger for you to review, ready to lodge through the ATO's Online services for business or your tax agent
Real-time reporting
Profit & Loss, Balance Sheet, Cash Flow, and more -- always up to date
Creating Your Account
- 1Visit the NeatSum sign-up page
- 2Enter your name, email address, and create a password
- 3Verify your email address
- 4You are now logged in and ready to set up your first company
Setting Up Your First Company
After signing up, you need to create a company. This is where all your financial data lives.
Choose Set up my company on the welcome screen (to add another company later, use New company). The setup wizard has seven steps:
- 1Industry: select the closest match
- 2Structure: sole trader, partnership, company, trust, charity or non-profit, or other
- 3Identity: your business name, and your ABN (optional)
- 4Financial year: the month and day your financial year starts (1 July for most Australian businesses)
- 5GST: whether you are registered for GST and, if you are, how often you report (monthly, quarterly or annually) and on what basis (accrual or cash)
- 6Contact: address, phone and email, all optional
- 7Review: check the details, then click Create Company
Everything is recorded in Australian dollars; there is no currency to choose.
When you create a company, NeatSum automatically sets up a default Chart of Accounts -- a pre-built list of about 48 accounts covering common categories like bank accounts, revenue, expenses, and tax. You can customise these later.
Navigating the App
The menu on the left is organised by job. Each name opens a panel with its pages; on a phone, the bar at the bottom has Home, Sales, Purchases, Banking and More.
| Menu | What you'll find |
|---|---|
| Home | Dashboard, Approvals, AI suggestions to review, Notifications and this guide |
| Sales | Invoices, Quotes & orders, Credit notes, Repeating invoices & bills, Customer payments, Customer deposits, Products & services, Invoice reminders |
| Purchases | Bills, Purchase orders, Supplier credit notes, Supplier payments, Batch payments, Expense claims, Receipts inbox |
| Banking | Bank accounts (reconcile), Bank feeds, Import statement, Receive money, Spend money, Transfer money, Bank rules, Reconciliation history |
| Contacts | All contacts, Customers, Suppliers |
| Accounting | Chart of accounts, Manual journals, Posted transactions, Lock dates & periods, Currencies |
| Tax | GST & BAS, Tax rates |
| Reports | All reports, Profit and loss, Balance sheet, Cash flow, Trial balance, General ledger, Aged receivables and payables, Statements, Budgets, Scheduled reports |
| Payroll, Fixed assets, Inventory, Projects | Each module's pages, reports and settings (shown with a Pro badge if your plan does not include them) |
| Settings (bottom of the menu) | Company settings, Document numbering, Online payments (Stripe), Approval rules, Import data, Team (users & roles), Audit trail, AI activity log, Billing, and every module's settings |
Create anything: the + New button at the top of every page lists everything you can create: invoice, bill, quote, journal, contact and more.
Search: press Ctrl+K (or click Search) to jump to any page, contact, invoice or bill. Old menu names still work, so "Purchase invoices" finds Bills and "Pipeline" finds Quotes & orders.
Your account: click your initials (bottom of the menu, or top right) for your profile and sign-in security, your companies, billing and the tour.
Core Concepts -- Accounting Made Simple
Before you start entering transactions, let's cover the basics. Even if you are new to accounting, these concepts are straightforward once you see how they work.
What Is an Account?
An account is a bucket that tracks a specific type of money. Just like you might have separate envelopes for rent, groceries, and savings, accounting uses "accounts" to categorise where money comes from and where it goes.
Examples of accounts:
- "Bank Account" -- tracks how much cash you have in the bank
- "Sales Revenue" -- tracks how much money you have earned from selling
- "Rent Expense" -- tracks how much you have spent on rent
- "Accounts Receivable" -- tracks money customers owe you
The Seven Account Categories
Every account in NeatSum falls into one of seven categories:
| # | Category | What It Tracks | Example |
|---|---|---|---|
| 1 | Assets | Things you own or are owed | Bank account, equipment, money customers owe you |
| 2 | Liabilities | Things you owe others | Loans, credit cards, money you owe suppliers |
| 3 | Equity | The owner's stake in the business | Owner's capital, retained earnings |
| 4 | Income | Money earned | Sales revenue, interest income, service fees |
| 5 | Expenses | Money spent to operate | Rent, salaries, office supplies, advertising |
| 6 | Contra-Asset | Reduces an asset's value | Accumulated depreciation (reduces equipment value over time) |
| 7 | Tax | Tax collected or payable | GST collected, GST paid |
What Is the Chart of Accounts?
The Chart of Accounts (COA) is the complete list of all accounts in your business. It is the backbone of your accounting system -- every transaction you record is categorised using accounts from this list.
Think of it as your financial filing cabinet. Each drawer (category) holds folders (accounts) that organise every dollar flowing through your business.
What Are Debits and Credits?
This is where most people get confused, but it is simpler than it sounds.
Every transaction in accounting has two sides -- a debit and a credit. They must always be equal. This is called double-entry accounting, and it is what keeps your books balanced.
Here is the simple rule:
| Account Type | Debit (left side) | Credit (right side) |
|---|---|---|
| Assets | Increases | Decreases |
| Expenses | Increases | Decreases |
| Liabilities | Decreases | Increases |
| Income | Decreases | Increases |
| Equity | Decreases | Increases |
Real-world example: You receive $1,000 from a customer for a completed project.
| Account | Debit | Credit |
|---|---|---|
| Bank Account (Asset) | $1,000 | |
| Sales Revenue (Income) | $1,000 |
Your bank goes up by $1,000 (debit to an asset). Your revenue goes up by $1,000 (credit to income). Both sides equal $1,000 -- the books are balanced.
What Is a Journal Entry?
A journal entry is the formal record of a financial transaction. It lists which accounts are affected and by how much.
When you create an invoice or record a payment in NeatSum, the system creates journal entries behind the scenes. You can also create manual journal entries for adjustments, corrections, or transactions that do not fit standard workflows (like recording depreciation or writing off bad debt).
What Is a Transaction?
A transaction is any financial event that affects your accounts. In NeatSum, transactions include:
- Invoices you send to customers
- Bills you receive from suppliers
- Payments made or received
- Journal entries
- Bank transfers
- Expense claims
Every transaction creates ledger entries that update your account balances and flow into your financial reports.
How Money Flows Through the System
Here is the big picture:
You do business
|
v
Record it (invoice, bill, payment, journal entry)
|
v
NeatSum creates ledger entries (debits and credits)
|
v
Account balances update automatically
|
v
Reports reflect the current state of your businessEverything is connected. When you create a sale invoice, your Accounts Receivable goes up. When the customer pays, Accounts Receivable goes down and your Bank Account goes up. Your Profit & Loss and Balance Sheet always reflect the latest data.
Chart of Accounts
Why It Matters
Your Chart of Accounts is the foundation of your accounting system. A well-organised COA makes it easy to:
- Track where your money is going
- Generate meaningful reports
- Prepare accurate tax returns
- Compare performance across periods
Viewing Your Accounts
- 1Navigate to Accounting > Chart of accounts
- 2You will see all your accounts grouped by category (Assets, Liabilities, Equity, Income, Expenses, etc.)
- 3Each account shows its code, name, type, and current balance
- 4Use the expand/collapse arrows to see parent-child account hierarchies
- 5Use the search bar at the top to quickly find a specific account
Creating a New Account
- 1Click Add account (or the "+" button)
- 2Fill in the details:
- Account Name -- A clear, descriptive name (e.g., "Office Supplies")
- Account Code -- A unique number for organising accounts (e.g., 5100)
- Category -- Select the type: Asset, Liability, Equity, Income, Expense, Contra-Asset, or Tax
- Account Type -- The specific sub-type within the category (e.g., under Assets: "Current Asset" or "Fixed Asset")
- Parent Account (optional) -- If this is a sub-account, select the parent account
- Description (optional) -- A note about what this account is used for - 3Click Save
Editing an Account
- 1Find the account in your Chart of Accounts
- 2Click the Edit icon next to the account
- 3Update the name, description, or other details
- 4Click Save
Archiving and Deleting Accounts
- Archive: If you no longer use an account but it has historical transactions, archive it instead of deleting. This hides it from active lists but preserves the data. Click the archive icon next to the account.
- Delete: You can only delete an account if it has no transactions linked to it. Click the delete icon and confirm.
Structuring Parent and Child Accounts
Parent-child relationships let you group related accounts for clearer reporting.
Example:
5000 - Operating Expenses (parent)
5100 - Office Supplies (child)
5200 - Rent (child)
5300 - Utilities (child)When you view reports, the parent account shows the combined total of all its children. This gives you both a summary view and the ability to drill down into details.
To create a child account, simply select the parent account when creating or editing.
Best Practices
- Use consistent naming -- Pick a style and stick with it (e.g., "Office Supplies" not "supplies - office" in one place and "Office Supply Expense" in another)
- Use meaningful account codes -- Group related accounts with similar numbering (1000s for assets, 2000s for liabilities, 3000s for equity, 4000s for income, 5000s for expenses)
- Don't over-create accounts -- You do not need a separate account for every minor expense. Group similar items together (e.g., "Office Expenses" instead of separate accounts for pens, paper, and envelopes)
- Do use sub-accounts for detail -- If you need more granularity, create child accounts under a parent rather than cluttering the top level
- Review periodically -- Archive accounts you no longer use to keep your COA clean
Contacts -- Customers and Suppliers
Contacts are the people and businesses you do business with. NeatSum tracks both customers (people who pay you) and suppliers (people you pay).
Viewing Contacts
- 1Navigate to Contacts > All contacts
- 2You will see a list of all contacts with their name, type (customer/supplier), email, phone, and balance
- 3Use the search bar to find a specific contact
- 4Use filters to view only customers or only suppliers
Adding a Contact
- 1Click Add contact
- 2Fill in the details:
- Name -- Business or individual name
- Contact Type -- Customer, Supplier, or Both
- Email and Phone
- Billing Address -- Used on invoices
- Shipping Address (optional) -- If different from billing
- Tax ID / ABN (optional)
- Credit Limit (optional) -- Set a maximum outstanding balance - 3Click Save
Editing and Deleting Contacts
- Click on a contact to view their full profile, including all invoices, payments, and transaction history
- Click Edit to update their details
- Click Delete to remove a contact (only possible if they have no linked transactions)
Useful Contact Features
- Duplicate Detection: NeatSum can identify potential duplicate contacts. Look for the duplicate check option to merge records.
- Merge Contacts: If you accidentally created two records for the same contact, you can merge them into one, combining all their transaction history.
- Export/Import: Export your contacts to CSV or import contacts from a CSV file for bulk setup.
- Credit Check: Before creating a large invoice, you can check if a customer is near their credit limit.
- Audit History: View a log of all changes made to a contact record.
Items and Products
Items are the products and services you sell or purchase. Setting up items saves you time when creating invoices and bills -- instead of typing details each time, you select from your item list.
Creating an Item
- 1Navigate to Sales > Products & services
- 2Click Add item
- 3Fill in:
- Item Code -- A short reference code (e.g., "WIDGET-001")
- Name -- Descriptive name (e.g., "Standard Widget")
- Description -- What the item is
- Selling Price -- Your standard sale price
- Purchase Price -- What you pay for it
- Tax Rate -- Default tax to apply
- Income Account -- Which account to record sales to (e.g., Sales Revenue)
- Expense Account -- Which account to record costs to (e.g., Cost of Goods Sold)
- Track Inventory (optional) -- Enable to track stock levels - 4Click Save
Managing Items
- Edit items to update pricing or details
- Delete items that are no longer needed (if not linked to existing transactions)
- View items with their current stock levels and values when inventory tracking is enabled
Sales -- Quotes, Orders, and Invoices
NeatSum supports a complete sales workflow from initial quote to final payment. You can use the full pipeline or skip directly to invoicing -- whatever fits your business.
The Sales Pipeline
Quote (optional) --> Sales Order (optional) --> Invoice --> PaymentSales Quotes
A quote is a proposal you send to a potential customer. It is not a financial commitment -- no accounting entries are created until it becomes an invoice.
Creating a Quote:
- 1Navigate to Sales > Quotes & orders, then New (or + New > New quote)
- 2Select Quote
- 3Choose the Customer
- 4Add line items -- select items or type custom descriptions with quantities and prices
- 5Set an expiry date -- how long the quote is valid
- 6Click Save (as draft) or Send to the customer
Quote Statuses: Draft, Sent, Accepted, Declined, Expired, Converted
When a customer accepts, you can convert the quote to a Sales Order or directly to an Invoice with one click.
Sales Orders
A sales order is a confirmed commitment from a customer. It helps you track what has been ordered versus what has been invoiced and delivered.
Creating a Sales Order:
- 1Convert from an accepted quote, or create one directly
- 2Fill in customer, items, quantities, and pricing
- 3Save or confirm the order
Order Statuses: Draft, Confirmed, Partially Invoiced, Fully Invoiced
You can generate invoices from a sales order -- either for the full amount or partial amounts as you deliver.
Sale Invoices
An invoice is a formal request for payment. When you create an invoice, NeatSum records the accounting entries automatically:
- Accounts Receivable increases (the customer owes you money)
- Revenue increases (you have earned income)
Creating an Invoice:
- 1Navigate to Sales > Invoices
- 2Click Create invoice
- 3Select the Customer
- 4Set the Invoice Date and Due Date
- 5Add line items:
- Select from your items list, or type a custom line
- Set quantity, unit price, and tax rate for each line - 6Review the subtotal, tax, and total
- 7Click Save or Approve
Invoice Statuses: Pending, Unpaid, Partially Paid, Paid
Additional Actions:
- Print/Export as PDF -- Generate a professional PDF to email or print
- Email -- Where emailing is turned on for your company, send the invoice to your customer from NeatSum with the PDF attached (see the question "Can I send invoices to customers from NeatSum?" below)
- Create a Credit Note -- If you need to issue a refund or adjustment
Credit Notes
A credit note reduces the amount a customer owes. Use it for returns, discounts, or billing corrections.
Creating a Credit Note:
- 1Navigate to Sales > Credit notes
- 2Click Create Credit Note
- 3Select the customer and reference the original invoice
- 4Enter the items and amounts being credited
- 5Save
The credit note reduces the Accounts Receivable balance. You can allocate it against outstanding invoices.
Purchases -- Bills and Purchase Orders
Just as invoices track what customers owe you, bills (purchase invoices) track what you owe suppliers.
Purchase Orders
A purchase order (PO) is a formal request to a supplier for goods or services. It helps you track what you have ordered and manage receiving.
Creating a Purchase Order:
- 1Navigate to Purchases > Purchase orders
- 2Click Create Purchase Order
- 3Select the Supplier
- 4Add line items with quantities and prices
- 5Save or send to the supplier
PO Statuses: Draft, Pending Approval, Approved, Sent, Partially Received, Received, Cancelled
When goods arrive, you record a Goods Receipt to track what was delivered versus what was ordered. This feeds into the three-way matching system (more on this below).
Purchase Invoices (Bills)
When you receive a bill from a supplier:
- 1Navigate to Purchases > Bills
- 2Click Create purchase invoice
- 3Select the Supplier
- 4Enter the invoice date and due date
- 5Add line items with amounts and tax rates
- 6Save
This creates accounting entries:
- Expenses (or the relevant account) increases
- Accounts Payable increases (you owe the supplier)
Three-Way Matching
For businesses that use purchase orders, NeatSum offers three-way matching to verify that:
- 1What you ordered (Purchase Order)
- 2What you received (Goods Receipt)
- 3What you were billed (Purchase Invoice)
all agree. If there are discrepancies, the system flags them for review. This prevents you from overpaying or paying for goods you did not receive.
Supplier Credit Notes
A supplier credit note is the purchase-side equivalent of a credit note. Use it when a supplier owes you money (e.g., returned goods or a billing error).
- 1Navigate to Purchases > Supplier credit notes
- 2Create a supplier credit note referencing the original purchase invoice
- 3The system reduces your Accounts Payable balance
Payments -- Money In and Money Out
Incoming Payments (Money You Receive)
When a customer pays an invoice:
- 1Navigate to Sales > Customer payments
- 2Click Record payment
- 3Select the Customer
- 4Choose the invoices to apply the payment to (you can split a single payment across multiple invoices)
- 5Enter the amount, date, and payment method
- 6Save
This creates entries:
- Bank Account increases (you received cash)
- Accounts Receivable decreases (the customer no longer owes you)
Summary cards at the top of the page show total received, payments this month, and payment count.
Outgoing Payments (Money You Pay)
When you pay a supplier:
- 1Navigate to Purchases > Supplier payments
- 2Click Record payment
- 3Select the Supplier
- 4Choose the bills to apply the payment to
- 5Enter the amount, date, and payment method
- 6Save
This creates entries:
- Accounts Payable decreases (you no longer owe the supplier)
- Bank Account decreases (cash went out)
Batch Payments
Need to pay multiple suppliers at once? Batch payments let you group several outgoing payments into a single batch:
- 1Navigate to Purchases > Batch payments
- 2Select multiple outstanding bills
- 3Process them together
- 4One record, multiple payments handled
Receive Money and Spend Money
Not all money movements are tied to invoices. For standalone transactions:
- Receive Money -- Use for one-off income that is not linked to an invoice and not a customer prepayment (e.g., interest income, a refund from a vendor). For prepayments from customers, use the dedicated Customer Deposits feature below.
- Spend Money -- Use for expenses not tied to a specific bill (e.g., bank fees, petty cash purchases, subscriptions)
These are recorded directly to the accounts you choose, without going through the invoicing workflow.
Customer Deposits
When a customer pays you before you've raised an invoice -- a booking deposit, a security bond, an advance against a future order -- the money is not income yet. You owe them either goods, services, or a refund. Until the matching invoice is issued, the prepayment lives on the Balance Sheet as a liability, not on the P&L as revenue.
Customer Deposits is the dedicated screen for these prepayments. Each deposit you record:
- 1Posts a journal: Dr Bank / Cr 2520 Customer Deposits (a seeded liability account, system key
CUSTOMER_DEPOSIT_LIABILITY). - 2Tracks status -- Open, FullyReleased, or Voided -- on the deposit detail page.
- 3Lets you build a Deferred Revenue Schedule that releases the liability into income over time -- straight-line monthly, quarterly, annually, or on custom dates -- without raising any invoice. Each release posts Dr 2520 Customer Deposits / Cr [Revenue account] automatically.
- 4Can be voided while still Open (no releases yet); voiding posts the reverse journal and cancels any pending schedule installments.
Open the detail page at /app/customer-deposits/:id to see the original deposit journal, the schedule (if any), the release history, and the void action.
Journal Entries
What They Are
A journal entry is the most fundamental way to record a financial transaction. It directly specifies which accounts to debit and which to credit.
Most of the time, NeatSum creates journal entries automatically when you create invoices, record payments, or enter bills. Manual journal entries are for situations that don't fit those standard workflows.
When to Use Manual Journal Entries
- Adjustments -- Correcting a misclassification or error
- Depreciation -- Recording monthly asset depreciation
- Accruals -- Recognising expenses incurred but not yet billed
- Write-offs -- Writing off bad debt
- Opening balances -- Entering account balances when you first start using NeatSum
- Transfers between accounts -- Moving money between bank accounts (when Banking > Transfer money is turned on for your company, use that instead) or making internal allocations
How to Create a Journal Entry
- 1Navigate to Accounting > Manual journals
- 2Click Create Journal Entry
- 3Fill in:
- Date -- When the transaction occurred
- Reference -- A short identifier (e.g., "JE-001" or "Rent Mar 2026")
- Description -- Explain what this entry is for - 4Add lines:
- Each line needs an Account, Description, and either a Debit or Credit amount
- The total debits must equal the total credits -- NeatSum will warn you if they do not balance - 5Click Save
Step-by-Step Example: Recording a Rent Payment
You pay $2,000 rent by bank transfer on March 1.
| Line | Account | Debit | Credit |
|---|---|---|---|
| 1 | Rent Expense | $2,000 | |
| 2 | Bank Account | $2,000 |
What this means:
- Rent Expense goes up by $2,000 (you spent money on rent)
- Bank Account goes down by $2,000 (cash left your bank)
Step-by-Step Example: Recording a Cash Sale
A customer pays you $500 cash for a consulting session.
| Line | Account | Debit | Credit |
|---|---|---|---|
| 1 | Cash on Hand | $500 | |
| 2 | Consulting Revenue | $500 |
What this means:
- Cash on Hand increases (you have more cash)
- Revenue increases (you earned income)
Viewing Journal Entries
- The journal entries list shows all entries with date, reference, and description
- Filter by type (Manual or Reversal) using the tabs
- Search by description or reference number
- Click any entry to see its full details and the accounts affected
Expense Claims
Expense claims let employees submit business expenses for reimbursement. This is useful for travel, meals, office supplies, or any out-of-pocket business spending.
Submitting an Expense Claim
- 1Navigate to Purchases > Expense claims
- 2Click New claim
- 3Fill in:
- Claim Reference -- A unique identifier
- Description -- What the expense is for
- Line Items -- Each expense item with amount, category, and description
- Attachments -- Upload receipts (optional but recommended) - 4Submit the claim
Claim Status Workflow
Draft --> Submitted --> Approved --> Paid- Draft -- Saved but not yet submitted
- Submitted -- Awaiting manager approval
- Approved -- Approved and ready for payment
- Paid -- Reimbursement processed
Use the status tabs to filter claims by their current stage.
Recurring Transactions
If you have transactions that repeat on a regular schedule -- monthly rent, weekly supplier payments, or periodic invoices -- you can automate them with recurring templates.
Setting Up a Recurring Transaction
- 1Navigate to Sales > Repeating invoices & bills
- 2Click Create Recurring Template
- 3Choose the type: Invoice, Bill, or Journal Entry
- 4Fill in the transaction details (customer/supplier, line items, amounts)
- 5Set the frequency: Daily, Weekly, Fortnightly, Monthly, Quarterly, or Yearly
- 6Set the start date and optionally an end date
- 7Save
Managing Recurring Transactions
- Pause/Resume -- Temporarily stop a recurring template without deleting it
- Generate Next -- Manually trigger the next occurrence
- View Execution History -- See all past instances that were generated
- Statistics -- View how many active templates you have and their total monthly value
Recurring transactions are automatically generated daily at 6:00 AM UTC. You will find the generated transactions in their respective sections (invoices, bills, etc.).
Inventory Management
If you sell physical products, NeatSum can track your stock levels, movements, and value.
Inventory Dashboard
Navigate to Inventory > Overview to see:
- Total items tracked
- Total stock value
- Quantities on hand
- Top-selling items
- Low stock alerts
- Recent stock movements
Managing Inventory Items
- 1Navigate to Inventory > Stock items
- 2Add items with stock tracking enabled
- 3Set minimum stock levels to get alerts when inventory is low
Stock Movements
Every time stock changes, NeatSum records a stock movement. Types include:
- Purchase Receipt -- Stock added from a supplier delivery
- Sale -- Stock reduced from a customer sale
- Adjustment -- Manual correction to stock levels
- Transfer -- A movement recorded as a transfer. Stock on hand is kept per item, not per location, so a transfer does not move stock from one location to another
- Write-off -- Removing damaged or obsolete stock
- Opening -- Initial stock balance
To manually adjust stock:
- 1Navigate to Inventory > Stock movements
- 2Click Adjust stock
- 3Select the item, enter the new quantity, and provide a reason
Inventory Locations
You can list the warehouses or other places you keep stock under Inventory Settings, and give each item a default location. Stock on hand is tracked per item, not per location: NeatSum does not yet hold separate stock levels at each location or move stock between them.
Fixed Assets and Depreciation
Fixed assets are long-term items your business owns -- equipment, vehicles, furniture, computers. Over time, these lose value, and accounting tracks this through depreciation.
Adding a Fixed Asset
- 1Navigate to Fixed assets > Assets
- 2Click Add Asset
- 3Fill in:
- Asset Name -- e.g., "Office Laptop"
- Asset Code -- A unique identifier
- Purchase Date -- When you bought it
- Purchase Cost -- How much it cost
- Useful Life -- How long it will last (in years)
- Depreciation Method -- How to calculate the decline in value (e.g., Straight Line, Diminishing Value)
- Residual Value -- Expected value at the end of its useful life - 4Save
How Depreciation Works
Depreciation spreads the cost of an asset over its useful life. Instead of recording the full cost as an expense on the day you buy it, a portion is expensed each month.
Example: You buy a $12,000 piece of equipment with a 5-year useful life and $0 residual value, using straight-line depreciation.
- Annual depreciation = $12,000 / 5 = $2,400
- Monthly depreciation = $200
Each month, NeatSum records:
- Debit: Depreciation Expense ($200)
- Credit: Accumulated Depreciation ($200)
The asset's net book value decreases from $12,000 toward $0 over the 5 years.
Applying Depreciation
NeatSum calculates depreciation automatically. On the 1st of each month, you'll see a prompt to review and apply the month's depreciation entries.
- 1Review the proposed depreciation amounts
- 2Confirm to apply them
- 3The entries post to your ledger
You can also view the Asset Register Report showing all assets with their cost, accumulated depreciation, and current net book value.
Disposing of an Asset
When you sell or retire an asset, mark it as disposed and record the disposal date and any proceeds. NeatSum calculates the gain or loss on disposal.
Bank Reconciliation
Bank reconciliation is the process of matching your accounting records with your actual bank statements. This ensures that what you have recorded in NeatSum matches what actually happened in your bank account.
Why Reconcile?
- Catch errors or missing transactions
- Detect unauthorized transactions
- Ensure your books are accurate
- Build confidence in your financial reports
Setting Up Bank Accounts
- 1Navigate to Banking > Bank accounts
- 2Click Add bank account
- 3Enter:
- Account Name -- e.g., "Business Checking"
- Account Number and BSB
- Account Type -- Checking, Savings, Credit Card, etc.
- Opening Balance -- The balance on the date you start tracking
Importing Bank Statements
- 1Navigate to Banking > Import statement
- 2Choose the bank account, then upload the CSV, OFX or QFX file your bank exports, as it is. For a CSV, NeatSum works out the columns (date, description, reference, and one signed amount or separate debit and credit columns) and shows a preview; change any column it got wrong. An OFX or QFX file needs no columns, and each transaction's bank id means a re-imported line is always recognised
- 3Any row it can't read (a date or amount it can't understand) is listed by row number, and nothing is imported until it is fixed
- 4Lines already on the account (same date, amount and description) are flagged and skipped unless you tick them
- 5Check the opening and closing balances, then import. The transactions are ready for matching
To take a mistaken import back out, delete the statement under Statements on this account on the same screen (only while none of its lines is matched). On the reconciliation screen, Exclude takes a single line out of the reconciliation, and the Excluded filter lets you restore it.
Reconciling Transactions
- 1Navigate to Banking > Bank accounts
- 2Select the bank account to reconcile
- 3For each bank statement line, match it to a corresponding transaction in NeatSum:
- Auto-match -- The system suggests matches based on date, amount, and description
- Manual match -- Select the correct transaction yourself
- Create new -- If no matching transaction exists, create one directly - 4When all items are matched and the balance agrees, complete the reconciliation
Matching Rules
Set up rules to automatically match recurring bank transactions:
- 1Navigate to Banking > Bank rules
- 2Create rules based on patterns (e.g., "Any transaction with description containing 'RENT' should match to Rent Expense")
- 3Enable or disable rules as needed
Reconciliation Dashboard
The dashboard shows:
- Reconciled vs. unreconciled amounts per account
- Days since last reconciliation
- Book balance vs. bank balance comparison chart
Payroll
NeatSum includes a payroll module to manage employees, process pay runs, and handle leave.
Payroll Dashboard
Navigate to Payroll > Overview to see:
- Active employee count
- Total payroll, superannuation, and tax amounts
- Next pay run date
- Outstanding leave balances
- Trend charts
Adding Employees
- 1Navigate to Payroll > Employees
- 2Click Add Employee
- 3Enter their details:
- Name, email, phone
- Position and department
- Employment type (full-time, part-time, casual, contractor)
- Pay rate and frequency (weekly, fortnightly, monthly)
- Tax file number
- Bank account details (for payment)
- Superannuation fund and rate - 4Save
Creating a Pay Run
A pay run processes salaries for a pay period.
- 1Navigate to Payroll > Pay runs
- 2Click Create Pay Run
- 3Select the pay period (e.g., "1 Mar -- 15 Mar 2026")
- 4Review the calculated amounts for each employee:
- Gross pay
- Tax (PAYG withholding)
- Superannuation
- Net pay (what the employee receives) - 5Approve and process the pay run
Pay Run Statuses: Draft, Approved, Paid
Managing Leave
- 1Navigate to Payroll > Leave
- 2Employees can request leave (annual, sick, unpaid)
- 3Managers approve or decline requests
- 4Leave balances update automatically
Payroll Reports
Access reports for:
- Pay summaries
- Tax summaries
- Superannuation reporting
Projects and Time Tracking
If you work on projects for clients or want to track the profitability of internal initiatives, NeatSum offers project management and time tracking.
Creating a Project
- 1Navigate to Projects > Projects
- 2Click New project
- 3Enter:
- Project name and code
- Description
- Budget (if applicable) - 4Save
Project Statuses: Active, Completed, On Hold, Cancelled
Logging Time
- 1Navigate to Projects > Timesheets
- 2Click Add Time Entry
- 3Select the project and task
- 4Enter the date, hours worked, and hourly rate
- 5Mark as billable or non-billable
- 6Save
Work in Progress (WIP) Report
The WIP report shows:
- Hours logged per project
- Revenue earned vs. costs incurred
- Project profitability
You can post WIP journal entries to recognise revenue from time-based work.
Budgeting
Budgets help you plan your spending and measure performance against your plan.
Creating a Budget
- 1Navigate to Reports > Budgets
- 2Click Create budget
- 3Enter:
- Budget name (e.g., "FY 2026 Operating Budget")
- Financial year / date range
- Allocate amounts to specific accounts for each period (monthly or quarterly) - 4Save
Budget Statuses: Draft, Approved, Active, Closed
Budget Features
- Clone an existing budget as a starting point for next year
- Import from a previous year's actual figures
- Budget vs. Actual -- Compare your budget to actual results and see the variance (over or under budget)
- Rolling Forecast -- Automatically project future periods based on current trends
- Export your budget to CSV
Reading the Budget vs. Actual Report
The report shows three columns for each account:
- Budget -- What you planned to spend or earn
- Actual -- What actually happened
- Variance -- The difference (positive means under budget for expenses, over budget for income)
Use this monthly to catch overspending early and adjust your plans.
Financial Reports
Reports are where everything comes together. They show you the financial health and performance of your business.
Profit & Loss (P&L)
What it tells you: How much money your business earned and spent over a period of time -- and whether you made a profit or a loss.
How to access: Navigate to Reports > Profit and loss
Structure:
Revenue (Income)
- Sales Revenue
- Service Revenue
- Other Income
Less: Cost of Goods Sold
= Gross Profit
Less: Operating Expenses
- Rent
- Salaries
- Utilities
- etc.
= Net Profit (or Loss)How to read it:
- Revenue is the total money earned
- Gross Profit is revenue minus direct costs (what it cost to deliver your product or service)
- Net Profit is what remains after all expenses -- this is your bottom line
Using it for decisions:
- Are your expenses growing faster than revenue? Time to cut costs.
- Which expense categories are the largest? Are they worth it?
- Is gross margin healthy? If not, you may need to raise prices or reduce direct costs.
Features:
- Select any date range
- Compare periods -- See this month vs. last month, or this year vs. last year
- Monthly trend -- View revenue and expenses across months in a chart
- Drill down -- Click any line to see the individual transactions behind the number
- Export to PDF, Excel or CSV, or print it, from the Export menu
Balance Sheet
What it tells you: A snapshot of what your business owns, owes, and is worth at a specific point in time.
How to access: Navigate to Reports > Balance sheet
Structure:
Assets (what you own)
Current Assets (cash, receivables, inventory)
Non-Current Assets (equipment, vehicles)
Liabilities (what you owe)
Current Liabilities (bills due soon, credit cards)
Non-Current Liabilities (long-term loans)
Equity (the owner's share)
Owner's Capital
Retained Earnings
Assets = Liabilities + Equity (this must always balance)How to read it:
- Current Assets are things that can be converted to cash within a year
- Current Liabilities are debts due within a year
- If Current Assets > Current Liabilities, your business can cover its short-term obligations
- Equity represents the accumulated value of the business to its owners
Features:
- Select an as-at date (e.g., end of financial year)
- Compare periods -- See how your position changed
- Monthly trend -- Track asset growth over time
- Drill down into any account
- Export to PDF, Excel or CSV, or print it, from the Export menu
Cash Flow Statement
What it tells you: How cash moved in and out of your business during a period. Profit does not always equal cash -- this report shows the difference.
How to access: Navigate to Reports > Cash flow
Structure:
Cash from Operating Activities
(Cash received from customers, paid to suppliers, etc.)
Cash from Investing Activities
(Buying/selling equipment, investments)
Cash from Financing Activities
(Loans received, loan repayments, owner contributions)
Net Change in Cash
Opening Cash Balance
Closing Cash BalanceHow to read it:
- Positive operating cash flow means your core business generates cash -- this is the most important section
- Negative investing cash flow usually means you are buying assets to grow (not necessarily bad)
- Watch for situations where you are profitable on paper but running low on actual cash
Features:
- Select a date range
- Compare periods
- Monthly trend chart
- Drill down into components
- Export to PDF, Excel or CSV, or print it, from the Export menu
Trial Balance
What it tells you: A list of all accounts and their balances at a point in time. The total debits must equal the total credits.
How to access: Navigate to Reports > Trial balance
Why it matters: It is the ultimate check that your books are balanced. If debits do not equal credits, something is wrong.
- Export to PDF, Excel or CSV, or print it, from the Export menu
Ledger
What it tells you: Every single transaction for a specific account, showing how the balance changed over time.
How to access: Navigate to Reports > General ledger
Use it to drill into an account and see exactly what happened -- every invoice, payment, and adjustment.
- Export the period to PDF, Excel or CSV, or print it, from the Export menu
Ageing Reports
Both ageing reports export to Excel or CSV, or print, from the Export menu.
Accounts Receivable (AR) Ageing
What it tells you: Which customers owe you money and how long those amounts have been outstanding.
How to access: Navigate to Reports > Aged receivables
Ageing buckets: Current, 1-30 days, 31-60 days, 61-90 days, 90+ days
Why it matters: The longer an invoice goes unpaid, the harder it is to collect. Use this report to identify overdue accounts and follow up promptly.
Accounts Payable (AP) Ageing
What it tells you: Which suppliers you owe money to and when payments are due.
How to access: Navigate to Reports > Aged payables
Use it to plan cash flow and prioritize payments.
Account Statements
Generate statements for individual customers or suppliers showing all transactions and the running balance.
How to access: Navigate to Reports > Statements
Tax Management and BAS
Tax Rates
NeatSum supports multiple tax types commonly used in Australia:
| Tax Type | Description |
|---|---|
| Standard | Regular GST rate (typically 10%) |
| Zero-rated | GST applies but at 0% |
| GST-free | Exempt from GST entirely |
| Input-taxed | GST on inputs cannot be claimed |
| Export | GST-free exports |
| Capital | Capital acquisitions with GST |
| BAS-excluded | Not reported on BAS |
Managing Tax Rates
- 1Navigate to your company settings or tax configuration
- 2View existing tax rates
- 3Add new rates with:
- Name (e.g., "GST 10%")
- Percentage
- Tax type
- Description - 4Activate or deactivate rates as needed
When creating invoices, bills, or journal entries, you select the applicable tax rate for each line item. NeatSum calculates the tax automatically.
GST / BAS Report
The BAS (Business Activity Statement) report summarises your GST obligations for a period.
How to access: Navigate to Tax > GST & BAS
The report calculates:
- GST collected on sales
- GST paid on purchases
- Net GST payable (or refundable)
NeatSum calculates these figures for you to review; it does not lodge them, and it is not a registered tax or BAS agent. Lodge your BAS through the ATO's Online services for business, or have your tax agent lodge it, then record that with Mark lodged on the Lodgement History tab.
Settings and Administration
Company Settings
Configure your company's core details:
- Business name and details
- Financial year end date
- Default accounts (e.g., which bank account to use by default)
- Tax settings
Team Management
Invite the people who work on your books -- a bookkeeper, your accountant, a business partner -- and choose what each of them can do.
Who can have a team
| Plan | People per company |
|---|---|
| Free | Just you |
| Pro | Up to 10, including you |
| Enterprise | No limit, plus custom roles and per-person permissions |
The limit is per company. If you run two companies on Pro, each can have up to 10 people.
Invite someone
Only an Owner or Admin can invite people.
- 1Go to Settings > Team (users & roles)
- 2Click Invite new
- 3Enter their email address and choose a role (see below)
- 4Click Send invite
They get an email with a link to join. If they don't have a NeatSum account yet, they create one from that link. The invitation is valid for 24 hours.
Pending invitations are listed under Pending Invites, where you can Resend one (which also restarts the 24 hours) or Cancel it.
How the 10 people are counted
The top of the Team page shows how many people you have, for example "7 of 10 people (including 2 pending invitations)".
- Counted: everyone who has joined (including you), and every pending
invitation that hasn't expired.
- Not counted: suspended people, and invitations that were cancelled,
declined, bounced or have expired.
When you reach 10, Invite new is turned off. To make room, you can:
- Cancel a pending invitation you no longer need
- Suspend or Remove someone who no longer needs access
- Upgrade to Enterprise for no limit (Settings > Billing)
Reactivating a suspended person, or resending an expired invitation, takes a seat again, so it needs a free place too.
Roles
| Role | Access Level |
|---|---|
| Viewer | Can view data but cannot create, edit, or delete anything |
| Staff | Records time and expenses, with limited visibility |
| Bookkeeper | Day-to-day data entry, without deleting or approving |
| Accountant | Full financial read and write, without admin settings |
| Admin | Full access including settings and team management |
| Owner | Complete control over the company |
Tip: for an outside accountant, Accountant is usually right; for someone who only needs to look, use Viewer.
Managing your team
Under Members, an Owner or Admin can:
- Change someone's role -- pick a different role for them
- Suspend -- turn off their access for now without losing their history;
Reactivate brings it back. A suspended person doesn't take one of your 10 places.
- Set expiry -- give access that ends automatically on a date (up to a
year ahead), handy for a temporary bookkeeper or an auditor
- Remove -- take them out of the company
Everything a team member records stays in your books after they leave.
Enterprise: custom roles and permissions
On Enterprise you can also create custom roles under the Roles tab and set per-person permissions -- for example, giving someone full access to Sales but only view access to Payroll. Invite the person with a built-in role first, then give them the custom role once they've joined.
Currency Register
You can record the currencies you deal in and the exchange rates you want to use:
- 1Add additional currencies in your settings
- 2Set exchange rates against your base currency
Transactions are recorded in your base currency only. Invoices, bills and payments have no currency field, so there is nothing to select when you create one, and no conversion is applied. The register is a reference list for now; it does not change how anything posts.
Accounting Periods
Control when transactions can be entered:
- Open -- Transactions can be created and edited for this period
- Locked -- No changes allowed (useful after completing a reconciliation)
- Closed -- Permanently closed (end of financial year)
Locking periods prevents accidental changes to finalised data.
Audit Trail
Every action in NeatSum is logged:
- 1Navigate to Settings > Audit trail
- 2See who did what, when, and what changed
- 3Filter by entity type, action, user, or date range
- 4View before-and-after details for any change
The audit trail is essential for compliance and helps you track down issues.
API Keys
For advanced users and integrations:
- 1Navigate to your settings
- 2Create API keys for programmatic access
- 3Manage IP whitelisting for security
- 4Revoke keys when no longer needed
Notifications and Reminders
- Notifications -- Receive alerts for important events (overdue invoices, low stock, etc.)
- Invoice reminders (Sales > Invoice reminders) -- Configure automatic reminders for unpaid invoices:
- Set how many days before due date to send a reminder
- Set follow-up reminders after the due date
- Customise email templates
End-to-End Workflows
Here are complete walkthroughs of common business scenarios.
Scenario 1: Customer Purchase -- From Quote to Cash
Situation: A customer asks for a price on your services. They accept, you deliver, and they pay.
Step 1: Create a Quote
- 1Go to Sales > Quotes & orders, then New (or + New > New quote)
- 2Create a quote for the customer with line items and pricing
- 3Send it to the customer
Step 2: Convert to Invoice
- 1When the customer accepts, open the quote
- 2Click Convert to invoice (or convert to Sales Order first if you want to track delivery)
- 3Review and approve the invoice
Step 3: Record Payment
- 1When the customer pays, go to Sales > Customer payments
- 2Record the payment against the invoice
- 3The invoice status changes to Paid
What happened in the accounts:
| Event | Debit | Credit |
|---|---|---|
| Invoice created | Accounts Receivable | Sales Revenue |
| Payment received | Bank Account | Accounts Receivable |
Step 4: Check Reports
- Profit & Loss now shows the revenue
- Balance Sheet shows the increased bank balance
- Aged receivables no longer shows this customer as owing money
Scenario 2: Purchasing Supplies -- From Order to Payment
Situation: You need to order office supplies from a supplier.
Step 1: Create a Purchase Order
- 1Go to Purchases > Purchase orders
- 2Create a PO for the supplier with the items and quantities needed
- 3Send it to the supplier
Step 2: Receive Goods
- 1When the supplies arrive, record a Goods Receipt against the PO
- 2This updates your inventory (if applicable)
Step 3: Enter the Bill
- 1When the supplier's invoice arrives, go to Purchases > Bills
- 2Create the purchase invoice, referencing the PO
- 3NeatSum runs three-way matching (PO, receipt, bill) to verify everything aligns
Step 4: Pay the Bill
- 1Go to Purchases > Supplier payments
- 2Record the payment against the bill
What happened in the accounts:
| Event | Debit | Credit |
|---|---|---|
| Bill entered | Office Supplies Expense | Accounts Payable |
| Payment made | Accounts Payable | Bank Account |
Scenario 3: Bank Transfer Between Accounts
Situation: You want to transfer $5,000 from your checking account to your savings account.
Using Transfer Money (when Banking > Transfer money is in your menu):
- 1Go to Banking > Transfer money
- 2Choose the account the money came from (Checking) and the account it went to (Savings)
- 3Enter the amount ($5,000) and the date the money moved (type it or pick it), and a reference or description if you like
- 4Click Record transfer
NeatSum debits Savings and credits Checking on that date. There is no GST, and nothing appears on your profit and loss or your BAS.
The transfer shows in both accounts' transactions: as money out of Checking and money in to Savings. When you reconcile, match it once on each account's bank statement; reconciling one side does not hide it from the other.
Voiding a transfer: find it in the list on the Transfer Money screen and click Void. NeatSum keeps it on record and posts a reversal dated on the transfer's own date, so both accounts go back as they were in that period. If that period is locked or its BAS has been lodged, the reversal is dated today instead. A transfer that has been reconciled on either account can't be voided until you remove its match in Bank Reconciliation.
Using a Journal Entry (if Transfer Money is not in your menu):
- 1Go to Accounting > Manual journals
- 2Create a new entry:
| Account | Debit | Credit |
|---|---|---|
| Savings Account | $5,000 | |
| Checking Account | $5,000 |
- 1Save
Either way, money moved from one bank account to another. Total cash did not change, just where it sits.
Scenario 4: Monthly Payroll
Situation: It is the end of the month and you need to pay your employees.
- 1Go to Payroll > Pay runs
- 2Create a new pay run for the period
- 3Review each employee's calculated pay (gross, tax, super, net)
- 4Approve the pay run
- 5Process payment
The system records:
- Salary expense
- Tax payable (PAYG withholding)
- Superannuation payable
- Bank account decrease
Scenario 5: End-of-Month Routine
Situation: It is the last day of the month and you want to close out your books.
- 1Reconcile your bank accounts -- Import the latest statement and match all transactions
- 2Review aged receivables -- Follow up on overdue invoices
- 3Review aged payables -- Plan upcoming payments
- 4Apply depreciation -- Confirm the monthly depreciation entries
- 5Review P&L -- Check revenue and expenses for the month
- 6Review Balance Sheet -- Confirm assets, liabilities, and equity look right
- 7Lock the period -- Once satisfied, lock the accounting period to prevent changes
Common Mistakes and How to Fix Them
Misclassified Transactions
Problem: You recorded an expense to the wrong account (e.g., "Advertising" instead of "Office Supplies").
Fix:
- 1Create a journal entry to reverse the error:
- Debit: Office Supplies (correct account)
- Credit: Advertising (wrong account) - 2Or, if the original transaction is still editable, simply edit it and change the account
Prevention: Review your account classifications regularly. Use clear, descriptive account names.
Unbalanced Journal Entries
Problem: You try to save a journal entry but get an error that debits do not equal credits.
Fix: Check each line of your journal entry. Make sure the total debit amount exactly equals the total credit amount. Even a one-cent difference will prevent saving.
Prevention: Double-check your numbers before saving. Use a calculator if needed.
Duplicate Entries
Problem: The same transaction was recorded twice (e.g., you entered a bill manually and also imported it from a bank statement).
Fix:
- 1Identify the duplicate by reviewing the transaction list or ledger
- 2Correct it where it was entered. A posted entry is never deleted, because that would change reports you have already run, BAS figures for lodged periods and your reconciliations:
- an invoice or bill: open it and choose Void (or raise a credit note or supplier credit note)
- a manual journal: open it under Journal Entries and choose Reverse entry (accountants and admins)
- a draft that was never approved can still be deleted from its own page - 3If it has already been reconciled, unmatch it on the reconciliation first
Prevention:
- Use bank reconciliation to match imported transactions to existing records instead of creating new ones
- Check for existing records before entering a new one
Paying an Invoice Twice
Problem: You recorded two payments against the same invoice.
Fix:
- 1Void the duplicate payment from the invoice's payments list (Void payment). Payments are voided, not deleted, so the record stays and its journal is reversed. If Void payment isn't available on your account yet, contact support.
- 2The invoice status will revert to its correct state (e.g., from "Paid" back to "Partially Paid")
Forgetting to Record a Transaction
Problem: A transaction happened but was never entered in NeatSum. Your bank balance does not match your records.
Fix:
- 1During bank reconciliation, you will notice unmatched bank statement lines
- 2Create the missing transactions directly from the reconciliation screen
- 3Match them and complete the reconciliation
Wrong Period
Problem: You accidentally dated a transaction in the wrong month or year.
Fix: Edit the transaction and correct the date. If the period is locked, you will need to unlock it first (or record an adjusting entry in the current period).
Best Practices
Keep Your Books Clean
- Enter transactions promptly -- Don't let weeks of receipts pile up. Enter them as they happen or at least weekly.
- Attach receipts -- Upload photos or scans of receipts to transactions. This saves time during audits and helps you remember what purchases were for.
- Use consistent descriptions -- Write clear, consistent descriptions on transactions so they are easy to find later.
- Reconcile regularly -- Do bank reconciliation at least monthly. Weekly is even better.
Monthly Workflow Checklist
Use this checklist at the end of each month:
- Enter all outstanding invoices and bills
- Record all payments received and made
- Import and reconcile bank statements
- Apply monthly depreciation
- Review and follow up on overdue receivables (Aged receivables report)
- Review upcoming payables (Aged payables report)
- Run the Profit & Loss report and review results
- Run the Balance Sheet and confirm it balances
- Check the Trial Balance (debits should equal credits)
- Lock the completed period
Reconciliation Tips
- Start with the bank balance -- Always compare your NeatSum bank account balance to your actual bank statement balance
- Work chronologically -- Match transactions from oldest to newest
- Use matching rules -- Set up automatic rules for recurring bank transactions (rent, subscriptions, payroll)
- Investigate differences immediately -- Don't leave unmatched items for "later"
- Small differences matter -- Even a $1 difference means something is wrong. Track it down.
General Tips
- Use the demo company to practice before entering real data
- Back up your data before making bulk changes
- Lock periods once reconciled to prevent accidental edits
- Review the audit trail periodically to catch unauthorized changes
- Set up payment reminders so customers pay on time
- Use recurring templates for transactions that repeat every month
- Leverage AI features -- Let the AI assistant categorise transactions and flag anomalies
Frequently Asked Questions
Getting Started
Q: I just signed up. What should I do first? A: Create your company, review the default Chart of Accounts (customise if needed), add your contacts (customers and suppliers), and start entering your current invoices and bills. If you're coming from another system, you may want to enter opening balances using a journal entry.
Q: Can I manage multiple businesses? A: Yes. You can create multiple companies and switch between them. Each company has completely separate data.
Q: Can I invite my accountant to access my books? A: Yes, on Pro or Enterprise. Invite them as a team member with the appropriate role (e.g., Accountant or Admin). Pro includes up to 10 people per company; Enterprise has no limit and lets you control exactly which modules each person can access.
Chart of Accounts
Q: Should I change the default Chart of Accounts? A: The defaults work well for most small businesses. Review them and add accounts specific to your business (e.g., if you have industry-specific revenue streams). Remove or archive any you won't use.
Q: What if I choose the wrong account for a transaction? A: You can edit the transaction and change the account, or create a journal entry to move the amount to the correct account.
Invoices and Payments
Q: What is the difference between an invoice and a receipt? A: An invoice is a request for payment -- you send it to a customer before they pay. A receipt is confirmation that payment was received. In NeatSum, you create an invoice, and when the customer pays, you record an incoming payment.
Q: Can I send invoices to customers from NeatSum? A: Where emailing is turned on for your company, yes: click Email on the invoice (or the envelope beside it in the Invoices list). The To address, subject and message are filled in from the customer and from your template under Settings > Email templates, and you can change them before sending. The PDF is attached, and if you have connected Stripe and money is owing, the email and the PDF include a Pay-now link. It comes from "your business via NeatSum", and replies go to the business email in your company settings. Each email is listed on the invoice as "Sent to ... on ...". Quotes, credit notes and customer statements have the same Email button.
Where emailing is not turned on for your company, NeatSum does not email invoices for you. Click Print on the invoice to print it or save it as a PDF, then send it to your customer yourself. If you have connected Stripe, Share payment link copies a link your customer can use to pay online.
Q: What if a customer only pays part of an invoice? A: Record the partial payment. The invoice status will change to "Partially Paid." You can record additional payments later until the invoice is fully paid.
Q: Can I split a payment across multiple invoices? A: Yes. When recording an incoming payment, you can allocate it across multiple outstanding invoices.
Journal Entries
Q: When do I need to create a manual journal entry? A: Most of the time, you don't -- NeatSum creates them automatically when you enter invoices, bills, and payments. Use manual entries for adjustments, corrections, depreciation, write-offs, and opening balances.
Q: What happens if my journal entry doesn't balance? A: NeatSum won't let you save it. The total debits must equal the total credits. Check your numbers and try again.
Reports
Q: My Profit & Loss shows a profit, but I have no cash. What's going on? A: This is common. Profit is calculated on an accrual basis (when revenue is earned), not when cash is received. Check your Cash Flow Statement and Aged receivables -- you may have outstanding invoices that haven't been paid yet.
Q: How often should I look at reports? A: At minimum, review the Profit & Loss and Balance Sheet monthly. Check the Aged receivables and Aged payables reports weekly if you have many customers or suppliers. Review Cash Flow whenever you're planning significant spending.
Q: What's a Trial Balance for? A: It's a sanity check. If total debits equal total credits, your books are balanced. If they don't, there's an error somewhere that needs to be found and fixed.
Bank Reconciliation
Q: How often should I reconcile? A: Monthly at minimum. Weekly or even daily is better for businesses with many transactions. The more frequently you reconcile, the easier each reconciliation is.
Q: What if my bank balance doesn't match NeatSum? A: Common reasons include: unrecorded transactions, duplicate entries, timing differences (transactions in transit), or data entry errors. Use the reconciliation process to identify and resolve each discrepancy.
Tax
Q: How does GST work in NeatSum? A: When you create invoices and bills, you assign a tax rate to each line item. NeatSum calculates the GST automatically. The GST & BAS report (Tax > GST & BAS) summarises your GST collected and paid for the period, giving you the figures to lodge your BAS through the ATO's Online services for business or your tax agent.
Data and Security
Q: Is my data safe? A: NeatSum uses Firebase Authentication for secure login, and all data is isolated per company. The audit trail tracks every change. You can also lock accounting periods to prevent unauthorized modifications.
Q: Can I export my data? A: Yes. Most reports can be exported to PDF, Excel or CSV. Contacts can be exported to CSV. You can also use the API for programmatic data access.
Troubleshooting
Q: I can't delete an account / contact / item. Why? A: If a record has transactions linked to it, NeatSum prevents deletion to protect your data integrity. Instead, archive the record to hide it from active use while preserving the history.
Q: I made a mistake in a locked period. What do I do? A: You have two options: (1) Unlock the period temporarily, make the correction, and re-lock it. (2) Record an adjusting journal entry in the current (open) period.
Q: Something seems wrong with my numbers. Where do I start? A: Start with the Trial Balance -- if it doesn't balance, there's a fundamental issue. Then check bank reconciliation for any unmatched items. Review the Ledger for the specific accounts that seem off. The Audit Trail can also show if someone made an unexpected change.
Clear Water Pty Ltd -- End-to-End Demo
A complete, hands-on simulation. You will set up a real company in the app, enter a full quarter of transactions, and finish with a self-balancing set of books that you can validate against every report. Every step lists the exact figures you should see, so you can catch errors the moment they happen instead of at month-end.
25.1 The Company
Clear Water Pty Ltd -- a Melbourne-based wholesale distributor of bottled spring water. Sells to corporate clients (hotels, cafes) and direct subscribers.
| Attribute | Value |
|---|---|
| Legal name | Clear Water Pty Ltd |
| Industry | Wholesale Trade |
| Structure | Company |
| ABN | 12 345 678 901 |
| Address | 42 Spring Street, Richmond VIC 3121 |
| Financial year | 1 July -- 30 June (FY27) |
| GST registered | Yes, quarterly |
| Period under simulation | 2026-07-01 -- 2026-09-30 (Q1 FY27) |
Cast at a glance: every entity gets a full setup table later in Step 25.4. The summary below is a teaser so you know who appears in which transaction.
| Role | Name | Type | Terms / Notes | First appears in |
|---|---|---|---|---|
| Customer | Hilton Melbourne | Company | Net 30, 50,000 credit limit | Step 25.4.1, Step 25.6.1 (INV-001) |
| Customer | Cafe Aurora | Company | Net 14, 5,000 credit limit | Step 25.4.1, Step 25.6.2 (INV-002) |
| Customer | Direct Subscriber Group | Individual | Prepaid, no credit | Step 25.4.1, Step 25.6.3 (INV-003) |
| Supplier | Aqua Source Springs | Company | Net 30, ABN 33 444 555 666 | Step 25.4.2, Step 25.5.1 (PO-001) |
| Supplier | PET Bottle Co. | Company | Net 14, ABN 44 555 666 777 | Step 25.4.2 (no Q1 transactions) |
| Supplier | Truckline Logistics | Company | Net 7, ABN 55 666 777 888 | Step 25.4.2, Step 25.5.4 (TR-2087) |
| Supplier | CityPower | Company | Net 14, ABN 66 777 888 999 | Step 25.4.2, Step 25.5.5 (CP-44102) |
| Supplier | Richmond Property Trust | Company | Net 0, recurring rent | Step 25.4.2, Step 25.5.7 (rent template) |
| Employee | Sam Driver | Individual | Full-time delivery driver, 30.00/hr | Step 25.4.4 (full setup), Step 25.10 (pay run) |
25.2 How to Use This Section
Each step follows the same pattern:
- 1Open -- a clickable button takes you straight to the app screen.
- 2What to enter -- exact field values you should type.
- 3Why this matters -- one-sentence rationale.
- 4Expected GL Impact -- the journal the system should post.
- 5Running balances after this step -- self-check figures.
After each major workflow you will find a Section Snapshot with cumulative totals. At the very end (Step 25.10) a Master Validation Table cross-references every figure against the reports module.
25.3 Setup Phase
Step 25.3.1 -- Create the Company
Open the company switcher in the header (top-right) and choose New company. Walk through the 7-step wizard.
Step 1 -- Industry
| Field | Value |
|---|---|
| Industry | Wholesale Trade |
Step 2 -- Structure
| Field | Value |
|---|---|
| Structure | Company |
Step 3 -- Identity
| Field | Value |
|---|---|
| Business name | Clear Water Pty Ltd |
| ABN | Leave blank (optional; the wizard rejects an ABN that is not valid) |
Step 4 -- Financial Year
| Field | Value |
|---|---|
| Start month | July |
| Start day | 1 |
Step 5 -- GST
| Field | Value |
|---|---|
| GST | Registered |
| Reporting frequency | Quarterly |
| Basis | Accrual |
Step 6 -- Contact (optional)
| Field | Value |
|---|---|
| Address | 42 Spring Street, Richmond VIC 3121 |
| Phone | (03) 9000 1234 |
| hello@clearwater.com.au |
Step 7 -- Review
Check the summary, then click Create Company. Everything is recorded in Australian dollars.
Step 25.3.2 -- Verify the Chart of Accounts
Open Chart of Accounts.
You should see seven categories already populated: Assets, Liabilities, Equity, Income, Cost of Sales, Operating Expenses, Payroll/Depreciation. Confirm the following key accounts exist:
| Code | Name | Category |
|---|---|---|
| 1000 | Business Bank Account | Assets |
| 1100 | Accounts Receivable | Assets |
| 1210 | GST Paid on Purchases | Assets |
| 1300 | Inventory | Assets |
| 1500 | Fixed Assets - Vehicles | Assets |
| 1800 | Accumulated Depreciation | Contra-Asset |
| 2000 | Accounts Payable | Liabilities |
| 2200 | GST Collected on Sales | Liabilities |
| 2800 | Business Loan | Liabilities |
| 3000 | Owner's Capital | Equity |
| 4000 | Sales | Income |
| 4200 | Service Revenue | Income |
| 5000 | Cost of Goods Sold | Cost of Sales |
| 6100 | Rent | Expenses |
| 7500 | Depreciation Expense | Depreciation |
Click Add account and create these three custom accounts (the defaults don't include them). Open the Add account modal and fill the same field set for each row:
Account 1 of 3 -- 6080 Utilities
| Field | Value |
|---|---|
| Account code | 6080 |
| Name | Utilities |
| Category | Expenses (Operating) |
| Sub-category | Premises Costs |
| Description | Electricity, water, gas, network supply for the warehouse |
| Default tax rate | GST 10% |
| System key | (leave blank -- not a system account) |
| Parent account | (none) |
| Currency | AUD |
| Status | Active |
| Show on dashboard | No |
| Lock for posting | No |
Account 2 of 3 -- 6700 Vehicle Running Costs
| Field | Value |
|---|---|
| Account code | 6700 |
| Name | Vehicle Running Costs |
| Category | Expenses (Operating) |
| Sub-category | Vehicle & Travel |
| Description | Fuel, tolls, parking, registration, servicing |
| Default tax rate | GST 10% |
| System key | (leave blank) |
| Parent account | (none) |
| Currency | AUD |
| Status | Active |
| Show on dashboard | No |
| Lock for posting | No |
Account 3 of 3 -- 2300 Accruals
| Field | Value |
|---|---|
| Account code | 2300 |
| Name | Accruals |
| Category | Liabilities (Current) |
| Sub-category | Accrued Expenses |
| Description | Period-end estimated expenses for which no bill has yet arrived |
| Default tax rate | BAS Excluded |
| System key | (leave blank) |
| Parent account | (none) |
| Currency | AUD |
| Status | Active |
| Show on dashboard | No |
| Lock for posting | No |
CUSTOMER_DEPOSIT_LIABILITY). You don't need to add it -- the dedicated Customer Deposits module posts to it automatically. Don't be tempted to pick an "Assets" category for a deposit just because the word sounds asset-like; a customer prepayment is a liability because you owe goods or a refund.Step 25.3.3 -- Confirm Tax Rates
Open Tax Rates.
You should see three rates already seeded:
| Name | Rate | Type | BAS box (sales) | BAS box (purchases) | Default |
|---|---|---|---|---|---|
| GST 10% | 10.0% | standard | G1 / 1A | G11 / 1B | Yes |
| GST Free | 0.0% | gst_free | G3 | G14 | No |
| BAS Excluded | 0.0% | bas_excluded | -- | -- | No |
No changes needed for the demo. If you ever need to add a custom rate (for example an Input-Taxed sale), click + Add Tax Rate and fill:
| Field | Example value |
|---|---|
| Name | Input-Taxed Sales |
| Rate (%) | 0.0 |
| Type | input_taxed |
| Applies to | Sales |
| BAS box (sales) | G4 |
| BAS box (purchases) | -- |
| Is default? | No |
| Active | Yes |
| Description | Residential rent, financial supplies, etc. |
Step 25.3.4 -- Open the Accounting Period
Open Accounting → Lock dates & periods and click New period:
| Field | Value |
|---|---|
| Period name | FY27 Q1 |
| Period type | Quarter |
| Financial year | FY27 (1 Jul 2026 -- 30 Jun 2027) |
| Parent period | FY27 (auto-created if it doesn't exist) |
| Start date | 2026-07-01 |
| End date | 2026-09-30 |
| Status | Open |
| Posting allowed for roles | Admin, Bookkeeper, Accountant |
| Prior-period status check | Pass (no prior FY27 period exists) |
| Soft-close date | (leave blank -- we'll set it at Step 25.8.4) |
| Hard-lock date | (leave blank) |
| Notes | First quarter of FY27 -- Clear Water demo |
Step 25.3.5 -- Record Opening Balances
Open Manual journals, then click + New Journal Entry.
| Field | Value |
|---|---|
| Date | 2026-07-01 |
| Reference | OPEN-001 |
| Source | Manual |
| Narration | Opening balances for Clear Water Pty Ltd |
| Currency | AUD |
| Project / Cost centre | (none) |
| Branch / Department | (none -- single-site) |
| Recurring template? | No |
| Auto-reverse on date | (leave blank -- opening balances are permanent) |
| Attachments | Owner contribution receipt + Loan agreement PDF (optional) |
| Tags | opening-balance, fy27 |
Lines:
| # | Account | Description | Debit | Credit | Tax |
|---|---|---|---|---|---|
| 1 | 1000 Business Bank Account | Opening cash | 80,000.00 | BAS Excluded | |
| 2 | 3000 Owner's Capital | Owner contribution | 40,000.00 | BAS Excluded | |
| 3 | 2800 Business Loan | NAB business loan @ 7.2% | 40,000.00 | BAS Excluded |
Click Post.
Section Snapshot -- after 25.3
| Account | Balance |
|---|---|
| 1000 Cash | 80,000 Dr |
| 2800 Loan | 40,000 Cr |
| 3000 Capital | 40,000 Cr |
| Trial Balance | 80,000 = 80,000 |
25.4 Master Data
Step 25.4.1 -- Add Customers
Open Contacts, then click Add contact. Repeat the form once per customer, ticking Is Customer every time. Every column below is a real field on the Add Contact form -- fill what's listed, leave the rest at default.
Customer 1 of 3 -- Hilton Melbourne
| Field | Value |
|---|---|
| Display name | Hilton Melbourne |
| Contact type | Company |
| Is Customer | Yes |
| Is Supplier | No |
| Primary contact name | Priya Shah (Accounts Payable) |
| ap@hilton.example | |
| Phone | (03) 9419 1234 |
| Mobile | -- |
| Website | https://hilton.com/melbourne |
| ABN | 11 222 333 444 |
| ACN | -- |
| Currency | AUD |
| Payment terms | Net 30 |
| Credit limit | 50,000.00 |
| Default sales account | 4000 Sales |
| Default tax (sales) | GST 10% |
| Default income discount | 0% |
| Opening balance | 0.00 |
| Opening balance as at | 2026-07-01 |
| Status | Active |
| Tags | corporate, hotel |
| Notes | Q3 supply contract -- 1,200 bottles/month minimum |
Billing & shipping (Hilton):
| Address type | Street | Suburb / State / Postcode | Country |
|---|---|---|---|
| Billing | 192 Wellington Pde | East Melbourne VIC 3002 | Australia |
| Shipping | Loading dock B, 192 Wellington Pde | East Melbourne VIC 3002 | Australia |
Customer 2 of 3 -- Cafe Aurora
| Field | Value |
|---|---|
| Display name | Cafe Aurora |
| Contact type | Company |
| Is Customer | Yes |
| Is Supplier | No |
| Primary contact name | Marco Lin (Owner) |
| accounts@aurora.example | |
| Phone | (03) 9417 8822 |
| ABN | 22 333 444 555 |
| Currency | AUD |
| Payment terms | Net 14 |
| Credit limit | 5,000.00 |
| Default sales account | 4000 Sales |
| Default tax (sales) | GST 10% |
| Opening balance | 0.00 |
| Opening balance as at | 2026-07-01 |
| Status | Active |
| Tags | small-business, cafe |
| Notes | Weekly delivery, prefers Tuesday AM |
Billing & shipping (Cafe Aurora) -- billing = shipping:
| Address type | Street | Suburb / State / Postcode | Country |
|---|---|---|---|
| Billing & shipping | 17 Brunswick St | Fitzroy VIC 3065 | Australia |
Customer 3 of 3 -- Direct Subscriber Group
| Field | Value |
|---|---|
| Display name | Direct Subscriber Group |
| Contact type | Individual |
| Is Customer | Yes |
| Is Supplier | No |
| Primary contact name | (consumer group, no single contact) |
| subs@clearwater.com.au | |
| Phone | -- |
| ABN | -- |
| Currency | AUD |
| Payment terms | Prepaid |
| Credit limit | 0.00 |
| Default sales account | 4000 Sales |
| Default tax (sales) | GST 10% |
| Opening balance | 0.00 |
| Opening balance as at | 2026-07-01 |
| Status | Active |
| Tags | consumer, subscription |
| Notes | Aggregated subscriber group; revenue recognised in single monthly invoice |
Step 25.4.2 -- Add Suppliers
Stay on Contacts, click Add contact again. This time tick Is Supplier on every contact. Five suppliers are needed for the demo (the rent supplier is added here so Step 25.5.7 doesn't need a side-trip to create it).
Supplier 1 of 5 -- Aqua Source Springs
| Field | Value |
|---|---|
| Display name | Aqua Source Springs |
| Contact type | Company |
| Is Customer | No |
| Is Supplier | Yes |
| Primary contact name | Karen Wells (Sales) |
| sales@aquasource.example | |
| Phone | (03) 5945 7700 |
| ABN | 33 444 555 666 |
| Currency | AUD |
| Payment terms | Net 30 |
| Credit limit (their limit on us) | 25,000.00 |
| Default expense account | 1300 Inventory |
| Default tax (purchases) | GST 10% |
| Default payment method | EFT |
| Bank name | NAB |
| BSB | 083-004 |
| Account name | Aqua Source Springs Pty Ltd |
| Account number | 1122 3344 |
| Opening balance owed | 0.00 |
| Opening balance as at | 2026-07-01 |
| Address | 14 Spring Lane, Healesville VIC 3777 |
| Status | Active |
| Tags | inventory, primary-supplier |
| Notes | Source of all spring water; 2-day lead time |
Supplier 2 of 5 -- PET Bottle Co.
| Field | Value |
|---|---|
| Display name | PET Bottle Co. |
| Contact type | Company |
| Is Supplier | Yes |
| Primary contact name | Tom Halliday |
| orders@petbottle.example | |
| Phone | (03) 9870 1133 |
| ABN | 44 555 666 777 |
| Currency | AUD |
| Payment terms | Net 14 |
| Default expense account | 1300 Inventory |
| Default tax (purchases) | GST 10% |
| Default payment method | EFT |
| Bank name | Westpac |
| BSB | 033-008 |
| Account name | PET Bottle Co. Pty Ltd |
| Account number | 5566 7788 |
| Opening balance owed | 0.00 |
| Opening balance as at | 2026-07-01 |
| Address | 22 Industrial Way, Dandenong South VIC 3175 |
| Status | Active |
| Tags | packaging |
| Notes | Reserve supplier -- no Q1 transactions in this demo |
Supplier 3 of 5 -- Truckline Logistics
| Field | Value |
|---|---|
| Display name | Truckline Logistics |
| Contact type | Company |
| Is Supplier | Yes |
| Primary contact name | Vince Romano (Despatch) |
| accounts@truckline.example | |
| Phone | (03) 9311 4400 |
| ABN | 55 666 777 888 |
| Currency | AUD |
| Payment terms | Net 7 |
| Default expense account | 5100 Freight & Courier |
| Default tax (purchases) | GST 10% |
| Default payment method | EFT |
| Bank name | ANZ |
| BSB | 013-006 |
| Account name | Truckline Logistics Pty Ltd |
| Account number | 9988 7766 |
| Opening balance owed | 0.00 |
| Address | 89 Freight Drive, Tullamarine VIC 3043 |
| Status | Active |
| Tags | logistics |
Supplier 4 of 5 -- CityPower
| Field | Value |
|---|---|
| Display name | CityPower |
| Contact type | Company |
| Is Supplier | Yes |
| Primary contact name | Customer Care Team |
| billing@citypower.example | |
| Phone | 13 22 33 |
| ABN | 66 777 888 999 |
| Currency | AUD |
| Payment terms | Net 14 |
| Default expense account | 6080 Utilities |
| Default tax (purchases) | GST 10% (lines may override to GST Free) |
| Default payment method | BPAY |
| BPAY biller code | 47711 |
| Opening balance owed | 0.00 |
| Address | GPO Box 1234, Melbourne VIC 3001 |
| Status | Active |
| Tags | utilities |
| Notes | Mixed-tax bills -- network supply charge is GST Free |
Supplier 5 of 5 -- Richmond Property Trust
| Field | Value |
|---|---|
| Display name | Richmond Property Trust |
| Contact type | Company |
| Is Supplier | Yes |
| Primary contact name | Helen Tran (Property Manager) |
| leasing@richmondpt.example | |
| Phone | (03) 9428 6611 |
| ABN | 77 888 999 000 |
| Currency | AUD |
| Payment terms | Net 0 (due on the 1st of the month) |
| Default expense account | 6100 Rent |
| Default tax (purchases) | GST 10% |
| Default payment method | EFT |
| Bank name | CBA |
| BSB | 062-100 |
| Account name | Richmond Property Trust |
| Account number | 4455 6677 |
| Opening balance owed | 0.00 |
| Address | Level 4, 200 Victoria St, Richmond VIC 3121 |
| Status | Active |
| Tags | landlord, recurring |
| Notes | Warehouse lease 2026-07-01 -- 2027-06-30, $2,200 ex GST monthly |
Step 25.4.3 -- Add Items
Open Items, then click Add item. Repeat once per row -- the table below is one item per column block, listing every field on the form.
Item 1 of 4 -- 600ml Spring Water
| Field | Value |
|---|---|
| Item code / SKU | SW-600 |
| Name | 600ml Spring Water |
| Item type | Product (inventory-tracked) |
| Description (sales) | 600ml bottled spring water -- single unit |
| Description (purchases) | 600ml PET bottle, case-packed |
| Unit of measure | each |
| Track inventory | Yes |
| Default location | Richmond Warehouse |
| Reorder level | 1,000 |
| Reorder quantity | 5,000 |
| Default supplier | Aqua Source Springs |
| Barcode (GTIN) | 9312345600015 |
| For sale | Yes |
| Sell price (ex tax) | 1.80 |
| Sales account | 4000 Sales |
| Sales tax | GST 10% |
| For purchase | Yes |
| Cost price (ex tax) | 0.50 |
| Purchase account | 1300 Inventory (capitalises to inventory until sold) |
| COGS account | 5000 Cost of Goods Sold |
| Purchase tax | GST 10% |
| Opening stock qty | 0 |
| Opening stock value | 0.00 |
| Opening stock as at | 2026-07-01 |
| Status | Active |
Item 2 of 4 -- 12L Cooler Bottle
| Field | Value |
|---|---|
| Item code / SKU | CB-12L |
| Name | 12L Cooler Bottle |
| Item type | Product (inventory-tracked) |
| Description (sales) | 12-litre refillable cooler bottle |
| Unit of measure | each |
| Track inventory | Yes |
| Default location | Richmond Warehouse |
| Reorder level | 50 |
| Reorder quantity | 200 |
| Default supplier | Aqua Source Springs |
| Barcode (GTIN) | 9312345601128 |
| For sale | Yes |
| Sell price (ex tax) | 14.00 |
| Sales account | 4000 Sales |
| Sales tax | GST 10% |
| For purchase | Yes |
| Cost price (ex tax) | 4.00 |
| Purchase account | 1300 Inventory |
| COGS account | 5000 Cost of Goods Sold |
| Purchase tax | GST 10% |
| Opening stock qty | 0 |
| Opening stock value | 0.00 |
| Status | Active |
Item 3 of 4 -- Delivery Service
| Field | Value |
|---|---|
| Item code / SKU | SVC-DEL |
| Name | Delivery Service |
| Item type | Service (no inventory) |
| Description (sales) | Per-drop metropolitan delivery |
| Unit of measure | drop |
| Track inventory | No |
| For sale | Yes |
| Sell price (ex tax) | 20.00 |
| Sales account | 4200 Service Revenue |
| Sales tax | GST 10% |
| For purchase | No |
| Status | Active |
Item 4 of 4 -- Bottle Deposit
| Field | Value |
|---|---|
| Item code / SKU | SVC-DEP |
| Name | Bottle Deposit |
| Item type | Service (no inventory) |
| Description (sales) | Refundable deposit on returnable cooler bottle |
| Unit of measure | bottle |
| Track inventory | No |
| For sale | Yes |
| Sell price (ex tax) | 5.00 |
| Sales account | 4200 Service Revenue |
| Sales tax | GST Free (deposits are not a supply) |
| For purchase | No |
| Status | Active |
Leave opening stock at 0 on the two products -- inventory will arrive via the first purchase order in Step 25.5.
Step 25.4.4 -- Add the Employee (Sam Driver)
Open Payroll Employees, then click + New Employee. The form is a 6-step wizard -- one screen per step. The values below are demo placeholders (TFN, BSB and account number especially are not real). Use these exact values so the pay run in Step 25.10.2 produces the journal documented there.
Step 1 of 6 -- Personal Information
| Field | Value |
|---|---|
| First name | Sam |
| Last name | Driver |
| sam.driver@clearwater.com.au | |
| Phone | 0412 555 904 |
| Date of birth | 1990-04-12 |
| Address | 88 Church St, Richmond VIC 3121 |
Click Next.
Step 2 of 6 -- Employment Details
| Field | Value |
|---|---|
| Job title / Role | Delivery Driver |
| Department | Operations |
| Employment type | Full-time |
| Start date | 2026-07-01 |
The Department dropdown is empty on a fresh company. Click + New beside it, type Operations, hit save, and it will be selected automatically. (Behind the scenes this creates a row in payroll_department.)
Click Next.
Step 3 of 6 -- Pay Details
| Field | Value |
|---|---|
| Pay type | Hourly |
| Hourly rate ($) | 30.00 |
| Hours per week | 38 |
| Pay frequency | Weekly |
A Live Preview card appears in the side panel and recalculates as you type:
| Preview line | Amount (per pay) |
|---|---|
| Gross pay (38 × $30.00) | 1,140.00 |
| PAYG withholding (resident, threshold claimed) | 184.00 |
| Superannuation guarantee (12%) | 136.80 |
| Net take-home | 956.00 |
Click Next.
Step 4 of 6 -- Tax & Superannuation
| Field | Value |
|---|---|
| Residency for tax purposes | Australian resident for tax purposes |
| TFN status | TFN provided |
| Tax File Number (TFN) | 123 456 782 (demo only -- not a real TFN) |
| Claims the tax-free threshold | Yes |
| Has a study or training support loan | No |
| Medicare levy exemption | No exemption |
| Super fund name | AustralianSuper |
| Super USI | STA0100AU |
| Super member number | 12345678 |
| Super rate (%) | 12 (the Superannuation Guarantee rate since 1 July 2025, and NeatSum's default) |
***; only the detail view (and pay-run output) decrypts them.Click Next.
Step 5 of 6 -- Bank & Emergency Contact
| Field | Value |
|---|---|
| Bank name | Commonwealth Bank |
| BSB | 062-000 (demo only) |
| Account name | Sam Driver |
| Account number | 1234 5678 (demo only) |
| Emergency contact name | Jamie Driver |
| Emergency contact phone | 0421 987 654 |
| Emergency contact relation | Spouse |
Click Next.
Step 6 of 6 -- Review & Confirm
The wizard echoes back every field you entered, plus an Estimated per-pay cost to the company card:
| Cost line | Amount |
|---|---|
| Gross wages | 1,140.00 |
| Super contribution | 136.80 |
| Total employer cost per week | 1,276.80 |
Click Save Employee.
| Leave type | Annual accrual rate |
|---|---|
| Annual leave | 20 days |
| Sick / Personal carer's | 10 days |
| Personal | 5 days |
| Long service | 8.67 days (≈13 weeks per 10 years' service) |
wages_expense_id, super_expense_id, payg_payable_id, super_payable_id, wages_payable_id, bank_account_id. The employee form itself doesn't enforce this -- the pay-run Post button does. Don't worry about it now; Step 25.10.1 walks the setup.Section Snapshot -- after 25.4
No GL impact (master data only). Counts: 8 contacts (3 customers + 5 suppliers), 4 items, 1 employee + 1 department.
25.5 Purchases Workflow
We process purchases first because Clear Water needs inventory in stock before it can sell anything.
Step 25.5.1 -- Purchase Order to Aqua Source Springs
Open Purchase Orders, then click New purchase order.
Header:
| Field | Value |
|---|---|
| Supplier | Aqua Source Springs |
| Supplier reference | (their quote number, leave blank for the demo) |
| PO number | PO-001 (auto-suggested by document numbering) |
| Order date | 2026-07-02 |
| Expected delivery date | 2026-07-04 |
| Currency | AUD |
| FX rate | 1.0000 (no conversion) |
| Tax mode | Tax Exclusive |
| Ship to | Richmond Warehouse, 42 Spring Street, Richmond VIC 3121 |
| Delivery instructions | Roller-door access; deliver before 2pm |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | First inventory PO -- launch stock |
| Attachments | (optional supplier quote PDF) |
| Approval status | Auto-approved (no approval rule yet -- see Step 25.10 Approvals) |
Lines (one row per item):
| # | Item | Description | Account override | Qty | Unit cost (ex) | Discount % | Tax | Project | Line memo | Line total (ex) |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml PET bottle, case-packed | (default 1300 Inventory) | 5,000 | 0.50 | 0 | GST 10% | -- | -- | 2,500.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 2,500.00 |
| GST | 250.00 |
| Total (inc tax) | 2,750.00 |
Click Approve / Send.
Step 25.5.2 -- Goods Receipt (Partial)
From the PO-001 detail page, click Receive Goods.
Header:
| Field | Value |
|---|---|
| GR number | GR-001 (auto) |
| Linked PO | PO-001 |
| Receipt date | 2026-07-04 |
| Receiving location | Richmond Warehouse |
| Received by | (your user name) |
| Carrier / Driver name | Aqua Source own truck |
| Delivery docket # | DD-77104 |
| Condition | Good (no breakage on this delivery) |
| GR notes | Short-shipped by 200 -- supplier flagged for credit on next PO |
| Attachments | Photo of delivery docket (optional) |
Lines:
| # | Item | Ordered | Previously received | Receiving now | Outstanding | Condition | Bin / Location |
|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 5,000 | 0 | 4,800 | 200 | Good | Bay A-12 |
Save.
Step 25.5.3 -- Bill from Aqua Source (Three-Way Match)
Open Bills, then click New bill. The system will offer to match against PO-001 / GR-001 -- accept.
Header:
| Field | Value |
|---|---|
| Supplier | Aqua Source Springs |
| Bill number (theirs) | INV-AQ-7711 |
| Internal reference | BILL-001 (auto) |
| Bill date | 2026-07-04 |
| Due date | 2026-08-03 (auto from Net 30 terms) |
| Due-date method | From bill date + supplier terms |
| Currency | AUD |
| FX rate | 1.0000 |
| Tax mode | Tax Exclusive |
| AP account | 2000 Accounts Payable (default) |
| Payment method | EFT (default from supplier) |
| Match against | PO-001 + GR-001 |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | First inventory bill -- 200-unit short-ship to chase |
| Attachments | Bill PDF from supplier |
| Approval status | Auto-approved |
Lines (auto-filled from GR):
| # | Item | Description | Account | Qty | Unit cost (ex) | Discount % | Tax | Project | Line total (ex) |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml PET bottle, case-packed | 1300 Inventory | 4,800 | 0.50 | 0 | GST 10% | -- | 2,400.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 2,400.00 |
| GST | 240.00 |
| Total (inc tax) | 2,640.00 |
| Account | Dr | Cr |
| 1300 Inventory | 2,400.00 | |
| 1210 GST Paid | 240.00 | |
| 2000 Accounts Payable | | 2,640.00 |
Step 25.5.4 -- Direct Bill from Truckline (No PO)
Stay on Bills, click New bill. When the Match against PO? prompt appears, click Skip Match -- this is a service bill with no PO.
Header:
| Field | Value |
|---|---|
| Supplier | Truckline Logistics |
| Bill number (theirs) | TR-2087 |
| Internal reference | BILL-002 |
| Bill date | 2026-07-15 |
| Due date | 2026-07-22 (Net 7 terms) |
| Due-date method | From bill date + supplier terms |
| Currency | AUD |
| FX rate | 1.0000 |
| Tax mode | Tax Exclusive |
| AP account | 2000 Accounts Payable |
| Payment method | EFT |
| Match against | (skipped -- no PO) |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | First-week freight charges |
| Attachments | Truckline invoice PDF |
Lines (use a manual GL line, no item):
| # | Item | Description | Account | Qty | Unit cost (ex) | Discount % | Tax | Project | Line total (ex) |
|---|---|---|---|---|---|---|---|---|---|
| 1 | (none) | First-week freight | 5100 Freight & Courier | 1 | 400.00 | 0 | GST 10% | -- | 400.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 400.00 |
| GST | 40.00 |
| Total (inc tax) | 440.00 |
| Account | Dr | Cr |
| 5100 Freight & Courier | 400.00 | |
| 1210 GST Paid | 40.00 | |
| 2000 AP | | 440.00 |
Step 25.5.5 -- Mixed-Tax Bill from CityPower
Header:
| Field | Value |
|---|---|
| Supplier | CityPower |
| Bill number (theirs) | CP-44102 |
| Internal reference | BILL-003 |
| Bill date | 2026-07-30 |
| Due date | 2026-08-13 (Net 14) |
| Currency | AUD |
| FX rate | 1.0000 |
| Tax mode | Tax Exclusive |
| AP account | 2000 Accounts Payable |
| Payment method | BPAY (default from supplier) |
| BPAY reference | 47711 / customer ref 99887766 |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | July electricity -- mixed-tax bill |
| Attachments | CityPower bill PDF |
Lines:
| # | Item | Description | Account | Qty | Unit cost (ex) | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|
| 1 | (none) | Electricity usage July | 6080 Utilities | 1 | 200.00 | GST 10% | 200.00 |
| 2 | (none) | Network supply charge | 6080 Utilities | 1 | 20.00 | GST Free | 20.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 220.00 |
| GST | 20.00 (only on the $200 line) |
| Total (inc tax) | 240.00 |
| Account | Dr | Cr |
| 6080 Utilities | 220.00 | |
| 1210 GST Paid | 20.00 | |
| 2000 AP | | 240.00 |
Step 25.5.6 -- Supplier Credit Note from Aqua Source
200 units from the 4,800 received are defective. Open Supplier credit notes, click + New supplier credit note.
Header:
| Field | Value |
|---|---|
| Supplier | Aqua Source Springs |
| Supplier credit note number | SCN-000001 (auto) |
| Date | 2026-07-30 |
| Allocate against | Bill INV-AQ-7711 |
| Reason | Defective goods on receipt |
| Restock to inventory? | No (defective units written off) |
| Affects inventory? | Yes (reverses the original inventory hit) |
| Reference doc | Photos in attachments |
| Currency | AUD |
| Tax mode | Tax Exclusive |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | 200 cracked bottles -- chasing replacement on next PO |
| Attachments | Photos of defective units |
Lines:
| # | Item | Description | Account | Qty | Unit cost (ex) | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | Defective units credit | 1300 Inventory | 200 | 0.50 | GST 10% | 100.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 100.00 |
| GST | 10.00 |
| Total (inc tax) | 110.00 credit against AP |
| Account | Dr | Cr |
| 2000 AP | 110.00 | |
| 1300 Inventory | | 100.00 |
| 1210 GST Paid | | 10.00 |
Step 25.5.7 -- Recurring Rent Template
Open Recurring, then click + New Template. Richmond Property Trust was added as Supplier 5 of 5 in Step 25.4.2, so the dropdown is ready.
Header:
| Field | Value |
|---|---|
| Template name | Monthly Rent -- Richmond warehouse |
| Document type | Bill |
| Supplier | Richmond Property Trust |
| Currency | AUD |
| Tax mode | Tax Exclusive |
| Frequency | Monthly |
| Day of month | 1 |
| Start date | 2026-07-01 |
| End condition | End date |
| End date | 2027-06-30 |
| Occurrences (alternative) | (12 -- not used since End date is set) |
| Status | Active |
| Posting mode | Auto-post (no review queue) |
| Skip dates | (none -- no holidays bypass) |
| Pause from | (blank) |
| Notify on post | hello@clearwater.com.au |
| Notify on failure | hello@clearwater.com.au |
| Attachments template | Lease agreement PDF |
Lines:
| # | Item | Description | Account | Qty | Unit cost (ex) | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|
| 1 | (none) | Warehouse rent -- Richmond | 6100 Rent | 1 | 2,200.00 | GST 10% | 2,200.00 |
Save. The system will auto-post a $2,420 bill (2,200 + 220 GST) on 2026-07-01, 2026-08-01, and 2026-09-01.
| Account | Dr | Cr |
| 6100 Rent | 2,200.00 | |
| 1210 GST Paid | 220.00 | |
| 2000 AP | | 2,420.00 |
Step 25.5.8 -- Outgoing Payment to Truckline
Open Supplier payments, click + New Payment.
Header:
| Field | Value |
|---|---|
| Payment number | OP-001 (auto) |
| Supplier | Truckline Logistics |
| Payment date | 2026-08-05 |
| Bank-clear date | 2026-08-05 (same day for EFT) |
| Bank account | 1000 Business Bank Account |
| Payment method | EFT |
| EFT reference | TRUCKLINE-2087 |
| Cheque number (if applicable) | -- |
| Amount | 440.00 |
| Currency | AUD |
| FX rate | 1.0000 |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | Pay TR-2087 in full |
| Attachments | (optional remittance PDF) |
Allocations:
| Bill | Outstanding | Amount applied |
|---|---|---|
| TR-2087 | 440.00 | 440.00 |
| Account | Dr | Cr |
| 2000 AP | 440.00 | |
| 1000 Cash | | 440.00 |
Step 25.5.9 -- Pay Rent (Jul + Aug)
Create two more outgoing payments via Supplier payments. Each one is a full-form entry like Step 25.5.8 -- the table below shows just the differing fields.
| Field | Payment 1 | Payment 2 |
|---|---|---|
| Payment number | OP-002 | OP-003 |
| Supplier | Richmond Property Trust | Richmond Property Trust |
| Payment date | 2026-07-05 | 2026-08-05 |
| Bank-clear date | 2026-07-05 | 2026-08-05 |
| Bank account | 1000 Business Bank Account | 1000 Business Bank Account |
| Payment method | EFT | EFT |
| EFT reference | RPT-RENT-JUL | RPT-RENT-AUG |
| Amount | 2,420.00 | 2,420.00 |
| Allocate to | Rent bill 2026-07-01 | Rent bill 2026-08-01 |
| Internal memo | July rent | August rent |
September rent bill remains unpaid.
Step 25.5.10 -- Batch Payment
Open Batch Payment, click + New Batch.
Header:
| Field | Value |
|---|---|
| Batch number | BATCH-001 (auto) |
| Batch date | 2026-09-05 |
| Bank-clear date | 2026-09-05 |
| Bank account | 1000 Business Bank Account |
| Payment method | EFT (single ABA file output) |
| EFT file format | ABA (Australian Bankers' Association) |
| Bank lodgement reference | CW-Q1-AP-RUN |
| Currency | AUD |
| Internal memo | Q1 month-3 AP run |
| Approval status | Auto-approved |
Selected bills (the picker shows only open AP bills with bank details on file):
| # | Supplier | Bill | Outstanding | Amount applied | BSB | Account |
|---|---|---|---|---|---|---|
| 1 | Aqua Source Springs | INV-AQ-7711 (after SCN-000001) | 2,530.00 | 2,530.00 | 083-004 | 1122 3344 |
| 2 | CityPower | CP-44102 | 240.00 | 240.00 | (BPAY -- excluded from ABA file, posted manually) | -- |
Totals:
| Line | Amount |
|---|---|
| Total selected | 2,770.00 |
| ABA-eligible | 2,530.00 (Aqua Source only) |
| BPAY portion | 240.00 (CityPower) |
| Total batch payment | 2,770.00 |
| Account | Dr | Cr |
| 2000 AP | 2,770.00 | |
| 1000 Cash | | 2,770.00 |
Step 25.5.11 -- Expense Claim (Driver Fuel)
Open Expense Claims, click New claim.
Header:
| Field | Value |
|---|---|
| Claim number | EXP-001 (auto) |
| Employee / Claimant | Sam Driver (selectable because Step 25.4.4 added him) |
| Claim date | 2026-08-20 |
| Period covered | 2026-08-15 -- 2026-08-19 |
| Reimburse to bank account | 1000 Business Bank Account |
| Reimbursement method | EFT to Sam's bank (BSB 062-000 / Acct 1234 5678) |
| Currency | AUD |
| Tax mode | Tax Inclusive (receipts are GST-inclusive) |
| Project / Job | (none) |
| Branch / Department | Operations |
| Internal memo | Weekly delivery fuel claim |
| Attachments | Fuel receipts (3 dockets) |
| Approval status | Pending → Approved (see below) |
Lines (claim by receipt):
| # | Date | Description | Account | Receipt | Tax | Amount (inc tax) |
|---|---|---|---|---|---|---|
| 1 | 2026-08-15 | Fuel @ Shell Richmond -- 28L unleaded | 6700 Vehicle Running Costs | R-9911 | GST 10% | 44.00 |
| 2 | 2026-08-17 | Fuel @ BP Abbotsford -- 18L unleaded | 6700 Vehicle Running Costs | R-9912 | GST 10% | 27.50 |
| 3 | 2026-08-19 | Toll -- CityLink return trip | 6700 Vehicle Running Costs | R-9913 | GST 10% | 16.50 |
Distance (km) × Rate per km. This bypasses the per-receipt tax calc; the system uses the ATO cents-per-km rate.Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 80.00 |
| GST | 8.00 |
| Total reimbursement (inc tax) | 88.00 |
Submit, then open Approvals and approve as the manager. Approval routes through the company's default approval rule (Sam → Manager) -- see Step 25.10 for setting up custom routes.
| Account | Dr | Cr |
| 6700 Vehicle Running Costs | 80.00 | |
| 1210 GST Paid | 8.00 | |
| 1000 Cash | | 88.00 |
Section Snapshot -- after 25.5
| Item | Value |
|---|---|
| AP outstanding | 2,420 (only Sept rent left) |
| Cash | 80,000 - 440 - 4,840 - 2,770 - 88 = 71,862 |
| Inventory (600ml) | 4,600 units, $2,300 |
| GST Paid YTD | 240 + 40 + 20 + 660 - 10 + 8 = 958 |
| Expense accounts so far | Freight 400 - Utilities 220 - Rent 6,600 - Vehicle 80 |
25.6 Sales Workflow
Step 25.6.1 -- Quote → Sales Order → Invoice (Hilton)
Open Quotes & orders, then click New quote.
Header (Quote):
| Field | Value |
|---|---|
| Customer | Hilton Melbourne |
| Quote number | Q-001 (auto) |
| Quote date | 2026-07-03 |
| Valid until | 2026-07-17 (14 days) |
| Customer PO reference | HIL-PO-9921 |
| Sales rep | (your user name) |
| Currency | AUD |
| FX rate | 1.0000 |
| Tax mode | Tax Exclusive |
| Bill-to address | 192 Wellington Pde, East Melbourne VIC 3002 |
| Ship-to address | Loading dock B, 192 Wellington Pde |
| Delivery date | 2026-07-08 |
| Delivery method | Truckline (own driver) |
| Project / Job | Hilton Q3 supply contract |
| Branch / Department | Sales |
| Quote terms | Prices ex GST. Valid 14 days from issue. |
| Internal notes | Aligns with Q3 contract minimum 1,200 bottles/month |
| Customer-facing notes | Thank you for your continued business. |
| Attachments | Q3 contract PDF |
Lines:
| # | Item | Description | Account | Qty | Unit price (ex) | Discount % | Tax | Project | Line total (ex) |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml bottled spring water -- single unit | 4000 Sales | 1,200 | 1.80 | 0 | GST 10% | Hilton Q3 supply contract | 2,160.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 2,160.00 |
| GST | 216.00 |
| Total (inc tax) | 2,376.00 |
Save as Sent.
When Hilton accepts, click Convert to Sales Order (status: Open). Then click Convert to invoice to create INV-001 dated 2026-07-05, due 2026-08-04. The conversion carries every field above forward; only re-confirm the Invoice date and the Online payment toggle (leave Off for the demo unless Stripe is set up).
| Account | Dr | Cr |
| 1100 Accounts Receivable | 2,376.00 | |
| 4000 Sales | | 2,160.00 |
| 2200 GST Collected | | 216.00 |
| 5000 COGS | 600.00 | |
| 1300 Inventory | | 600.00 |
Step 25.6.2 -- Direct Sale Invoice (Cafe Aurora)
Open Invoices, click New invoice. No quote needed -- direct invoice.
Header:
| Field | Value |
|---|---|
| Customer | Cafe Aurora |
| Invoice number | INV-002 (auto) |
| Invoice date | 2026-07-10 |
| Due date | 2026-07-24 (Net 14, auto from terms) |
| Due-date method | From invoice date + customer terms |
| Customer PO reference | -- |
| Sales rep | (your user name) |
| Currency | AUD |
| FX rate | 1.0000 |
| Tax mode | Tax Exclusive |
| Bill-to address | 17 Brunswick St, Fitzroy VIC 3065 |
| Ship-to address | (same as billing) |
| Delivery method | Truckline (own driver) |
| Project / Job | (none) |
| Branch / Department | Sales |
| Online payment enabled | No |
| Stripe payment link | -- |
| Recurring template? | No |
| Customer-facing notes | Pay via EFT to BSB 062-000 / Acct 5566 7788 |
| Internal memo | First Cafe Aurora invoice |
| Attachments | (none) |
Lines:
| # | Item | Description | Account | Qty | Unit price (ex) | Discount % | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml bottled spring water | 4000 Sales | 200 | 1.80 | 0 | GST 10% | 360.00 |
| 2 | Delivery Service | Per-drop metropolitan delivery | 4200 Service Revenue | 1 | 20.00 | 0 | GST 10% | 20.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 380.00 |
| GST | 38.00 |
| Freight | -- (built into Delivery Service line) |
| Total (inc tax) | 418.00 |
| Account | Dr | Cr |
| 1100 AR | 418.00 | |
| 4000 Sales | | 360.00 |
| 4200 Service Revenue | | 20.00 |
| 2200 GST Collected | | 38.00 |
| 5000 COGS | 100.00 | |
| 1300 Inventory | | 100.00 |
Step 25.6.3 -- Mixed Taxable + GST-Free Invoice (Direct Subscribers)
Open Invoices, click New invoice.
Header:
| Field | Value |
|---|---|
| Customer | Direct Subscriber Group |
| Invoice number | INV-003 (auto) |
| Invoice date | 2026-07-15 |
| Due date | 2026-08-14 (Net 30 default; override Prepaid if subscription is paid in advance -- demo uses Net 30) |
| Currency | AUD |
| Tax mode | Tax Exclusive |
| Bill-to address | -- (consumer group, no address) |
| Ship-to address | (assorted -- per-subscriber) |
| Project / Job | (none) |
| Branch / Department | Sales |
| Online payment enabled | No |
| Recurring template? | No (could be -- left manual for the demo) |
| Customer-facing notes | Includes refundable deposit for cooler bottle |
| Internal memo | Aggregated subscriber invoice for week ending 2026-07-15 |
Lines:
| # | Item | Description | Account | Qty | Unit price (ex) | Discount % | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml bottled spring water | 4000 Sales | 50 | 1.80 | 0 | GST 10% | 90.00 |
| 2 | Bottle Deposit | Refundable deposit on returnable cooler bottle | 4200 Service Revenue | 50 | 5.00 | 0 | GST Free | 250.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 340.00 |
| GST | 9.00 (only on the spring-water line) |
| Total (inc tax) | 349.00 |
| Account | Dr | Cr |
| 1100 AR | 349.00 | |
| 4000 Sales | | 90.00 |
| 4200 Service Revenue | | 250.00 |
| 2200 GST Collected | | 9.00 |
| 5000 COGS | 25.00 | |
| 1300 Inventory | | 25.00 |
Step 25.6.4 -- Multi-Line Invoice (Hilton, August)
Open Invoices, click New invoice.
Header:
| Field | Value |
|---|---|
| Customer | Hilton Melbourne |
| Invoice number | INV-004 (auto) |
| Invoice date | 2026-08-12 |
| Due date | 2026-09-11 (Net 30) |
| Customer PO reference | HIL-PO-9988 |
| Sales rep | (your user name) |
| Currency | AUD |
| Tax mode | Tax Exclusive |
| Bill-to address | 192 Wellington Pde, East Melbourne VIC 3002 |
| Ship-to address | Loading dock B, 192 Wellington Pde |
| Delivery date | 2026-08-13 |
| Project / Job | Hilton Q3 supply contract |
| Branch / Department | Sales |
| Online payment enabled | No |
| Apply customer deposit? | No (the $1,100 deposit posted in Step 25.6.8 stays on the BS) |
| Customer-facing notes | August supply, contracted quantity |
| Internal memo | Month 2 of Q3 contract |
Lines:
| # | Item | Description | Account | Qty | Unit price (ex) | Discount % | Tax | Project | Line total (ex) |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | 600ml bottled spring water | 4000 Sales | 1,000 | 1.80 | 0 | GST 10% | Hilton Q3 supply contract | 1,800.00 |
| 2 | Delivery Service | Per-drop metropolitan delivery (10 drops) | 4200 Service Revenue | 10 | 20.00 | 0 | GST 10% | Hilton Q3 supply contract | 200.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 2,000.00 |
| GST | 200.00 |
| Total (inc tax) | 2,200.00 |
| Account | Dr | Cr |
| 1100 AR | 2,200.00 | |
| 4000 Sales | | 1,800.00 |
| 4200 Service Revenue | | 200.00 |
| 2200 GST Collected | | 200.00 |
| 5000 COGS | 500.00 | |
| 1300 Inventory | | 500.00 |
Step 25.6.5 -- Credit Note for Damaged Stock
50 of the 200 bottles on INV-002 were damaged in transit. Open Credit Notes, click + New Credit Note.
Header:
| Field | Value |
|---|---|
| Customer | Cafe Aurora |
| Credit note number | CN-001 (auto) |
| Date | 2026-07-21 |
| Allocate against | INV-002 |
| Reason | Damaged in transit |
| Restock to inventory? | Yes (the bottles are returnable -- they reverse back into stock) |
| Affects inventory? | Yes |
| Currency | AUD |
| Tax mode | Tax Exclusive |
| Project / Job | (none) |
| Branch / Department | Sales |
| Customer-facing notes | Goodwill credit -- damage reported on delivery |
| Internal memo | Driver Sam logged damage at drop-off |
| Attachments | Photo from Cafe Aurora |
Lines:
| # | Item | Description | Account | Qty | Unit price (ex) | Tax | Line total (ex) |
|---|---|---|---|---|---|---|---|
| 1 | 600ml Spring Water | Damaged bottles returned | 4000 Sales | 50 | 1.80 | GST 10% | 90.00 |
Totals:
| Line | Amount |
|---|---|
| Subtotal (ex tax) | 90.00 |
| GST | 9.00 |
| Total credit (inc tax) | 99.00 |
| Account | Dr | Cr |
| 4000 Sales | 90.00 | |
| 2200 GST Collected | 9.00 | |
| 1100 AR | | 99.00 |
| 1300 Inventory | 25.00 | |
| 5000 COGS | | 25.00 |
After allocation, INV-002 outstanding = 418 - 99 = 319.00.
Step 25.6.6 -- Receive Full Payment from Cafe Aurora
Open Customer payments, click + New Payment.
Header:
| Field | Value |
|---|---|
| Payment number | IP-001 (auto) |
| Customer | Cafe Aurora |
| Payment date | 2026-07-22 |
| Bank-clear date | 2026-07-22 (same day for EFT) |
| Bank account | 1000 Business Bank Account |
| Payment method | EFT |
| Reference (their) | CAFE-AURORA-INV002 |
| Amount | 319.00 |
| Currency | AUD |
| FX rate | 1.0000 |
| Project / Job | (none) |
| Internal memo | Cafe Aurora paid INV-002 net of CN-001 |
| Attachments | (optional EFT remittance email) |
Allocations:
| Invoice | Outstanding | Amount applied |
|---|---|---|
| INV-002 (after CN-001) | 319.00 | 319.00 |
| Account | Dr | Cr |
| 1000 Cash | 319.00 | |
| 1100 AR | | 319.00 |
Step 25.6.7 -- Receive Partial Payment from Hilton
Open Customer payments, click + New Payment.
Header:
| Field | Value |
|---|---|
| Payment number | IP-002 (auto) |
| Customer | Hilton Melbourne |
| Payment date | 2026-07-25 |
| Bank-clear date | 2026-07-25 |
| Bank account | 1000 Business Bank Account |
| Payment method | EFT |
| Reference (their) | HIL-PAY-44721 |
| Amount | 1,500.00 |
| Currency | AUD |
| Project / Job | Hilton Q3 supply contract |
| Internal memo | Partial payment of INV-001 -- balance due by 2026-08-04 |
Allocations:
| Invoice | Outstanding | Amount applied | Remaining after |
|---|---|---|---|
| INV-001 | 2,376.00 | 1,500.00 | 876.00 |
INV-001 outstanding after = 2,376 - 1,500 = 876.00.
Step 25.6.8 -- Customer Prepayment via Customer Deposits
Hilton sends $1,100 in advance for a future order. Use the dedicated Customer Deposits feature -- not a Sale Invoice (no invoice yet) and not a Receive Money (which would lose the liability tracking and the future revenue-recognition workflow). Open Customer Deposits and click New deposit.
| Field | Value |
|---|---|
| Deposit number | CD-0001 (auto) |
| Date | 2026-08-15 |
| Customer | Hilton Melbourne |
| Bank account | 1000 Business Bank Account |
| Liability account | 2520 Customer Deposits (system-keyed -- can't change) |
| Amount | 1,100.00 |
| Currency | AUD |
| FX rate | 1.0000 |
| Payment method | EFT |
| Reference | Advance for Q3 supply |
| Project / Job | Hilton Q3 supply contract |
| Branch / Department | Sales |
| Release schedule | (none yet -- create later via "+ Build Schedule") |
| Internal memo | Advance against future Sept invoice |
| Attachments | Hilton remittance email |
Save. The deposit appears in the list with status Open and a generated Deposit # (e.g. CD-0001). Click it to land on /app/customer-deposits/:id -- you'll see the original journal, an empty Releases table, and a + Build Schedule action you can use later if Hilton wants the deposit released to revenue on a fixed cadence.
| Account | Dr | Cr |
| 1000 Cash | 1,100.00 | |
| 2520 Customer Deposits | | 1,100.00 |
Section Snapshot -- after 25.6
| Item | Value |
|---|---|
| 4000 Sales (net of CN) | 2,160 + 360 + 90 + 1,800 - 90 = 4,320 |
| 4200 Service Revenue | 20 + 250 + 200 = 470 |
| 2200 GST Collected | 216 + 38 + 9 + 200 - 9 = 454 |
| 5000 COGS (net) | 600 + 100 + 25 + 500 - 25 = 1,200 |
| 1300 Inventory | 2,300 - 1,200 = 1,100 (= 2,200 units × $0.50) |
| 1100 AR open | 876 + 0 + 349 + 2,200 = 3,425 |
| 1000 Cash | 71,862 + 319 + 1,500 + 1,100 = 74,781 |
| 2520 Customer Deposits | 1,100 |
25.7 Banking
Step 25.7.1 -- Import a Bank Statement
Open Banking → Import statement and fill in:
| Field | Value |
|---|---|
| Bank Account | 1000 Business Bank Account |
| Statement Date | 2026-09-30 |
| Opening Balance | 0.00 (the first line below carries the opening balance) |
| Closing Balance | 41806.00 |
The importer reads CSV, OFX and QFX files. This file has a header row and the columns Date, Description, Reference, Amount; amounts are signed (money out is negative). A bank's own export works too: the preview shows the columns it found, and you can change them. Save this as clearwater-q1.csv and upload it:
date,description,reference,amount
2026-07-01,Opening balance,,80000.00
2026-07-05,RPT-RENT JUL,,-2420.00
2026-07-15,VAN PURCHASE - DEALER,,-33000.00
2026-07-22,CAFE AURORA PAY,,319.00
2026-07-25,HILTON PAY PARTIAL,,1500.00
2026-08-05,TRUCKLINE LOGISTICS,,-440.00
2026-08-05,RPT-RENT AUG,,-2420.00
2026-08-15,HILTON DEPOSIT,,1100.00
2026-08-20,DRIVER FUEL REIMB,,-88.00
2026-09-05,BATCH AP RUN,,-2770.00
2026-09-25,BANK MTHLY FEE,,-25.00
2026-09-30,INTEREST CREDIT,,50.00The preview should show 12 transactions and confirm that the opening balance plus the transactions equals the closing balance.
Step 25.7.2 -- Reconcile Matched Lines
Open Bank Reconciliation. The system should auto-suggest matches for:
| Statement Line | App Transaction |
|---|---|
| RPT-RENT JUL -2,420 | Outgoing Payment to Richmond Property Trust 2026-07-05 |
| RPT-RENT AUG -2,420 | Outgoing Payment to Richmond Property Trust 2026-08-05 |
| CAFE AURORA PAY +319 | Incoming Payment from Cafe Aurora 2026-07-22 |
| HILTON PAY PARTIAL +1,500 | Incoming Payment from Hilton 2026-07-25 |
| TRUCKLINE LOGISTICS -440 | Outgoing Payment to Truckline 2026-08-05 |
| HILTON DEPOSIT +1,100 | Customer Deposit CD-0001 (2026-08-15) |
| DRIVER FUEL REIMB -88 | Expense Claim payout 2026-08-20 |
| BATCH AP RUN -2,770 | Batch Payment 2026-09-05 |
Confirm each match.
Step 25.7.3 -- Create New Transactions for Bank-Only Lines
Two statement lines have no matching app transaction. Create them on the spot:
Bank fee -- click Create Spend Money from the BANK MTHLY FEE row:
| Field | Value |
|---|---|
| Spend Money number | SM-001 (auto) |
| Date | 2026-09-25 |
| Bank account | 1000 Business Bank Account |
| Payee | (text) "CityBank Monthly Fee" -- no contact required |
| Account | 6020 Bank Fees |
| Amount | 25.00 |
| Currency | AUD |
| Tax | BAS Excluded |
| Project / Job | (none) |
| Branch / Department | (none) |
| Memo | September monthly account-keeping fee |
| Recurring template? | Optional -- you can promote to a monthly recurring after this entry |
| Attachments | (none) |
Interest income -- click Create Receive Money from the INTEREST CREDIT row:
| Field | Value |
|---|---|
| Receive Money number | RM-001 (auto) |
| Date | 2026-09-30 |
| Bank account | 1000 Business Bank Account |
| Payer | (text) "CityBank Interest" -- no contact required |
| Account | 4400 Interest Income |
| Amount | 50.00 |
| Currency | AUD |
| Tax | BAS Excluded |
| Project / Job | (none) |
| Memo | Q1 interest credit on operating account |
| Attachments | (none) |
| Account | Dr | Cr |
| 6020 Bank Fees | 25.00 | |
| 1000 Cash | | 25.00 |
| 1000 Cash | 50.00 | |
| 4400 Interest Income | | 50.00 |
Step 25.7.4 -- Add a Matching Rule for Future Bank Fees
From Banking → Bank rules, click New rule.
| Field | Value |
|---|---|
| Rule name | Auto-categorise CityBank monthly fee |
| Priority | 100 (lower number = higher priority) |
| Active | Yes |
| Scope | Account: 1000 Business Bank Account only |
| Direction | Money out (debits only) |
| Description contains | BANK MTHLY FEE |
| Description regex | (alternative -- leave blank) |
| Amount range | $20.00 -- $30.00 |
| Counterparty contains | -- |
| Action | Create Spend Money (auto-post) |
| Account | 6020 Bank Fees |
| Tax | BAS Excluded |
| Memo template | Monthly account fee -- {{statement_date}} |
| Apply retroactively | No (the September fee is already booked) |
Future months will auto-categorise the bank fee with no manual entry.
Step 25.7.5 -- Confirm Bank vs GL Match
After all lines are matched (except the van -- see Step 25.8.2), the bank reconciliation page should show:
| Indicator | Expected |
|---|---|
| Statement closing balance | 41,806.00 |
| Cash GL closing balance | 41,806.00 |
| Difference | 0.00 |
25.8 Adjustments and Period-End
Step 25.8.1 -- Accrued September Electricity
CityPower's September bill hasn't arrived yet, but you used $240 of electricity. Accrue it. Open Manual journals, click + New Journal Entry.
Header:
| Field | Value |
|---|---|
| Journal number | JNL-002 (auto -- OPEN-001 was JNL-001) |
| Date | 2026-09-30 |
| Reference | ACC-001 |
| Source | Manual -- period-end accrual |
| Narration | Accrue Sept electricity (estimated) |
| Currency | AUD |
| Project / Cost centre | (none) |
| Branch / Department | Operations |
| Recurring template? | Optional -- you could promote to a quarterly accrual template |
| Auto-reverse on date | 2026-10-01 (the actual CityPower bill in Oct will replace this estimate) |
| Attachments | Estimated meter reading photo |
| Tags | accrual, period-end, fy27-q1 |
Lines:
| # | Account | Description | Debit | Credit | Tax |
|---|---|---|---|---|---|
| 1 | 6080 Utilities | September electricity (estimated) | 240.00 | BAS Excluded | |
| 2 | 2300 Accruals | Reverses on 2026-10-01 | 240.00 | BAS Excluded |
Step 25.8.2 -- Register the Delivery Van as a Fixed Asset
Open Fixed Assets → + New Asset (menu Fixed assets → Assets).
| Field | Value |
|---|---|
| Asset code | FA-001 (auto) |
| Asset name | Delivery Van -- Iveco Daily |
| Asset type | Vehicles |
| Asset tag / Serial / VIN | VIN: ZCFC359000Z123456 |
| Registration plate | 1AB-2CD (VIC) |
| Location | Richmond Warehouse |
| Custodian | Sam Driver |
| Condition | Excellent (new) |
| Supplier | Iveco Melbourne (created ad-hoc as a one-off contact, not a saved supplier) |
| Acquisition date | 2026-07-15 |
| In-service date | 2026-07-15 |
| Depreciation start date | 2026-07-15 (matches in-service date; full-month convention so July gets a full $500) |
| Cost (ex GST) | 30,000.00 |
| GST | 3,000.00 |
| Total cost (inc GST) | 33,000.00 |
| Salvage / Residual value | 0.00 |
| Useful life | 5 years (60 months) |
| Depreciation method | Straight-Line |
| Tax depreciation method | Diminishing Value (override for ATO tax-depreciation report) |
| Tax effective life | 8 years (ATO Vehicles - Light Commercial) |
| Low-value pool | No (over the $1,000 threshold) |
| Asset GL account | 1500 Fixed Assets - Vehicles |
| Accumulated depreciation account | 1800 Accumulated Depreciation |
| Depreciation expense account | 7500 Depreciation Expense |
| Paid from | 1000 Business Bank Account |
| Warranty expiry | 2029-07-14 (3-year manufacturer warranty) |
| Insurance policy | (link to policy doc -- optional) |
| Status | Active |
| Tags | vehicle, delivery, q1-fy27 |
| Attachments | Tax invoice from Iveco Melbourne |
| Account | Dr | Cr |
| 1500 Fixed Assets - Vehicles | 30,000.00 | |
| 1210 GST Paid | 3,000.00 | |
| 1000 Cash | | 33,000.00 |
This creates the matching bank line for the 2026-07-15 statement entry from Step 25.7.1 -- go back to reconciliation and match it.
Step 25.8.3 -- Run Depreciation for Q1
Open Fixed Assets → Run depreciation (menu Fixed assets → Run depreciation).
Run-setup form (one run per month):
| Field | Value |
|---|---|
| Run number | DEP-RUN-001 / 002 / 003 (auto, one per month) |
| Period | 2026-07 / 2026-08 / 2026-09 |
| Depreciation method scope | All methods |
| Asset selection | All active assets (currently only FA-001) |
| Asset pool selection | (none in this run) |
| Calculation basis | Book (straight-line per asset) |
| Recalc-from-scratch | No (incremental from last run) |
| Posting mode | Draft → Review → Post |
| Post date | Last day of period (e.g. 2026-07-31) |
| Notes | Q1 monthly depreciation |
Each run posts:
| Account | Dr | Cr |
|---|---|---|
| 7500 Depreciation Expense | 500.00 | |
| 1800 Accumulated Depreciation | 500.00 |
After three runs: total Dr 7500 = 1,500.00 / Cr 1800 = 1,500.00.
Calculation: $30,000 ÷ 5 years ÷ 12 months = $500/month.
Step 25.8.4 -- Lock the Period
Return to Accounting → Lock dates & periods and open FY27 Q1. Click Lock Period and fill the dialog:
| Field | Value |
|---|---|
| Period | FY27 Q1 (2026-07-01 -- 2026-09-30) |
| New status | Locked |
| Soft-close date | 2026-10-15 (allows late adjustments by Admin until this date) |
| Hard-lock date | 2026-10-31 (no changes after this, even by Admin) |
| Lock reason / memo | Q1 reports finalised, BAS calculated |
| Who can unlock? | Admin only |
| Run pre-lock balance check? | Yes (refuses to lock if Trial Balance is out) |
| Notify roles on lock | Bookkeeper, Accountant |
The system runs a final balance check and refuses to lock if any accounts are out of balance.
25.9 Reporting and Validation
This is the audit step. Each report below should match the figures shown.
Step 25.9.1 -- Trial Balance
Open Trial Balance.
Report parameters:
| Field | Value |
|---|---|
| As-at date | 2026-09-30 |
| Basis | Accrual |
| Currency | AUD (company default) |
| Branch / Department filter | All |
| Project filter | All |
| Account categories | All (Assets, Liabilities, Equity, Income, Expenses, Contra-Asset, Tax) |
| Include zero-balance accounts | No |
| Group by | Category |
| Show YTD movement | No |
| Comparison period | None |
| Export format | PDF / Excel / CSV |
| Account | Dr | Cr |
|---|---|---|
| 1000 Business Bank Account | 41,806.00 | |
| 1100 Accounts Receivable | 3,425.00 | |
| 1210 GST Paid on Purchases | 3,958.00 | |
| 1300 Inventory | 1,100.00 | |
| 1500 Fixed Assets - Vehicles | 30,000.00 | |
| 1800 Accumulated Depreciation | 1,500.00 | |
| 2000 Accounts Payable | 2,420.00 | |
| 2200 GST Collected on Sales | 454.00 | |
| 2300 Accruals | 240.00 | |
| 2520 Customer Deposits | 1,100.00 | |
| 2800 Business Loan | 40,000.00 | |
| 3000 Owner's Capital | 40,000.00 | |
| 4000 Sales | 4,320.00 | |
| 4200 Service Revenue | 470.00 | |
| 4400 Interest Income | 50.00 | |
| 5000 Cost of Goods Sold | 1,200.00 | |
| 5100 Freight & Courier | 400.00 | |
| 6020 Bank Fees | 25.00 | |
| 6080 Utilities | 460.00 | |
| 6100 Rent | 6,600.00 | |
| 6700 Vehicle Running Costs | 80.00 | |
| 7500 Depreciation Expense | 1,500.00 | |
| TOTAL | 90,554.00 | 90,554.00 |
Step 25.9.2 -- Profit & Loss
Open Profit & Loss.
Report parameters:
| Field | Value |
|---|---|
| Period start | 2026-07-01 |
| Period end | 2026-09-30 |
| Basis | Accrual |
| Currency | AUD |
| Branch / Department filter | All |
| Project filter | All |
| Comparison period | None (alternatives: Prior Year, Prior Period, Budget) |
| Comparison type | -- |
| Show % of revenue column | No |
| Round to | 1 (no rounding) |
| Group revenue / expenses by | Category |
| Include zero-balance accounts | No |
| Export format | PDF / Excel / CSV |
| Line | Amount |
|---|---|
| Revenue | |
| 4000 Sales | 4,320.00 |
| 4200 Service Revenue | 470.00 |
| 4400 Interest Income | 50.00 |
| Total Revenue | 4,840.00 |
| Cost of Sales | |
| 5000 Cost of Goods Sold | 1,200.00 |
| 5100 Freight & Courier | 400.00 |
| Gross Profit | 3,240.00 |
| Operating Expenses | |
| 6020 Bank Fees | 25.00 |
| 6080 Utilities | 460.00 |
| 6100 Rent | 6,600.00 |
| 6700 Vehicle Running Costs | 80.00 |
| 7500 Depreciation Expense | 1,500.00 |
| Total Operating Expenses | 8,665.00 |
| Net Profit / (Loss) | (5,425.00) |
Step 25.9.3 -- Balance Sheet
Open Balance Sheet.
Report parameters:
| Field | Value |
|---|---|
| As-at date | 2026-09-30 |
| Basis | Accrual |
| Currency | AUD |
| Branch / Department filter | All |
| Project filter | All |
| Comparison date | None (alternative: prior year-end 2026-06-30) |
| Show net-of-depreciation lines | Yes |
| Group by | Category → Sub-category |
| Include zero-balance accounts | No |
| Round to | 1 |
| Export format | PDF / Excel / CSV |
| Line | Amount |
|---|---|
| Assets | |
| 1000 Business Bank Account | 41,806.00 |
| 1100 Accounts Receivable | 3,425.00 |
| 1210 GST Paid (BAS receivable) | 3,958.00 |
| 1300 Inventory | 1,100.00 |
| 1500 Fixed Assets - Vehicles | 30,000.00 |
| 1800 Less: Accumulated Depreciation | (1,500.00) |
| Total Assets | 78,789.00 |
| Liabilities | |
| 2000 Accounts Payable | 2,420.00 |
| 2200 GST Collected | 454.00 |
| 2300 Accruals | 240.00 |
| 2520 Customer Deposits | 1,100.00 |
| 2800 Business Loan | 40,000.00 |
| Total Liabilities | 44,214.00 |
| Equity | |
| 3000 Owner's Capital | 40,000.00 |
| Current Year Earnings | (5,425.00) |
| Total Equity | 34,575.00 |
| Total Liabilities + Equity | 78,789.00 |
Step 25.9.4 -- Cash Flow
Open Cash Flow.
Report parameters:
| Field | Value |
|---|---|
| Period start | 2026-07-01 |
| Period end | 2026-09-30 |
| Method | Indirect (start from net profit, add back non-cash) |
| Basis | Accrual |
| Currency | AUD |
| Branch / Department filter | All |
| Comparison period | None |
| Group by | Operating / Investing / Financing |
| Show monthly columns | No |
| Export format | PDF / Excel / CSV |
The closing cash position should be 41,806.00, matching the bank statement and the GL.
Step 25.9.5 -- AR Ageing
Open Aged receivables.
Report parameters:
| Field | Value |
|---|---|
| As-at date | 2026-09-30 |
| Type | Receivable |
| Bucket size | 30 days |
| Bucket count | 4 (Current, 31-60, 61-90, 90+) |
| Customer filter | All |
| Currency | AUD |
| Branch / Department filter | All |
| Group by | Customer |
| Include credit balances | Yes |
| Include zero-balance customers | No |
| Show invoice detail | Optional toggle |
| Export format | CSV |
| Customer | Current (0-30) | 31-60 | 61-90 | 90+ | Total |
|---|---|---|---|---|---|
| Hilton Melbourne (INV-001 partial + INV-004) | 2,200.00 | 876.00 | 0 | 0 | 3,076.00 |
| Direct Subscriber Group (INV-003) | 0 | 349.00 | 0 | 0 | 349.00 |
| Total AR | 3,425.00 |
Step 25.9.6 -- AP Ageing
Open Aged payables.
Report parameters:
| Field | Value |
|---|---|
| As-at date | 2026-09-30 |
| Type | Payable |
| Bucket size | 30 days |
| Bucket count | 4 (Current, 31-60, 61-90, 90+) |
| Supplier filter | All |
| Currency | AUD |
| Branch / Department filter | All |
| Group by | Supplier |
| Include debit balances | Yes |
| Include zero-balance suppliers | No |
| Show bill detail | Optional toggle |
| Export format | CSV |
| Supplier | Current | 31-60 | Total |
|---|---|---|---|
| Richmond Property Trust (Sept rent) | 2,420.00 | 0 | 2,420.00 |
| Total AP | 2,420.00 |
Step 25.9.7 -- GST / BAS Report
Open Tax > GST & BAS.
Report parameters:
| Field | Value |
|---|---|
| Period | Quarter (alternative: Custom Dates) |
| Quarter | Q1 (Jul-Sep) |
| Financial Year | The one running Jul 2026 to Jun 2027 |
| GST basis | Accrual, chosen when the company was created (Settings → Company settings to check) |
| Output | Print, or CSV of the transactions behind the figures |
Click Generate. NeatSum calculates the figures for you to review; it does not lodge them. Click Save as BAS and finalise it (Finalise asks you to confirm you have reviewed the figures), lodge it through the ATO's Online services for business or your tax agent, then click Mark lodged to keep the record.
| Line | Amount |
|---|---|
| GST Collected (sales) | 454.00 |
| GST Paid (purchases + assets) | 3,958.00 |
| Net BAS Position | (3,504.00) refund |
The large refund is driven by the $3,000 GST credit on the van. Reconcile control accounts:
| Control Account | GL Balance | BAS Report |
|---|---|---|
| 2200 GST Collected | 454.00 Cr | 454.00 |
| 1210 GST Paid | 3,958.00 Dr | 3,958.00 |
Both should match exactly.
Step 25.9.8 -- Customer Statement
Open Statements.
Statement parameters:
| Field | Value |
|---|---|
| Type | Customer Statement |
| Customer | Hilton Melbourne |
| From | 2026-07-01 |
| To | 2026-09-30 |
| Output | Print (or save as PDF from the print dialog), or CSV |
Where emailing is turned on for your company, Email on a customer statement sends it to the customer with the PDF attached. Where it is not, NeatSum does not email statements: print or save it, and send it to the customer yourself.
It should show:
| Doc | Date | Amount | Outstanding |
|---|---|---|---|
| INV-001 | 2026-07-05 | 2,376.00 | 876.00 |
| Payment | 2026-07-25 | (1,500.00) | -- |
| INV-004 | 2026-08-12 | 2,200.00 | 2,200.00 |
| Hilton total open | 3,076.00 |
(Note: the $1,100 customer deposit is not on the statement -- it sits on the Balance Sheet as a liability.)
Step 25.9.9 -- Audit Trail
Open the Audit Trail (menu Settings → Audit trail).
Filter parameters:
| Field | Value |
|---|---|
| Date range | 2026-07-01 -- 2026-09-30 (or "Today" for the live demo session) |
| User filter | All |
| Action type | All (Create / Update / Delete / Post / Lock / Login) |
| Entity type | All (or filter to: Journal, Invoice, Bill, Payment, Asset, Period) |
| Document number contains | -- |
| Severity | All |
| Group by | Date |
| Export format | CSV (audit exports are CSV-only by design) |
Confirm at least three recent entries -- a journal post, an invoice creation, and a payment -- each with timestamp and your user ID.
Step 25.9.10 -- Master Validation Table
Single source of truth for self-checking. Every figure here must match the corresponding report.
| # | Account / Metric | Source | Expected |
|---|---|---|---|
| 1 | Trial Balance Dr = Cr | TB report | 90,554.00 = 90,554.00 |
| 2 | Net Profit / (Loss) | P&L | (5,425.00) |
| 3 | Total Assets | Balance Sheet | 78,789.00 |
| 4 | Total L + E | Balance Sheet | 78,789.00 |
| 5 | Closing Cash | Cash Flow | 41,806.00 |
| 6 | Closing Cash | Bank statement line 12 | 41,806.00 |
| 7 | Total AR | Aged receivables | 3,425.00 |
| 8 | Total AP | Aged payables | 2,420.00 |
| 9 | GST Collected | BAS | 454.00 |
| 10 | GST Paid | BAS | 3,958.00 |
| 11 | Net BAS (refund) | BAS | (3,504.00) |
| 12 | Inventory units (600ml) | Stock Movements | 2,200 |
| 13 | Inventory value | Balance Sheet | 1,100.00 |
| 14 | Fixed Asset NBV | BS (1500 - 1800) | 28,500.00 |
| 15 | Customer Deposits | Balance Sheet | 1,100.00 |
| 16 | Equity | Balance Sheet | 34,575.00 |
| 17* | Wages YTD (if Step 25.10 pay runs were processed) | P&L 7000 Wages | 1,140.00 × N pay runs |
| 18* | Super payable YTD (if Step 25.10 pay runs were processed) | BS 2220 Super Payable | 136.80 × N pay runs |
| 19* | PAYG payable YTD (if Step 25.10 pay runs were processed) | BS 2210 PAYG Payable | 184.00 × N pay runs |
\* Rows 17-19 are only present if you completed the optional payroll walkthrough in Step 25.10. They sit outside the Step 25.1-Step 25.9 core narrative.
If every row matches, Clear Water Pty Ltd is fully audited end-to-end.
25.10 Optional Advanced Modules
These were not part of the core narrative but the app supports them in full. The Payroll module gets a full 4-step walkthrough below because it ties directly to the employee you set up in Step 25.4.4. The other modules get a short field table each so you know what to fill rather than guess.
Step 25.10.1 -- Configure Payroll Settings (one-time)
Open Payroll Settings. Six account-mapping fields are mandatory before a pay run can post -- the Run Pay button stays disabled until they're set.
General
| Field | Value |
|---|---|
| Default pay frequency | Weekly |
| Standard hours per week | 38 |
| Super guarantee rate (%) | 12 |
| Country | au |
| Region / State | vic |
| Financial year end | June |
Account mapping (mandatory -- COA codes from Step 25.3.2)
| Field | Value |
|---|---|
| Wages expense account | 7000 Wages & Salaries (add this to COA if missing -- category Expenses) |
| Super expense account | 7010 Superannuation Expense (add to COA -- category Expenses) |
| PAYG payable | 2210 PAYG Withholding Payable (add to COA -- category Liabilities) |
| Super payable | 2220 Superannuation Payable (add to COA -- category Liabilities) |
| Wages payable (clearing) | 2230 Wages Payable (add to COA -- category Liabilities) |
| Bank account | 1000 Business Bank Account |
Compliance
| Field | Value |
|---|---|
| STP lodgement | Not supported -- lodge through your own STP software or agent (Step 25.10.4) |
| WPN / ABN | 12 345 678 901 (from Step 25.3.1) |
| Public holidays | AU - VIC (auto-loaded from the public-holiday seed) |
Step 25.10.2 -- Run a Pay Run for Sam Driver
Open Pay Runs, click + New Pay Run.
Header:
| Field | Value |
|---|---|
| Pay run number | PR-001 (auto) |
| Pay frequency | Weekly |
| Period start | 2026-07-06 |
| Period end | 2026-07-12 |
| Pay date | 2026-07-15 |
| Bank account | 1000 Business Bank Account |
| Posting mode | Draft → Review → Post |
| Notes | First pay run -- Sam Driver only |
| STP lodgement | Not supported -- lodge separately (see Step 25.10.4) |
Employee selection: tick Sam Driver (the only employee). The system auto-creates a pay-run line per employee:
Per-employee pay-run line (Sam Driver):
| Field | Value |
|---|---|
| Employee | Sam Driver |
| Hours -- ordinary | 38 |
| Hours -- overtime | 0 |
| Hours -- public holiday | 0 |
| Allowances -- per pay | 0.00 |
| Deductions -- per pay | 0.00 |
| Reimbursements (from claim feed) | 0.00 |
| Pay rate (from employee record) | $30.00/hr |
| Gross ordinary pay (38 × $30.00) | 1,140.00 |
| Tax-free threshold claimed? | Yes |
| PAYG withholding | 184.00 |
| Super contribution (12%) | 136.80 |
| Net pay | 956.00 |
| Disbursement BSB / Account | 062-000 / 1234 5678 (from employee record) |
Click Post Pay Run.
Step 25.10.3 -- Expected GL Impact (per pay run)
| Account | Dr | Cr |
|---|---|---|
| 7000 Wages & Salaries | 1,140.00 | |
| 7010 Superannuation Expense | 136.80 | |
| 2210 PAYG Withholding Payable | 184.00 | |
| 2220 Superannuation Payable | 136.80 | |
| 1000 Business Bank Account | 956.00 |
Step 25.10.4 -- STP Lodgement
NeatSum does not lodge Single Touch Payroll to the ATO. Nothing is transmitted, and no lodgement receipt is stored against a pay run. Earlier versions of this guide described a button that sent pay events and recorded what came back; it was never built.
STP lodgement is due on or before each payday, so if you pay employees you must lodge each pay event yourself, through STP-enabled software or a registered agent. What NeatSum gives you for that:
| What you get here | Where |
|---|---|
| Gross, PAYG withheld and super per employee | Pay run detail, Step 25.10.2 |
| Payslips | Pay run detail, per employee |
| PAYG Withholding Payable balance for your BAS | 2210, see Step 25.10.3 |
| Super Payable balance to pay through your clearing house | 2220 |
The journal a finalised pay run posts is real and correct: it is the transmission to the ATO that does not happen.
Other Modules -- Quick Reference
The remaining advanced modules each get a single-form field table. Each one is one screen on the live app.
Projects -- Open Projects, click New project.
| Field | Value |
|---|---|
| Project code | PROJ-001 (auto) |
| Project name | Hilton Q3 supply contract |
| Customer | Hilton Melbourne |
| Status | Active |
| Start date | 2026-07-01 |
| End date | 2026-09-30 |
| Budgeted revenue | 6,000.00 |
| Budgeted cost | 1,200.00 |
| Project manager | (your user) |
| Default project tag for new docs | Yes |
After saving, retroactively tag INV-001 and INV-004 to this project (open each invoice → Project field). Log a timesheet entry: open Timesheet, click New entry:
| Field | Value |
|---|---|
| Employee | Sam Driver |
| Date | 2026-07-08 |
| Project | Hilton Q3 supply contract |
| Hours | 4.0 |
| Activity | Delivery |
| Billable? | No (cost-only -- delivery is per-drop billed) |
| Notes | First Hilton drop -- 1,200 bottles unloaded |
The WIP report at the bottom of the project page shows actual revenue, actual cost (including timesheet × pay rate), and project margin.
Budgets -- Open Budgeting, click + New Budget.
| Field | Value |
|---|---|
| Budget name | FY27 Q1 Operating Budget |
| Period type | Quarterly |
| Period start | 2026-07-01 |
| Period end | 2026-09-30 |
| Basis | Account-level |
| Compare against | Actual |
| Currency | AUD |
| Branch / Department | All |
Budget lines:
| Account | Q1 Budget |
|---|---|
| 4000 Sales | 8,000.00 |
| 6100 Rent | 6,600.00 |
| 6080 Utilities | 600.00 |
| 7500 Depreciation Expense | 1,500.00 |
Run Budget vs Actual -- you'll see sales 46% under budget (4,320 / 8,000), rent on target, depreciation on target.
Approvals & Roles -- Open Settings → Team (users & roles) → Roles, click + New Role.
| Field | Value |
|---|---|
| Role name | Sales Clerk |
| Description | Front-line invoicing role -- can create invoices and quotes only |
| Permissions | sale_invoice:create, sale_invoice:read, contact:read, item:read |
| Inherits from | (none -- bottom-of-stack role) |
| Default for new users | No |
Then Settings → Approval rules, click New rule:
| Field | Value |
|---|---|
| Rule name | High-value PO approval |
| Document type | Purchase Order |
| Trigger | Amount ≥ $1,000.00 |
| Routes to | Role: Manager (approve), then Admin (escalation) |
| Notification channel | Email + in-app inbox |
| Auto-approve fallback | After 48h with no decision, escalate to Admin |
| Active | Yes |
Tax depreciation pools -- Open Fixed assets → Tax depreciation pools, click + New Pool.
| Field | Value |
|---|---|
| Pool name | Low Value Pool |
| Pool type | Low Value Pool (ATO) |
| Threshold | $1,000.00 (per-asset cap) |
| First-year rate (%) | 18.75 |
| Subsequent-year rate (%) | 37.5 |
| Calculation method | Diminishing Value |
| Asset GL account | 1510 Low-Value Pool Assets |
| Accumulated depreciation account | 1810 Pool Accumulated Depreciation |
| Depreciation expense account | 7510 Pool Depreciation Expense |
Then add any sub-$1,000 asset (e.g. a $750 office printer) to demonstrate ATO low-value pooling.
AI Copilot -- Click the AI Assistant (bottom-right of any page).
| Field | Value |
|---|---|
| Conversation mode | Read + Write (alternative: Read-only) |
| Allowed tools | Reports, Contacts, Items, Invoices, Bills, Journals |
| Approval required for | Any tool that creates or updates records |
| Context window | Current company only |
| Audit trail | Every tool call is logged to /app/audit/ai |
Ask: "What's my AR ageing?" or "Draft an invoice for Hilton for 500 bottles". Watch the assistant pull live data and propose actions for you to approve.
Recurring -- continued -- The rent template from Step 25.5.7 keeps auto-posting on the 1st of each month for the rest of FY27. Confirm by opening Recurring → execution log:
| Field | Value |
|---|---|
| Filter status | All |
| Filter template | Monthly Rent -- Richmond warehouse |
| Filter date range | 2026-07-01 -- 2027-06-30 |
| Group by | Template |
| Show next-fire timestamp | Yes |
Switching to NeatSum
Moving from Xero, MYOB or a spreadsheet works the way accountants convert books everywhere: you pick a conversion date (your first day in NeatSum), and bring across where the business stood the day before. That is your balances (a trial balance), the invoices and bills still open, and your chart of accounts and contacts. Your history stays in your old system.
The import screens are under Settings, so you need a role that can change company settings to see them.
Choosing the Conversion Date
- Use the 1st of a month, ideally the start of a GST period (1 July, 1 October, 1 January or 1 April for quarterly GST) or the start of your financial year. Your first BAS in NeatSum is then whole.
- Everything you bring across is as at the day before the conversion date. For a 1 October start, export everything as at 30 September.
- Enter invoices, bills and bank transactions dated on or after the conversion date in NeatSum, not in your old system.
Exporting from Xero
Run each report as at the day before your conversion date:
| What | Where in Xero | NeatSum box |
|---|---|---|
| Chart of accounts | Accounting > Chart of accounts > Export | Chart of accounts |
| Contacts | Contacts > All contacts > Export | Contacts |
| Trial Balance | Reports > Trial Balance, dated the day before the conversion date, accrual basis | Opening trial balance |
| What customers owe | Reports > Aged Receivables Detail, or Sales > Invoices > Export | Open invoices |
| What you owe suppliers | Reports > Aged Payables Detail, or Purchases > Bills > Export | Open bills |
With early access, these files go in exactly as Xero exports them (or saved as CSV). Use Download template on a box if you want NeatSum's own layout instead. If you use the Aged Receivables Detail, it leaves customer prepayments out: add Xero's sales invoices export in Customer credits and prepayments to bring them across (and the bills export in Supplier credits and prepayments). For MYOB, the accounts list export is read directly; give the other files in NeatSum's layout.
Without early access, NeatSum reads its own CSV layouts only. Open What this file looks like on each box for the columns, and copy your Xero figures into that layout.
Importing
- 1Go to Settings > Import data (the page is called Import your books).
- 2Add the files you have. Only the trial balance and the conversion date are needed for balances; the rest is optional.
- 3Enter the Conversion date. With early access, if the trial balance says a different date, NeatSum offers to use the day after it.
- 4Click Check these files. Nothing is written yet.
- 5Read the preview, fix anything it lists, and click Check again until it is clear.
- 6Click Import these books.
With early access, Assess this client rates the files Easy, Moderate, Complex or Not supported, with the reasons (for example fixed assets or loans). It also writes nothing.
Reviewing the Preview
The preview lists every balance line with the NeatSum account it will post to. Check these before you import:
- Accounts. A code you already have is matched, not duplicated. With early access, an account with the same name and type as one of NeatSum's starting accounts is matched to it and takes your code and name; you can change any match. Replace the default chart of accounts archives the starting accounts you don't use (only for a company with no transactions yet).
- The trial balance must balance exactly. NeatSum does not plug a difference. With early access, you can put a difference you cannot trace on Historical Adjustment on the Conversion balances screen afterwards.
- Open invoices must add up to Accounts Receivable, and open bills to Accounts Payable, in the trial balance. If they don't, the import is refused, because the aged reports and the balance sheet would disagree from day one.
- A second trial balance is refused while an earlier import's balances are still in place. Reverse or undo the earlier import first (see below), then import again.
What the Import Posts
With early access (conversion):
- One conversion journal, dated the day before the conversion date.
- If the conversion date starts your financial year, last year's income and expense balances are closed to Retained Earnings, so your first year in NeatSum starts at zero.
- A bank account's own opening balance is not counted twice.
- Open invoices and bills are listed for collection and payment, but post nothing themselves: the journal already holds Accounts Receivable and Accounts Payable.
- Every day before the conversion date is locked.
Without early access:
- One opening journal, reference IMPORT-OB- followed by the conversion date, dated on the conversion date.
- Income and expense lines are posted as they are. At the start of a financial year, give a trial balance with last year's profit already in Retained Earnings, or those figures land in your first NeatSum year.
- Open invoices and bills post nothing themselves, as above.
- Nothing is locked, and there is no tie-out.
Conversion Balances (Early Access)
Settings > Conversion balances shows the balances as at the day before your conversion date, and where they came from.
- You can also type balances in here instead of importing a trial balance.
- To correct a figure, change it and click Save conversion balances. Each save posts one new conversion journal and reverses the previous one, so there is only ever one in force.
- Put any difference you cannot trace on Historical Adjustment.
- Where it is turned on, Bring across more adds bank statement lines and your fixed asset register. History before the conversion date can come across as monthly summaries, chosen on the import screen.
Tie-out: What "Verified" Means (Early Access)
On the Conversion balances screen, click Run tie-out. NeatSum puts what your source files said beside its own books as at the balances date, line by line:
- every trial balance account, and the trial balance totals
- bank accounts, Accounts Receivable, Accounts Payable, GST and Retained Earnings
- the number and total of open invoices and bills, and the contacts created
Verified means every line matches to the cent. There is no tolerance. Anything else shows Review required with each difference listed. Run it again after any change, and use Download to keep a copy.
Verified does not mean the export was right. The tie-out compares NeatSum with the files you gave it, so a trial balance run at the wrong date or on a cash basis agrees with itself. Paid invoices, transaction history, attachments, payroll and tracking categories are not imported, so they are not compared. Balances typed in by hand have no files to compare with.
Undoing an Import
With early access: on Settings > Conversion balances, Undo import shows what would be removed before you confirm. Undo reverses the conversion journal, removes the open invoices and bills, credits and statement lines it brought in, removes or puts back the stock it brought in, removes contacts nothing else uses, archives the accounts it created, puts renamed accounts back, and unlocks the time before the conversion date.
Undo is refused, with the reasons listed, while anything it would remove has been used:
- an imported invoice or bill has a payment, credit note or deposit applied (or had one applied and removed), or has been changed
- a BAS has been finalised or lodged for a period from the balances date
- the conversion's locked period has been closed, or another locked period covers the balances date
- a bank account has a completed reconciliation that relies on its conversion balance
- imported stock has been bought, sold or adjusted, or an imported credit, statement line or fixed asset has been used
Undo the later work first (for example remove the payment or undo the reconciliation), then undo the import. Contacts and accounts used since are kept, and listed as kept.
Without early access: the opening journal can be reversed as a whole. There is no button for this yet, so contact NeatSum support with the journal's reference (IMPORT-OB- and the date). Reversing it also removes the open invoices and bills that came with it, and is refused, with the documents named, while any of them has been paid, credited or changed. The contacts, accounts and opening stock it brought in stay.