Spreadsheet: 144313d1330909756-vba-sentence-wrong-please-help-how-to-fix-that-compay-template
Sheet: DETAILEDDEBITPAYMENTSREPORT(1)

Payee Trans ID | Payer Trans ID | Date Created | Created By | Date Authorised | 1st Authoriser | 2nd Authoriser | Payment Date | Date Settled | Bank Settlement ID | Date Deposited | Payable Amount | Receivable Amount | Currency | Status | From Client | To Client | Reference1 | Reference2 | Reference3 | Document Type | Notes |  |  |  | Reference2 | CODE 1 |  | CODE 2 |  | GST |  | GST | TTL
C932101 | C932101 | 2012-02-28 15:59:02 | [NAME] | 2012-02-28 16:55:17 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 2609.75 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | SCHENKER AUSTRALIA P/L - MELBOURNE [203076] | 20999915 | SCS121145 |  | INVOICE | HUATEC&CCBS 2372.50&GST 237.25 | HUATEC-CCBS2372.50&GST237.25 | J | HUATEC | SCS121145 | CCBS | 2372.50 | 0 |  | GST | 237.25 | 237.25 | #N/A | #N/A
C932562 | C932562 | 2012-02-29 09:51:09 | [NAME] | 2012-02-29 10:44:28 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 397.57 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | SCHENKER AUSTRALIA P/L - PERTH [203079] | 60169006 | SCA346088 |  | INVOICE | HUATEC&CCIT 361.43&GST 36.14 | HUATEC-CCIT361.43&GST36.14 | J | HUATEC | SCA346088 | CCIT | 361.43 | 0 |  | GST | 36.14 | 36.14 | #N/A | #N/A
C932436 | C932436 | 2012-02-29 09:16:46 | [NAME] | 2012-02-29 10:44:25 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 315.26 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | NIPPON EXPRESS - SYDNEY [202020] | VIO-11022 | SCS121297 |  | INVOICE | THRM&CCAO 85.91&CCBS 208.50&GST 20.85 | THRM-CCAO85.91&CCBS208.50*GST20.85 | J | THRM | SCS121297 | CCAO | 85.91 | CCBS | 208.50 | GST | 20.85 | 20.85 | 315.26 | 0
C932489 | C932489 | 2012-02-29 09:27:43 | [NAME] | 2012-02-29 10:44:27 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 2629.35 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | POTA GLOBAL MANAGEMENT - NSW [202083] | 128778 | SCS121300 |  | INVOICE | THRM&CCAO 662.00&CCBS 1788.50&GST 178.85 | THRM-CCAO662.00&CCBS1788.50*GST178.85 | J | THRM | SCS121300 | CCAO | 662.00 | CCBS | 1788.50 | GST |  | 0 | 2450.5 | 178.8499999999999
C932075 | C932075 | 2012-02-28 15:46:18 | [NAME] | 2012-02-28 16:56:12 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 786.25 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | YUSEN GLOBAL LOGISTICS - SYD/BNE [203086] | YTW00205601 | SCA345931 |  | INVOICE | CANAUS&CCAO 505.94&CCIT 254.83&GST 25.48 | CANAUS-CCAO505.94&CCIT254.83*GST25.48 | J | CANAUS | SCA345931 | CCAO | 1919.49 | CCIT | 254.83 | GST | 25.48 | 25.48 | 2199.8 | -1413.55
C932484 | C932484 | 2012-02-29 09:26:45 | Rebecca  Villazon | 2012-02-29 10:44:26 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 308.37 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | DHL GLOBAL FORWARDING (NSW-AIRFREIGHT) [201734] | SYD H 922246 | SCA346074 |  | INVOICE | THRM&CCAO145.57&CCIT148.00&GST14.80 | THRM-CCAO145.57&CCIT148.00*GST14.80 | J | THRM | SCA346074 | CCAO | 145.57 | CCIT | 148.00 | GST |  | 0 | 293.57 | 14.80000000000001
C932484 | C932484 | 2012-02-29 09:26:45 | Rebecca  Villazon | 2012-02-29 10:44:26 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 314.08 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | DHL GLOBAL FORWARDING (NSW-AIRFREIGHT) [201734] | SYD H 921884 | SCA346153 |  | INVOICE | THRM&CCAO137.53&CCIT160.50&GST16.05 | THRM-CCAO137.53&CCIT160.50*GST16.05 | J | THRM | SCA346153 | CCAO | 137.53 | CCIT | 160.50 | GST | 16.05 | 16.05 | 314.08 | 0
C932224 | C932224 | 2012-02-28 16:55:18 | [NAME] | 2012-02-28 16:55:18 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932101 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932101 | TransactionFee(inctax)for:C932101 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
[NAME] | [NAME] | 2012-02-28 16:56:12 | [NAME] | 2012-02-28 16:56:12 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932075 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932075 | TransactionFee(inctax)for:C932075 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932646 | C932646 | 2012-02-29 10:25:43 | [NAME] | 2012-02-29 11:34:53 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-02-29 00:00:00 | 200.7 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | DP WORLD TERMINAL - PORT BOTANY [201531] | VPB552081 | 64505 |  | INVOICE | VBS Invoice | VBSInvoice | J | #N/A | 64505 | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932714 | C932714 | 2012-02-29 10:44:25 | [NAME] | 2012-02-29 10:44:25 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932436 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932436 | TransactionFee(inctax)for:C932436 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932715 | C932715 | 2012-02-29 10:44:26 | Rebecca  Villazon | 2012-02-29 10:44:26 | Rebecca  Villazon |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932484 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932484 | TransactionFee(inctax)for:C932484 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932716 | C932716 | 2012-02-29 10:44:27 | [NAME] | 2012-02-29 10:44:27 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932489 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932489 | TransactionFee(inctax)for:C932489 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932717 | C932717 | 2012-02-29 10:44:28 | [NAME] | 2012-02-29 10:44:28 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932562 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932562 | TransactionFee(inctax)for:C932562 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A | #N/A | #N/A | GST | #N/A | #N/A | #N/A | #N/A
C932899 | C932899 | 2012-02-29 11:34:54 | [NAME] | 2012-02-29 11:34:54 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932646 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932646 | TransactionFee(inctax)for:C932646 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
C932909 | C932909 | 2012-02-29 11:38:52 | [NAME] | 2012-02-29 14:31:45 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1358.1 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | NIPPON EXPRESS - SYDNEY [202020] | VOI-11014 | SCS121303 |  | INVOICE | THRM&CCAO 551.03&CCIT 733.70&GST 73.37 | THRM-CCAO551.03&CCIT733.70*GST73.37 | J | THRM | SCS121303 | CCAO | 551.03 |  |  | GST | 73.37 | 73.37 | 624.4 | 733.6999999999999
C933206 | C933206 | 2012-02-29 13:58:29 | [NAME] | 2012-02-29 14:32:33 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 160.3 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | NSW - EXPEDITORS INTERNATIONAL [203514] | E950752009 | SCA346172 |  | INVOICE | EMC&CCIT 145.73&GST 14.57 | EMC-CCIT145.73&GST14.57 | J | EMC | SCA346172 | CCIT | 145.73 |  |  | GST | 14.57 | 14.57 | 160.3 | 0
C933206 | C933206 | 2012-02-29 13:58:29 | [NAME] | 2012-02-29 14:32:33 | [NAME] | [NAME] |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 158.05 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | NSW - EXPEDITORS INTERNATIONAL [203514] | E950751978 | SCA346155 |  | INVOICE | EMC&CCIT 143.68&GST 14.37 | EMC-CCIT143.68&GST14.37 | J | EMC | SCA346155 | CCIT | 143.68 |  |  | GST | 14.37 | 14.37 | 158.05 | 0
C933270 | C933270 | 2012-02-29 14:31:46 | [NAME] | 2012-02-29 14:31:46 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C932909 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C932909 | TransactionFee(inctax)for:C932909 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
C933271 | C933271 | 2012-02-29 14:32:33 | [NAME] | 2012-02-29 14:32:33 | [NAME] |  |  | 2012-02-29 15:30:01 | 1915 | 2012-03-02 00:00:00 | 1.76 | 0 | AUD | Settled | CEVA FREIGHT (AUST) PTY LTD - NSW [202122] | COMPAY TRANSACTION FEES [200353] | C933206 | Transaction Fee: INVOICE (inc tax) |  | INVOICE | Transaction Fee (inc tax) for: C933206 | TransactionFee(inctax)for:C933206 | J | #N/A | Transaction Fee: INVOICE (inc tax) | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | #N/A |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 272.53 |  |  | GST |  | 0 | 272.53 | -272.53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 1728.74 |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 141 |  |  | GST | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 590 |  |  | GST |  | 0 | 590 | -590
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 590 |  |  | GST |  | 0 | 590 | -590
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 164.87 |  |  | GST |  | 0 | 164.87 | -164.87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 413.17 |  |  | GST |  | 0 | 413.17 | -413.17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 14184.35 |  |  | GST |  | 0 | 14184.35 | -14184.35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | #N/A | 0 | #N/A | 121.96 |  |  | GST |  | 0 | 121.96 | -121.96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.4 | 26.4