Brisbane Transport Museum

QOCS - Brisbane Transport Museum

Operational data for admissions, cash, stock, and daily Square reporting.

Treasurer income detailed report

Build a copy-ready transaction-level income table from completed Square cash and card payments, with line items allocated to the same columns used in the QOCS income spreadsheet.

Detailed report filters

CSV Excel

Summary totals

Rows
69
Transactions and refund rows in the preview.
Total cash sales
$145.00
Positive cash payment rows.
Total card sales
$1,245.88
Positive card payment rows.
Total refunds
$0.00
Refund rows shown as negative values.
Net total
$1,390.88
Cash plus card less refunds.
GST collected
$126.12
Square tax amount across included rows.

Total by income category

Membership Books & Magazines Food & Drink Shirts Badges & Donations GST Refund Film Hire Museum Admission
$0.00 $91.44 $100.93 $135.82 $0.00 $0.00 $1,054.56

Range interpreted in Australia/Brisbane from 01 Aug 2026 00:00 to 18 Aug 2026 23:59.

Warnings

Unmapped Square items

  • Unnamed item x 1 is not mapped to a treasurer income column.
  • V2292 Key Ring - Regular x 1 is not mapped to a treasurer income column.

Orders where category totals do not match the transaction total

  • TR2P (Unnamed item x 1) differs by 1.02 between Total Amount and allocated categories.
  • 7hcN (BTM Fridge Magnet - Bus 100 1983 MAN SL200 x 1; Pepsi Max 375ml - Regular x 1; V2292 Key Ring - Regular x 1) differs by 7.11 between Total Amount and allocated categories.

Detailed preview table

Date Details Receipt Total Amount Membership Books & Magazines Food & Drink Shirts Badges & Donations GST Refund Film Hire Museum Admission GST Collected Payment Method Square Reference
2026-08-02 Club Polo-Shirt - Medium, With Pocket x 1 1wFh 41.40 0.00 0.00 0.00 41.40 0.00 0.00 0.00 3.76 CARD Payment 1wFhUJ...rFZY / Order LFUDCI...UaZY
2026-08-02 Unnamed item x 1 TR2P 1.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.09 CARD Payment TR2PFR...CNZY / Order l8J78t...5YZY
2026-08-02 Museum Admission - Adult x 1; Museum Admission - Child x 2 pM6f 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment pM6f8a...PJZY / Order 1s1xzU...vNZY
2026-08-02 Museum Admission - Concession x 1 jJo0 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment jJo0fY...5fZY / Order zHNWBp...6UZY
2026-08-02 Museum Admission - Adult x 1 hOLi 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment hOLicZ...UdZY / Order l6680z...jEZY
2026-08-02 Museum Admission - Concession x 1 nH8v 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment nH8vje...3VZY / Order bP5Rmt...GgZY
2026-08-02 Museum Admission - Concession x 1 hepP 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment hepPfi...yXZY / Order 3dfqzU...pFZY
2026-08-02 Museum Admission - Adult x 1 DDzh 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment DDzhoY...PLZY / Order zhGYXb...4ZZY
2026-08-02 Museum Admission - Concession x 1 znBv 15.00 0.00 0.00 0.00 0.00 0.00 0.00 15.00 1.36 CASH Payment znBvJe...seZY / Order DpIdLy...HCZY
2026-08-02 Museum Admission - Concession x 1 NwPT 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment NwPTfA...HSZY / Order vhVFsm...ILZY
2026-08-02 Museum Admission - Concession x 2 R6Jw 30.48 0.00 0.00 0.00 0.00 0.00 0.00 30.48 2.77 CARD Payment R6JwIE...2IZY / Order pEYXD7...RJZY
2026-08-02 Museum Admission - Adult x 1 d0vE 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment d0vEBR...JFZY / Order RA0pgE...OEZY
2026-08-02 Museum Admission - Adult x 2 D98t 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment D98tFX...GZZY / Order XreG9Q...D7YY
2026-08-02 Museum Admission - Family x 1 taIb 50.00 0.00 0.00 0.00 0.00 0.00 0.00 50.00 4.55 CASH Payment taIbQG...xJZY / Order dqi95D...j7YY
2026-08-02 Museum Admission - Concession x 1; Museum Admission - Companion Card - x 1 hISJ 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment hISJbu...qaZY / Order 1MB3LO...PfZY
2026-08-02 Museum Admission - Child x 1 Lxug 10.16 0.00 0.00 0.00 0.00 0.00 0.00 10.16 0.92 CARD Payment LxugoV...TWZY / Order P5Hwum...jSZY
2026-08-02 Museum Admission - Child x 1 r5ei 10.16 0.00 0.00 0.00 0.00 0.00 0.00 10.16 0.92 CARD Payment r5eiAt...kBZY / Order dqqpFh...7AZY
2026-08-02 Museum Admission - Child x 1 DpcY 10.16 0.00 0.00 0.00 0.00 0.00 0.00 10.16 0.92 CARD Payment DpcYYx...DVZY / Order vDQWQD...pEZY
2026-08-02 Museum Admission - Child x 1; Museum Admission - Adult x 1 54Sg 30.48 0.00 0.00 0.00 0.00 0.00 0.00 30.48 2.77 CARD Payment 54Sgtd...1XZY / Order RGz7q2...gHZY
2026-08-02 Museum Admission - Adult x 2 3FNC 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment 3FNCTI...xRZY / Order 5unild...WaZY
2026-08-02 Museum Admission - Family x 1 HXWm 50.80 0.00 0.00 0.00 0.00 0.00 0.00 50.80 4.62 CARD Payment HXWmCh...OWZY / Order Fw7rYV...KIZY
2026-08-02 Museum Admission - Adult x 2 Fkbt 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment Fkbtyj...FXZY / Order J0sfwu...tWZY
2026-08-02 Museum Admission - Concession x 1; Museum Admission - Adult x 1 Fgni 35.56 0.00 0.00 0.00 0.00 0.00 0.00 35.56 3.23 CARD Payment FgniBJ...AUZY / Order Ptf72R...8VZY
2026-08-02 Sausage Sizzle - Regular x 2 rjni 5.00 0.00 0.00 5.00 0.00 0.00 0.00 0.00 0.45 CASH Payment rjnijR...JfZY / Order NsDpcr...DXZY
2026-08-02 Pepsi Max 375ml - Regular x 1 RAGD 1.02 0.00 0.00 1.02 0.00 0.00 0.00 0.00 0.09 CARD Payment RAGDd1...jVZY / Order HprjJc...PSZY
2026-08-02 Museum Admission - Adult x 2; Museum Admission - Concession x 1 VUxa 55.88 0.00 0.00 0.00 0.00 0.00 0.00 55.88 5.08 CARD Payment VUxagX...l8YY / Order py16bH...RBZY
2026-08-02 Museum Admission - Adult x 2 n5zc 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment n5zca0...oTZY / Order 54QmSN...IXZY
2026-08-02 Bus Badge BCC Man 18.310 W1487 x 1 tyKm 12.19 0.00 0.00 0.00 12.19 0.00 0.00 0.00 1.11 CARD Payment tyKmMO...5DZY / Order vpthzp...KIZY
2026-08-02 Coke Can 375ml - Regular x 1; NU Springwater 600ML - Regular x 1; Solo 375ml - Regular x 1; Kirks Pasito 375ml - Regular x 1; Dairy Milk Chocolate - Regular x 1; Sausage Sizzle - Regular x 4 fRz5 20.83 0.00 0.00 20.83 0.00 0.00 0.00 0.00 1.76 CARD Payment fRz5o0...o8YY / Order j9qr8P...G6YY
2026-08-02 Museum Admission - Adult x 2 zrNq 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment zrNqOr...36YY / Order 7lIBJS...m7YY
2026-08-02 Museum Admission - Adult x 1 tqaa 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment tqaaFe...FLZY / Order LBmdua...oMZY
2026-08-02 Sausage Sizzle - Regular x 2 t8Vn 5.08 0.00 0.00 5.08 0.00 0.00 0.00 0.00 0.46 CARD Payment t8VnRd...5SZY / Order NcbHt0...XDZY
2026-08-02 Sausage Sizzle - Regular x 1; Pepsi Max 375ml - Regular x 1 vzA5 3.50 0.00 0.00 3.50 0.00 0.00 0.00 0.00 0.32 CASH Payment vzA5A6...4JZY / Order 7FmMNz...OTZY
2026-08-02 Museum Admission - Family x 1 xKJm 50.00 0.00 0.00 0.00 0.00 0.00 0.00 50.00 4.55 CASH Payment xKJmzM...VdZY / Order PtJKP1...rXZY
2026-08-02 Sausage Sizzle - Regular x 2; Coke Can 375ml - Regular x 1 tuUI 8.13 0.00 0.00 8.13 0.00 0.00 0.00 0.00 0.74 CARD Payment tuUIuS...e8YY / Order RcIWtc...nOZY
2026-08-02 Museum Admission - Adult x 2 RuNT 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment RuNTva...TUZY / Order bN66sO...SYZY
2026-08-02 Sausage Sizzle - Regular x 1; Pepsi Max 375ml - Regular x 1 z9a4 3.56 0.00 0.00 3.56 0.00 0.00 0.00 0.00 0.32 CARD Payment z9a4Ax...3IZY / Order xqdLwj...cfZY
2026-08-02 Museum Admission - Adult x 2 vVJX 40.64 0.00 0.00 0.00 0.00 0.00 0.00 40.64 3.69 CARD Payment vVJXJU...dFZY / Order VIVKpQ...zeZY
2026-08-02 Sausage Sizzle - Regular x 2; Pepsi Max 375ml - Regular x 2 R2z8 7.11 0.00 0.00 7.11 0.00 0.00 0.00 0.00 0.65 CARD Payment R2z8Xw...XJZY / Order fPuyht...ZBZY
2026-08-02 Museum Admission - Concession x 1; Museum Admission - Companion Card - x 1; Museum Admission - Adult x 1 Zoa6 35.56 0.00 0.00 0.00 0.00 0.00 0.00 35.56 3.23 CARD Payment Zoa6w3...CaZY / Order Tz7aJy...0EZY
2026-08-02 Museum Admission - Adult x 1 LvJO 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment LvJOUZ...LSZY / Order la05uc...JSZY
2026-08-02 Sausage Sizzle - Regular x 1 d4X3 2.54 0.00 0.00 2.54 0.00 0.00 0.00 0.00 0.23 CARD Payment d4X3tD...eNZY / Order dUVOgE...vcZY
2026-08-02 Sausage Sizzle - Regular x 4 hehr 10.16 0.00 0.00 10.16 0.00 0.00 0.00 0.00 0.92 CARD Payment hehrrS...V9YY / Order FWEQHu...k6YY
2026-08-02 Dairy Milk Chocolate - Regular x 1; Bus Badge CityGlider x 1 zX3M 14.73 0.00 0.00 2.54 12.19 0.00 0.00 0.00 1.34 CARD Payment zX3Mcw...jUZY / Order 58I5UY...KLZY
2026-08-02 Sausage Sizzle - Regular x 2 5QMr 5.08 0.00 0.00 5.08 0.00 0.00 0.00 0.00 0.46 CARD Payment 5QMrjp...GUZY / Order VyWS2S...7CZY
2026-08-02 Bus Badge Orange Panther x 1 9stH 12.19 0.00 0.00 0.00 12.19 0.00 0.00 0.00 1.11 CARD Payment 9stHuG...8GZY / Order J8KQyM...jYZY
2026-08-02 Museum Admission - Adult x 1 PNtf 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment PNtfbD...79YY / Order dC04dT...A9YY
2026-08-02 Museum Admission - Concession x 1; Museum Admission - Adult x 1 dqqE 35.56 0.00 0.00 0.00 0.00 0.00 0.00 35.56 3.23 CARD Payment dqqEjG...kTZY / Order vPOQxY...xbZY
2026-08-02 Museum Admission - Adult x 1 D1W2 20.32 0.00 0.00 0.00 0.00 0.00 0.00 20.32 1.85 CARD Payment D1W2e1...zFZY / Order hqfsBX...nFZY
2026-08-02 Museum Admission - Concession x 1 f7Oc 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment f7OcKH...dTZY / Order DtudMf...ffZY
2026-08-02 Sausage Sizzle - Regular x 1 rloS 2.50 0.00 0.00 2.50 0.00 0.00 0.00 0.00 0.23 CASH Payment rloSHX...YHZY / Order 1gVKYP...lFZY
2026-08-02 Sausage Sizzle - Regular x 1 FicO 2.54 0.00 0.00 2.54 0.00 0.00 0.00 0.00 0.23 CARD Payment FicOa5...6NZY / Order F6QzQd...nYZY
2026-08-02 Sausage Sizzle - Regular x 3 7xuK 7.62 0.00 0.00 7.62 0.00 0.00 0.00 0.00 0.69 CARD Payment 7xuKYm...aSZY / Order J42tZA...2CZY
2026-08-02 QBIC 100 Years Commemorative Booklet - Regular x 1 FAB9 30.48 0.00 30.48 0.00 0.00 0.00 0.00 0.00 2.77 CARD Payment FAB90R...ndZY / Order P3g1CA...8KZY
2026-08-02 BTM Fridge Magnet - Bus 100 1983 MAN SL200 x 1; Pepsi Max 375ml - Regular x 1; V2292 Key Ring - Regular x 1 7hcN 13.21 0.00 0.00 1.02 5.08 0.00 0.00 0.00 1.20 CARD Payment 7hcNA4...GYZY / Order XRXV9t...3AZY
2026-08-02 Sausage Sizzle - Regular x 2 tmeP 5.08 0.00 0.00 5.08 0.00 0.00 0.00 0.00 0.46 CARD Payment tmeP2E...5aZY / Order vzCdVn...meZY
2026-08-02 Bus Badge BCC Man 18.310 W1487 x 1 1kBy 12.19 0.00 0.00 0.00 12.19 0.00 0.00 0.00 1.11 CARD Payment 1kByWU...HTZY / Order zdEGE6...BGZY
2026-08-02 Bus Badge Green VST x 1 pYu4 12.19 0.00 0.00 0.00 12.19 0.00 0.00 0.00 1.11 CARD Payment pYu43d...kMZY / Order B46Kbw...K7YY
2026-08-02 Pepsi Max 375ml - Regular x 1 PFDq 1.02 0.00 0.00 1.02 0.00 0.00 0.00 0.00 0.09 CARD Payment PFDqoi...FbZY / Order 7PTK6f...iaZY
2026-08-02 Caramilk Bar - Regular x 1; Fanta Can 375ml - Regular x 1 LTry 4.57 0.00 0.00 4.57 0.00 0.00 0.00 0.00 0.42 CARD Payment LTrysq...XBZY / Order fzmN78...MZZY
2026-08-02 First 50 Years of Motorised Buses in Brisbane 1911-1960s - Regular x 1 5soW 30.48 0.00 30.48 0.00 0.00 0.00 0.00 0.00 2.77 CARD Payment 5soWfE...Q9YY / Order xyXwzE...RCZY
2026-08-10 Museum Admission - Concession x 1 9Qnx 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment 9QnxZm...6fZY / Order BubPjk...7GZY
2026-08-10 Museum Admission - Concession x 1 LL3g 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment LL3gvi...nXZY / Order 77NAJE...WYZY
2026-08-10 Museum Admission - Concession x 1 dqoh 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment dqohED...iLZY / Order DlibIz...vBZY
2026-08-10 Museum Admission - Concession x 1 JSza 15.24 0.00 0.00 0.00 0.00 0.00 0.00 15.24 1.39 CARD Payment JSzaGO...0OZY / Order LzH5lI...79YY
2026-08-10 Museum Admission - Concession x 1 BsWc 15.00 0.00 0.00 0.00 0.00 0.00 0.00 15.00 1.36 CASH Payment BsWcG6...DbZY / Order vzqVkc...CXZY
2026-08-10 QBIC 100 Years Commemorative Booklet - Regular x 1 L5wR 30.48 0.00 30.48 0.00 0.00 0.00 0.00 0.00 2.77 CARD Payment L5wRdf...heZY / Order nv8MLm...zHZY
2026-08-10 Matchbox Car Models - Regular x 1 7XL3 4.00 0.00 0.00 0.00 4.00 0.00 0.00 0.00 0.36 CASH Payment 7XL3kK...iDZY / Order PFteOb...CIZY
2026-08-10 BUS BADGE BCC VOLGREN OPTIMUS x 1; Bus Badge Orange Panther x 1; Frantelle Water 600ml - Regular x 1 LznO 26.42 0.00 0.00 2.03 24.39 0.00 0.00 0.00 2.22 CARD Payment LznO7K...aAZY / Order V4r149...W9YY