IncomeSync

What it does

Statements in. An income picture out.

Everything below is in the shipped program. Where something is coming but not built, this site says so rather than implying otherwise.

1. Importing

Point IncomeSync at a folder, or drop files into an inbox it watches. It reads Excel and PDF commission statements from multiple suppliers, in formats that do not agree with one another.

Deduplication that is not naive

Every statement line is fingerprinted from the values as they were printed, before any name tidying happens, so normalising a supplier name later can never silently create or destroy a duplicate.

Ranked sources

When a detailed statement and a summary statement cover the same period and adviser, the more detailed source supersedes the less detailed one. The ranking is a setting in your installation, not a rule buried in code.

A managed document library

Imported statements are filed as FY 2026-27 / 2026-08 Aug /…. Files are moved and renamed within the library only — never deleted, never overwritten. A name collision gets a numbered suffix instead.

Nothing is quietly dropped

Files IncomeSync recognises as duplicates go to _Duplicates. Files it cannot parse go to _Needs Attention, where you can see them, rather than into a log nobody reads.

2. Making the names line up

Raw statement records are never edited. Everything below is applied when you look at the numbers, which means you can change your mind, and your original import stays exactly as the supplier sent it.

Name and grouping features
FeatureWhat it solves
Name-variant mergingB Smith, Barry Smith and Smith B are one client, counted once.
Client groupsSmith Trucking and Smith Investments roll up to “Smith Group” when you want the household or business view, and stay separate when you do not.
Advisers with rankLead, secondary and tertiary adviser on the same income, so split arrangements report honestly.
Suppliers and product typesYour own categories, set up as data in your installation. No hard-coded list of somebody else's suppliers.
Known-ceased marking“Yes, that policy was cancelled, we knew” — recorded once, so it stops appearing on the worklist.

Where a name was guessed, the screen says so. If a client or adviser was inferred from statement text rather than read from a column or set by you, the program shows you which of the three it was. An ambiguous match resolves to nothing at all, because income attributed to the wrong client is worse than income attributed to nobody.

3. Analysis

Overview

Where the income came from this period, at a glance.

Clients

Income by client and by client group, largest first.

Advisers

Income by adviser, respecting lead and secondary ranking.

Policies

Income by policy and product type.

Upfront vs ongoing

The split that tells you how much of the book is recurring.

Periods and trends

Month by month and year by year, on the Australian financial year.

Compare

This financial year against last, side by side.

At risk

Streams that have stopped or gone quiet, with the ones you have already acknowledged filtered out.

Drill-down

Click any figure and see the statement lines that make it up.

The income figure throughout is the adviser share excluding GST — the amount that actually reaches your account, not the supplier-level gross. One definition, used everywhere, so two screens can never disagree.

4. Getting it out

PDF reports

For client meetings and for your own review. Carries your business name and logo.

Excel exports

For your accountant, in a workbook they can work with rather than a screenshot they have to retype.

5. Living with it

Your branding

Business name, address, contact details and logo, applied through the program and onto every report.

An app password

Optional password on opening the program, for a shared desk.

Backups

Automatic backups, and a second backup folder you nominate — put it on a different drive.

Safe upgrades

Every change to the database structure ships with a migration and takes an automatic backup first.

Set up as data, not code

Suppliers, categories, adviser names, financial-year start: all configuration, all yours to change.

Guided first run

A setup wizard walks the first install through business details, folders and your first import.

Being straight about the edges

  • Windows is the supported platform. IncomeSync is built and tested for Windows first, and that is what is sold.
  • One licence, one computer, one user. It is not a shared server product and does not pretend to be.
  • Your parsers are only as current as your statements. When a supplier changes a statement layout, the parser for it has to be updated. That is real ongoing work and it is part of what a renewal pays for.
  • It reports, it does not reconcile your books. IncomeSync tells you what your statements say. It is not an accounting system and does not replace one.