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

  1. 1Visit the NeatSum sign-up page
  2. 2Enter your name, email address, and create a password
  3. 3Verify your email address
  4. 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:

  1. 1Industry: select the closest match
  2. 2Structure: sole trader, partnership, company, trust, charity or non-profit, or other
  3. 3Identity: your business name, and your ABN (optional)
  4. 4Financial year: the month and day your financial year starts (1 July for most Australian businesses)
  5. 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)
  6. 6Contact: address, phone and email, all optional
  7. 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.

Moving from Xero, MYOB or a spreadsheet? See 26. Switching to NeatSum for what to export, how to import it and how to check it came across.
Tip: Want to explore before committing? NeatSum offers a Demo Company pre-loaded with sample data so you can click around and learn without affecting real data. Choose Explore the demo on the welcome screen.

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.

MenuWhat you'll find
HomeDashboard, Approvals, AI suggestions to review, Notifications and this guide
SalesInvoices, Quotes & orders, Credit notes, Repeating invoices & bills, Customer payments, Customer deposits, Products & services, Invoice reminders
PurchasesBills, Purchase orders, Supplier credit notes, Supplier payments, Batch payments, Expense claims, Receipts inbox
BankingBank accounts (reconcile), Bank feeds, Import statement, Receive money, Spend money, Transfer money, Bank rules, Reconciliation history
ContactsAll contacts, Customers, Suppliers
AccountingChart of accounts, Manual journals, Posted transactions, Lock dates & periods, Currencies
TaxGST & BAS, Tax rates
ReportsAll reports, Profit and loss, Balance sheet, Cash flow, Trial balance, General ledger, Aged receivables and payables, Statements, Budgets, Scheduled reports
Payroll, Fixed assets, Inventory, ProjectsEach 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:

#CategoryWhat It TracksExample
1AssetsThings you own or are owedBank account, equipment, money customers owe you
2LiabilitiesThings you owe othersLoans, credit cards, money you owe suppliers
3EquityThe owner's stake in the businessOwner's capital, retained earnings
4IncomeMoney earnedSales revenue, interest income, service fees
5ExpensesMoney spent to operateRent, salaries, office supplies, advertising
6Contra-AssetReduces an asset's valueAccumulated depreciation (reduces equipment value over time)
7TaxTax collected or payableGST 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 TypeDebit (left side)Credit (right side)
AssetsIncreasesDecreases
ExpensesIncreasesDecreases
LiabilitiesDecreasesIncreases
IncomeDecreasesIncreases
EquityDecreasesIncreases

Real-world example: You receive $1,000 from a customer for a completed project.

AccountDebitCredit
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.

Good news: For most day-to-day work in NeatSum (creating invoices, recording payments, entering bills), the system handles the debits and credits automatically. You only need to think about them when creating manual journal entries.

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 business

Everything 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

  1. 1Navigate to Accounting > Chart of accounts
  2. 2You will see all your accounts grouped by category (Assets, Liabilities, Equity, Income, Expenses, etc.)
  3. 3Each account shows its code, name, type, and current balance
  4. 4Use the expand/collapse arrows to see parent-child account hierarchies
  5. 5Use the search bar at the top to quickly find a specific account

Creating a New Account

  1. 1Click Add account (or the "+" button)
  2. 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
  3. 3Click Save

Editing an Account

  1. 1Find the account in your Chart of Accounts
  2. 2Click the Edit icon next to the account
  3. 3Update the name, description, or other details
  4. 4Click Save
Note: Some accounts are system accounts -- these were created automatically when you set up your company (like Accounts Receivable, Accounts Payable, and GST accounts). You can edit their descriptions but cannot change their names or categories, because other parts of the system depend on them.

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

  1. 1Navigate to Contacts > All contacts
  2. 2You will see a list of all contacts with their name, type (customer/supplier), email, phone, and balance
  3. 3Use the search bar to find a specific contact
  4. 4Use filters to view only customers or only suppliers

Adding a Contact

  1. 1Click Add contact
  2. 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
  3. 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

  1. 1Navigate to Sales > Products & services
  2. 2Click Add item
  3. 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
  4. 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  -->  Payment

Sales 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:

  1. 1Navigate to Sales > Quotes & orders, then New (or + New > New quote)
  2. 2Select Quote
  3. 3Choose the Customer
  4. 4Add line items -- select items or type custom descriptions with quantities and prices
  5. 5Set an expiry date -- how long the quote is valid
  6. 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:

  1. 1Convert from an accepted quote, or create one directly
  2. 2Fill in customer, items, quantities, and pricing
  3. 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:

  1. 1Navigate to Sales > Invoices
  2. 2Click Create invoice
  3. 3Select the Customer
  4. 4Set the Invoice Date and Due Date
  5. 5Add line items:
    - Select from your items list, or type a custom line

    - Set quantity, unit price, and tax rate for each line
  6. 6Review the subtotal, tax, and total
  7. 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
Tip: Use the Sales overview (Sales > Overview) to see your overall sales performance -- metrics, trends, and pipeline status at a glance.

Credit Notes

A credit note reduces the amount a customer owes. Use it for returns, discounts, or billing corrections.

Creating a Credit Note:

  1. 1Navigate to Sales > Credit notes
  2. 2Click Create Credit Note
  3. 3Select the customer and reference the original invoice
  4. 4Enter the items and amounts being credited
  5. 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:

  1. 1Navigate to Purchases > Purchase orders
  2. 2Click Create Purchase Order
  3. 3Select the Supplier
  4. 4Add line items with quantities and prices
  5. 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:

  1. 1Navigate to Purchases > Bills
  2. 2Click Create purchase invoice
  3. 3Select the Supplier
  4. 4Enter the invoice date and due date
  5. 5Add line items with amounts and tax rates
  6. 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:

  1. 1What you ordered (Purchase Order)
  2. 2What you received (Goods Receipt)
  3. 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).

  1. 1Navigate to Purchases > Supplier credit notes
  2. 2Create a supplier credit note referencing the original purchase invoice
  3. 3The system reduces your Accounts Payable balance

Payments -- Money In and Money Out

Incoming Payments (Money You Receive)

When a customer pays an invoice:

  1. 1Navigate to Sales > Customer payments
  2. 2Click Record payment
  3. 3Select the Customer
  4. 4Choose the invoices to apply the payment to (you can split a single payment across multiple invoices)
  5. 5Enter the amount, date, and payment method
  6. 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:

  1. 1Navigate to Purchases > Supplier payments
  2. 2Click Record payment
  3. 3Select the Supplier
  4. 4Choose the bills to apply the payment to
  5. 5Enter the amount, date, and payment method
  6. 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:

  1. 1Navigate to Purchases > Batch payments
  2. 2Select multiple outstanding bills
  3. 3Process them together
  4. 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:

  1. 1Posts a journal: Dr Bank / Cr 2520 Customer Deposits (a seeded liability account, system key CUSTOMER_DEPOSIT_LIABILITY).
  2. 2Tracks status -- Open, FullyReleased, or Voided -- on the deposit detail page.
  3. 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.
  4. 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.

Why this matters: Booking the prepayment straight to income overstates revenue and understates GST timing. Holding it as a liability and recognising revenue only when earned is the textbook accrual treatment and is what the BAS / IFRS / AASB-15 expect.
Common Mistake: Don't use Receive Money for a customer prepayment just because there's no invoice yet. Receive Money goes to whatever account you pick (often a P&L account by accident). Customer Deposits routes through the seeded liability account every time and gives you the release-to-revenue tooling later.

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

  1. 1Navigate to Accounting > Manual journals
  2. 2Click Create Journal Entry
  3. 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
  4. 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
  5. 5Click Save

Step-by-Step Example: Recording a Rent Payment

You pay $2,000 rent by bank transfer on March 1.

LineAccountDebitCredit
1Rent Expense$2,000
2Bank 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.

LineAccountDebitCredit
1Cash on Hand$500
2Consulting 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

  1. 1Navigate to Purchases > Expense claims
  2. 2Click New claim
  3. 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)
  4. 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

  1. 1Navigate to Sales > Repeating invoices & bills
  2. 2Click Create Recurring Template
  3. 3Choose the type: Invoice, Bill, or Journal Entry
  4. 4Fill in the transaction details (customer/supplier, line items, amounts)
  5. 5Set the frequency: Daily, Weekly, Fortnightly, Monthly, Quarterly, or Yearly
  6. 6Set the start date and optionally an end date
  7. 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

  1. 1Navigate to Inventory > Stock items
  2. 2Add items with stock tracking enabled
  3. 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:

  1. 1Navigate to Inventory > Stock movements
  2. 2Click Adjust stock
  3. 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

  1. 1Navigate to Fixed assets > Assets
  2. 2Click Add Asset
  3. 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
  4. 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.

  1. 1Review the proposed depreciation amounts
  2. 2Confirm to apply them
  3. 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

  1. 1Navigate to Banking > Bank accounts
  2. 2Click Add bank account
  3. 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

  1. 1Navigate to Banking > Import statement
  2. 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
  3. 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
  4. 4Lines already on the account (same date, amount and description) are flagged and skipped unless you tick them
  5. 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

  1. 1Navigate to Banking > Bank accounts
  2. 2Select the bank account to reconcile
  3. 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
  4. 4When all items are matched and the balance agrees, complete the reconciliation

Matching Rules

Set up rules to automatically match recurring bank transactions:

  1. 1Navigate to Banking > Bank rules
  2. 2Create rules based on patterns (e.g., "Any transaction with description containing 'RENT' should match to Rent Expense")
  3. 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

  1. 1Navigate to Payroll > Employees
  2. 2Click Add Employee
  3. 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
  4. 4Save

Creating a Pay Run

A pay run processes salaries for a pay period.

  1. 1Navigate to Payroll > Pay runs
  2. 2Click Create Pay Run
  3. 3Select the pay period (e.g., "1 Mar -- 15 Mar 2026")
  4. 4Review the calculated amounts for each employee:
    - Gross pay

    - Tax (PAYG withholding)

    - Superannuation

    - Net pay (what the employee receives)
  5. 5Approve and process the pay run

Pay Run Statuses: Draft, Approved, Paid

Managing Leave

  1. 1Navigate to Payroll > Leave
  2. 2Employees can request leave (annual, sick, unpaid)
  3. 3Managers approve or decline requests
  4. 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

  1. 1Navigate to Projects > Projects
  2. 2Click New project
  3. 3Enter:
    - Project name and code

    - Description

    - Budget (if applicable)
  4. 4Save

Project Statuses: Active, Completed, On Hold, Cancelled

Logging Time

  1. 1Navigate to Projects > Timesheets
  2. 2Click Add Time Entry
  3. 3Select the project and task
  4. 4Enter the date, hours worked, and hourly rate
  5. 5Mark as billable or non-billable
  6. 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

  1. 1Navigate to Reports > Budgets
  2. 2Click Create budget
  3. 3Enter:
    - Budget name (e.g., "FY 2026 Operating Budget")

    - Financial year / date range

    - Allocate amounts to specific accounts for each period (monthly or quarterly)
  4. 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 Balance

How 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 TypeDescription
StandardRegular GST rate (typically 10%)
Zero-ratedGST applies but at 0%
GST-freeExempt from GST entirely
Input-taxedGST on inputs cannot be claimed
ExportGST-free exports
CapitalCapital acquisitions with GST
BAS-excludedNot reported on BAS

Managing Tax Rates

  1. 1Navigate to your company settings or tax configuration
  2. 2View existing tax rates
  3. 3Add new rates with:
    - Name (e.g., "GST 10%")

    - Percentage

    - Tax type

    - Description
  4. 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

PlanPeople per company
FreeJust you
ProUp to 10, including you
EnterpriseNo 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.

  1. 1Go to Settings > Team (users & roles)
  2. 2Click Invite new
  3. 3Enter their email address and choose a role (see below)
  4. 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

RoleAccess Level
ViewerCan view data but cannot create, edit, or delete anything
StaffRecords time and expenses, with limited visibility
BookkeeperDay-to-day data entry, without deleting or approving
AccountantFull financial read and write, without admin settings
AdminFull access including settings and team management
OwnerComplete 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:

  1. 1Add additional currencies in your settings
  2. 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:

  1. 1Navigate to Settings > Audit trail
  2. 2See who did what, when, and what changed
  3. 3Filter by entity type, action, user, or date range
  4. 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:

  1. 1Navigate to your settings
  2. 2Create API keys for programmatic access
  3. 3Manage IP whitelisting for security
  4. 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

  1. 1Go to Sales > Quotes & orders, then New (or + New > New quote)
  2. 2Create a quote for the customer with line items and pricing
  3. 3Send it to the customer

Step 2: Convert to Invoice

  1. 1When the customer accepts, open the quote
  2. 2Click Convert to invoice (or convert to Sales Order first if you want to track delivery)
  3. 3Review and approve the invoice

Step 3: Record Payment

  1. 1When the customer pays, go to Sales > Customer payments
  2. 2Record the payment against the invoice
  3. 3The invoice status changes to Paid

What happened in the accounts:

EventDebitCredit
Invoice createdAccounts ReceivableSales Revenue
Payment receivedBank AccountAccounts 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

  1. 1Go to Purchases > Purchase orders
  2. 2Create a PO for the supplier with the items and quantities needed
  3. 3Send it to the supplier

Step 2: Receive Goods

  1. 1When the supplies arrive, record a Goods Receipt against the PO
  2. 2This updates your inventory (if applicable)

Step 3: Enter the Bill

  1. 1When the supplier's invoice arrives, go to Purchases > Bills
  2. 2Create the purchase invoice, referencing the PO
  3. 3NeatSum runs three-way matching (PO, receipt, bill) to verify everything aligns

Step 4: Pay the Bill

  1. 1Go to Purchases > Supplier payments
  2. 2Record the payment against the bill

What happened in the accounts:

EventDebitCredit
Bill enteredOffice Supplies ExpenseAccounts Payable
Payment madeAccounts PayableBank 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):

  1. 1Go to Banking > Transfer money
  2. 2Choose the account the money came from (Checking) and the account it went to (Savings)
  3. 3Enter the amount ($5,000) and the date the money moved (type it or pick it), and a reference or description if you like
  4. 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):

  1. 1Go to Accounting > Manual journals
  2. 2Create a new entry:
AccountDebitCredit
Savings Account$5,000
Checking Account$5,000
  1. 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.

  1. 1Go to Payroll > Pay runs
  2. 2Create a new pay run for the period
  3. 3Review each employee's calculated pay (gross, tax, super, net)
  4. 4Approve the pay run
  5. 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.

  1. 1Reconcile your bank accounts -- Import the latest statement and match all transactions
  2. 2Review aged receivables -- Follow up on overdue invoices
  3. 3Review aged payables -- Plan upcoming payments
  4. 4Apply depreciation -- Confirm the monthly depreciation entries
  5. 5Review P&L -- Check revenue and expenses for the month
  6. 6Review Balance Sheet -- Confirm assets, liabilities, and equity look right
  7. 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:

  1. 1Create a journal entry to reverse the error:
    - Debit: Office Supplies (correct account)

    - Credit: Advertising (wrong account)
  2. 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:

  1. 1Identify the duplicate by reviewing the transaction list or ledger
  2. 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
  3. 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:

  1. 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.
  2. 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:

  1. 1During bank reconciliation, you will notice unmatched bank statement lines
  2. 2Create the missing transactions directly from the reconciliation screen
  3. 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.

Tip: Set aside about 90 minutes. Work in a brand-new company so you don't pollute live data. You can come back to any step at any time -- the running balances after each step let you re-enter and verify.

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.

AttributeValue
Legal nameClear Water Pty Ltd
IndustryWholesale Trade
StructureCompany
ABN12 345 678 901
Address42 Spring Street, Richmond VIC 3121
Financial year1 July -- 30 June (FY27)
GST registeredYes, quarterly
Period under simulation2026-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.

RoleNameTypeTerms / NotesFirst appears in
CustomerHilton MelbourneCompanyNet 30, 50,000 credit limitStep 25.4.1, Step 25.6.1 (INV-001)
CustomerCafe AuroraCompanyNet 14, 5,000 credit limitStep 25.4.1, Step 25.6.2 (INV-002)
CustomerDirect Subscriber GroupIndividualPrepaid, no creditStep 25.4.1, Step 25.6.3 (INV-003)
SupplierAqua Source SpringsCompanyNet 30, ABN 33 444 555 666Step 25.4.2, Step 25.5.1 (PO-001)
SupplierPET Bottle Co.CompanyNet 14, ABN 44 555 666 777Step 25.4.2 (no Q1 transactions)
SupplierTruckline LogisticsCompanyNet 7, ABN 55 666 777 888Step 25.4.2, Step 25.5.4 (TR-2087)
SupplierCityPowerCompanyNet 14, ABN 66 777 888 999Step 25.4.2, Step 25.5.5 (CP-44102)
SupplierRichmond Property TrustCompanyNet 0, recurring rentStep 25.4.2, Step 25.5.7 (rent template)
EmployeeSam DriverIndividualFull-time delivery driver, 30.00/hrStep 25.4.4 (full setup), Step 25.10 (pay run)

25.2 How to Use This Section

Each step follows the same pattern:

  1. 1Open -- a clickable button takes you straight to the app screen.
  2. 2What to enter -- exact field values you should type.
  3. 3Why this matters -- one-sentence rationale.
  4. 4Expected GL Impact -- the journal the system should post.
  5. 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.

Common Mistake: Don't try to combine Clear Water with another company's data. Start fresh -- create a new company from the company switcher in the top-right corner, then come back here.

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

FieldValue
IndustryWholesale Trade

Step 2 -- Structure

FieldValue
StructureCompany

Step 3 -- Identity

FieldValue
Business nameClear Water Pty Ltd
ABNLeave blank (optional; the wizard rejects an ABN that is not valid)

Step 4 -- Financial Year

FieldValue
Start monthJuly
Start day1

Step 5 -- GST

FieldValue
GSTRegistered
Reporting frequencyQuarterly
BasisAccrual

Step 6 -- Contact (optional)

FieldValue
Address42 Spring Street, Richmond VIC 3121
Phone(03) 9000 1234
Emailhello@clearwater.com.au

Step 7 -- Review

Check the summary, then click Create Company. Everything is recorded in Australian dollars.

Why this matters: Creating the company seeds 60 default accounts and 5 tax rates -- you start with a complete chart, not a blank page. The financial year, GST settings and accounting basis you pick here are baked into every report you'll run later.
Expected Result: You land on the Dashboard with Clear Water as the active company. The header shows the new company name. The first-run wizard banner offers shortcuts to "Set up your team", "Add bank account" and "Import customers" -- you can dismiss these for the demo.

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:

CodeNameCategory
1000Business Bank AccountAssets
1100Accounts ReceivableAssets
1210GST Paid on PurchasesAssets
1300InventoryAssets
1500Fixed Assets - VehiclesAssets
1800Accumulated DepreciationContra-Asset
2000Accounts PayableLiabilities
2200GST Collected on SalesLiabilities
2800Business LoanLiabilities
3000Owner's CapitalEquity
4000SalesIncome
4200Service RevenueIncome
5000Cost of Goods SoldCost of Sales
6100RentExpenses
7500Depreciation ExpenseDepreciation

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

FieldValue
Account code6080
NameUtilities
CategoryExpenses (Operating)
Sub-categoryPremises Costs
DescriptionElectricity, water, gas, network supply for the warehouse
Default tax rateGST 10%
System key(leave blank -- not a system account)
Parent account(none)
CurrencyAUD
StatusActive
Show on dashboardNo
Lock for postingNo

Account 2 of 3 -- 6700 Vehicle Running Costs

FieldValue
Account code6700
NameVehicle Running Costs
CategoryExpenses (Operating)
Sub-categoryVehicle & Travel
DescriptionFuel, tolls, parking, registration, servicing
Default tax rateGST 10%
System key(leave blank)
Parent account(none)
CurrencyAUD
StatusActive
Show on dashboardNo
Lock for postingNo

Account 3 of 3 -- 2300 Accruals

FieldValue
Account code2300
NameAccruals
CategoryLiabilities (Current)
Sub-categoryAccrued Expenses
DescriptionPeriod-end estimated expenses for which no bill has yet arrived
Default tax rateBAS Excluded
System key(leave blank)
Parent account(none)
CurrencyAUD
StatusActive
Show on dashboardNo
Lock for postingNo
Tip: Tax rate on the account drives the default tax for any line that doesn't override it. For accruals you want BAS Excluded because the GST is recognised when the actual tax invoice arrives (see Step 25.8.1).
Note: The 2520 Customer Deposits liability account is already seeded by default (system key 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:

NameRateTypeBAS box (sales)BAS box (purchases)Default
GST 10%10.0%standardG1 / 1AG11 / 1BYes
GST Free0.0%gst_freeG3G14No
BAS Excluded0.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:

FieldExample value
NameInput-Taxed Sales
Rate (%)0.0
Typeinput_taxed
Applies toSales
BAS box (sales)G4
BAS box (purchases)--
Is default?No
ActiveYes
DescriptionResidential rent, financial supplies, etc.

Step 25.3.4 -- Open the Accounting Period

Open Accounting → Lock dates & periods and click New period:

FieldValue
Period nameFY27 Q1
Period typeQuarter
Financial yearFY27 (1 Jul 2026 -- 30 Jun 2027)
Parent periodFY27 (auto-created if it doesn't exist)
Start date2026-07-01
End date2026-09-30
StatusOpen
Posting allowed for rolesAdmin, Bookkeeper, Accountant
Prior-period status checkPass (no prior FY27 period exists)
Soft-close date(leave blank -- we'll set it at Step 25.8.4)
Hard-lock date(leave blank)
NotesFirst quarter of FY27 -- Clear Water demo
Why this matters: Open periods accept postings; locked periods reject them. We will lock this period at the end of Step 25.8 so reports become tamper-proof. The Posting allowed for roles field is your guard against accidental backdating once month-end starts.

Step 25.3.5 -- Record Opening Balances

Open Manual journals, then click + New Journal Entry.

FieldValue
Date2026-07-01
ReferenceOPEN-001
SourceManual
NarrationOpening balances for Clear Water Pty Ltd
CurrencyAUD
Project / Cost centre(none)
Branch / Department(none -- single-site)
Recurring template?No
Auto-reverse on date(leave blank -- opening balances are permanent)
AttachmentsOwner contribution receipt + Loan agreement PDF (optional)
Tagsopening-balance, fy27

Lines:

#AccountDescriptionDebitCreditTax
11000 Business Bank AccountOpening cash80,000.00BAS Excluded
23000 Owner's CapitalOwner contribution40,000.00BAS Excluded
32800 Business LoanNAB business loan @ 7.2%40,000.00BAS Excluded

Click Post.

Why this matters: Without opening balances the books start at zero -- but Clear Water already has $80,000 in cash, half from the owner and half from a bank loan.
Expected GL Impact: Total debits 80,000.00, total credits 80,000.00. The save button is disabled until they balance.
Running balances after this step: Cash = 80,000 - Capital = 40,000 - Loan = 40,000 - Trial Balance Dr=Cr=80,000.

Section Snapshot -- after 25.3

AccountBalance
1000 Cash80,000 Dr
2800 Loan40,000 Cr
3000 Capital40,000 Cr
Trial Balance80,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

FieldValue
Display nameHilton Melbourne
Contact typeCompany
Is CustomerYes
Is SupplierNo
Primary contact namePriya Shah (Accounts Payable)
Emailap@hilton.example
Phone(03) 9419 1234
Mobile--
Websitehttps://hilton.com/melbourne
ABN11 222 333 444
ACN--
CurrencyAUD
Payment termsNet 30
Credit limit50,000.00
Default sales account4000 Sales
Default tax (sales)GST 10%
Default income discount0%
Opening balance0.00
Opening balance as at2026-07-01
StatusActive
Tagscorporate, hotel
NotesQ3 supply contract -- 1,200 bottles/month minimum

Billing & shipping (Hilton):

Address typeStreetSuburb / State / PostcodeCountry
Billing192 Wellington PdeEast Melbourne VIC 3002Australia
ShippingLoading dock B, 192 Wellington PdeEast Melbourne VIC 3002Australia

Customer 2 of 3 -- Cafe Aurora

FieldValue
Display nameCafe Aurora
Contact typeCompany
Is CustomerYes
Is SupplierNo
Primary contact nameMarco Lin (Owner)
Emailaccounts@aurora.example
Phone(03) 9417 8822
ABN22 333 444 555
CurrencyAUD
Payment termsNet 14
Credit limit5,000.00
Default sales account4000 Sales
Default tax (sales)GST 10%
Opening balance0.00
Opening balance as at2026-07-01
StatusActive
Tagssmall-business, cafe
NotesWeekly delivery, prefers Tuesday AM

Billing & shipping (Cafe Aurora) -- billing = shipping:

Address typeStreetSuburb / State / PostcodeCountry
Billing & shipping17 Brunswick StFitzroy VIC 3065Australia

Customer 3 of 3 -- Direct Subscriber Group

FieldValue
Display nameDirect Subscriber Group
Contact typeIndividual
Is CustomerYes
Is SupplierNo
Primary contact name(consumer group, no single contact)
Emailsubs@clearwater.com.au
Phone--
ABN--
CurrencyAUD
Payment termsPrepaid
Credit limit0.00
Default sales account4000 Sales
Default tax (sales)GST 10%
Opening balance0.00
Opening balance as at2026-07-01
StatusActive
Tagsconsumer, subscription
NotesAggregated subscriber group; revenue recognised in single monthly invoice
Tip: Setting a default sales account and default tax here means every new invoice line auto-fills with 4000/GST 10% -- you only override when a line is genuinely different (e.g. the GST-free Bottle Deposit in Step 25.6.3).

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

FieldValue
Display nameAqua Source Springs
Contact typeCompany
Is CustomerNo
Is SupplierYes
Primary contact nameKaren Wells (Sales)
Emailsales@aquasource.example
Phone(03) 5945 7700
ABN33 444 555 666
CurrencyAUD
Payment termsNet 30
Credit limit (their limit on us)25,000.00
Default expense account1300 Inventory
Default tax (purchases)GST 10%
Default payment methodEFT
Bank nameNAB
BSB083-004
Account nameAqua Source Springs Pty Ltd
Account number1122 3344
Opening balance owed0.00
Opening balance as at2026-07-01
Address14 Spring Lane, Healesville VIC 3777
StatusActive
Tagsinventory, primary-supplier
NotesSource of all spring water; 2-day lead time

Supplier 2 of 5 -- PET Bottle Co.

FieldValue
Display namePET Bottle Co.
Contact typeCompany
Is SupplierYes
Primary contact nameTom Halliday
Emailorders@petbottle.example
Phone(03) 9870 1133
ABN44 555 666 777
CurrencyAUD
Payment termsNet 14
Default expense account1300 Inventory
Default tax (purchases)GST 10%
Default payment methodEFT
Bank nameWestpac
BSB033-008
Account namePET Bottle Co. Pty Ltd
Account number5566 7788
Opening balance owed0.00
Opening balance as at2026-07-01
Address22 Industrial Way, Dandenong South VIC 3175
StatusActive
Tagspackaging
NotesReserve supplier -- no Q1 transactions in this demo

Supplier 3 of 5 -- Truckline Logistics

FieldValue
Display nameTruckline Logistics
Contact typeCompany
Is SupplierYes
Primary contact nameVince Romano (Despatch)
Emailaccounts@truckline.example
Phone(03) 9311 4400
ABN55 666 777 888
CurrencyAUD
Payment termsNet 7
Default expense account5100 Freight & Courier
Default tax (purchases)GST 10%
Default payment methodEFT
Bank nameANZ
BSB013-006
Account nameTruckline Logistics Pty Ltd
Account number9988 7766
Opening balance owed0.00
Address89 Freight Drive, Tullamarine VIC 3043
StatusActive
Tagslogistics

Supplier 4 of 5 -- CityPower

FieldValue
Display nameCityPower
Contact typeCompany
Is SupplierYes
Primary contact nameCustomer Care Team
Emailbilling@citypower.example
Phone13 22 33
ABN66 777 888 999
CurrencyAUD
Payment termsNet 14
Default expense account6080 Utilities
Default tax (purchases)GST 10% (lines may override to GST Free)
Default payment methodBPAY
BPAY biller code47711
Opening balance owed0.00
AddressGPO Box 1234, Melbourne VIC 3001
StatusActive
Tagsutilities
NotesMixed-tax bills -- network supply charge is GST Free

Supplier 5 of 5 -- Richmond Property Trust

FieldValue
Display nameRichmond Property Trust
Contact typeCompany
Is SupplierYes
Primary contact nameHelen Tran (Property Manager)
Emailleasing@richmondpt.example
Phone(03) 9428 6611
ABN77 888 999 000
CurrencyAUD
Payment termsNet 0 (due on the 1st of the month)
Default expense account6100 Rent
Default tax (purchases)GST 10%
Default payment methodEFT
Bank nameCBA
BSB062-100
Account nameRichmond Property Trust
Account number4455 6677
Opening balance owed0.00
AddressLevel 4, 200 Victoria St, Richmond VIC 3121
StatusActive
Tagslandlord, recurring
NotesWarehouse lease 2026-07-01 -- 2027-06-30, $2,200 ex GST monthly
Why bank details matter here: Step 25.5.10 walks a Batch Payment that picks suppliers off this list and pre-fills BSB/account number into the EFT export file. Skipping bank details now means the batch UI shows a red "missing payment details" badge later.
Common Mistake: A contact can be both a customer and a supplier (tick both boxes). For Clear Water none of them are -- but in real life a supplier you also sell to (e.g. a cafe that you both deliver water to and buy beans from) needs both flags so they appear in both invoice and bill dropdowns.

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

FieldValue
Item code / SKUSW-600
Name600ml Spring Water
Item typeProduct (inventory-tracked)
Description (sales)600ml bottled spring water -- single unit
Description (purchases)600ml PET bottle, case-packed
Unit of measureeach
Track inventoryYes
Default locationRichmond Warehouse
Reorder level1,000
Reorder quantity5,000
Default supplierAqua Source Springs
Barcode (GTIN)9312345600015
For saleYes
Sell price (ex tax)1.80
Sales account4000 Sales
Sales taxGST 10%
For purchaseYes
Cost price (ex tax)0.50
Purchase account1300 Inventory (capitalises to inventory until sold)
COGS account5000 Cost of Goods Sold
Purchase taxGST 10%
Opening stock qty0
Opening stock value0.00
Opening stock as at2026-07-01
StatusActive

Item 2 of 4 -- 12L Cooler Bottle

FieldValue
Item code / SKUCB-12L
Name12L Cooler Bottle
Item typeProduct (inventory-tracked)
Description (sales)12-litre refillable cooler bottle
Unit of measureeach
Track inventoryYes
Default locationRichmond Warehouse
Reorder level50
Reorder quantity200
Default supplierAqua Source Springs
Barcode (GTIN)9312345601128
For saleYes
Sell price (ex tax)14.00
Sales account4000 Sales
Sales taxGST 10%
For purchaseYes
Cost price (ex tax)4.00
Purchase account1300 Inventory
COGS account5000 Cost of Goods Sold
Purchase taxGST 10%
Opening stock qty0
Opening stock value0.00
StatusActive

Item 3 of 4 -- Delivery Service

FieldValue
Item code / SKUSVC-DEL
NameDelivery Service
Item typeService (no inventory)
Description (sales)Per-drop metropolitan delivery
Unit of measuredrop
Track inventoryNo
For saleYes
Sell price (ex tax)20.00
Sales account4200 Service Revenue
Sales taxGST 10%
For purchaseNo
StatusActive

Item 4 of 4 -- Bottle Deposit

FieldValue
Item code / SKUSVC-DEP
NameBottle Deposit
Item typeService (no inventory)
Description (sales)Refundable deposit on returnable cooler bottle
Unit of measurebottle
Track inventoryNo
For saleYes
Sell price (ex tax)5.00
Sales account4200 Service Revenue
Sales taxGST Free (deposits are not a supply)
For purchaseNo
StatusActive

Leave opening stock at 0 on the two products -- inventory will arrive via the first purchase order in Step 25.5.

Why this matters: The sales/purchase/COGS accounts on each item drive where the money lands automatically. Set them once here and you never have to choose accounts on every invoice line. The default supplier field is what feeds the "reorder" suggestion when stock falls below the reorder level.

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

FieldValue
First nameSam
Last nameDriver
Emailsam.driver@clearwater.com.au
Phone0412 555 904
Date of birth1990-04-12
Address88 Church St, Richmond VIC 3121

Click Next.

Step 2 of 6 -- Employment Details

FieldValue
Job title / RoleDelivery Driver
DepartmentOperations
Employment typeFull-time
Start date2026-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

FieldValue
Pay typeHourly
Hourly rate ($)30.00
Hours per week38
Pay frequencyWeekly

A Live Preview card appears in the side panel and recalculates as you type:

Preview lineAmount (per pay)
Gross pay (38 × $30.00)1,140.00
PAYG withholding (resident, threshold claimed)184.00
Superannuation guarantee (12%)136.80
Net take-home956.00

Click Next.

Step 4 of 6 -- Tax & Superannuation

FieldValue
Residency for tax purposesAustralian resident for tax purposes
TFN statusTFN provided
Tax File Number (TFN)123 456 782 (demo only -- not a real TFN)
Claims the tax-free thresholdYes
Has a study or training support loanNo
Medicare levy exemptionNo exemption
Super fund nameAustralianSuper
Super USISTA0100AU
Super member number12345678
Super rate (%)12 (the Superannuation Guarantee rate since 1 July 2025, and NeatSum's default)
Note: TFN, BSB and bank account number are encrypted at rest by the payroll service before they hit the database. The list view masks them as ***; only the detail view (and pay-run output) decrypts them.

Click Next.

Step 5 of 6 -- Bank & Emergency Contact

FieldValue
Bank nameCommonwealth Bank
BSB062-000 (demo only)
Account nameSam Driver
Account number1234 5678 (demo only)
Emergency contact nameJamie Driver
Emergency contact phone0421 987 654
Emergency contact relationSpouse

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 lineAmount
Gross wages1,140.00
Super contribution136.80
Total employer cost per week1,276.80

Click Save Employee.

Why this matters: Adding an employee is master data only -- there is no GL impact at this point. Money moves when you process a pay run (Step 25.10.2). The system does, however, automatically create four leave-balance rows behind the scenes, all starting at 0.0 days and accruing per pay run:
Leave typeAnnual accrual rate
Annual leave20 days
Sick / Personal carer's10 days
Personal5 days
Long service8.67 days (≈13 weeks per 10 years' service)
Precondition for the pay run: Before the first pay run can post, six account-mapping fields must be set in Payroll Settings (Step 25.10.1): 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.
Common Mistake: Don't tick "Claim tax-free threshold" if Sam already claims it at another job. The default is on, but it's a per-employer declaration -- only one employer at a time should hold it. For Clear Water as Sam's only job, leave it ticked.

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:

FieldValue
SupplierAqua Source Springs
Supplier reference(their quote number, leave blank for the demo)
PO numberPO-001 (auto-suggested by document numbering)
Order date2026-07-02
Expected delivery date2026-07-04
CurrencyAUD
FX rate1.0000 (no conversion)
Tax modeTax Exclusive
Ship toRichmond Warehouse, 42 Spring Street, Richmond VIC 3121
Delivery instructionsRoller-door access; deliver before 2pm
Project / Job(none)
Branch / DepartmentOperations
Internal memoFirst inventory PO -- launch stock
Attachments(optional supplier quote PDF)
Approval statusAuto-approved (no approval rule yet -- see Step 25.10 Approvals)

Lines (one row per item):

#ItemDescriptionAccount overrideQtyUnit cost (ex)Discount %TaxProjectLine memoLine total (ex)
1600ml Spring Water600ml PET bottle, case-packed(default 1300 Inventory)5,0000.500GST 10%----2,500.00

Totals:

LineAmount
Subtotal (ex tax)2,500.00
GST250.00
Total (inc tax)2,750.00

Click Approve / Send.

Why this matters: A PO is a commitment, not an accounting transaction. No GL movement yet -- the bill (Step 25.5.3) is what hits the books.

Step 25.5.2 -- Goods Receipt (Partial)

From the PO-001 detail page, click Receive Goods.

Header:

FieldValue
GR numberGR-001 (auto)
Linked POPO-001
Receipt date2026-07-04
Receiving locationRichmond Warehouse
Received by(your user name)
Carrier / Driver nameAqua Source own truck
Delivery docket #DD-77104
ConditionGood (no breakage on this delivery)
GR notesShort-shipped by 200 -- supplier flagged for credit on next PO
AttachmentsPhoto of delivery docket (optional)

Lines:

#ItemOrderedPreviously receivedReceiving nowOutstandingConditionBin / Location
1600ml Spring Water5,00004,800200GoodBay A-12

Save.

Why this matters: Aqua Source short-shipped by 200 units. Recording the actual receipt (not the order) keeps inventory accurate and feeds the three-way match. The remaining 200 stays on the PO as outstanding -- if Aqua Source ships the back-order later, you receive against the same PO without creating a new one.

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:

FieldValue
SupplierAqua Source Springs
Bill number (theirs)INV-AQ-7711
Internal referenceBILL-001 (auto)
Bill date2026-07-04
Due date2026-08-03 (auto from Net 30 terms)
Due-date methodFrom bill date + supplier terms
CurrencyAUD
FX rate1.0000
Tax modeTax Exclusive
AP account2000 Accounts Payable (default)
Payment methodEFT (default from supplier)
Match againstPO-001 + GR-001
Project / Job(none)
Branch / DepartmentOperations
Internal memoFirst inventory bill -- 200-unit short-ship to chase
AttachmentsBill PDF from supplier
Approval statusAuto-approved

Lines (auto-filled from GR):

#ItemDescriptionAccountQtyUnit cost (ex)Discount %TaxProjectLine total (ex)
1600ml Spring Water600ml PET bottle, case-packed1300 Inventory4,8000.500GST 10%--2,400.00

Totals:

LineAmount
Subtotal (ex tax)2,400.00
GST240.00
Total (inc tax)2,640.00
Expected GL Impact:
| Account | Dr | Cr |

| 1300 Inventory | 2,400.00 | |

| 1210 GST Paid | 240.00 | |

| 2000 Accounts Payable | | 2,640.00 |
Running balances after this step: Inventory = 2,400 - GST Paid = 240 - AP = 2,640 - Stock units (600ml) = 4,800.

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:

FieldValue
SupplierTruckline Logistics
Bill number (theirs)TR-2087
Internal referenceBILL-002
Bill date2026-07-15
Due date2026-07-22 (Net 7 terms)
Due-date methodFrom bill date + supplier terms
CurrencyAUD
FX rate1.0000
Tax modeTax Exclusive
AP account2000 Accounts Payable
Payment methodEFT
Match against(skipped -- no PO)
Project / Job(none)
Branch / DepartmentOperations
Internal memoFirst-week freight charges
AttachmentsTruckline invoice PDF

Lines (use a manual GL line, no item):

#ItemDescriptionAccountQtyUnit cost (ex)Discount %TaxProjectLine total (ex)
1(none)First-week freight5100 Freight & Courier1400.000GST 10%--400.00

Totals:

LineAmount
Subtotal (ex tax)400.00
GST40.00
Total (inc tax)440.00
Expected GL Impact:
| 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:

FieldValue
SupplierCityPower
Bill number (theirs)CP-44102
Internal referenceBILL-003
Bill date2026-07-30
Due date2026-08-13 (Net 14)
CurrencyAUD
FX rate1.0000
Tax modeTax Exclusive
AP account2000 Accounts Payable
Payment methodBPAY (default from supplier)
BPAY reference47711 / customer ref 99887766
Project / Job(none)
Branch / DepartmentOperations
Internal memoJuly electricity -- mixed-tax bill
AttachmentsCityPower bill PDF

Lines:

#ItemDescriptionAccountQtyUnit cost (ex)TaxLine total (ex)
1(none)Electricity usage July6080 Utilities1200.00GST 10%200.00
2(none)Network supply charge6080 Utilities120.00GST Free20.00

Totals:

LineAmount
Subtotal (ex tax)220.00
GST20.00 (only on the $200 line)
Total (inc tax)240.00
Why this matters: Mixed-tax bills test the per-line tax behaviour. The GST-free supply charge produces no GST credit -- the BAS report should reflect this distinction.
Expected GL Impact:
| 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:

FieldValue
SupplierAqua Source Springs
Supplier credit note numberSCN-000001 (auto)
Date2026-07-30
Allocate againstBill INV-AQ-7711
ReasonDefective goods on receipt
Restock to inventory?No (defective units written off)
Affects inventory?Yes (reverses the original inventory hit)
Reference docPhotos in attachments
CurrencyAUD
Tax modeTax Exclusive
Project / Job(none)
Branch / DepartmentOperations
Internal memo200 cracked bottles -- chasing replacement on next PO
AttachmentsPhotos of defective units

Lines:

#ItemDescriptionAccountQtyUnit cost (ex)TaxLine total (ex)
1600ml Spring WaterDefective units credit1300 Inventory2000.50GST 10%100.00

Totals:

LineAmount
Subtotal (ex tax)100.00
GST10.00
Total (inc tax)110.00 credit against AP
Expected GL Impact:
| Account | Dr | Cr |

| 2000 AP | 110.00 | |

| 1300 Inventory | | 100.00 |

| 1210 GST Paid | | 10.00 |
Running balances after this step: Inventory = 2,300 - GST Paid net = 230 - AP outstanding to Aqua Source = 2,530 - Stock units (600ml) = 4,600.

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:

FieldValue
Template nameMonthly Rent -- Richmond warehouse
Document typeBill
SupplierRichmond Property Trust
CurrencyAUD
Tax modeTax Exclusive
FrequencyMonthly
Day of month1
Start date2026-07-01
End conditionEnd date
End date2027-06-30
Occurrences (alternative)(12 -- not used since End date is set)
StatusActive
Posting modeAuto-post (no review queue)
Skip dates(none -- no holidays bypass)
Pause from(blank)
Notify on posthello@clearwater.com.au
Notify on failurehello@clearwater.com.au
Attachments templateLease agreement PDF

Lines:

#ItemDescriptionAccountQtyUnit cost (ex)TaxLine total (ex)
1(none)Warehouse rent -- Richmond6100 Rent12,200.00GST 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.

Why this matters: Recurring eliminates manual data entry for predictable transactions. Confirm three rent bills now appear in the Bills list dated the 1st of each month.
Expected GL Impact (per posting × 3):
| 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:

FieldValue
Payment numberOP-001 (auto)
SupplierTruckline Logistics
Payment date2026-08-05
Bank-clear date2026-08-05 (same day for EFT)
Bank account1000 Business Bank Account
Payment methodEFT
EFT referenceTRUCKLINE-2087
Cheque number (if applicable)--
Amount440.00
CurrencyAUD
FX rate1.0000
Project / Job(none)
Branch / DepartmentOperations
Internal memoPay TR-2087 in full
Attachments(optional remittance PDF)

Allocations:

BillOutstandingAmount applied
TR-2087440.00440.00
Expected GL Impact:
| 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.

FieldPayment 1Payment 2
Payment numberOP-002OP-003
SupplierRichmond Property TrustRichmond Property Trust
Payment date2026-07-052026-08-05
Bank-clear date2026-07-052026-08-05
Bank account1000 Business Bank Account1000 Business Bank Account
Payment methodEFTEFT
EFT referenceRPT-RENT-JULRPT-RENT-AUG
Amount2,420.002,420.00
Allocate toRent bill 2026-07-01Rent bill 2026-08-01
Internal memoJuly rentAugust rent

September rent bill remains unpaid.

Step 25.5.10 -- Batch Payment

Open Batch Payment, click + New Batch.

Header:

FieldValue
Batch numberBATCH-001 (auto)
Batch date2026-09-05
Bank-clear date2026-09-05
Bank account1000 Business Bank Account
Payment methodEFT (single ABA file output)
EFT file formatABA (Australian Bankers' Association)
Bank lodgement referenceCW-Q1-AP-RUN
CurrencyAUD
Internal memoQ1 month-3 AP run
Approval statusAuto-approved

Selected bills (the picker shows only open AP bills with bank details on file):

#SupplierBillOutstandingAmount appliedBSBAccount
1Aqua Source SpringsINV-AQ-7711 (after SCN-000001)2,530.002,530.00083-0041122 3344
2CityPowerCP-44102240.00240.00(BPAY -- excluded from ABA file, posted manually)--

Totals:

LineAmount
Total selected2,770.00
ABA-eligible2,530.00 (Aqua Source only)
BPAY portion240.00 (CityPower)
Total batch payment2,770.00
Why this matters: Batch payments save trips when paying many suppliers at once. The system creates one bank transaction but allocates to multiple bills.
Expected GL Impact:
| 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:

FieldValue
Claim numberEXP-001 (auto)
Employee / ClaimantSam Driver (selectable because Step 25.4.4 added him)
Claim date2026-08-20
Period covered2026-08-15 -- 2026-08-19
Reimburse to bank account1000 Business Bank Account
Reimbursement methodEFT to Sam's bank (BSB 062-000 / Acct 1234 5678)
CurrencyAUD
Tax modeTax Inclusive (receipts are GST-inclusive)
Project / Job(none)
Branch / DepartmentOperations
Internal memoWeekly delivery fuel claim
AttachmentsFuel receipts (3 dockets)
Approval statusPending → Approved (see below)

Lines (claim by receipt):

#DateDescriptionAccountReceiptTaxAmount (inc tax)
12026-08-15Fuel @ Shell Richmond -- 28L unleaded6700 Vehicle Running CostsR-9911GST 10%44.00
22026-08-17Fuel @ BP Abbotsford -- 18L unleaded6700 Vehicle Running CostsR-9912GST 10%27.50
32026-08-19Toll -- CityLink return trip6700 Vehicle Running CostsR-9913GST 10%16.50
Alternative -- mileage: Instead of receipts, you can switch the claim to Mileage mode and enter Distance (km) × Rate per km. This bypasses the per-receipt tax calc; the system uses the ATO cents-per-km rate.

Totals:

LineAmount
Subtotal (ex tax)80.00
GST8.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.

Expected GL Impact (on approval and payment):
| Account | Dr | Cr |

| 6700 Vehicle Running Costs | 80.00 | |

| 1210 GST Paid | 8.00 | |

| 1000 Cash | | 88.00 |

Section Snapshot -- after 25.5

ItemValue
AP outstanding2,420 (only Sept rent left)
Cash80,000 - 440 - 4,840 - 2,770 - 88 = 71,862
Inventory (600ml)4,600 units, $2,300
GST Paid YTD240 + 40 + 20 + 660 - 10 + 8 = 958
Expense accounts so farFreight 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):

FieldValue
CustomerHilton Melbourne
Quote numberQ-001 (auto)
Quote date2026-07-03
Valid until2026-07-17 (14 days)
Customer PO referenceHIL-PO-9921
Sales rep(your user name)
CurrencyAUD
FX rate1.0000
Tax modeTax Exclusive
Bill-to address192 Wellington Pde, East Melbourne VIC 3002
Ship-to addressLoading dock B, 192 Wellington Pde
Delivery date2026-07-08
Delivery methodTruckline (own driver)
Project / JobHilton Q3 supply contract
Branch / DepartmentSales
Quote termsPrices ex GST. Valid 14 days from issue.
Internal notesAligns with Q3 contract minimum 1,200 bottles/month
Customer-facing notesThank you for your continued business.
AttachmentsQ3 contract PDF

Lines:

#ItemDescriptionAccountQtyUnit price (ex)Discount %TaxProjectLine total (ex)
1600ml Spring Water600ml bottled spring water -- single unit4000 Sales1,2001.800GST 10%Hilton Q3 supply contract2,160.00

Totals:

LineAmount
Subtotal (ex tax)2,160.00
GST216.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).

Why this matters: This three-step lifecycle (Quote → SO → Invoice) is what the Sales module is built for. The journal posts only when the Invoice is created -- the quote and SO are commitments.
Expected GL Impact (on invoice posting):
| 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:

FieldValue
CustomerCafe Aurora
Invoice numberINV-002 (auto)
Invoice date2026-07-10
Due date2026-07-24 (Net 14, auto from terms)
Due-date methodFrom invoice date + customer terms
Customer PO reference--
Sales rep(your user name)
CurrencyAUD
FX rate1.0000
Tax modeTax Exclusive
Bill-to address17 Brunswick St, Fitzroy VIC 3065
Ship-to address(same as billing)
Delivery methodTruckline (own driver)
Project / Job(none)
Branch / DepartmentSales
Online payment enabledNo
Stripe payment link--
Recurring template?No
Customer-facing notesPay via EFT to BSB 062-000 / Acct 5566 7788
Internal memoFirst Cafe Aurora invoice
Attachments(none)

Lines:

#ItemDescriptionAccountQtyUnit price (ex)Discount %TaxLine total (ex)
1600ml Spring Water600ml bottled spring water4000 Sales2001.800GST 10%360.00
2Delivery ServicePer-drop metropolitan delivery4200 Service Revenue120.000GST 10%20.00

Totals:

LineAmount
Subtotal (ex tax)380.00
GST38.00
Freight-- (built into Delivery Service line)
Total (inc tax)418.00
Expected GL Impact:
| 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:

FieldValue
CustomerDirect Subscriber Group
Invoice numberINV-003 (auto)
Invoice date2026-07-15
Due date2026-08-14 (Net 30 default; override Prepaid if subscription is paid in advance -- demo uses Net 30)
CurrencyAUD
Tax modeTax Exclusive
Bill-to address-- (consumer group, no address)
Ship-to address(assorted -- per-subscriber)
Project / Job(none)
Branch / DepartmentSales
Online payment enabledNo
Recurring template?No (could be -- left manual for the demo)
Customer-facing notesIncludes refundable deposit for cooler bottle
Internal memoAggregated subscriber invoice for week ending 2026-07-15

Lines:

#ItemDescriptionAccountQtyUnit price (ex)Discount %TaxLine total (ex)
1600ml Spring Water600ml bottled spring water4000 Sales501.800GST 10%90.00
2Bottle DepositRefundable deposit on returnable cooler bottle4200 Service Revenue505.000GST Free250.00

Totals:

LineAmount
Subtotal (ex tax)340.00
GST9.00 (only on the spring-water line)
Total (inc tax)349.00
Why this matters: The Bottle Deposit line is GST-free -- this tests that the system applies tax line-by-line, not invoice-wide.
Expected GL Impact:
| 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:

FieldValue
CustomerHilton Melbourne
Invoice numberINV-004 (auto)
Invoice date2026-08-12
Due date2026-09-11 (Net 30)
Customer PO referenceHIL-PO-9988
Sales rep(your user name)
CurrencyAUD
Tax modeTax Exclusive
Bill-to address192 Wellington Pde, East Melbourne VIC 3002
Ship-to addressLoading dock B, 192 Wellington Pde
Delivery date2026-08-13
Project / JobHilton Q3 supply contract
Branch / DepartmentSales
Online payment enabledNo
Apply customer deposit?No (the $1,100 deposit posted in Step 25.6.8 stays on the BS)
Customer-facing notesAugust supply, contracted quantity
Internal memoMonth 2 of Q3 contract

Lines:

#ItemDescriptionAccountQtyUnit price (ex)Discount %TaxProjectLine total (ex)
1600ml Spring Water600ml bottled spring water4000 Sales1,0001.800GST 10%Hilton Q3 supply contract1,800.00
2Delivery ServicePer-drop metropolitan delivery (10 drops)4200 Service Revenue1020.000GST 10%Hilton Q3 supply contract200.00

Totals:

LineAmount
Subtotal (ex tax)2,000.00
GST200.00
Total (inc tax)2,200.00
Expected GL Impact:
| 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:

FieldValue
CustomerCafe Aurora
Credit note numberCN-001 (auto)
Date2026-07-21
Allocate againstINV-002
ReasonDamaged in transit
Restock to inventory?Yes (the bottles are returnable -- they reverse back into stock)
Affects inventory?Yes
CurrencyAUD
Tax modeTax Exclusive
Project / Job(none)
Branch / DepartmentSales
Customer-facing notesGoodwill credit -- damage reported on delivery
Internal memoDriver Sam logged damage at drop-off
AttachmentsPhoto from Cafe Aurora

Lines:

#ItemDescriptionAccountQtyUnit price (ex)TaxLine total (ex)
1600ml Spring WaterDamaged bottles returned4000 Sales501.80GST 10%90.00

Totals:

LineAmount
Subtotal (ex tax)90.00
GST9.00
Total credit (inc tax)99.00
Expected GL Impact:
| 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:

FieldValue
Payment numberIP-001 (auto)
CustomerCafe Aurora
Payment date2026-07-22
Bank-clear date2026-07-22 (same day for EFT)
Bank account1000 Business Bank Account
Payment methodEFT
Reference (their)CAFE-AURORA-INV002
Amount319.00
CurrencyAUD
FX rate1.0000
Project / Job(none)
Internal memoCafe Aurora paid INV-002 net of CN-001
Attachments(optional EFT remittance email)

Allocations:

InvoiceOutstandingAmount applied
INV-002 (after CN-001)319.00319.00
Expected GL Impact:
| 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:

FieldValue
Payment numberIP-002 (auto)
CustomerHilton Melbourne
Payment date2026-07-25
Bank-clear date2026-07-25
Bank account1000 Business Bank Account
Payment methodEFT
Reference (their)HIL-PAY-44721
Amount1,500.00
CurrencyAUD
Project / JobHilton Q3 supply contract
Internal memoPartial payment of INV-001 -- balance due by 2026-08-04

Allocations:

InvoiceOutstandingAmount appliedRemaining after
INV-0012,376.001,500.00876.00

INV-001 outstanding after = 2,376 - 1,500 = 876.00.

Common Mistake: Don't enter the payment as a single $1,500 line untied to an invoice -- it would land in unallocated AR and the invoice would still show as fully open. Always tick the invoice to allocate.

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.

FieldValue
Deposit numberCD-0001 (auto)
Date2026-08-15
CustomerHilton Melbourne
Bank account1000 Business Bank Account
Liability account2520 Customer Deposits (system-keyed -- can't change)
Amount1,100.00
CurrencyAUD
FX rate1.0000
Payment methodEFT
ReferenceAdvance for Q3 supply
Project / JobHilton Q3 supply contract
Branch / DepartmentSales
Release schedule(none yet -- create later via "+ Build Schedule")
Internal memoAdvance against future Sept invoice
AttachmentsHilton 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.

Why this matters: A prepayment is a liability -- you owe Hilton goods or a refund. It is not income until the matching invoice is raised or you explicitly release it through a deferred-revenue schedule. The Customer Deposits feature enforces this routing through the seeded 2520 Customer Deposits liability account so you can never accidentally book it to the P&L.
Expected GL Impact:
| Account | Dr | Cr |

| 1000 Cash | 1,100.00 | |

| 2520 Customer Deposits | | 1,100.00 |
Tip: If you later need to refund Hilton instead of fulfilling the order, hit Void on the deposit detail page while it's still Open. The void posts the exact reverse journal and cancels any pending schedule installments. Once any release has been posted, voiding is blocked -- you must reverse those releases first.

Section Snapshot -- after 25.6

ItemValue
4000 Sales (net of CN)2,160 + 360 + 90 + 1,800 - 90 = 4,320
4200 Service Revenue20 + 250 + 200 = 470
2200 GST Collected216 + 38 + 9 + 200 - 9 = 454
5000 COGS (net)600 + 100 + 25 + 500 - 25 = 1,200
1300 Inventory2,300 - 1,200 = 1,100 (= 2,200 units × $0.50)
1100 AR open876 + 0 + 349 + 2,200 = 3,425
1000 Cash71,862 + 319 + 1,500 + 1,100 = 74,781
2520 Customer Deposits1,100

25.7 Banking

Step 25.7.1 -- Import a Bank Statement

Open Banking → Import statement and fill in:

FieldValue
Bank Account1000 Business Bank Account
Statement Date2026-09-30
Opening Balance0.00 (the first line below carries the opening balance)
Closing Balance41806.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:

csv
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.00

The preview should show 12 transactions and confirm that the opening balance plus the transactions equals the closing balance.

Note: The 2026-07-15 van purchase line will need a matching transaction in the system (Step 25.8.2 will create it). Don't reconcile that line yet.

Step 25.7.2 -- Reconcile Matched Lines

Open Bank Reconciliation. The system should auto-suggest matches for:

Statement LineApp Transaction
RPT-RENT JUL -2,420Outgoing Payment to Richmond Property Trust 2026-07-05
RPT-RENT AUG -2,420Outgoing Payment to Richmond Property Trust 2026-08-05
CAFE AURORA PAY +319Incoming Payment from Cafe Aurora 2026-07-22
HILTON PAY PARTIAL +1,500Incoming Payment from Hilton 2026-07-25
TRUCKLINE LOGISTICS -440Outgoing Payment to Truckline 2026-08-05
HILTON DEPOSIT +1,100Customer Deposit CD-0001 (2026-08-15)
DRIVER FUEL REIMB -88Expense Claim payout 2026-08-20
BATCH AP RUN -2,770Batch 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:

FieldValue
Spend Money numberSM-001 (auto)
Date2026-09-25
Bank account1000 Business Bank Account
Payee(text) "CityBank Monthly Fee" -- no contact required
Account6020 Bank Fees
Amount25.00
CurrencyAUD
TaxBAS Excluded
Project / Job(none)
Branch / Department(none)
MemoSeptember 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:

FieldValue
Receive Money numberRM-001 (auto)
Date2026-09-30
Bank account1000 Business Bank Account
Payer(text) "CityBank Interest" -- no contact required
Account4400 Interest Income
Amount50.00
CurrencyAUD
TaxBAS Excluded
Project / Job(none)
MemoQ1 interest credit on operating account
Attachments(none)
Expected GL Impact:
| 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.

FieldValue
Rule nameAuto-categorise CityBank monthly fee
Priority100 (lower number = higher priority)
ActiveYes
ScopeAccount: 1000 Business Bank Account only
DirectionMoney out (debits only)
Description containsBANK MTHLY FEE
Description regex(alternative -- leave blank)
Amount range$20.00 -- $30.00
Counterparty contains--
ActionCreate Spend Money (auto-post)
Account6020 Bank Fees
TaxBAS Excluded
Memo templateMonthly account fee -- {{statement_date}}
Apply retroactivelyNo (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:

IndicatorExpected
Statement closing balance41,806.00
Cash GL closing balance41,806.00
Difference0.00
Common Mistake: A non-zero difference is the single best indicator of unbooked transactions. Don't ignore it -- find every line.

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:

FieldValue
Journal numberJNL-002 (auto -- OPEN-001 was JNL-001)
Date2026-09-30
ReferenceACC-001
SourceManual -- period-end accrual
NarrationAccrue Sept electricity (estimated)
CurrencyAUD
Project / Cost centre(none)
Branch / DepartmentOperations
Recurring template?Optional -- you could promote to a quarterly accrual template
Auto-reverse on date2026-10-01 (the actual CityPower bill in Oct will replace this estimate)
AttachmentsEstimated meter reading photo
Tagsaccrual, period-end, fy27-q1

Lines:

#AccountDescriptionDebitCreditTax
16080 UtilitiesSeptember electricity (estimated)240.00BAS Excluded
22300 AccrualsReverses on 2026-10-01240.00BAS Excluded
Why this matters: Accrual recognises the expense in the period it was incurred, not when the cash leaves. Without it the September P&L would understate utilities.
Note: GST is not booked on accruals -- it is booked when the actual tax invoice arrives (in October).

Step 25.8.2 -- Register the Delivery Van as a Fixed Asset

Open Fixed Assets → + New Asset (menu Fixed assets → Assets).

FieldValue
Asset codeFA-001 (auto)
Asset nameDelivery Van -- Iveco Daily
Asset typeVehicles
Asset tag / Serial / VINVIN: ZCFC359000Z123456
Registration plate1AB-2CD (VIC)
LocationRichmond Warehouse
CustodianSam Driver
ConditionExcellent (new)
SupplierIveco Melbourne (created ad-hoc as a one-off contact, not a saved supplier)
Acquisition date2026-07-15
In-service date2026-07-15
Depreciation start date2026-07-15 (matches in-service date; full-month convention so July gets a full $500)
Cost (ex GST)30,000.00
GST3,000.00
Total cost (inc GST)33,000.00
Salvage / Residual value0.00
Useful life5 years (60 months)
Depreciation methodStraight-Line
Tax depreciation methodDiminishing Value (override for ATO tax-depreciation report)
Tax effective life8 years (ATO Vehicles - Light Commercial)
Low-value poolNo (over the $1,000 threshold)
Asset GL account1500 Fixed Assets - Vehicles
Accumulated depreciation account1800 Accumulated Depreciation
Depreciation expense account7500 Depreciation Expense
Paid from1000 Business Bank Account
Warranty expiry2029-07-14 (3-year manufacturer warranty)
Insurance policy(link to policy doc -- optional)
StatusActive
Tagsvehicle, delivery, q1-fy27
AttachmentsTax invoice from Iveco Melbourne
Expected GL Impact (on registration):
| 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):

FieldValue
Run numberDEP-RUN-001 / 002 / 003 (auto, one per month)
Period2026-07 / 2026-08 / 2026-09
Depreciation method scopeAll methods
Asset selectionAll active assets (currently only FA-001)
Asset pool selection(none in this run)
Calculation basisBook (straight-line per asset)
Recalc-from-scratchNo (incremental from last run)
Posting modeDraft → Review → Post
Post dateLast day of period (e.g. 2026-07-31)
NotesQ1 monthly depreciation

Each run posts:

AccountDrCr
7500 Depreciation Expense500.00
1800 Accumulated Depreciation500.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:

FieldValue
PeriodFY27 Q1 (2026-07-01 -- 2026-09-30)
New statusLocked
Soft-close date2026-10-15 (allows late adjustments by Admin until this date)
Hard-lock date2026-10-31 (no changes after this, even by Admin)
Lock reason / memoQ1 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 lockBookkeeper, Accountant

The system runs a final balance check and refuses to lock if any accounts are out of balance.

Common Mistake: Don't lock until reports tie out (Section 25.9). Locking early means having to unlock to fix anything, which is logged in the Audit Trail.

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:

FieldValue
As-at date2026-09-30
BasisAccrual
CurrencyAUD (company default)
Branch / Department filterAll
Project filterAll
Account categoriesAll (Assets, Liabilities, Equity, Income, Expenses, Contra-Asset, Tax)
Include zero-balance accountsNo
Group byCategory
Show YTD movementNo
Comparison periodNone
Export formatPDF / Excel / CSV
AccountDrCr
1000 Business Bank Account41,806.00
1100 Accounts Receivable3,425.00
1210 GST Paid on Purchases3,958.00
1300 Inventory1,100.00
1500 Fixed Assets - Vehicles30,000.00
1800 Accumulated Depreciation1,500.00
2000 Accounts Payable2,420.00
2200 GST Collected on Sales454.00
2300 Accruals240.00
2520 Customer Deposits1,100.00
2800 Business Loan40,000.00
3000 Owner's Capital40,000.00
4000 Sales4,320.00
4200 Service Revenue470.00
4400 Interest Income50.00
5000 Cost of Goods Sold1,200.00
5100 Freight & Courier400.00
6020 Bank Fees25.00
6080 Utilities460.00
6100 Rent6,600.00
6700 Vehicle Running Costs80.00
7500 Depreciation Expense1,500.00
TOTAL90,554.0090,554.00
Expected Result: Debits equal credits at exactly 90,554.00. If they don't, return to the Section Snapshot tables and identify where the divergence began.

Step 25.9.2 -- Profit & Loss

Open Profit & Loss.

Report parameters:

FieldValue
Period start2026-07-01
Period end2026-09-30
BasisAccrual
CurrencyAUD
Branch / Department filterAll
Project filterAll
Comparison periodNone (alternatives: Prior Year, Prior Period, Budget)
Comparison type--
Show % of revenue columnNo
Round to1 (no rounding)
Group revenue / expenses byCategory
Include zero-balance accountsNo
Export formatPDF / Excel / CSV
LineAmount
Revenue
4000 Sales4,320.00
4200 Service Revenue470.00
4400 Interest Income50.00
Total Revenue4,840.00
Cost of Sales
5000 Cost of Goods Sold1,200.00
5100 Freight & Courier400.00
Gross Profit3,240.00
Operating Expenses
6020 Bank Fees25.00
6080 Utilities460.00
6100 Rent6,600.00
6700 Vehicle Running Costs80.00
7500 Depreciation Expense1,500.00
Total Operating Expenses8,665.00
Net Profit / (Loss)(5,425.00)
Note: Q1 is an investment quarter -- a $30k van and three months of rent before sales scale. The loss is expected.

Step 25.9.3 -- Balance Sheet

Open Balance Sheet.

Report parameters:

FieldValue
As-at date2026-09-30
BasisAccrual
CurrencyAUD
Branch / Department filterAll
Project filterAll
Comparison dateNone (alternative: prior year-end 2026-06-30)
Show net-of-depreciation linesYes
Group byCategory → Sub-category
Include zero-balance accountsNo
Round to1
Export formatPDF / Excel / CSV
LineAmount
Assets
1000 Business Bank Account41,806.00
1100 Accounts Receivable3,425.00
1210 GST Paid (BAS receivable)3,958.00
1300 Inventory1,100.00
1500 Fixed Assets - Vehicles30,000.00
1800 Less: Accumulated Depreciation(1,500.00)
Total Assets78,789.00
Liabilities
2000 Accounts Payable2,420.00
2200 GST Collected454.00
2300 Accruals240.00
2520 Customer Deposits1,100.00
2800 Business Loan40,000.00
Total Liabilities44,214.00
Equity
3000 Owner's Capital40,000.00
Current Year Earnings(5,425.00)
Total Equity34,575.00
Total Liabilities + Equity78,789.00
Expected Result: Total Assets = Total Liabilities + Equity at 78,789.00. The accounting equation holds.

Step 25.9.4 -- Cash Flow

Open Cash Flow.

Report parameters:

FieldValue
Period start2026-07-01
Period end2026-09-30
MethodIndirect (start from net profit, add back non-cash)
BasisAccrual
CurrencyAUD
Branch / Department filterAll
Comparison periodNone
Group byOperating / Investing / Financing
Show monthly columnsNo
Export formatPDF / 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:

FieldValue
As-at date2026-09-30
TypeReceivable
Bucket size30 days
Bucket count4 (Current, 31-60, 61-90, 90+)
Customer filterAll
CurrencyAUD
Branch / Department filterAll
Group byCustomer
Include credit balancesYes
Include zero-balance customersNo
Show invoice detailOptional toggle
Export formatCSV
CustomerCurrent (0-30)31-6061-9090+Total
Hilton Melbourne (INV-001 partial + INV-004)2,200.00876.00003,076.00
Direct Subscriber Group (INV-003)0349.0000349.00
Total AR3,425.00

Step 25.9.6 -- AP Ageing

Open Aged payables.

Report parameters:

FieldValue
As-at date2026-09-30
TypePayable
Bucket size30 days
Bucket count4 (Current, 31-60, 61-90, 90+)
Supplier filterAll
CurrencyAUD
Branch / Department filterAll
Group bySupplier
Include debit balancesYes
Include zero-balance suppliersNo
Show bill detailOptional toggle
Export formatCSV
SupplierCurrent31-60Total
Richmond Property Trust (Sept rent)2,420.0002,420.00
Total AP2,420.00

Step 25.9.7 -- GST / BAS Report

Open Tax > GST & BAS.

Report parameters:

FieldValue
PeriodQuarter (alternative: Custom Dates)
QuarterQ1 (Jul-Sep)
Financial YearThe one running Jul 2026 to Jun 2027
GST basisAccrual, chosen when the company was created (Settings → Company settings to check)
OutputPrint, 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.

LineAmount
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 AccountGL BalanceBAS Report
2200 GST Collected454.00 Cr454.00
1210 GST Paid3,958.00 Dr3,958.00

Both should match exactly.

Step 25.9.8 -- Customer Statement

Open Statements.

Statement parameters:

FieldValue
TypeCustomer Statement
CustomerHilton Melbourne
From2026-07-01
To2026-09-30
OutputPrint (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:

DocDateAmountOutstanding
INV-0012026-07-052,376.00876.00
Payment2026-07-25(1,500.00)--
INV-0042026-08-122,200.002,200.00
Hilton total open3,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:

FieldValue
Date range2026-07-01 -- 2026-09-30 (or "Today" for the live demo session)
User filterAll
Action typeAll (Create / Update / Delete / Post / Lock / Login)
Entity typeAll (or filter to: Journal, Invoice, Bill, Payment, Asset, Period)
Document number contains--
SeverityAll
Group byDate
Export formatCSV (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 / MetricSourceExpected
1Trial Balance Dr = CrTB report90,554.00 = 90,554.00
2Net Profit / (Loss)P&L(5,425.00)
3Total AssetsBalance Sheet78,789.00
4Total L + EBalance Sheet78,789.00
5Closing CashCash Flow41,806.00
6Closing CashBank statement line 1241,806.00
7Total ARAged receivables3,425.00
8Total APAged payables2,420.00
9GST CollectedBAS454.00
10GST PaidBAS3,958.00
11Net BAS (refund)BAS(3,504.00)
12Inventory units (600ml)Stock Movements2,200
13Inventory valueBalance Sheet1,100.00
14Fixed Asset NBVBS (1500 - 1800)28,500.00
15Customer DepositsBalance Sheet1,100.00
16EquityBalance Sheet34,575.00
17*Wages YTD (if Step 25.10 pay runs were processed)P&L 7000 Wages1,140.00 × N pay runs
18*Super payable YTD (if Step 25.10 pay runs were processed)BS 2220 Super Payable136.80 × N pay runs
19*PAYG payable YTD (if Step 25.10 pay runs were processed)BS 2210 PAYG Payable184.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

FieldValue
Default pay frequencyWeekly
Standard hours per week38
Super guarantee rate (%)12
Countryau
Region / Statevic
Financial year endJune

Account mapping (mandatory -- COA codes from Step 25.3.2)

FieldValue
Wages expense account7000 Wages & Salaries (add this to COA if missing -- category Expenses)
Super expense account7010 Superannuation Expense (add to COA -- category Expenses)
PAYG payable2210 PAYG Withholding Payable (add to COA -- category Liabilities)
Super payable2220 Superannuation Payable (add to COA -- category Liabilities)
Wages payable (clearing)2230 Wages Payable (add to COA -- category Liabilities)
Bank account1000 Business Bank Account

Compliance

FieldValue
STP lodgementNot supported -- lodge through your own STP software or agent (Step 25.10.4)
WPN / ABN12 345 678 901 (from Step 25.3.1)
Public holidaysAU - VIC (auto-loaded from the public-holiday seed)
Why this matters: Without these six account FKs the pay run knows where the money should go in the ledger -- without them, it has no idea. The system intentionally refuses to post rather than guess. The four new COA accounts (7000, 7010, 2210, 2220, 2230) are easy adds: same form as Step 25.3.2.

Step 25.10.2 -- Run a Pay Run for Sam Driver

Open Pay Runs, click + New Pay Run.

Header:

FieldValue
Pay run numberPR-001 (auto)
Pay frequencyWeekly
Period start2026-07-06
Period end2026-07-12
Pay date2026-07-15
Bank account1000 Business Bank Account
Posting modeDraft → Review → Post
NotesFirst pay run -- Sam Driver only
STP lodgementNot 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):

FieldValue
EmployeeSam Driver
Hours -- ordinary38
Hours -- overtime0
Hours -- public holiday0
Allowances -- per pay0.00
Deductions -- per pay0.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 withholding184.00
Super contribution (12%)136.80
Net pay956.00
Disbursement BSB / Account062-000 / 1234 5678 (from employee record)

Click Post Pay Run.

Step 25.10.3 -- Expected GL Impact (per pay run)

AccountDrCr
7000 Wages & Salaries1,140.00
7010 Superannuation Expense136.80
2210 PAYG Withholding Payable184.00
2220 Superannuation Payable136.80
1000 Business Bank Account956.00
Running balances after one pay run: Cash decreases by $956.00; PAYG payable accrues $184.00 owed to the ATO at next BAS; Super payable accrues $136.80 owed to AustralianSuper, to be paid through your clearing house within 7 business days of payday (Payday Super). NeatSum records super but does not pay it.

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 hereWhere
Gross, PAYG withheld and super per employeePay run detail, Step 25.10.2
PayslipsPay run detail, per employee
PAYG Withholding Payable balance for your BAS2210, see Step 25.10.3
Super Payable balance to pay through your clearing house2220

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.

FieldValue
Project codePROJ-001 (auto)
Project nameHilton Q3 supply contract
CustomerHilton Melbourne
StatusActive
Start date2026-07-01
End date2026-09-30
Budgeted revenue6,000.00
Budgeted cost1,200.00
Project manager(your user)
Default project tag for new docsYes

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:

FieldValue
EmployeeSam Driver
Date2026-07-08
ProjectHilton Q3 supply contract
Hours4.0
ActivityDelivery
Billable?No (cost-only -- delivery is per-drop billed)
NotesFirst 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.

FieldValue
Budget nameFY27 Q1 Operating Budget
Period typeQuarterly
Period start2026-07-01
Period end2026-09-30
BasisAccount-level
Compare againstActual
CurrencyAUD
Branch / DepartmentAll

Budget lines:

AccountQ1 Budget
4000 Sales8,000.00
6100 Rent6,600.00
6080 Utilities600.00
7500 Depreciation Expense1,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.

FieldValue
Role nameSales Clerk
DescriptionFront-line invoicing role -- can create invoices and quotes only
Permissionssale_invoice:create, sale_invoice:read, contact:read, item:read
Inherits from(none -- bottom-of-stack role)
Default for new usersNo

Then Settings → Approval rules, click New rule:

FieldValue
Rule nameHigh-value PO approval
Document typePurchase Order
TriggerAmount ≥ $1,000.00
Routes toRole: Manager (approve), then Admin (escalation)
Notification channelEmail + in-app inbox
Auto-approve fallbackAfter 48h with no decision, escalate to Admin
ActiveYes
PO-001 ($2,750) would have triggered approval if this rule existed earlier.

Tax depreciation pools -- Open Fixed assets → Tax depreciation pools, click + New Pool.

FieldValue
Pool nameLow Value Pool
Pool typeLow Value Pool (ATO)
Threshold$1,000.00 (per-asset cap)
First-year rate (%)18.75
Subsequent-year rate (%)37.5
Calculation methodDiminishing Value
Asset GL account1510 Low-Value Pool Assets
Accumulated depreciation account1810 Pool Accumulated Depreciation
Depreciation expense account7510 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).

FieldValue
Conversation modeRead + Write (alternative: Read-only)
Allowed toolsReports, Contacts, Items, Invoices, Bills, Journals
Approval required forAny tool that creates or updates records
Context windowCurrent company only
Audit trailEvery 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:

FieldValue
Filter statusAll
Filter templateMonthly Rent -- Richmond warehouse
Filter date range2026-07-01 -- 2027-06-30
Group byTemplate
Show next-fire timestampYes

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.

Two versions of these screens. Every company has Settings > Import data, which reads NeatSum's own CSV layouts. The Xero-style conversion (reading Xero and MYOB exports directly, the Conversion balances screen, the tie-out and a whole-import undo) is in early access: NeatSum turns it on company by company. Where this chapter says "with early access", the step needs it. If you don't see the screen it describes, it is not on for your company yet.

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:

WhatWhere in XeroNeatSum box
Chart of accountsAccounting > Chart of accounts > ExportChart of accounts
ContactsContacts > All contacts > ExportContacts
Trial BalanceReports > Trial Balance, dated the day before the conversion date, accrual basisOpening trial balance
What customers oweReports > Aged Receivables Detail, or Sales > Invoices > ExportOpen invoices
What you owe suppliersReports > Aged Payables Detail, or Purchases > Bills > ExportOpen 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

  1. 1Go to Settings > Import data (the page is called Import your books).
  2. 2Add the files you have. Only the trial balance and the conversion date are needed for balances; the rest is optional.
  3. 3Enter the Conversion date. With early access, if the trial balance says a different date, NeatSum offers to use the day after it.
  4. 4Click Check these files. Nothing is written yet.
  5. 5Read the preview, fix anything it lists, and click Check again until it is clear.
  6. 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.

Need more help? Open the AI Assistant (bottom-right of any page) -- ask questions about your books in plain English, summarise reports, or have it draft an invoice or journal entry for you to review before posting.