Spreadsheet: 773358d1647811386-add-and-delete-rows-from-tables-mock-statement
Sheet: data

RH | Report Code | CLISTMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
RH | Report Heading | Client Statement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
RH | Report Date | 2022-01-02 00:00:00
RH | Report Time | 11:36:16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
RH | Report Queued By Op | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
RH | Report Selection Criteria | <<1>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
RH | Report Parameters |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
RH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
RH | Report Comp Name | Wayne Enterprise |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
RH | Report Comp Phone
RH | Report Comp Fax
RH | Report Comp Address 1
RH | Report Comp Address 2
RH | Report Comp Address 3
RH | Report Comp Suburb
RH | Report Comp State
RH | Report Comp Postcode
WH | STSCLIACCCODE | WEAI
WH | STSCLINAME
WH | STSBICONTNAME
WH | SRUENDDATEA | 31 Jan 2022
WH | STSCLOPENBALWH | 0.00
WH | STSTROPENBALWH | 0.00
WH | STSBRKSTMTBYPOR | Y
WH | STSCONSOLSTMT | S
WH | STSSTMTINVFLAG | I
SH | STSSTMTTYPE | CO
SH | STSSHEETNAME | WEAI
SH | STSSTMTHEAD | Tax Invoice/Statement
SH | PORCODE | WEAI
SH | PORDESC
SH | STSBIADDR
SH | STSOPENBAL | 0.00
SH | STSCLOPENBAL | 0.00
SH | STSTROPENBAL | 0.00
SH | STSAGEDBAL | 0.00 | 0 | 0 | 0 | 0 | 0
SH | INVCODE | TX6002 | 6002
SH | STSINVDUEDATE
SH | COMNAME
SH | COMABN
SH | COMTRADNAME
SH | COMINVADDR
SH | BACBANK
SH | BACBSBCODE
SH | BACNUM
SH | BACNAME
SH | COMINVPAYADDR
CH | STRDATE | FILCLIREF1STRDESC | STRCHGDESC | STRPAYDAMT | STRPAYTAMT | STRCOMAMT | STROTHCHAMT | STRGSTAMT | STRCHCRAMT | STRREFAMT | STRTTYCODE | STRCHGCAT | FILCODE | TRNSRVCHAMT | TRNSOLCHAMT | TRNCRTCHAMT | TRNNOTSRVSOLCRTCHAMT | TTYCAT | TRNGSTEXEMPTAMT | FILCLIREF1 | FINADDINFO_3 | FILCLIREF2
D | 2021-12-29 00:00:00 | 4625WCE Customer 1 | PAYMENT - AGENCY TRUST | 0 | 1682 | 420.5 | 0 | 42.05 | 462.55 |  | PAYT | OTH | 55122 | 0 | 0 | 0 | 0 | 810 | 0 | 4625WCE
D | 2021-12-29 00:00:00 | 6754WCE Customer 2 | PAYMENT - AGENCY TRUST | 0 | 1528 | 382 | 0 | 38.2 | 420.2 |  | PAYT | OTH | 89994 | 0 | 0 | 0 | 0 | 810 | 0 | 6754WCE
D | 2021-12-29 00:00:00 | 6524WCE Customer 3 | PAYMENT - AGENCY TRUST | 0 | 951 | 237.75 | 0 | 23.775 | 261.525 |  | PAYT | OTH | 85378 | 0 | 0 | 0 | 0 | 810 | 0 | 6524WCE
D | 2021-12-29 00:00:00 | 4625WCE Customer 1 | PAYMENT - AGENCY TRUST | 0 | 403 | 100.75 | 0 | 10.075 | 110.825 |  | PAYT | OTH | 55122 | 0 | 0 | 0 | 0 | 810 | 0 | 4625WCE
D | 2021-12-29 00:00:00 | 6548WCE Customer 5 | PAYMENT - AGENCY TRUST | 0 | 111 | 27.75 | 0 | 2.775 | 30.525 |  | PAYT | OTH | 54782 | 0 | 0 | 0 | 0 | 810 | 0 | 6548WCE
D | 2021-12-31 00:00:00 | 4625WCE Customer 1 | PAYMENT - AGENCY TRUST |  | 359 | 89.75 | 0 | 8.975 | 98.725 |  | PAYT | OTH | 55122 | 0 | 0 | 0 | 0 | 810 | 0 | 4625WCE
D | 2022-01-04 00:00:00 | 6808WCE Customer 7 | PAYMENT - AGENCY TRUST |  | 1398 | 349.5 | 0 | 34.95 | 384.45 |  | PAYT | OTH | 54866 | 0 | 0 | 0 | 0 | 810 | 0 | 6808WCE
D | 2022-01-04 00:00:00 | 6050WCE Customer 8 | PAYMENT - AGENCY TRUST |  | 1379 | 344.75 | 0 | 34.475 | 379.225 |  | PAYT | OTH | 82822 | 0 | 0 | 0 | 0 | 810 | 0 | 6050WCE
D | 2022-01-05 00:00:00 | 5208WCE Customer 9 | PAYMENT - AGENCY TRUST |  | 1300 | 325 | 0 | 32.5 | 357.5 |  | PAYT | OTH | 54771 | 0 | 0 | 0 | 0 | 810 | 0 | 5208WCE
D | 2022-01-05 00:00:00 | 6808WCE Customer 7 | PAYMENT - AGENCY TRUST |  | 85 | 21.25 | 0 | 2.125 | 23.375 |  | PAYT | OTH | 54866 | 0 | 0 | 0 | 0 | 810 | 0 | 6808WCE
D | 2022-01-05 00:00:00 | 6808WCE Customer 7 | PAYMENT - AGENCY TRUST |  | 458 | 114.5 | 0 | 11.45 | 125.95 |  | PAYT | OTH | 54866 | 0 | 0 | 0 | 0 | 810 | 0 | 6808WCE
D | 2022-01-06 00:00:00 | 6053WCE Customer 12 | PAYMENT - AGENCY TRUST |  | 1938 | 484.5 | 0 | 48.45 | 532.95 |  | PAYT | OTH | 55063 | 0 | 0 | 0 | 0 | 810 | 0 | 6053WCE
D | 2022-01-06 00:00:00 | 4834WCE Customer 13 | PAYMENT - AGENCY TRUST |  | 871 | 217.75 | 0 | 21.775 | 239.525 |  | PAYT | OTH | 54541 | 0 | 0 | 0 | 0 | 810 | 0 | 4834WCE
D | 2022-01-06 00:00:00 | 5568WCE Customer 14 | PAYMENT - AGENCY TRUST |  | 1402 | 350.5 | 0 | 35.05 | 385.55 |  | PAYT | OTH | 59998 | 0 | 0 | 0 | 0 | 810 | 0 | 5568WCE
D | 2022-01-06 00:00:00 | 6900WCE Customer 4 | PAYMENT - AGENCY TRUST |  | 102 | 25.5 | 0 | 2.55 | 28.05 |  | PAYT | OTH | 85377 | 0 | 0 | 0 | 0 | 810 | 0 | 6900WCE
D | 2022-01-07 00:00:00 | 5729WCE Customer 16 | PAYMENT - AGENCY TRUST |  | 119 | 29.75 | 0 | 2.975 | 32.725 |  | PAYT | OTH | 85378 | 0 | 0 | 0 | 0 | 810 | 0 | 5729WCE
D | 2022-01-07 00:00:00 | 6900WCE Customer 4 | PAYMENT - AGENCY TRUST |  | 753 | 188.25 | 0 | 18.825 | 207.075 |  | PAYT | OTH | 85377 | 0 | 0 | 0 | 0 | 810 | 0 | 6900WCE
D | 2022-01-08 00:00:00 | 5774WCE Customer 18 | PAYMENT - AGENCY TRUST |  | 1216 | 304 | 0 | 30.4 | 334.4 |  | PAYT | OTH | 85701 | 0 | 0 | 0 | 0 | 810 | 0 | 5774WCE
D | 2022-01-10 00:00:00 | 6900WCE Customer 4 | PAYMENT - AGENCY TRUST |  | 334 | 83.5 | 0 | 8.35 | 91.85 |  | PAYT | OTH | 85377 | 0 | 0 | 0 | 0 | 810 | 0 | 6900WCE
D | 2022-01-10 00:00:00 | 6999WCE Customer 20 | PAYMENT - AGENCY TRUST |  | 1081 | 270.25 | 0 | 27.025 | 297.275 |  | PAYT | OTH | 84664 | 0 | 0 | 0 | 0 | 810 | 0 | 6999WCE
D | 2022-01-10 00:00:00 | 5951WCE Customer 21 | PAYMENT - AGENCY TRUST |  | 317 | 79.25 | 0 | 7.925000000000001 | 87.175 |  | PAYT | OTH | 84664 | 0 | 0 | 0 | 0 | 810 | 0 | 5951WCE
D | 2022-01-10 00:00:00 | 6900WCE Customer 4 | PAYMENT - AGENCY TRUST |  | 762 | 190.5 | 0 | 19.05 | 209.55 |  | PAYT | OTH | 85377 | 0 | 0 | 0 | 0 | 810 | 0 | 6900WCE
D | 2022-01-31 00:00:00 | CLIENT CONTRA CREDIT | CLIENT CONTRA CREDIT |  | 33519 | 0 | 0 | 0 |  |  | CLCC |  |  | 0 | 0 | 0 | 0 | 610 | 0
D | 2022-01-31 00:00:00 | TRUST REFUND | TRUST REFUND | 0 | 18549 | 4637.25 | 0 | 463.725 | 5100.975 | 13448.025 | TRRF |  |  | 0 | 0 | 0 | 0 | 900 | 776.2