Statement Sorter Marlow Bay Upholstery Fictional sample. The business, the bank, every name and every amount are made up. 2026-08-01 to 2026-10-30

Not finished: 9 of 42 lines, A$5,689.10, still need you.

Until then, every total below leaves that money out.

What the statement says
  • 01/08/2026 RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY -2,150.00 7,262.60 REF 00417 STANDING ORDER
  • 03/08/2026 INV 1041 TIDEWATER MOTEL 3,280.00 CR 10,542.60
  • 04/08/2026 EFTPOS HALLORAN FOAM WHOLESALE SYD -612.40 9,930.20 CARD 2207 VALUE 02/08
  • 07/08/2026 TFR TO SAVER 4471 -1,500.00 8,111.45
  • 08/08/2026 ATM WDL WOLLONG ST -300.00 7,811.45
  • 11/08/2026 POS PEBBLE RD SUPERMARKET -186.20 7,625.25
  • 15/08/2026 PYMT T HOLLOWAY 1,800.00 CR 9,318.07
  • 19/08/2026 INV 1042 ROSEDEAN CAFE 1,460.00 CR 10,778.07
  • 04/09/2026 INV 1043 LARCHFIELD SCHOOL 5,240.00 CR 12,646.67
  • 05/09/2026 DENHOLM INDUSTRIAL SEWING MACHINE -4,280.00 8,366.67
  • 10/09/2026 XFER 88213 -950.00 7,115.47
  • 22/09/2026 TAX OFFICE PAYMENT -1,860.00 4,857.81
  • 09/10/2026 TFR TO SAVER 4471 -1,000.00 4,363.81
  • 20/10/2026 LOAN REPAYMENT KINGFISHER FINANCE -620.00 4,607.61
  • 27/10/2026 TOPSTITCH TRADE DAY -410.00 4,109.51
  • 30/10/2026 INTEREST 3.18 CR 4,073.69
Sorted. Dashed means our guess, not checked.
  • ATM WDL WOLLONG STNeeds you-A$300.00
  • PYMT T HOLLOWAYNeeds you+A$1,800.00
  • INV 1042 ROSEDEAN CAFENeeds you+A$1,460.00
  • XFER 88213Needs you-A$950.00
  • LOAN REPAYMENT KINGFISHER FINANCENeeds you-A$620.00
  • TOPSTITCH TRADE DAYNeeds you-A$410.00
  • INV 1041 TIDEWATER MOTELSales and fees+A$3,280.00
  • INV 1043 LARCHFIELD SCHOOLSales and fees+A$5,240.00
  • INTERESTInterest received+A$3.18
  • RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY REF 00417 STANDING ORDERRent-A$2,150.00
  • EFTPOS HALLORAN FOAM WHOLESALE SYD CARD 2207 VALUE 02/08Stock and materials-A$612.40
  • TAX OFFICE PAYMENTTax and government payments-A$1,860.00
  • POS PEBBLE RD SUPERMARKETPrivate-A$186.20
  • DENHOLM INDUSTRIAL SEWING MACHINELarge purchase-A$4,280.00
  • TFR TO SAVER 4471Between my accounts-A$1,500.00
  • TFR TO SAVER 4471Between my accounts-A$1,000.00

and 26 more lines in the workbook

What needs you

LineDateStatement saysAmountWhat I need to knowMy suggestion
62026-08-08ATM WDL WOLLONG ST-A$300.00Cash out. I can't tell what the cash paid for.Private
102026-08-15PYMT T HOLLOWAY+A$1,800.00Money came in and the line doesn't say why. A sale, a loan, money of your own, or something else?Sales and fees
112026-08-19INV 1042 ROSEDEAN CAFE+A$1,460.00A$1,460.00 came in, at or above the A$1,000.00 you asked to see. Is this what it looks like: earned, not borrowed or your own money?Sales and fees
212026-09-10XFER 88213-A$950.00A transfer, and I can't tell whose account the other end is. Yours, or a payment to someone?No suggestion
262026-09-18POSTAGE PARCEL DEPOT-A$36.50Same date, wording and amount as line 25, and the balance moved both times. The bank did take it twice. Is that right, or do you need to ask for it back?No suggestion
282026-09-26REFUND BRIGHTWATER TEXTILES+A$64.00This looks like a refund, but the purchase it came from is not on this statement. What category did that purchase belong to?No suggestion
322026-10-06PHARMACY LARKSPUR-A$48.60Says "pharmacy", which is often private. Business or private?Private
382026-10-20LOAN REPAYMENT KINGFISHER FINANCE-A$620.00Says "repayment". A loan payment is often part debt and part interest, so it stays out of spending until you say. Keep it as Loan money, or split it?Loan money
402026-10-27TOPSTITCH TRADE DAY-A$410.00Nothing on this line says what it was for.No suggestion

Lines of A$1,000.00 or more you have already answered

LineDateStatement saysAmountWhat I need to knowCategory now
12026-08-01RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY REF 00417 STANDING ORDER-A$2,150.00Your rule: "CRAIGMOOR"Rent
22026-08-03INV 1041 TIDEWATER MOTEL+A$3,280.00Your rule: "TIDEWATER MOTEL"Sales and fees
52026-08-07TFR TO SAVER 4471-A$1,500.00Goes to your own account "SAVER 4471"Between my accounts
152026-09-01RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY-A$2,150.00Your rule: "CRAIGMOOR"Rent
182026-09-04INV 1043 LARCHFIELD SCHOOL+A$5,240.00Your rule: "LARCHFIELD SCHOOL"Sales and fees
192026-09-05DENHOLM INDUSTRIAL SEWING MACHINE-A$4,280.00Your rule: "DENHOLM"Large purchase
272026-09-22TAX OFFICE PAYMENT-A$1,860.00Your rule: "TAX OFFICE"Tax and government payments
302026-10-01RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY-A$2,150.00Your rule: "CRAIGMOOR"Rent
312026-10-02INV 1044 TIDEWATER MOTEL+A$2,975.00Your rule: "TIDEWATER MOTEL"Sales and fees
342026-10-09TFR TO SAVER 4471-A$1,000.00Goes to your own account "SAVER 4471"Between my accounts

Our guesses, not checked

One word suggested these. Nobody has confirmed them. Please scan them.

LineDateStatement saysAmountWhat I need to knowCategory now
82026-08-12MERCHANT FEE AUG-A$42.18The line says "merchant fee"Bank and payment fees
222026-09-12MERCHANT FEE SEP-A$39.66The line says "merchant fee"Bank and payment fees
232026-09-12BOOKKEEPER J ANSTEY-A$220.00The line says "bookkeeper"Accountant and legal
252026-09-18POSTAGE PARCEL DEPOT-A$36.50The line says "postage"Office supplies
352026-10-12MERCHANT FEE OCT-A$51.20The line says "merchant fee"Bank and payment fees
372026-10-15INV 1045 ROSEDEAN CAFE+A$980.00The line says "inv"Sales and fees
422026-10-30INTEREST+A$3.18The line says "interest"Interest received

Checks against the statement

  • Lines that could not be read (should be 0)OK
  • All categories add up to all linesOK
  • Opening balance plus all movements equals closing balanceOK
  • Places where the running balance does not follow (should be 0)OK
  • Lines outside the period the statement states (should be 0)OK
  • Statement can be shown to be completeOK
  • Possible duplicates flagged (for you to look at)1

Month by month

MonthMoney inSpendingTax and governmentPrivateLarge purchasesUndecidedNet movement
Aug 2026A$3,280.00A$3,749.63A$186.20A$3,560.00+A$804.17
Sep 2026A$5,240.00A$3,511.46A$1,860.00A$4,280.00A$1,050.50-A$5,333.96
Oct 2026A$3,958.18A$2,688.70A$1,078.60-A$809.12

What each rule caught

  • SEWPROSoftware and subscriptions

    SEWPRO MONTHLY SUBSCRIPTION-A$39.00

    SEWPRO MONTHLY SUBSCRIPTION-A$39.00

    SEWPRO MONTHLY SUBSCRIPTION-A$39.00

  • SUPERMARKETPrivate

    POS PEBBLE RD SUPERMARKET-A$186.20

  • DENHOLMLarge purchase

    DENHOLM INDUSTRIAL SEWING MACHINE-A$4,280.00

  • CRAIGMOORRent

    RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY REF 00417 STANDING ORDER-A$2,150.00

    RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY-A$2,150.00

    RENT WORKSHOP BAY 4 CRAIGMOOR PROPERTY-A$2,150.00

  • NTH COAST POWERPower, water and gas

    DD ELECTRICITY NTH COAST POWER-A$318.75

    DD ELECTRICITY NTH COAST POWER-A$301.20

    DD ELECTRICITY NTH COAST POWER-A$295.40

  • KESTREL TELPhone and internet

    MOBILE PLAN BILLPAY KESTREL TEL-A$65.00

    MOBILE PLAN BILLPAY KESTREL TEL-A$65.00

    MOBILE PLAN BILLPAY KESTREL TEL-A$65.00

  • HALLORAN FOAMStock and materials

    EFTPOS HALLORAN FOAM WHOLESALE SYD CARD 2207 VALUE 02/08-A$612.40

    EFTPOS HALLORAN FOAM WHOLESALE SYD-A$780.10

    REFUND HALLORAN FOAM WHOLESALE+A$120.00

  • COPPERTOPTravel and fuel

    FUEL COPPERTOP SERVO-A$94.30

    FUEL COPPERTOP SERVO-A$88.10

  • BUSINESS PACKInsurance

    INSURANCE BUSINESS PACK QUARTERLY-A$428.00

  • TAX OFFICETax and government payments

    TAX OFFICE PAYMENT-A$1,860.00

  • TIDEWATER MOTELSales and fees

    INV 1041 TIDEWATER MOTEL+A$3,280.00

    INV 1044 TIDEWATER MOTEL+A$2,975.00

  • LARCHFIELD SCHOOLSales and fees

    INV 1043 LARCHFIELD SCHOOL+A$5,240.00

  • Your account: SAVER 4471Between my accounts

    TFR TO SAVER 4471-A$1,500.00

    TFR TO SAVER 4471-A$1,000.00

Assumptions to confirm

  • Every line of A$1,000.00 or more, in or out, is on the first sheet, waiting or already answered.

What this does not do

Tying only means the sums add up. It does not mean a category is right.

It runs on this computer and uploads nothing. If you paste a statement into a chat, your AI service receives it. To avoid that, give your agent the file path instead.

Alipay and WeChat exports: the columns were taken from public sample files in an open-source bookkeeping project. Neither company publishes a specification that I could find, and no real export has been tried. If the columns don't match, the tool stops and says so.

Formulas were worked out by the pack's own calculator, and the file was not opened in real Excel.

It does not say what is deductible. Your accountant decides that.