Spreadsheet: 541739d1507534355-return-amount-values-based-on-date-and-name-criteria-cash-outflow-reporting
Sheet: RAWFILE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper column1 | Helper column2 |  |  |  |  |  | Subbie Payments
 | Date | Ref | Tran | BankSt | Per | Payments | Receipts | Note |  | WeekEnding |  |  |  |  |  |  |  |  |  |  |  | Creditors Payments
 | 2017-08-22 00:00:00 | 228171 | CBPAY | 2208 | FUT | 15380.05 |  | Payment |  |  |  |  |  |  |  |  |  |  |  |  |  | Payroll Payments
 | 2017-08-25 00:00:00 | 258171 | CBPAY | 2808 | FUT | 5311.36 |  | Oasis Inc.
 | 2017-08-25 00:00:00 | 258172 | CBPAY | 2808 | FUT | 4383.4 |  | [NAME]
 | 2017-08-25 00:00:00 | 258173 | CBPAY | 2808 | FUT | 6195.7 |  | Payment
 | 2017-08-25 00:00:00 | S25801 | CBPAY | 2808 | FUT | 5065.89 |  | Accurata
 | 2017-08-25 00:00:00 | S25803 | CBPAY | 2808 | FUT | 11822.27 |  | AmpleX Inc
 | 2017-08-25 00:00:00 | S25804 | CBPAY | 2808 | FUT | 19811.56 |  | [NAME]
 | 2017-08-25 00:00:00 | S25805 | CBPAY | 2808 | FUT | 10025.37 |  | Eletric Co.
 | 2017-08-25 00:00:00 | S25806 | CBPAY | 2808 | FUT | 10598 |  | E Team Co.
 | 2017-08-25 00:00:00 | S25807 | CBPAY | 2808 | FUT | 2985.13 |  | Hire Us Inc.
 | 2017-08-25 00:00:00 | S25808 | CBPAY | 2808 | FUT | 24.68 |  | Post No.
 | 2017-08-25 00:00:00 | S25809 | CBPAY | 2808 | FUT | 4384.25 |  | Timberland
 | 2017-08-25 00:00:00 | S25810 | CBPAY | 2808 | FUT | 1654.95 |  | Axis Arrow
 | 2017-08-25 00:00:00 | S25811 | CBPAY | 2808 | FUT | 8800 |  | [NAME]
 | 2017-08-25 00:00:00 | S25812 | CBPAY | 2808 | FUT | 5328.18 |  | Const.net
 | 2017-08-25 00:00:00 | S25814 | CBPAY | 2808 | FUT | 6758.95 |  | Dayclore
 | 2017-08-25 00:00:00 | S25817 | CBPAY | 2808 | FUT | 10051.61 |  | Crackery
 | 2017-08-25 00:00:00 | S25819 | CBPAY | 2808 | FUT | 660 |  | Co Concepts
 | 2017-08-25 00:00:00 | S25820 | CBPAY | 2808 | FUT | 5247 |  | Cross Reference Co
 | 2017-08-25 00:00:00 | S25822 | CBPAY | 2808 | FUT | 4201.04 |  | [NAME]
 | 2017-08-25 00:00:00 | C25817 | CBPAY | 2808 | FUT | 1105.51 |  | LBN Inc.
 | 2017-08-25 00:00:00 | C25818 | CBPAY | 2808 | FUT | 3359.11 |  | Maraki group
 | 2017-08-25 00:00:00 | C25819 | CBPAY | 2808 | FUT | 16112.06 |  | Crafts and Stuffs
 | 2017-08-25 00:00:00 | C25820 | CBPAY | 2808 | FUT | 18699.12 |  | [NAME]
 | 2017-08-25 00:00:00 | C25821 | CBPAY | 2808 | FUT | 16753 |  | McG Enterprise
 | 2017-08-25 00:00:00 | C25822 | CBPAY | 2808 | FUT | 6727.98 |  | [NAME]
 | 2017-08-25 00:00:00 | C25823 | CBPAY | 2808 | FUT | 8263.15 |  | NewGen Tiling
 | 2017-08-25 00:00:00 | C25824 | CBPAY | 2808 | FUT | 4620.68 |  | NextGen Designs
 | 2017-08-25 00:00:00 | C25825 | CBPAY | 2808 | FUT | 5102.46 |  | Paradox Constuction
 | 2017-08-25 00:00:00 | C25826 | CBPAY | 2808 | FUT | 127.99 |  | PoolUs
 | 2017-08-25 00:00:00 | C25827 | CBPAY | 2808 | FUT | 201.57 |  | PPT Industries
 | 2017-08-28 00:00:00 | 288174 | CBPAY | 2808 | FUT | 0.03 |  | Payment
 | 2017-08-28 00:00:00 | 288175 | CBPAY | 2808 | FUT | 24625.92 |  | Payment
 | 2017-08-28 00:00:00 | P-WK01 | PATRF | 2808 | FUT | 32850.87 |  | PAYROLL TRANSFER
 | 2017-08-29 00:00:00 | 298171 | CBPAY | 2908 | FUT | 55 |  | Payment
 | 2017-08-29 00:00:00 | P-WK01 | PATRF | 2808 | FUT | 1367.65 |  | PAYROLL TRANSFER
 | 2017-08-31 00:00:00 | 310804 | CBPAY | 3108 | FUT | 7610 |  | Q LEAVE
 | 2017-08-31 00:00:00 | C31801 | CBPAY | 3008 | FUT | 27494.02 |  | ACCESS INSULATION
 | 2017-08-31 00:00:00 | C31805 | CBPAY | 3008 | FUT | 24312.48 |  | [NAME] Timber [NAME]
 | 2017-08-31 00:00:00 | C31845 | CBPAY | 3008 | FUT | 6692.84 |  | POLES & HOLES
 | 2017-08-31 00:00:00 | C31846 | CBPAY | 3008 | FUT | 54010.22 |  | Q-Crete Premix
 | 2017-08-31 00:00:00 | C31847 | CBPAY | 3008 | FUT | 2301.41 |  | [NAME] SHEET M
 | 2017-08-31 00:00:00 | C31858 | CBPAY | 3108 | FUT | 10114.5 |  | STRUCTERRE CONSULT
 | 2017-08-31 00:00:00 | C31863 | CBPAY | 409 | FUT | 155029.32 |  | TREND WINDOWS & DO
 | 2017-08-31 00:00:00 | C31864 | CBPAY | 3008 | FUT | 27214 |  | The Truss Company
 | 2017-08-31 00:00:00 | C31866 | CBPAY | 3008 | FUT | 1637.9 |  | Ultraprint
 | 2017-08-31 00:00:00 | C31867 | CBPAY | 3108 | FUT | 264 |  | United Hire Group
 | 2017-09-01 00:00:00 | 19171 | CBPAY | 109 | FUT | 2238.5 |  | Oasis Inc.
 | 2017-09-01 00:00:00 | 19172 | CBPAY | 109 | FUT | 337.73 |  | Payment
 | 2017-09-01 00:00:00 | 19175 | CBPAY | 109 | FUT | 13249.9 |  | Banjo NHS
 | 2017-09-01 00:00:00 | 19176 | CBPAY | 109 | FUT | 30000 |  | Blue Capital Real
 | 2017-09-01 00:00:00 | S01901 | CBPAY | 109 | FUT | 35.75 |  | A&S Tech Pty Ltd
 | 2017-09-01 00:00:00 | S01903 | CBPAY | 109 | FUT | 309.43 |  | AGL Sales Pty Limi
 | 2017-09-01 00:00:00 | S01904 | CBPAY | 109 | FUT | 6140.2 |  | Amplec Electrical
 | 2017-09-01 00:00:00 | S01905 | CBPAY | 109 | FUT | 8932 |  | [NAME]
 | 2017-09-01 00:00:00 | S01906 | CBPAY | 109 | FUT | 9093.57 |  | ATF Hire Group
 | 2017-09-01 00:00:00 | S01907 | CBPAY | 109 | FUT | 1654.79 |  | Axis Surveys
 | 2017-09-01 00:00:00 | S01908 | CBPAY | 109 | FUT | 88 |  | Bambrick Media Pty
 | 2017-09-01 00:00:00 | S01909 | CBPAY | 109 | FUT | 12650 |  | BGC Solid Plasteri
 | 2017-09-01 00:00:00 | S01910 | CBPAY | 109 | FUT | 1485 |  | [NAME]
 | 2017-09-01 00:00:00 | S01911 | CBPAY | 109 | FUT | 275 |  | [NAME]
 | 2017-09-01 00:00:00 | [NAME] | CBPAY | 109 | FUT | 2310 |  | Buildsafe Queensla
 | 2017-09-01 00:00:00 | S01914 | CBPAY | 109 | FUT | 8110.3 |  | [NAME]
 | 2017-09-01 00:00:00 | S01915 | CBPAY | 109 | FUT | 950.4 |  | CLEAN 'N' GREEN
 | 2017-09-04 00:00:00 | 409171 | CBPAY | 409 | FUT | 4929.17 |  | Payment
 | 2017-09-04 00:00:00 | P-WK01 | PATRF | 409 | FUT | 31625.67 |  | PAYROLL TRANSFER